|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 5th, 2003, 09:32 AM
|
|||
|
|||
|
Data source name not found and no default driver specified
Hi
We had a web site that works in windows NT very good with a DB in Access. Our clients migrate to Win 2000 and now the connection to the DB doesn't work,...the error is this: Error: Access is Denied. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /directory/progs/utils.inc, line 17 The code is this Sub ConectarBd(NomDSN) Connect_String = "DSN=lmsfamilia;" db.Open Connect_String End Sub What could it be? Thanks JP
|
|
#2
September 5th, 2003, 09:49 AM
|
|||
|
|||
|
Make sure your client has a DSN named lmsfamilia on his machine.
To check that, simply go to : Start-->Programs-->Administrative Tools-->Data Source(ODBC) then click the System DSN tab and *look* if its there... If not, then create it! Hope this helps! Sincerely Vlince
|
|
#3
September 5th, 2003, 09:56 AM
|
|||
|
|||
|
I've already done that DSN
Hi!
I'm sure the DSN is created in Data Source(ODBC) I'm really confused...two days with this error....the DSN is created...the users IWAM_ and IUSR_ have the rigth permision to the folder....so ...mh? Help please Thanks JP
|
|
#4
September 5th, 2003, 10:16 AM
|
|||
|
|||
|
OK then there is NOTHING *I* can do from here...in Montreal!
You'll need to DEBUG Start from the beginning, Create a simple .asp page that does this: -------------------------------------------------- <html> <body> <%Response.Write Now()%> </body> </html> -------------------------------------------------- then move up one leve... Create a *second* .asp page that *tries* to connect to your database. Use an OLEDB connection instead of a DSN to connect to your Access database Look here: http://www.able-consulting.com/ADO_Conn.htm Now you do NOT have much choice to go step by step in order to identify the problem I wish I could help you more...honestly! If the OLEDB approach doesn't work then try creating a *NEW* DSN following the steps in the wizard. Hope this helps! Sincerely Vlince
|
|
#5
September 5th, 2003, 11:16 AM
|
|||
|
|||
|
Double-check your DSN. If you have a typo in the path to the .mdb file you can get this error.
If the .mdb file is in some location outside of your web, make sure the IIS user account has permissions to the .mdb file. You can download and install newer MDAC packages from MS at www.microsoft.com/data You need to download Jet (Access) drivers separately. It is remotely possible there is a registry permissions problem where IIS can't get to the DSN registry entries.
|
|
#6
September 6th, 2003, 06:50 AM
|
|||
|
|||
|
Try removing "DSN=" from the connection string... we've often found that that is the cause of problems even though it shouldn't be....eg
Code:
Connect_String = "lmsfamilia" (Plus remove the SemiColon) Also.. make absolutely sure it's a system DSN
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Data source name not found and no default driver specified |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
