tags:

views:

444

answers:

1
+1  Q: 

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

I am trying to connect to list the servers on my network using osql.exe -L. Instead of a list of servers, however, I get the following error:

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

I'm not sure what's causing this problem - any pointers leading in the right direction will be helpful. Thanks so much!

A: 

The DSN is case sensitive, make sure your putting in the right name. It should match whatever you have in your odbc.ini file (unix) or in the "ODBC Data Source Administrator" (windows).

Winder  2010-03-08 17:42:29

related questions

C++ SQLBindParameter
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Tool: ETL from an ODBC to SQL 05?
What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
Microsoft.ApplicationBlocks.Data.ODBCHelper ?
What are the access restrictions on accessing a DSN
.NET ODBC Connection Pooling
ODBC Connection Pool
what is the difference between OLE DB and ODBC data sources?
Reading a COBOL DAT file
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
How to programmatically configure an ODBC Datasource using C#
Best way to debug an ODBC driver on Windows
What is a Privileged instruction?
Control which columns become primary keys with Microsoft Access ODBC link to Oracle
How do you deal with NULL values in columns of type boolean in MS Access?
Using Rails 2.x with MS SQL Server 2005
C# ODBC Dialog
How do I get ms-access to connect to ms-sql as a different user?
How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
Using MySQL on Visual Studio 2008
Using MS Access & ODBC to connect to a remote PostgreSQL
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Connect PHP to an AS/400