I am using Visual InterDev and Access97/access2000. I have the following database connection I add to all .asp pages via an include. I want to switch to 2000 and have problem with connection.
<%Dim objConn 'declare your variable to hold your connection
Set objConn = Server.CreateObject("ADODB.Connection"
objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=F:\ Support.mdb"
objConn.open
%>
This works great for ACCESS97. Can anyone let me know how to create the same type of DSNless connection and be able to connect to an ACCESS2000 database.
Thanks in advance
Mark
<%Dim objConn 'declare your variable to hold your connection
Set objConn = Server.CreateObject("ADODB.Connection"
objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=F:\ Support.mdb"
objConn.open
%>
This works great for ACCESS97. Can anyone let me know how to create the same type of DSNless connection and be able to connect to an ACCESS2000 database.
Thanks in advance
Mark