Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

.net framework 2.0 messed up my ASP database connection

Status
Not open for further replies.

ksbigfoot

Programmer
Apr 15, 2002
856
CA
The Windows 2000 server I am using just had the .NET framework 2.0 installed on it. The website is still using the the .NET framework 1.1.
My asp pages are being displayed properly, unless there is a database connection involved, then the page doesn't load.

The only message I get is "Page cannot be displayed". If I take out my database connection code, the page loads.

Here is the code I am using to connect to my database:
Code:
set conn = Server.Createobject("ADODB.Connection")
with conn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "C:\Databases\MyCompany\db2000.mdb"
    .Open
end with

Has anyone ran into this before?
Thanks
 
Try the following:

set conn = Server.CreateObject("ADODB.Connection")
with conn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open "C:\Databases\MyCompany\db2000.mdb"
end with

 
Howdy newconvix,
I ended up fixing my problem my problem by updating the MDAC on my server and also the Microsoft Jet to the latest version and everything seemed to work.
Thanks,
ksbigfoot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top