By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

Data source name not found and no default driver specified

P: 2
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
Sep 20 '06 #1
Share this Question
Share on Google+
4 Replies


P: 2
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.
Sep 21 '06 #2

P: 2
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
Mar 7 '08 #3

DrBunchman
Expert 100+
P: 979
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
Mar 7 '08 #4

P: 2
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") & ";"
Mar 8 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.