ODBC driver manager return 'Data source name not found.

ODBC driver manager return 'Data source name not found.

Why does the ODBC driver manager return 'Data source name not found and no default driver specified Vendor: 0'

View Answers

November 13, 2010 at 5:03 PM

Hi friends,

Hi friends, This type of error occurs during an attempt to connect to a database with the bridge. First, note that the error is coming from the ODBC driver manager. This indicates that the bridge-which is a normal ODBC client-has successfully called ODBC, so the problem isn't due to native libraries not being present. In this case, it appears that the error is due to the fact that an ODBC DSN (data source name) needs to be configured on the client machine. Developers often forget to do this, thinking that the bridge will magically find the DSN they configured on their remote server machine.

Thanks.









Related Tutorials/Questions & Answers:
ODBC driver manager return 'Data source name not found.
ODBC driver manager return 'Data source name not found.  Why does the ODBC driver manager return 'Data source name not found and no default driver specified Vendor: 0
How to Retrieve Excel data into mysql using type 2 JDBC-ODBC driver
How to Retrieve Excel data into mysql using type 2 JDBC-ODBC driver  Can any please help it is very urgent. I tried to read excel sheet using ODBC... Sources(ODBC) Open User DSN tab Add a user DSN Select Microsoft Excel Driver
Advertisements
SQLException caught: No data found
SQLException caught: No data found  i m using ms office 2010, n when i run my source code it is giving error SQLException caught:No data found, plz help me why i am getting this exception, thanks alot, my source code
how to set fetch size for jdbc odbc driver
how to set fetch size for jdbc odbc driver  What is the default fetch size for the JDBC ODBC driver and how can i fetch a set of results for JDBC ODBC driver?   Fetching results JDBC ODBC Driver A. The default fetch
What is ODBC - JDBC
by using ODBC driver will be able to store data into any database management system...-components:· An ODBC Driver Manager · ODBC Drivers The application asks to the ODBC driver manager to call to an appropriate ODBC driver.The ODBC driver manager
Connection using Jdbc-odbc bridge Driver
; function is used to load the JDBC-ODBC bridge driver. It takes driver name...;control panel >Administrative tool > Data source (ODBC). Step3:-Double click on Data source (ODBC),click on "Add" button, Select MS Access
Driver Manager Class
Driver Manager Class       The JDBC Driver Manager The JDBC Driver Manager... to a JDBC driver. Usually  Driver Manager is the backbone of the JDBC
Sun's JDBC-ODBC driver does not implement the getPrimaryKeys() method for the DatabaseMetaData Objects.
Sun's JDBC-ODBC driver does not implement the getPrimaryKeys() method for the DatabaseMetaData Objects.  Is there a way to find the primary key(s) for an Access Database table? Sun's JDBC-ODBC driver does not implement
adding DSN in Data Sources - JSP-Servlet
][ODBC Driver Manager] Data source name not found and no default driver specified... Manager] Data source name not found and no default driver specified... and it has been added in the data sources as online_exam is shown in the ODBC
Java driver manager
Java driver manager  What is DriverManager
No suitable driver found for jdbc:mysql://localhost:3306/TEST
No suitable driver found for jdbc:mysql://localhost:3306/TEST  hii, I have wrietten web project using jsp and hibernate but its not working. ava.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/TEST
JDBC-Odbc Connection
JDBC-ODBC Connection       JDBC-ODBC Connection is a JDBC driver that translates the operation... provides JDBC  for database in which an ODBC driver is available
Frameworks and example source for writing a JDBC driver.
Frameworks and example source for writing a JDBC driver.  Where can I find info, frameworks and example source for writing a JDBC driver
Data Source in Myeclipse - JDBC
Data Source in Myeclipse  How to create data source in MyEclipse 5.1.1 version .Here i cant find Myeclipe Report Design.Can u pls help
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.  String sql = "UPDATE emp_details SET empEname = ?, emailId = ?, guid =?, proximityCard =?, managerEmailId = ?, reviewerEmailId
Data Source - JDBC
Data Source  Hi, plz let me know why we r using Data Source . and how we will use in our java Code??? Thanks
open source data science
open source data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: open source... learn the topic "open source data science". Also tell me which
data science manager jobs
data science manager jobs  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: data science... learn the topic "data science manager jobs". Also tell me which
JDBC ODBC Connection In Java
a DSN to use JDBC ODBC Bridge driver. The DSN (Data Source Name) specifies... in the ODBC Data Source Administrator dialog box then, Click on Add button ->... to create DSN etc. JDBC-ODBC Bridge As its name JDBC-ODBC bridge, it acts like
JDBC-Odbc Connectivity
; DriverManager.getConnection ( ) :The Driver Manager call getConnection... ( ) : This method return you the property of the column's data type, size, the methods... JDBC-ODBC Connectivity     
open source data science masters
open source data science masters  Hi, I am beginner in Data Science... source data science masters Try to provide me good examples or tutorials links so that I can learn the topic "open source data science masters"
the open source data science masters
the open source data science masters  Hi, I am beginner in Data...: the open source data science masters Try to provide me good examples or tutorials links so that I can learn the topic "the open source data science
open source data science degree
open source data science degree  Hi, I am beginner in Data Science... source data science degree Try to provide me good examples or tutorials links so that I can learn the topic "open source data science degree". Also
best source to learn data science
best source to learn data science  Hi, I am beginner in Data Science... source to learn data science Try to provide me good examples or tutorials links so that I can learn the topic "best source to learn data science"
PHP SQL ODBC
to locate the database. Give Data Source Name (DSN). Click OK...-click on the Data Sources (ODBC) icon inside. Select System DSN tab. Click...)){   $id=odbc_result($rs,"id");   $name=odbc_result($rs
how to use StringTokenizer to retrieve the class name, attributes name and methods name from the Java Source Code
how to use StringTokenizer to retrieve the class name, attributes name and methods name from the Java Source Code  hi, I have done a program whereby... one problem which is retrieve the Class Name, Attributes Name and Methods Names
data science product manager jobs
data science product manager jobs  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: data... so that I can learn the topic "data science product manager jobs"
data science project manager jobs
data science project manager jobs  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: data... so that I can learn the topic "data science project manager jobs"
Product Components of JDBC
. The JDBC Driver Manager. 3. The JDBC Test Suite. 4. The JDBC-ODBC Bridge.ADS.... The JDBC Driver Manager. The JDBC Driver Manager is a very.... Usually  Driver Manager is the backbone of the JDBC architecture
ModuleNotFoundError: No module named 'poetry-data-manager'
ModuleNotFoundError: No module named 'poetry-data-manager'  Hi, My... named 'poetry-data-manager' How to remove the ModuleNotFoundError: No module named 'poetry-data-manager' error? Thanks   Hi
ModuleNotFoundError: No module named 'reference-data-manager'
ModuleNotFoundError: No module named 'reference-data-manager'  Hi...: No module named 'reference-data-manager' How to remove the ModuleNotFoundError: No module named 'reference-data-manager' error? Thanks   Hi
ModuleNotFoundError: No module named 'edc-data-manager'
ModuleNotFoundError: No module named 'edc-data-manager'  Hi, My... named 'edc-data-manager' How to remove the ModuleNotFoundError: No module named 'edc-data-manager' error? Thanks   Hi, In your
Spring data source C3P0
Spring data source C3P0 In Spring , we connect to a database via data source. When we are using jdbc layer in Spring , JNDI provide us data source or you can configure your own data source by implementing connection pool , provided
error getting repository data for epel repository not found centos 7
error getting repository data for epel repository not found centos 7  Hi, Can't find repository while installing one of the software using yum because of the error: error getting repository data for epel repository not found
error getting repository data for epel repository not found centos 7
error getting repository data for epel repository not found centos 7  Hi, Can't find repository while installing one of the software using yum because of the error: error getting repository data for epel repository not found
Php Sql ODBC
the database a Data Source Name (DSN). Click OK. Note that this configuration...-click on the Data Sources (ODBC) icon inside. Choose the System DSN tab...;);       $name=odbc_result($rs,"name");  
Which splunk component is used for getting data from data source
for getting data from a data source. Which splunk component is used for getting data from data source? Thanks   Hi, You can configure the datasource... information about the data source and configure it as data input source. After
jdbc odbc
jdbc odbc   i have two tables in database 1table's attribute..., `EMP_NAME` varchar(100) default NULL...) default NULL, `DEPT_NAME` varchar(255) default NULL
best source to learn python for data science
best source to learn python for data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: best source to learn python for data science Try to provide me good
How To Use Database Driver
it with JDBC driver manager. If the the class/driver you are loading not found...: JDBC-ODBC Bridge driver Type 2: Native-API/partly Java driver Type 3... today.ADS_TO_REPLACE_1 Driver Manager keeps track of all the database drivers
ODBC connection
ODBC connection   import java.sql.*; import java.util.*; public...=Class.forName("oracle.jdbc.driver.OracleDriver"); Driver d=(Driver... ODBC program,bt here I am getting error i.e Exception in Thread "main
ODBC connection
ODBC connection   import java.sql.*; import java.util.*; public...=Class.forName("oracle.jdbc.driver.OracleDriver"); Driver d=(Driver... ODBC program,bt here I am getting error i.e Exception in Thread "main
ODBC connection
ODBC connection   import java.sql.*; import java.util.*; public...=Class.forName("oracle.jdbc.driver.OracleDriver"); Driver d=(Driver... ODBC program,bt here I am getting error i.e Exception in Thread "main
data type used to store name.(getting an error)
data type used to store name.(getting an error)    Statement stm=con.createStatement(); String query="select * from employee where ename=\'"+ename+"\'"; ResultSet rs=stm.executeQuery(query
Open Source Download Manager
Open Source Download Manager Open source Download manager... and regularly updating them.    Free Download CFile Manager Open source...; Open source Limewire download manager LimeWire Download Manager
Guys Help me with this Application(when you put the name of the website it will return the IP of the web)
Guys Help me with this Application(when you put the name of the website it will return the IP of the web)  import java.awt.*; import java.awt.event.*; import java.net.*; import java.io.*; public class MyApp extends
Guys Help me with this Application(when you put the name of the website it will return the IP of the web)
Guys Help me with this Application(when you put the name of the website it will return the IP of the web)  import java.awt.*; import java.awt.event.*; import java.net.*; import java.io.*; public class MyApp extends
ModuleNotFoundError: No module named 'open_source_library_data_collector'
ModuleNotFoundError: No module named 'open_source_library_data_collector' ...: ModuleNotFoundError: No module named 'open_source_library_data_collector' How to remove the ModuleNotFoundError: No module named 'open_source_library_data_collector
JDBC Driver and Its Types
, and is closed  source. Client -> JDBC Driver -> ODBC...; JDBC Driver Manager The JDBC... JDBC-ODBC bridge plus ODBC driver, also called Type 1. Native
odbc - Java Beginners
What is odbc connection  What is odbc connection

Ads