| Author |
Establish ODBC connection
|
|
|
| Anyone know how to establish an ODBC connection
using .asp? Looking for ideas!
Thanks
Windows 2000, IIS Version 6
| |
| [ + 2 0 r p 3 ] 2004-06-29, 5:55 pm |
| you should be using the newer OLE DB to connect to you db.
example
dim objConn : set objConn = server.createobject("ADODB.connection")
objConn.open "provider=microsoft.jet.OLEDB.4.0; " & "data source=" &
server.mappath("yourdb.mdb") & ";"
"Steve" <anonymous@discussions.microsoft.com> wrote in message
news:22b6c01c45e23$8fd60250$a601280a@phx
.gbl...
> Anyone know how to establish an ODBC connection
> using .asp? Looking for ideas!
>
> Thanks
>
> Windows 2000, IIS Version 6
| |
|
| I'd rather not use OLE DB. My current workspace is setup
on ODBC, and I'd rather not change right now.
If anyone knows using ODBC, please fill me in.
>-----Original Message-----
>you should be using the newer OLE DB to connect to you db.
>
>example
>
>dim objConn : set objConn = server.createobject
("ADODB.connection")
>objConn.open "provider=microsoft.jet.OLEDB.4.0; "
& "data source=" &
>server.mappath("yourdb.mdb") & ";"
>
>
>"Steve" <anonymous@discussions.microsoft.com> wrote in
message
> news:22b6c01c45e23$8fd60250$a601280a@phx
.gbl...
>
>
>.
>
| |
| Aaron [SQL Server MVP] 2004-06-29, 8:45 pm |
| > I'd rather not use OLE DB.
Why?
> My current workspace is setup
> on ODBC, and I'd rather not change right now.
This doesn't make any sense. There is no "workspace" to "setup" in order to
use a DSN-less connection string. ODBC has been deprecated for a reason!
|
|
|
|