|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
August 13th, 2003, 10:14 AM
|
|||
|
|||
|
Help! - Microsoft OLE DB Provider for ODBC Drivers error '80004005'
I'm working on a website and I have a database issue... Hope this is the right forum...
here is the site and you'll see the error in the bottom left hand corner. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /providence28/index.asp, line 79 I'm running Microsoft Data Access Components Version 2.6, I have re-installed Windows 2000 SP4. I also updated the permissions in the registry to everyone full control to ODBC This works on my local box, but once I try it on the server it craps out. Any ideas... PLEASE!!! Tom URL URL
|
|
#2
August 13th, 2003, 10:37 AM
|
||||
|
||||
|
I will have to see your connect string (be SURE to put in dummy username and password!) to have a better idea.
You may be attempting to access the database as if it were installed locally (meaning it is not on the same server as your web server) when it is located on another machine. You will have to fully qualify the path to fix that. You may also have installed your database (which database it it, by the way?) so that it does not accept connections from the network. BTW: You can create 'DSN-less' connections so you don't have to install the ODBC setup on each computer.
__________________
Left DevShed May 28, 2005. Reason: Unresponsive administrators. Free code: http://sol-biotech.com/code/. Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html. Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html. It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it. --Me, I just made it up The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man. --George Bernard Shaw
|
|
#3
August 13th, 2003, 12:49 PM
|
|||
|
|||
|
here's what my team is using, it this what you needed?
Set oRSbodytext=Server.CreateObject("ADODB.Recordset") sqlText = "Select * from NewsView order by NewsDate" oRSbodytext.Open sqlText, "DSN=PCenterData"
|
|
#4
August 13th, 2003, 12:54 PM
|
||||
|
||||
|
Not really, I guess I would need to see the info in your ODBC setup. Can you connect from the machine you are having problems with via that DSN? You do realize that you must create the ODBC setup for that database on your server where you are running the program, right?
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Help! - Microsoft OLE DB Provider for ODBC Drivers error '80004005' |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
