cancel
Showing results for 
Search instead for 
Did you mean: 

Problems with ODBC drivers in Windows 7 64-bit

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

jeff_albion
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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.


jeff_albion
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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

jeff_albion
Employee
Employee
0 Kudos

Hi Justin,

Your second connection is picking up slightly different information passed in to the username field:

  1. 15:13:00 Attempting to connect using:
    UID=support;PWD=********;DBN=micros;DBF=D:\MICROS\Database\Data\micros.db;
  2. 15:13:08 Attempting to connect using:
    UID='''support''';PWD=********;DBN=micros;

Notice the appended single quotes around the 'support' username in your second connection attempt.

Regards,

Jeff Albion

SAP Active Global Support

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member188493
Contributor
0 Kudos

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