Jul
04
2005
DSN-less ODBC
Posted by admin under
ADO database
This way could be very difficult, since you have a lot of options you could specify in the connection string. However, the simple connection string I present to you here is actually all you need for adequate performance in most cases.
Lets say you have uploaded an ad2000.mdb file into your /database/ directory at your host. Now all you do is:
<%
Function Incdb_GetConnectionString( nNumber )
Incdb_GetConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\database\ad2000.mdb")
End Function
%>