Hi All,
I have been working on trying to get access via the ODBC with limited success and
a lot of frustration. At this point, the only place that I can get data to return is in a
Windows 10 machine running Excel 2010. Windows 10 with Excel will just spin even
though when you get into the SQL Query manager you can pull the data that you are
looking for.
I have been able communicate with the OBDC driver using JDBC which would be my
preferred method to utilize the OBDC. I have included here the URL string that I used
for the driver connection and two different outputs. One is a debug output and the other
is a trace from the OBDC driver. What I see is that when I use the Sample Data I get
a missing ADSPROF.PCE error so to me that means that I am talking directly to the
Adagio ODBC driver. When I use backup of the production data, I get the errors below.
Which appear to be a (-1) from the vendor and an SQLState of 28000 which is
an authorization issue. The user and password are correct, we have a license for ODBC
and it is clear that I am communication with the Adagio OBDC Data Driver(Version 9.2A).
Can someone see what I am missing in my URL string that I should have? I have yet to find a
good source of documentation for this level of interaction with the driver. If someone
could point me at it that would be great!
Thanks!
Brian
String conStr = "jdbc:odbc:"
+ "Driver=AdagioDataSourceDriver;"
+ "Names=LONG;"
+ "DBSelelector=PCE;"
+ "Columns=COMMON;"
+ "DBDirectory=<hidden>;"
+ "DBQ=<Same as hidden>;"
+ "READONLY=true;"
+ "UserID=<User>;"
+ "Password=<Pass>;"
+ "TablesAll=FALSE;"
+ "DBFilter=*";
From the Debug Output :DriverManager.getConnection("jdbc:odbc:Driver=AdagioDataSourceDriver;Names=LONG;DBSelelector=PCE;Columns=COMMON;DBDirectory=<hidden>;DBQ=<same as hidden> ;READONLY=true;UserID=<User>;Password=<Pass>;TablesAll=FALSE;DBFilter=*")
trying sun.jdbc.odbc.JdbcOdbcDriver
*Driver.connect (jdbc:odbc:Driver=AdagioDataSourceDriver;Names=LONG;DBSelelector=PCE;Columns=COMMON;DBDirectory=<hidden>;DBQ=<same as hidden>;READONLY=true;UserID=<User>;Password=<Pass>;TablesAll=FALSE;DBFilter=*)
JDBC to ODBC Bridge: Checking security
No SecurityManager present, assuming trusted application/applet
JDBC to ODBC Bridge 2.0001
Current Date/Time: Mon Apr 03 14:25:30 MST 2017
Loading JdbcOdbc library
Allocating Environment handle (SQLAllocEnv)
hEnv=16299776
Allocating Connection handle (SQLAllocConnect)
hDbc=16300000
Connecting (SQLDriverConnect), hDbc=16300000, szConnStrIn=Driver=AdagioDataSourceDriver;Names=LONG;DBSelelector=PCE;Columns=COMMON;DBDirectory=<Hidden>;DBQ=<Same as Hidden>;READONLY=true;UserID=<User>;Password=<Pass>;TablesAll=FALSE;DBFilter=*;UID=<User>;PWD=<Pass>
RETCODE = -1
ERROR - Generating SQLException...
SQLState(28000) vendor code(-1)
java.sql.SQLException: [DSI]: Error message not found: Connect Failed
From the SQL Log File:bin" com.peaces 2398-6ec EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x000000000082D1D0
HDBC * 0x000000000244EEA0 ( 0x000000000082D2B0)
bin" com.peaces 2398-6ec ENTER SQLDriverConnectW
HDBC 0x000000000082D2B0
HWND 0x0000000000000000
WCHAR * 0x000007FC10D05828 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x000007FC10D05828
SWORD -3
SWORD * 0x0000000000000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
bin" com.peaces 2398-6ec EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x000000000082D2B0
HWND 0x0000000000000000
WCHAR * 0x000007FC10D05828 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x000007FC10D05828
SWORD -3
SWORD * 0x0000000000000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [28000] [DSI]: Error message not found: Connect Failed (-1)
Previous Topic
Index
