Anyone know how to establish an ODBC connection
using .asp?  Looking for ideas!

Thanks

Windows 2000, IIS Version 6

[ Post a follow-up to this 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...
> Anyone know how to establish an ODBC connection
> using .asp?  Looking for ideas!
>
> Thanks
>
> Windows 2000, IIS Version 6

[ Post a follow-up to this message ]

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... 
>
>
>.
>

[ Post a follow-up to this message ]

> 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!

[ Post a follow-up to this message ]