Data source name not found and no default driver specified

[smcdanie]

When trying to view an asp page on my Windows 03 server, I get the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/LoginPage.asp, line 8

Line 8 in the code is: rsLogin.ActiveConnection = MM_connTesting_STRING

All of this was working at one point. My server (win2000) was hacked a month ago and was then rebuilt (to Win 2003). Now none of my asp pages display.

I tried some of the usual stuff with updating everything, but it still does not work.

If it matters, I use Dreamweaver 8 and I have full control of the server (I just don't know a lot about it). I did make sure that asp permissions were allowed.

Thanks
S

[smcdanie]

I figured it out. My path to the database was incorrect. I also had problems with permission on the database itself and a "time out" variable that I had to change from 5 to 5000.

[aceituna]

I figured it out. My path to the database was incorrect. I also had problems with permission on the database itself and a "time out" variable that I had to change from 5 to 5000.

hi could you please explain the permission, path and time out variables that you changed step by step as i have the same problem

[DrBunchman]

How are you connecting to your database? If it's a connection string can you print it and I'll go through the various properties.

Dr B

[aceituna]

How are you connecting to your database? If it's a connection string can you print it and I'll go through the various properties.

Dr B

am gettin the error at this point con1.Open Application("dcon") & "DATABASE=<database name2>;"

follow up
constr= '"PROVIDER=SQLOLEDB;" & _
' "DATA SOURCE=<datasource name>;DATABASE=<database name 1>;" & _
' "UID=SSI_User;PWD=;"

Application("dcon")=constr & Application("ppp") & ";"