Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
Dear All,
I got a major problem with the odbc and asp connection to my oracle database on the Microsoft 2000 server.
I received the error message is displayed as:OLE DB Provider error for ODBC Drivers error 80004005
[Microsoft] [ODBC Driver Manager] Data Source Name not found and no default driver specified.============================================
My connection string is:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "dsn=TEST;uid=TEST;pwd=TEST;"
Set RS = Server.CreateObject("ADODB.Recordset")
Please help me!
Thank you very much for your help!
MiLe
make sure you create a DSN entry call "TEST" pointing to wherever you need it to be (ms sql, ms access). Make sure the DSN entry is on the server. Also, create the DSN "TEST" entry that can be used by all users on the servers (SYSTEM DSN).
0 
There are Microsoft recommendations below:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified.
Causes:The most common cause is that the connection string is a session variable initialized in the Global.asa and Global.asa is not firing. You may check to see that the variable is being initialized correctly by adding the following code to the .asp page:
<%= "'auth_user' is " & request.servervariables("auth_user")%>
<%= "'auth_type' is " & request.servervariables("auth_type")%>
<%= "connection string is " & session("your_connectionstring")%>
If the Global.asa is not firing, check to make sure it is in an Application Root for IIS 4.0, or a Virtual Root with the "Execute" check box selected if running under IIS 3.0. Also, a bug may prevent the Global.asa from being fired when Windows NT permissions have restricted access to the folder.
The DSN name is not found. Check to make sure a 'User' type DSN is not being used.
If using a File or System DSN, try changing the connection string to "DSN=MySystemDSN" or "DBQ=MyFileDSN" as appropriate. Simplify!
Check to make sure that the most current drivers are installed.
If in doubt, download the latest MDAC (Microsoft Data Access Components) from the following Web site:
http://www.microsoft.com/data/Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not ??Cause:
This appears to be an issue with the order in which software is installed and uninstalled on the computer. If the ODBC core files become unsynchronized (they should all be the same version) you may see this error.Install the latest version of MDAC (Microsoft Data Access Components) from the following Web site to update all the core ODBC drivers:
http://www.microsoft.com/data/
0
Dear All,
Thank you very much for your info.
Yes, I did created a DSN entry on the Windows 2000 server (on system DSN), and
I did updated with the latest version of MDAC (MDAC 2.6 RTM (2.60.6526.3)),
but I still received the same error message. Is it the right version of MDAC for windows 2000 server?Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedWhat should I do?
Please help me,
Thank a lot!
MiLe
0 0
http://www.interauction.com/odbic/forum/M03570.html
I had the same problem until I found this post elsewhere.
It FIXES the problem and stops you tearing your hair out :)
0
Way to go Mark!!!! I had an issue where, I could use ASP to view records in a database, BUT when I went to refresh or add (or whatever), I would get an "Unspecified Error '80004005' at my connection string.
15 mins later, it would be fine, and then the problem would happen again.The fix at your link worked.
Thanks a million.
0
Dear all,
I have problem with this error
'Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified '
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.ConnectionTimeout = 15
DataConn.CommandTimeout = 30
DataConn.Open "DSN=Panel clinc"
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rsloginuser = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "SELECT * FROM user WHERE (UserId = '" & Session("UserId") & "') AND (Password = '" & Password & "')"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rsloginuser.Open cmdTemp, , 1, 3i have create a table in database call Panel clinic..but it doesn't work..
please help me...
0
Hello There!
Can someone tell me what I am doing wrong i keep getting this message!
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'DriverId'.
0
The two most common workarounds for this problem are:
Change the Anonymous Logon account on the IIS server from IUSR_MACHINE to a domain account that is recognized by both machines and has sufficient permissions to the resource. In addition, be sure that this account has the log on locally user right on the IIS machine. Recall that the Anonymous Logon account is configured through Internet Service Manager.
Note: If you later decide to change back to the IUSR_MACHINE account, be sure that the password provided in Internet Service Manager matches the password provided for this account in the User Manager tool. If the passwords do not match, you will encounter Access Denied errors.
Add a local account to the remote machine that exactly matches the username and password of the IUSR_MACHINE account on the IIS machine, and give this account access to the database.
Note: This workaround is not recommended because it involves maintaining two separate accounts. If the passwords get "out of sync" at some point in the future, access will be denied to the database, and errors will occur.
=======
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query./banmanpro/addadvertiser.asp, line 76
Need more information on this error, try the following MS Knowledgebase Article.
If you receive this error when attempting to insert a new record or update an existing record, then the permissions are not set correctly for the Anonymous User Account. If you are not an administrator on the web server, you will need to ask your Web Hosting Provider to make this change for you.
To fix this, use File Manager to find the folder holding your database. Note that this is done in file manager and not the Microsoft Management Console. Once the folder is located, right mouse-click on the folder and select Properties.The following dialog box appears. Select the Security folder. Next, click the Permissions button.
Next, select the Anonymous User Account and set the Permissions to Change (RWXD). In this case the Anonymous User is Everyone, however the name varies from one system to another. Click OK when finished.
=============
0
I have been pulling my hair out for two weeks over this problem:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Can't open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
/Search/TMP155728pht9.asp, line 4
My database file is fine. I am using Macromedia UltraDev unsuccessfully. Can someone please help me.
0
I have been getting this error message and it is driving me crazy. If anyone can help me I would appreciate it.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
/sdc/tutorlist3.asp, line 13
This is the code:sSql = "Select firstname,lastname,email,department,number,available From Tutors,Tutorsubject where department = '" & Request.Form("dept") & "' AND number = " & Request.Form("number") & " AND tutors.logonid = tutorsubject.logonid AND letter = '" & Request.Form("letter") & "';"
set conn = Server.CreateObject("ADODB.Connection")
conn.OPEN "DSN=SDC;" //line that is broken
set objRec = conn.execute(sSql)
Thanks, Petra Arrambide
0  |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
