on 02-21-2014 10:04 PM
When trying to execute a query through the ODBC driver upon initial connection the first query will be successful; however, the second query and any successive fail and return this error message: [Sybase][ODBC DRIVER][SQL Anywhere]Invalid user Id or Password.
Computer specs:
SQL Anywhere version 11
Windows 7 64-bit
Does anyone know why this might be happening and if there is anyway to correct this problem?
Hi Justin,
How exactly are you executing the query through the ODBC driver - is it a third-party program, or an ODBC application you wrote, or...?
Regards,
Jeff Albion
SAP Active Global Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Both the third-party program database browser (http://download.cnet.com/Database-Browser/3000-10254_4-10505025.html) and a custom perl script I wrote are exhibiting the same problems. The dbisql utility included with sql anywhere seems to work with out issues.
Hi Justin,
Are both programs specifying the login information on the connection string (i.e. "UID=username;PWD=password"), or are they using a Data Source Name (DSN) specified in the ODBC Data Source Administrator? Are they creating one connection, or multiple connections?
If they use a DSN, can you test to confirm that the DSN can first connect successfully in the ODBC Administrator?
Can you create an ODBC trace with the other two programs to demonstrate the login problem?
Regards,
Jeff Albion
SAP Active Global Support
Both are using the username, password, and dns.
For example:
$sybase_username = qq{'username'}; |
$sybase_password = qq{'password'};
$ENV{DBI_USER} = $sybase_username;
$ENV{DBI_PASS} = $sybase_password;
my $dsn = 'dbi:ODBC:Micros';
my $dbh = DBI->connect($dsn, $sybase_username, $sybase_password);
It is one connection. It will execute one query without a problem, but even if I add a join to the query it will fail.
The ODBC administrator reports that the connection is successful.
Here is the output of the ODBC trace:
Fri Feb 28 2014 15:13:00
15:13:00 Attempting to connect using:
UID=support;PWD=********;DBN=micros;DBF=D:\MICROS\Database\Data\micros.db;ENG=sqlMCRSERVER;START=D:\MICROS\Common\Bin\SrvcStartDB.exe;CON=SQL_DBC_3d536a0;ASTOP=YES;INT=NO;DBG=YES;LOG=C:\Users\Manager\Documents\odbclog.txt;DMRF
15:13:00 Attempting to connect to a running server...
15:13:00 Trying to start SharedMemory link ...
15:13:00 SharedMemory link started successfully
15:13:00 Attempting SharedMemory connection (no sasrv.ini cached address)
15:13:00 Connected to server over SharedMemory
15:13:00 Connected to SQL Anywhere Server version 11.0.1.2596
15:13:00 Application information:
15:13:00 IP=192.168.100.250;HOST=MCRSERVER;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:\Program Files (x86)\Vigilix\Bin\VxAgent.exe';PID=0xf48;THREAD=0x550;VERSION=11.0.1.2472;API=ODBC;TIMEZONEADJUSTMENT=-360
15:13:00 Connected to the server, attempting to connect to a running database...
15:13:00 [37765] Connected to database successfully
Fri Feb 28 2014 15:13:08
15:13:08 Attempting to connect using:
UID='''support''';PWD=********;DBN=micros;DBF=D:\MICROS\Database\Data\micros.db;ENG=sqlMCRSERVER;START=D:\MICROS\Common\Bin\SrvcStartDB.exe;CON=SQL_DBC_4aed838;ASTOP=YES;INT=NO;DBG=YES;LOG=C:\Users\Manager\Documents\odbclog.tx
15:13:08 Attempting to connect to a running server...
15:13:08 Trying to start SharedMemory link ...
15:13:08 SharedMemory link started successfully
15:13:08 Attempting SharedMemory connection (no sasrv.ini cached address)
15:13:08 Connected to server over SharedMemory
15:13:08 Connected to SQL Anywhere Server version 11.0.1.2596
15:13:08 Application information:
15:13:08 IP=192.168.100.250;HOST=MCRSERVER;OSUSER=Manager;OS='Windows 7 Build 7601 Service Pack 1';EXE=c:\perl\bin\perl.exe;PID=0x1a40;THREAD=0x1b1c;VERSION=11.0.1.2472;API=ODBC;TIMEZONEADJUSTMENT=-360
15:13:08 Connected to the server, attempting to connect to a running database...
15:13:08 Database is running, but could not connect to it
15:13:08 Invalid user ID or password
Hi Justin,
Your second connection is picking up slightly different information passed in to the username field:
Notice the appended single quotes around the 'support' username in your second connection attempt.
Regards,
Jeff Albion
SAP Active Global Support
This problems still hasn't been resolved and we have another client that has upgraded to Windows 7 64-bit with SQL Anywhere 11. They are experiencing the same problems as the previous client.
Here is a stack trace of the perl script trying to communicate with SQL anywhere.
perl rerun-mic 11b4-1b8c ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00000000
SQLHANDLE * 0x033EE1A8
perl rerun-mic 11b4-1b8c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x00000000
SQLHANDLE * 0x033EE1A8 ( 0x033EE1C0)
perl rerun-mic 11b4-1b8c ENTER SQLSetEnvAttr
SQLHENV 0x033EE1C0
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER -6
perl rerun-mic 11b4-1b8c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x033EE1C0
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 3 <SQL_OV_ODBC3>
SQLINTEGER -6
perl rerun-mic 11b4-1b8c ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x033EE1C0
SQLHANDLE * 0x03817DC4
perl rerun-mic 11b4-1b8c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x033EE1C0
SQLHANDLE * 0x03817DC4 ( 0x03413E00)
perl rerun-mic 11b4-1b8c ENTER SQLDriverConnectW
HDBC 0x03413E00
HWND 0x00000000
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x72D58B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
perl rerun-mic 11b4-1b8c EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x03413E00
HWND 0x00000000
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x72D58B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
DIAG [01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0)
perl rerun-mic 11b4-1b8c ENTER SQLErrorW
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB4C
SDWORD * 0x0140ED88
WCHAR * 0x0140E74C
SWORD 511
SWORD * 0x0140ED92
perl rerun-mic 11b4-1b8c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB4C [ 5] "IM002"
SDWORD * 0x0140ED88 (0)
WCHAR * 0x0140E74C [ 91] "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
SWORD 511
SWORD * 0x0140ED92 (91)
perl rerun-mic 11b4-1b8c ENTER SQLErrorW
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB4C
SDWORD * 0x0140ED88
WCHAR * 0x0140E74C
SWORD 511
SWORD * 0x0140ED92
perl rerun-mic 11b4-1b8c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB4C [ 5] "01S00"
SDWORD * 0x0140ED88 (0)
WCHAR * 0x0140E74C [ 68] "[Microsoft][ODBC Driver Manager] Invalid connection string attribute"
SWORD 511
SWORD * 0x0140ED92 (68)
perl rerun-mic 11b4-1b8c ENTER SQLErrorW
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB4C
SDWORD * 0x0140ED88
WCHAR * 0x0140E74C
SWORD 511
SWORD * 0x0140ED92
perl rerun-mic 11b4-1b8c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB4C
SDWORD * 0x0140ED88
WCHAR * 0x0140E74C
SWORD 511
SWORD * 0x0140ED92
perl rerun-mic 11b4-1b8c ENTER SQLConnectW
HDBC 0x03413E00
WCHAR * 0x037F6238 [ 6] "Micros"
SWORD 6
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
perl rerun-mic 11b4-1b8c EXIT SQLConnectW with return code -1 (SQL_ERROR)
HDBC 0x03413E00
WCHAR * 0x037F6238 [ 6] "Micros"
SWORD 6
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
DIAG [28000] [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password (-103)
perl rerun-mic 11b4-1b8c ENTER SQLErrorW
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB18
SDWORD * 0x0140ED60
WCHAR * 0x0140E718
SWORD 511
SWORD * 0x0140ED7E
perl rerun-mic 11b4-1b8c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB18 [ 5] "28000"
SDWORD * 0x0140ED60 (-103)
WCHAR * 0x0140E718 [ 62] "[Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password"
SWORD 511
SWORD * 0x0140ED7E (62)
perl rerun-mic 11b4-1b8c ENTER SQLErrorW
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB18
SDWORD * 0x0140ED60
WCHAR * 0x0140E718
SWORD 511
SWORD * 0x0140ED7E
perl rerun-mic 11b4-1b8c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 0x033EE1C0
HDBC 0x03413E00
HSTMT 0x00000000
WCHAR * 0x0140EB18
SDWORD * 0x0140ED60
WCHAR * 0x0140E718
SWORD 511
SWORD * 0x0140ED7E
perl rerun-mic 11b4-1b8c ENTER SQLErrorW
HENV 0x033EE1C0
HDBC 0x00000000
HSTMT 0x00000000
WCHAR * 0x0140EB18
SDWORD * 0x0140ED60
WCHAR * 0x0140E718
SWORD 511
SWORD * 0x0140ED7E
perl rerun-mic 11b4-1b8c EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 0x033EE1C0
HDBC 0x00000000
HSTMT 0x00000000
WCHAR * 0x0140EB18
SDWORD * 0x0140ED60
WCHAR * 0x0140E718
SWORD 511
SWORD * 0x0140ED7E
perl rerun-mic 11b4-1b8c ENTER SQLFreeHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x03413E00
perl rerun-mic 11b4-1b8c EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x03413E00
perl rerun-mic 11b4-1b8c ENTER SQLFreeHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x033EE1C0
perl rerun-mic 11b4-1b8c EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 0x033EE1C0
Also here is some more of a stack trace from the database browser program:
databasebrowser 1070-16c0 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 0x025417B8
SQLSMALLINT 2
SQLWCHAR * 0x0018E500
SQLINTEGER * 0x0018E0D8
SQLWCHAR * 0x0018E100
SQLSMALLINT 512
SQLSMALLINT * 0x0018E0E8
databasebrowser 1070-16c0 ENTER SQLColAttributesW
HSTMT 0x025417B8
UWORD 14
UWORD 11 <SQL_DESC_AUTO_UNIQUE_VALUE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0018E584
databasebrowser 1070-16c0 EXIT SQLColAttributesW with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 14
UWORD 11 <SQL_DESC_AUTO_UNIQUE_VALUE>
PTR 0x00000000
SWORD 0
SWORD * 0x00000000
SQLLEN * 0x0018E584 (0)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x00000000
SWORD 0
SWORD * 0x0018E678
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 1 (SQL_SUCCESS_WITH_INFO)
HDBC 0x025414D8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x00000000 <null pointer>
SWORD 0
SWORD * 0x0018E678 (24)
DIAG [01004] [Sybase][ODBC Driver]Data truncated (0)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x0392CDD8
SWORD 26
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 17 <SQL_DBMS_NAME>
PTR 0x0392CDD8 [ -3] "SQL Anywhere\ 0"
SWORD 26
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 36 <SQL_MULT_RESULT_SETS>
PTR 0x0018E67C
SWORD 4
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 36 <SQL_MULT_RESULT_SETS>
PTR 0x0018E67C [ -3] "Y\ 0"
SWORD 4
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 39 <SQL_OWNER_TERM>
PTR 0x00000000
SWORD 0
SWORD * 0x0018E678
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 1 (SQL_SUCCESS_WITH_INFO)
HDBC 0x025414D8
UWORD 39 <SQL_OWNER_TERM>
PTR 0x00000000 <null pointer>
SWORD 0
SWORD * 0x0018E678 (14)
DIAG [01004] [Sybase][ODBC Driver]Data truncated (0)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 39 <SQL_OWNER_TERM>
PTR 0x0392FA60
SWORD 16
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 39 <SQL_OWNER_TERM>
PTR 0x0392FA60 [ -3] "Creator\ 0"
SWORD 16
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 18 <SQL_DBMS_VER>
PTR 0x00000000
SWORD 0
SWORD * 0x0018E678
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 1 (SQL_SUCCESS_WITH_INFO)
HDBC 0x025414D8
UWORD 18 <SQL_DBMS_VER>
PTR 0x00000000 <null pointer>
SWORD 0
SWORD * 0x0018E678 (20)
DIAG [01004] [Sybase][ODBC Driver]Data truncated (0)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 18 <SQL_DBMS_VER>
PTR 0x0392DB98
SWORD 22
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 18 <SQL_DBMS_VER>
PTR 0x0392DB98 [ -3] "11.00.0001\ 0"
SWORD 22
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x00000000
SWORD 2048
SWORD * 0x0018E958
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x00000000 <null pointer>
SWORD 2048
SWORD * 0x0018E958 (2)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x00AF373C
SWORD 4
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 29 <SQL_IDENTIFIER_QUOTE_CHAR>
PTR 0x00AF373C [ -3] ""\ 0"
SWORD 4
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 41 <SQL_CATALOG_NAME_SEPARATOR>
PTR 0x00000000
SWORD 2048
SWORD * 0x0018E958
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 41 <SQL_CATALOG_NAME_SEPARATOR>
PTR 0x00000000 <null pointer>
SWORD 2048
SWORD * 0x0018E958 (0)
databasebrowser 1070-16c0 ENTER SQLAllocStmt
HDBC 0x025414D8
HSTMT * 0x0018E888
databasebrowser 1070-16c0 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
HSTMT * 0x0018E888 ( 0x00A6D138)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 93 <SQL_QUOTED_IDENTIFIER_CASE>
PTR 0x0018E8D0
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 93 <SQL_QUOTED_IDENTIFIER_CASE>
PTR 0x0018E8D0 (4) <SQL_IC_MIXED>
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0018E8BC
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0018E8BC (0)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0018E8BC
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0018E8BC (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0018E8BC
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0018E8BC (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0018E8BC
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0018E8BC (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0018E8BC
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0018E8BC (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLPrimaryKeysW
HSTMT 0x00A6D138
WCHAR * 0x00000000 <null pointer>
SWORD -3
WCHAR * 0x00ADB9FC [ -3] "dbo\ 0"
SWORD -3
WCHAR * 0x00AD9124 [ -3] "jdbc_helpkeys\ 0"
SWORD -3
databasebrowser 1070-16c0 EXIT SQLPrimaryKeysW with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
WCHAR * 0x00000000 <null pointer>
SWORD -3
WCHAR * 0x00ADB9FC [ -3] "dbo\ 0"
SWORD -3
WCHAR * 0x00AD9124 [ -3] "jdbc_helpkeys\ 0"
SWORD -3
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6840
SQLLEN 256
SQLLEN * 0x042F683C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6840
SQLLEN 256
SQLLEN * 0x042F683C (60077336)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6948
SQLLEN 258
SQLLEN * 0x042F6944
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6948
SQLLEN 258
SQLLEN * 0x042F6944 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6A58
SQLLEN 258
SQLLEN * 0x042F6A54
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6A58
SQLLEN 258
SQLLEN * 0x042F6A54 (1560)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 4
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6B68
SQLLEN 258
SQLLEN * 0x042F6B64
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 4
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6B68
SQLLEN 258
SQLLEN * 0x042F6B64 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 5
SWORD -18 <SQL_C_BOOKMARK>
PTR 0x042F6CA0
SQLLEN 4
SQLLEN * 0x042F6C9C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 5
SWORD -18 <SQL_C_BOOKMARK>
PTR 0x042F6CA0
SQLLEN 4
SQLLEN * 0x042F6C9C (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 6
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6CB0
SQLLEN 258
SQLLEN * 0x042F6CAC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 6
SWORD 1 <SQL_C_CHAR>
PTR 0x042F6CB0
SQLLEN 258
SQLLEN * 0x042F6CAC (2160)
databasebrowser 1070-16c0 ENTER SQLFetch
HSTMT 0x00A6D138
databasebrowser 1070-16c0 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 0x00A6D138
databasebrowser 1070-16c0 ENTER SQLFreeStmt
HSTMT 0x00A6D138
UWORD 1 <SQL_DROP>
databasebrowser 1070-16c0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 1 <SQL_DROP>
databasebrowser 1070-16c0 ENTER SQLAllocStmt
HDBC 0x025414D8
HSTMT * 0x0018E868
databasebrowser 1070-16c0 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
HSTMT * 0x0018E868 ( 0x00A6D138)
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 93 <SQL_QUOTED_IDENTIFIER_CASE>
PTR 0x0018E8B0
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 93 <SQL_QUOTED_IDENTIFIER_CASE>
PTR 0x0018E8B0 (4) <SQL_IC_MIXED>
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0018E89C (0)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0018E89C (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0018E89C (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 30 <SQL_MAX_COLUMN_NAME_LEN>
PTR 0x0018E89C (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 34 <SQL_MAX_CATALOG_NAME_LEN>
PTR 0x0018E89C (0)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 32 <SQL_MAX_SCHEMA_NAME_LEN>
PTR 0x0018E89C (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0018E89C
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 35 <SQL_MAX_TABLE_NAME_LEN>
PTR 0x0018E89C (128)
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLGetInfoW
HDBC 0x025414D8
UWORD 85 <SQL_NULL_COLLATION>
PTR 0x0393D3B8
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
HDBC 0x025414D8
UWORD 85 <SQL_NULL_COLLATION>
PTR 0x0393D3B8 (1) <SQL_NC_LOW>
SWORD 2
SWORD * 0x00000000
databasebrowser 1070-16c0 ENTER SQLStatisticsW
HSTMT 0x00A6D138
WCHAR * 0x00000000 <null pointer>
SWORD -3
WCHAR * 0x00AD9124 [ -3] "dbo\ 0"
SWORD -3
WCHAR * 0x00AD914C [ -3] "jdbc_helpkeys\ 0"
SWORD -3
UWORD 1 <SQL_INDEX_ALL>
UWORD 1 <SQL_ENSURE>
databasebrowser 1070-16c0 EXIT SQLStatisticsW with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
WCHAR * 0x00000000 <null pointer>
SWORD -3
WCHAR * 0x00AD9124 [ -3] "dbo\ 0"
SWORD -3
WCHAR * 0x00AD914C [ -3] "jdbc_helpkeys\ 0"
SWORD -3
UWORD 1 <SQL_INDEX_ALL>
UWORD 1 <SQL_ENSURE>
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8360
SQLLEN 256
SQLLEN * 0x042F835C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8360
SQLLEN 256
SQLLEN * 0x042F835C (70189128)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8468
SQLLEN 258
SQLLEN * 0x042F8464
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8468
SQLLEN 258
SQLLEN * 0x042F8464 (4980821)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8578
SQLLEN 258
SQLLEN * 0x042F8574
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8578
SQLLEN 258
SQLLEN * 0x042F8574 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 5
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8688
SQLLEN 256
SQLLEN * 0x042F8684
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 5
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8688
SQLLEN 256
SQLLEN * 0x042F8684 (2555904)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 6
SWORD 1 <SQL_C_CHAR>
PTR 0x042F88A0
SQLLEN 258
SQLLEN * 0x042F889C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 6
SWORD 1 <SQL_C_CHAR>
PTR 0x042F88A0
SQLLEN 258
SQLLEN * 0x042F889C (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 4
SWORD 5 <SQL_C_SHORT>
PTR 0x042F89C0
SQLLEN 2
SQLLEN * 0x042F89BC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 4
SWORD 5 <SQL_C_SHORT>
PTR 0x042F89C0
SQLLEN 2
SQLLEN * 0x042F89BC (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 7
SWORD 5 <SQL_C_SHORT>
PTR 0x042F89E0
SQLLEN 2
SQLLEN * 0x042F89DC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 7
SWORD 5 <SQL_C_SHORT>
PTR 0x042F89E0
SQLLEN 2
SQLLEN * 0x042F89DC (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 8
SWORD -18 <SQL_C_BOOKMARK>
PTR 0x042F8A38
SQLLEN 4
SQLLEN * 0x042F8A34
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 8
SWORD -18 <SQL_C_BOOKMARK>
PTR 0x042F8A38
SQLLEN 4
SQLLEN * 0x042F8A34 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 9
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8A48
SQLLEN 258
SQLLEN * 0x042F8A44
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 9
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8A48
SQLLEN 258
SQLLEN * 0x042F8A44 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 10
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8B68
SQLLEN 3
SQLLEN * 0x042F8B64
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 10
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8B68
SQLLEN 3
SQLLEN * 0x042F8B64 (6422628)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 11
SWORD -16 <SQL_C_SLONG>
PTR 0x042F8B78
SQLLEN 8
SQLLEN * 0x042F8B74
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 11
SWORD -16 <SQL_C_SLONG>
PTR 0x042F8B78
SQLLEN 8
SQLLEN * 0x042F8B74 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 12
SWORD -16 <SQL_C_SLONG>
PTR 0x042F8B88
SQLLEN 4
SQLLEN * 0x042F8B84
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 12
SWORD -16 <SQL_C_SLONG>
PTR 0x042F8B88
SQLLEN 4
SQLLEN * 0x042F8B84 (0)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x00A6D138
UWORD 13
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8B98
SQLLEN 258
SQLLEN * 0x042F8B94
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 13
SWORD 1 <SQL_C_CHAR>
PTR 0x042F8B98
SQLLEN 258
SQLLEN * 0x042F8B94 (0)
databasebrowser 1070-16c0 ENTER SQLFetch
HSTMT 0x00A6D138
databasebrowser 1070-16c0 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
databasebrowser 1070-16c0 ENTER SQLFetch
HSTMT 0x00A6D138
databasebrowser 1070-16c0 EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 0x00A6D138
databasebrowser 1070-16c0 ENTER SQLFreeStmt
HSTMT 0x00A6D138
UWORD 1 <SQL_DROP>
databasebrowser 1070-16c0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x00A6D138
UWORD 1 <SQL_DROP>
databasebrowser 1070-16c0 ENTER SQLGetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x0018E838
SQLINTEGER -5
SQLINTEGER * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x0018E838 (0) <SQL_CURSOR_FORWARD_ONLY>
SQLINTEGER -5
SQLINTEGER * 0x00000000
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 9 <SQL_ROWSET_SIZE>
SQLPOINTER 2
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 9 <SQL_ROWSET_SIZE>
SQLPOINTER 2
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLGetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 9 <SQL_ROWSET_SIZE>
SQLPOINTER 0x0018E834
SQLINTEGER -5
SQLINTEGER * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 9 <SQL_ROWSET_SIZE>
SQLPOINTER 0x0018E834 (2)
SQLINTEGER -5
SQLINTEGER * 0x00000000
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 1576 <unknown>
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 1576 <unknown>
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 23 <SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 0x0018E848
SQLINTEGER -4
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 23 <SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 0x0018E848
SQLINTEGER -4
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 23 <SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 0x00000000
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 23 <SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 0x00000000
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 11 <SQL_ATTR_RETRIEVE_DATA>
SQLPOINTER 0 <SQL_RD_OFF>
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 11 <SQL_ATTR_RETRIEVE_DATA>
SQLPOINTER 0 <SQL_RD_OFF>
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 11 <SQL_ATTR_RETRIEVE_DATA>
SQLPOINTER 1 <SQL_RD_ON>
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 11 <SQL_ATTR_RETRIEVE_DATA>
SQLPOINTER 1 <SQL_RD_ON>
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 23 <SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 0x0392CDE8
SQLINTEGER -4
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 23 <SQL_ATTR_ROW_BIND_OFFSET_PTR>
SQLPOINTER 0x0392CDE8
SQLINTEGER -4
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00000050
SQLLEN 129
SQLLEN * 0x0000004C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x00000050
SQLLEN 129
SQLLEN * 0x0000004C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x000000E0
SQLLEN 129
SQLLEN * 0x000000DC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x000000E0
SQLLEN 129
SQLLEN * 0x000000DC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x00000170
SQLLEN 129
SQLLEN * 0x0000016C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x00000170
SQLLEN 129
SQLLEN * 0x0000016C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 4
SWORD 1 <SQL_C_CHAR>
PTR 0x00000200
SQLLEN 129
SQLLEN * 0x000001FC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 4
SWORD 1 <SQL_C_CHAR>
PTR 0x00000200
SQLLEN 129
SQLLEN * 0x000001FC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 5
SWORD 1 <SQL_C_CHAR>
PTR 0x00000290
SQLLEN 129
SQLLEN * 0x0000028C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 5
SWORD 1 <SQL_C_CHAR>
PTR 0x00000290
SQLLEN 129
SQLLEN * 0x0000028C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 6
SWORD 1 <SQL_C_CHAR>
PTR 0x00000320
SQLLEN 129
SQLLEN * 0x0000031C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 6
SWORD 1 <SQL_C_CHAR>
PTR 0x00000320
SQLLEN 129
SQLLEN * 0x0000031C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 7
SWORD 1 <SQL_C_CHAR>
PTR 0x000003B0
SQLLEN 129
SQLLEN * 0x000003AC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 7
SWORD 1 <SQL_C_CHAR>
PTR 0x000003B0
SQLLEN 129
SQLLEN * 0x000003AC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 8
SWORD 1 <SQL_C_CHAR>
PTR 0x00000440
SQLLEN 129
SQLLEN * 0x0000043C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 8
SWORD 1 <SQL_C_CHAR>
PTR 0x00000440
SQLLEN 129
SQLLEN * 0x0000043C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 9
SWORD -28 <SQL_C_UTINYINT>
PTR 0x000004D0
SQLLEN 1
SQLLEN * 0x000004CC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 9
SWORD -28 <SQL_C_UTINYINT>
PTR 0x000004D0
SQLLEN 1
SQLLEN * 0x000004CC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 10
SWORD -28 <SQL_C_UTINYINT>
PTR 0x000004E0
SQLLEN 1
SQLLEN * 0x000004DC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 10
SWORD -28 <SQL_C_UTINYINT>
PTR 0x000004E0
SQLLEN 1
SQLLEN * 0x000004DC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 11
SWORD -28 <SQL_C_UTINYINT>
PTR 0x000004F0
SQLLEN 1
SQLLEN * 0x000004EC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 11
SWORD -28 <SQL_C_UTINYINT>
PTR 0x000004F0
SQLLEN 1
SQLLEN * 0x000004EC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 12
SWORD 1 <SQL_C_CHAR>
PTR 0x00000500
SQLLEN 129
SQLLEN * 0x000004FC
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 12
SWORD 1 <SQL_C_CHAR>
PTR 0x00000500
SQLLEN 129
SQLLEN * 0x000004FC (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 13
SWORD 1 <SQL_C_CHAR>
PTR 0x00000590
SQLLEN 129
SQLLEN * 0x0000058C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 13
SWORD 1 <SQL_C_CHAR>
PTR 0x00000590
SQLLEN 129
SQLLEN * 0x0000058C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLBindCol
HSTMT 0x025417B8
UWORD 14
SWORD -28 <SQL_C_UTINYINT>
PTR 0x00000620
SQLLEN 1
SQLLEN * 0x0000061C
databasebrowser 1070-16c0 EXIT SQLBindCol with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 14
SWORD -28 <SQL_C_UTINYINT>
PTR 0x00000620
SQLLEN 1
SQLLEN * 0x0000061C (BADMEM)
databasebrowser 1070-16c0 ENTER SQLSetStmtAttrW
SQLHSTMT 0x025417B8
SQLINTEGER 9 <SQL_ROWSET_SIZE>
SQLPOINTER 1
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x025417B8
SQLINTEGER 9 <SQL_ROWSET_SIZE>
SQLPOINTER 1
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLExtendedFetch
HSTMT 0x025417B8
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 0
SQLULEN * 0x0018E82C
UWORD * 0x0392E3D0
databasebrowser 1070-16c0 EXIT SQLExtendedFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 0x025417B8
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 0
SQLULEN * 0x0018E82C
UWORD * 0x0392E3D0
databasebrowser 1070-16c0 ENTER SQLFreeStmt
HSTMT 0x025417B8
UWORD 2 <SQL_UNBIND>
databasebrowser 1070-16c0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 2 <SQL_UNBIND>
databasebrowser 1070-16c0 ENTER SQLMoreResults
HSTMT 0x025417B8
databasebrowser 1070-16c0 EXIT SQLMoreResults with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 0x025417B8
databasebrowser 1070-16c0 ENTER SQLGetDiagFieldW
SQLSMALLINT 3
SQLHANDLE 0x025417B8
SQLSMALLINT 0
SQLSMALLINT -1249
SQLPOINTER 0x03944A64
SQLSMALLINT 4
SQLSMALLINT * 0x00000000
databasebrowser 1070-16c0 EXIT SQLGetDiagFieldW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3
SQLHANDLE 0x025417B8
SQLSMALLINT 0
SQLSMALLINT -1249
SQLPOINTER 0x03944A64
SQLSMALLINT 4
SQLSMALLINT * 0x00000000
databasebrowser 1070-16c0 ENTER SQLFreeStmt
HSTMT 0x025417B8
UWORD 0 <SQL_CLOSE>
databasebrowser 1070-16c0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 0 <SQL_CLOSE>
databasebrowser 1070-16c0 ENTER SQLFreeStmt
HSTMT 0x025417B8
UWORD 1 <SQL_DROP>
databasebrowser 1070-16c0 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 0x025417B8
UWORD 1 <SQL_DROP>
databasebrowser 1070-16c0 ENTER SQLAllocConnect
HENV 0x02540DF8
HDBC * 0x0018EC88
databasebrowser 1070-16c0 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x02540DF8
HDBC * 0x0018EC88 ( 0x025417B8)
databasebrowser 1070-16c0 ENTER SQLSetConnectAttrW
SQLHDBC 0x025417B8
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 15
SQLINTEGER -6
databasebrowser 1070-16c0 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 0x025417B8
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 15
SQLINTEGER -6
databasebrowser 1070-16c0 ENTER SQLDriverConnectW
HDBC 0x025417B8
HWND 0x00000000
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x72D58B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
databasebrowser 1070-16c0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x025417B8
HWND 0x00000000
WCHAR * 0x72D58B34 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x72D58B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [28000] [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password (-103)
databasebrowser 1070-16c0 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x025417B8
SQLSMALLINT 1
SQLWCHAR * 0x0018EBEC
SQLINTEGER * 0x0018E7C4
SQLWCHAR * 0x0018E7EC
SQLSMALLINT 512
SQLSMALLINT * 0x0018E7D4
databasebrowser 1070-16c0 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x025417B8
SQLSMALLINT 1
SQLWCHAR * 0x0018EBEC [ 5] "28000"
SQLINTEGER * 0x0018E7C4 (-103)
SQLWCHAR * 0x0018E7EC [ 62] "[Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password"
SQLSMALLINT 512
SQLSMALLINT * 0x0018E7D4 (62)
databasebrowser 1070-16c0 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x025417B8
SQLSMALLINT 2
SQLWCHAR * 0x0018EBEC
SQLINTEGER * 0x0018E7C4
SQLWCHAR * 0x0018E7EC
SQLSMALLINT 512
SQLSMALLINT * 0x0018E7D4
databasebrowser 1070-16c0 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x025417B8
SQLSMALLINT 2
SQLWCHAR * 0x0018EBEC
SQLINTEGER * 0x0018E7C4
SQLWCHAR * 0x0018E7EC
SQLSMALLINT 512
SQLSMALLINT * 0x0018E7D4
Your earlier ODBC trace points to an application error: extra quotes around the user id. Fix that and you should be good to go.
Fri Feb 28 2014 15:13:00
15:13:00 Attempting to connect using:
UID=support;PWD=********;DBN=micros;DBF=D:\MICROS\Database\Data\micros.db;ENG=sqlMCRSERVER;START=D:\MICROS\Common\Bin\SrvcStartDB.exe;CON=SQL_DBC_3d536a0;ASTOP=YES;INT=NO;DBG=YES;LOG=C:\Users\Manager\Documents\odbclog.txt;DMRF
15:13:00 Attempting to connect to a running server...
15:13:00 Trying to start SharedMemory link ...
15:13:00 SharedMemory link started successfully
15:13:00 Attempting SharedMemory connection (no sasrv.ini cached address)
15:13:00 Connected to server over SharedMemory
15:13:00 Connected to SQL Anywhere Server version 11.0.1.2596
15:13:00 Application information:
15:13:00 IP=192.168.100.250;HOST=MCRSERVER;OSUSER=SYSTEM;OS='Windows 7 Build 7601 Service Pack 1';EXE='C:\Program Files (x86)\Vigilix\Bin\VxAgent.exe';PID=0xf48;THREAD=0x550;VERSION=11.0.1.2472;API=ODBC;TIMEZONEADJUSTMENT=-360
15:13:00 Connected to the server, attempting to connect to a running database...
15:13:00 [37765] Connected to database successfully
Fri Feb 28 2014 15:13:08
15:13:08 Attempting to connect using:
UID='''support''';PWD=********;DBN=micros;DBF=D:\MICROS\Database\Data\micros.db;ENG=sqlMCRSERVER;START=D:\MICROS\Common\Bin\SrvcStartDB.exe;CON=SQL_DBC_4aed838;ASTOP=YES;INT=NO;DBG=YES;LOG=C:\Users\Manager\Documents\odbclog.tx
15:13:08 Attempting to connect to a running server...
15:13:08 Trying to start SharedMemory link ...
15:13:08 SharedMemory link started successfully
15:13:08 Attempting SharedMemory connection (no sasrv.ini cached address)
15:13:08 Connected to server over SharedMemory
15:13:08 Connected to SQL Anywhere Server version 11.0.1.2596
15:13:08 Application information:
15:13:08 IP=192.168.100.250;HOST=MCRSERVER;OSUSER=Manager;OS='Windows 7 Build 7601 Service Pack 1';EXE=c:\perl\bin\perl.exe;PID=0x1a40;THREAD=0x1b1c;VERSION=11.0.1.2472;API=ODBC;TIMEZONEADJUSTMENT=-360
15:13:08 Connected to the server, attempting to connect to a running database...
15:13:08 Database is running, but could not connect to it
15:13:08 Invalid user ID or password
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.