Solved

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

Posted on 2006-07-11
3
249 Views
Last Modified: 2013-12-04
The main page is help_desk_start.asp. This page will accept a badge number and check for this badge number to exist in the database. Based on the existence, the next page - that is help_desk.asp loads. This is the error I get after I enter my badge number -

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

C:\WEB\HELP_DESK\../ado/ado_start.inc, line 5

This is the content of the ado_start.inc file -

<%'SET UP ACTIVEX DATA OBJECT
set my_conn = server.createobject("adodb.connection")
set my_rows = server.createobject("adodb.recordset")
'my_conn.open "miles","web_man",""
my_conn.open "DSN=" & trim(ado_dsn) & ";UID=" & trim(ado_uid) & ";PWD=" & trim(ado_pwd) & ";DATABASE=" & trim(ado_database) & ";APP=" & trim(app)
my_rows.open sql, my_conn
app = "" %>

I have already tried the solution of changing the permissions on the registry key for Full Control.

thanks
0
Comment
Question by:ariesmeeta
3 Comments
 

Accepted Solution

by:
ryanstinson earned 125 total points
ID: 17085788
The problem is your connection string. the line:


my_conn.open "DSN=" & trim(ado_dsn) & ";UID=" & trim(ado_uid) & ";PWD=" & trim(ado_pwd) & ";DATABASE=" & trim(ado_database) & ";APP=" & trim(app)

I would do some debugging to identify the string and verify that the string is correct for connecting to your database.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
what font behind pdf 32 136
deny local logon 12 90
Allow X-Forwarded-For Headers to Site or No? 3 63
Set a time range for screen lockout for Windows 10/7 OS 2 15
In today's information driven age, entrepreneurs have so many great tools and options at their disposal to help turn good ideas into a thriving business. With cloud-based online services, such as Amazon's Web Services (AWS) or Microsoft's Azure, bus…
This is a guide to the following problem (not exclusive but here) on Windows: Users need our support and we supporters often use global administrative accounts to do this. Using these accounts safely is a real challenge. Any admin who takes se…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now