Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 DSN Less Connection		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

mafifi
Junior Member

USA
308 Posts
Posted - 05 May 2001 :  13:41:47  Show Profile  Send mafifi an ICQ Message
Is this the correct line of code for Access97 OR Access2000
quote:

conn.open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:\INETPUB\WWWROOT\Databasename.mdb"


Thanks,

Mo

Doug G
Support Moderator

USA
6493 Posts
Posted - 05 May 2001 :  15:01:03  Show Profile
The short answer is yes.

Actually, this is more accurately the connection string to use the Jet 4.0 OLE DB provider for ADO, which I think was introduced with MDAC (Microsoft Data Access Components) v2.0 or 2.1.

This provider will communicate with either an Access 2000 database or an Access 97 database, but needs an Access 2000 database for some features (Select @@Identity comes to mind).

I use this provider if available vs. the ODBC Access driver (the Driver=Microsoft Access Driver *.mdb). There is also a JET.OLEDB.3.51 (I think it's .51) provider if you have problems with the 4.0 provider.

======
Doug G
======
Go to Top of Page

SweSob
Starting Member

22 Posts
Posted - 09 May 2001 :  19:32:12  Show Profile
Here's an example:

examples of Access97 connectstrings:

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\db\yourdb.mdb" '## MS Access 97

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/db/yourdb.mdb") '## MS Access 97, virtual path

Examples of Access2000 connectstrings:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\forum\yourdb.mdb;" '## MS Access 2000

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/db/yourdb.mdb") '## MS Access 2000, virtual path
Go to Top of Page

mafifi
Junior Member

USA
308 Posts
Posted - 09 May 2001 :  20:45:45  Show Profile  Send mafifi an ICQ Message
Thanks.

Mo
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07