Skip to main content
Z
zybernau
Inspiring
October 19, 2010
Question

Connect to ORACLE database using SDKODBC Wrapper

  • October 19, 2010
  • 1 reply
  • 1088 views

hi everyone,

i have tried connecting to ms access database through SDKODBC Wrapper.

by the same way, i have also created a odbc connection from control panel-> admin tools -> ODBC connections.

for a oracle database.

i have also verified the URI and it says true.

URI is some thing like this,

"odbc://oradb?table=table_1&emp_no='123'#emp_name"

when i am trying to connect with the oracle DB it returns ODBC error

ISDKODBCWrapper::ODBCState mstate = sdk.Query(uri, WideString(newValue));

if (ISDKODBCWrapper::ODBCNormal == mstate)

do i need to configure in DB side so that it works fine?

thanks,

raja.

This topic has been closed for replies.

1 reply

Z
zybernauAuthor
Inspiring
October 19, 2010

here is the odbc trace log


odbcad32        e98-ed8 ENTER SQLAllocEnv 
  HENV *              0007BA8C
odbcad32        e98-ed8 EXIT  SQLAllocEnv  with return code 0 (SQL_SUCCESS)
  HENV *              0x0007BA8C ( 0x00a61540)
odbcad32        e98-ed8 ENTER SQLAllocConnect 
  HENV                00A61540
  HDBC *              0007BA94
odbcad32        e98-ed8 EXIT  SQLAllocConnect  with return code 0 (SQL_SUCCESS)
  HENV                00A61540
  HDBC *              0x0007BA94 ( 0x00a615e8)
odbcad32        e98-ed8 ENTER SQLDriverConnectW 
  HDBC                00A615E8
  HWND                00150EA2
  WCHAR *             0x74324EC8 [      -3] "******\ 0"
  SWORD                       -3 
  WCHAR *             0x74324EC8 
  SWORD                        2 
  SWORD *             0x00000000
  UWORD                        1 <SQL_DRIVER_COMPLETE>
odbcad32        e98-ed8 EXIT  SQLDriverConnectW  with return code 0 (SQL_SUCCESS)
  HDBC                00A615E8
  HWND                00150EA2
  WCHAR *             0x74324EC8 [      -3] "******\ 0"
  SWORD                       -3 
  WCHAR *             0x74324EC8 
  SWORD                        2 
  SWORD *             0x00000000
  UWORD                        1 <SQL_DRIVER_COMPLETE>
odbcad32        e98-ed8 ENTER SQLDisconnect 
  HDBC                00A615E8
odbcad32        e98-ed8 EXIT  SQLDisconnect  with return code 0 (SQL_SUCCESS)
  HDBC                00A615E8
odbcad32        e98-ed8 ENTER SQLFreeConnect 
  HDBC                00A615E8
odbcad32        e98-ed8 EXIT  SQLFreeConnect  with return code 0 (SQL_SUCCESS)
  HDBC                00A615E8
odbcad32        e98-ed8 ENTER SQLFreeEnv 
  HENV                00A61540
odbcad32        e98-ed8 EXIT  SQLFreeEnv  with return code 0 (SQL_SUCCESS)
  HENV                00A61540
InDesign        8d0-198 ENTER SQLAllocHandle 
  SQLSMALLINT                  1 <SQL_HANDLE_ENV>
  SQLHANDLE           00000000
  SQLHANDLE *         0012F6F0
InDesign        8d0-198 EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
  SQLSMALLINT                  1 <SQL_HANDLE_ENV>
  SQLHANDLE           00000000
  SQLHANDLE *         0x0012F6F0 ( 0x0fae1540)
InDesign        8d0-198 ENTER SQLSetEnvAttr 
  SQLHENV             0FAE1540
  SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
  SQLPOINTER          0x00000003
  SQLINTEGER                   0 
InDesign        8d0-198 EXIT  SQLSetEnvAttr  with return code 0 (SQL_SUCCESS)
  SQLHENV             0FAE1540
  SQLINTEGER                 200 <SQL_ATTR_ODBC_VERSION>
  SQLPOINTER          0x00000003 (BADMEM)
  SQLINTEGER                   0 
InDesign        8d0-198 ENTER SQLAllocHandle 
  SQLSMALLINT                  2 <SQL_HANDLE_DBC>
  SQLHANDLE           0FAE1540
  SQLHANDLE *         0012F6F4
InDesign        8d0-198 EXIT  SQLAllocHandle  with return code 0 (SQL_SUCCESS)
  SQLSMALLINT                  2 <SQL_HANDLE_DBC>
  SQLHANDLE           0FAE1540
  SQLHANDLE *         0x0012F6F4 ( 0x0fae15e8)
InDesign        8d0-198 ENTER SQLDriverConnectW 
  HDBC                0FAE15E8
  HWND                00000000
  WCHAR *             0x74324EC8 [      -3] "******\ 0"
  SWORD                       -3 
  WCHAR *             0x74324EC8 
  SWORD                        2 
  SWORD *             0x00000000
  UWORD                        0 <SQL_DRIVER_NOPROMPT>
InDesign        8d0-198 EXIT  SQLDriverConnectW  with return code -1 (SQL_ERROR)
  HDBC                0FAE15E8
  HWND                00000000
  WCHAR *             0x74324EC8 [      -3] "******\ 0"
  SWORD                       -3 
  WCHAR *             0x74324EC8 
  SWORD                        2 
  SWORD *             0x00000000
  UWORD                        0 <SQL_DRIVER_NOPROMPT>
  DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) 
InDesign        8d0-198 ENTER SQLDriverConnectW 
  HDBC                0FAE15E8
  HWND                00000000
  WCHAR *             0x74324EC8 [      -3] "******\ 0"
  SWORD                       -3 
  WCHAR *             0x74324EC8 
  SWORD                        2 
  SWORD *             0x00000000
  UWORD                        0 <SQL_DRIVER_NOPROMPT>
InDesign        8d0-198 EXIT  SQLDriverConnectW  with return code -1 (SQL_ERROR)
  HDBC                0FAE15E8
  HWND                00000000
  WCHAR *             0x74324EC8 [      -3] "******\ 0"
  SWORD                       -3 
  WCHAR *             0x74324EC8 
  SWORD                        2 
  SWORD *             0x00000000
  UWORD                        0 <SQL_DRIVER_NOPROMPT>
  DIAG [HY000] General error: Invalid file dsn '' (556) 
InDesign        8d0-198 ENTER SQLDisconnect 
  HDBC                0FAE15E8
InDesign        8d0-198 EXIT  SQLDisconnect  with return code -1 (SQL_ERROR)
  HDBC                0FAE15E8
  DIAG [08003] [Microsoft][ODBC Driver Manager] Connection not open (0) 
InDesign        8d0-198 ENTER SQLFreeHandle 
  SQLSMALLINT                  2 <SQL_HANDLE_DBC>
  SQLHANDLE           0FAE15E8
InDesign        8d0-198 EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
  SQLSMALLINT                  2 <SQL_HANDLE_DBC>
  SQLHANDLE           0FAE15E8
InDesign        8d0-198 ENTER SQLFreeHandle 
  SQLSMALLINT                  1 <SQL_HANDLE_ENV>
  SQLHANDLE           0FAE1540
InDesign        8d0-198 EXIT  SQLFreeHandle  with return code 0 (SQL_SUCCESS)
  SQLSMALLINT                  1 <SQL_HANDLE_ENV>
  SQLHANDLE           0FAE1540
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices