Contents
How do I set the default driver in ODBC?
Case Study
- Select Start, Settings, Control Panel, Administrative Tools, Data Sources (ODBC).
- Navigate to the System DSN tab and click Add to open the Create New Data Source dialog box.
- Select Microsoft Excel Driver as the driver for which you want to set up the data source.
- Specify a name for the data source.
What is ODBC data source name?
A Data Source Name (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the driver and other information that is required to access data from a data source.
Why am I getting ” data source name not found and no?
When trying to make a program on Windows that connects to a database via ODBC, I got the following error: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified. I’m sure my code is right.
Why is sqlcmd.exe not finding data source name?
So getting this error could make sense as there is more to sqlcmd.exe and osql.exe than the EXE itself. You should install the tools on the box that you are trying to run them from so that you can use them the right way and have access to the Libraries that they rely upon to run.
How to check the ODBC data source name?
You can check the drivers which are installed on your system by going to the ODBC Data Source Administrator. To open it, press ⊞ Win + R, and type in: odbcad32.exe. Then check the tab Drivers for installed drivers. The Name column indicates the exact name you should use in your connection string or DSN.
Is there an ODBC error with no DEFA?
ODBC Error: Data source name not found and no defa… Reply Topic Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic for Current User Bookmark Subscribe Printer Friendly Page All forum topics Previous Topic Next Topic jagrutijoshi Frequent Visitor Mark as New Bookmark Subscribe Mute Subscribe to RSS Feed