oracle - Odbc Connection Error -
oracle - Odbc Connection Error -
i using odbc connection 64 bit windows 2012 server oracle database located @ 64 bit windows 2012 server.
i getting error:
error: library 'odbc' 'dbconnection' not valid physical location. error: sql error return: error: library 'odbc' 'dbconne. error: sql error return: error: library 'odbc' 'dbconne. error: library 'odbc' 'dbconnection' not valid physical location. error: sql error return: error: library 'odbc' 'dbc. error: sql error return: error: library 'odbc' 'dbc. error: library 'odbc' 'dbconnection' not valid physical location. error: sql error return: error: library 'odbc' 'dbc. error: sql error return: error: library 'odbc' 'dbc. error: library 'odbc' 'dbconnection' not valid physical location. error: sql error return: error: library 'odbc' 'dbconne. error: sql error return: error: library 'odbc' 'dbconne.
with dbconnection beingness name of odbc connection.
have installed 64 bit oracle client?
have configured tns using "net manager"? there button "test service". work?
have configured odbc scheme dsn connection using odbcad32.exe
? there "test connection" button.
you question without code , without connection string. error got may because connect string not correct.
examples pyodbc
documentation (https://code.google.com/p/pyodbc/wiki/gettingstarted):
cnxn = pyodbc.connect('driver={sql server};server=localhost;database=testdb;uid=me;pwd=pass')
and simpler when dsn configured:
cnxn = pyodbc.connect('dsn=test;pwd=password')
you find connection strings specific oracle at: http://www.connectionstrings.com/oracle-in-oraclient11g_home1/
but if have dsn configured , tested seek utilize it:
dsn=dbconnection;ui=username;pwd=password
oracle oracle11g odbc
Comments
Post a Comment