Establish ODBC connection

[Steve]

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

Thanks

Windows 2000, IIS Version 6

 

[[ + 2 0 r p 3 ]]

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]

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.

 

[Aaron [SQL Server MVP]]

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!