Solved

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

Posted on 2006-07-11
3
250 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Many people tend to confuse the function of a virus with the one of adware, this misunderstanding of the basic of what each software is and how it operates causes users and organizations to take the wrong security measures that would protect them ag…
Users of Windows 10 Professional can disable automatic reboots using the policy editor. This tool is not included in the Windows home edition. But don't worry! Follow the instructions below to install (a Win7) policy editor on your Windows 10 Home e…
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…

821 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