TD 6.2 & 6.3 sqlsyb32(sybase)- No connect initiated

[wong6444]

Hello there,

I spent the last 2 weeks to search through all Forums and Internet and not able to find the similar problem.
Please see my attached zip file for detailed MSWord document to show screen captures, desktop configuration and sql.ini + SYBASE connection log files

I tested TD6.2 Build 36193 and TD 6.3 Build 44741 with sqlsyb32 - SYBASE Native router to connect to our SYBASE server
ALL TD 6.2 and TD 6.3 Connection failed with SQLERROR: 401 - "CANNOT Open Database"!
The Sqlsyb32 log file showing that there is no [connect] statement initiated!

SYBASE Connection tested against SYBASE ASE 15.0, 15.7 and 16.0 ==> I know that TD 6.x does not support the SYBASE 16.0 yet; however SQLTALK is able to connect with all of the 3 ASE versions!


TD6.2 Log file:
GUPTA TD 6.2 sqlsyb32 (native sybase rounter call!)
6/17/15 10:24:51 0> SQLRouter LOG Utility - version 2.1.0
6/17/15 10:24:51 0> SQLRouter/Sybase - version 4.0.0
6/17/15 10:24:51 0> Sybase Client-Library/15.0/P-EBF17358 ESD #22/PC Intel/
6/17/15 10:24:51 0> BUILD1500-120/OPT/Tue Nov 03 00:04:03 2009
6/17/15 10:24:51 0> [show environ] SYBASE=C:\sybase
6/17/15 10:24:51 0> [show environ] PATH=C:\sybase\DataAccess\ADONET\dll;C:\
6/17/15 10:24:51 0> sybase\DataAccess\OLEDB\dll;C:\sybase\DataAccess\ODBC\d
6/17/15 10:24:51 0> ll;C:\sybase\OCS-15_0\lib3p;C:\sybase\OCS-15_0\dll;C:\s
6/17/15 10:24:51 0> ybase\OCS-15_0\bin;C:\Program Files\Windows Resource Ki
6/17/15 10:24:51 0> ts\Tools\;C:\Program Files\Sybase\ASIQ-12_7\win32;C:\Pr
6/17/15 10:24:51 0> ogram Files\Support Tools\;C:\Program Files\Common File
6/17/15 10:24:51 0> s\VERITAS Shared;C:\WINDOWS\system32;C:\WINDOWS;C:\WIND
6/17/15 10:24:51 0> OWS\System32\Wbem;C:\Program Files\Diskeeper Corporatio
6/17/15 10:24:51 0> n\Diskeeper\;C:\Program Files\Windows Imaging\
6/17/15 10:24:51 0> REMOTEDBNAME=DEVSEHLF,DEVSVER,DEVSHELF
6/17/15 10:24:51 0> REMOTEDBNAME=QASEHLF,DEVSVER,QASEHLF
6/17/15 10:24:51 0> REMOTEDBNAME=PRODSHLF,PRODSVER,PRODSHLF
6/17/15 10:24:51 0> SYBAUTOCOMMIT=OFF
6/17/15 10:24:51 0> MAPGTICURSORS=OFF
6/17/15 10:24:51 0> ENHANCEDCURSORS=OFF
6/17/15 10:24:51 0> LONGBUFFER=32000
6/17/15 10:24:51 0> LOCKTIMEOUT=0
6/17/15 10:24:51 0> DISPLAYBINARYASHEX=0
6/17/15 10:24:51 0> YIELDONSERVERCALL=0
6/17/15 10:24:51 0> SYBAPPLICATIONNAME=TEST2016
6/17/15 10:24:51 0> SYBMAXMESSAGEs=300,1024
6/17/15 10:24:51 0> sybtracefile=D:\temp\TESTSybaseTrace.log /Tx /Ld
6/17/15 10:24:51 0> sybworkstationname=@WORKSTATION

==> Nothing after this step!!!! No [connect] statement log in this log file!!!

==================== SQL TALK =========================================================

Log for SQLTALK and able to see the [connect] statement!
6/17/15 13:30:32 0> sybtracefile=c:\temp\TESTSybaseTrace.log /Tx /Ld
6/17/15 13:30:32 0> sybworkstationname=@WORKSTATION
6/17/15 13:30:32 1> [connect] dbname = DEVSHELF username = tester
6/17/15 13:30:32 1> SERVERMSG: 5704:10 Changed client character set setting
6/17/15 13:30:32 1> to 'utf8'.
6/17/15 13:30:32 1> SERVERMSG: 5701:10 Changed database context to 'DEVSHEL
6/17/15 13:30:32 1> F'.
6/17/15 13:30:32 1> SERVERMSG: 5703:10 Changed language setting to 'us_engl
6/17/15 13:30:32 1> ish'.
6/17/15 13:30:32 1> TDS version - 7364
6/17/15 13:30:32 1> TDS packet size - 2048

Please see attached zip file with my simple connection app, and Detailed MSWord Document to show the sql.ini file and SYBASE LOG files for TD App and SQLTALK connection logs

Developer Desktop: Windows 7
TD 6.2 Installed drive: C:\Program Files (x86)\Gupta\ Team Developer 6.2
TD 6.3 Installed drive: C:\Program Files (x86)\Gupta\ Team Developer 6.3

Thanks for your help! I am also testing the ODBC connection against SYBASE ASE 15.7 and ASE 16.0. For sure TD 6.3 ODBC does not work with SYBASE ASE 16.0! SQLTALK is able to connect with ODBC to SYBASE 16.0 I will start a new bug with ODBC sybase connection test for TD 6.3 and TD 6.2.

I attached the

TestSYBASE_sqlsyb32_failed.zip

[VEspinal]

Hi:

Please check that you are using the correct sql.ini and the same one when connecting via SQLTalk and/or from the application.

It seems like you are using 2 sql.ini(s): one from the "C:\Temp\ConnectSYBASE" directory and one from the C:\ProgramData... Since it is loading the SQLBase server and that's why you got the error 401 ... cannot open Database.

I am attaching your sample, another sample, my sql.ini and a video that shows that I am able to connect to Sybase 15.7 using TD 6.3 SP1 via Database Explorer, SQLTalk and connecting natively from your application.

In case you are still experiencing problems to connect, please make a backup of your sql.ini in C:\ProgramData\Gupta\Team Developer 6.3 and copy over the one from the "C:\Temp\ConnectSYBASE" directory.

Make sure that you have the following section:
[win32client.dll
; order of win32client dll's is important when connecting to multiple databases.
; sqlws32 should always be the last and sqlodb32 be 2nd last.
; comdll=sqlora32
comdll=sqlsyb32
; comdll=sqlodb32
comdll=sqlws32

HTH

Thanks
Victor Espinal

[wong6444]

Thanks, I just downloaded TD 6.3 SP1 today and I will follow your instructions and try it again!

[wong6444]

Thanks Victor,

You are correct, After I changed the TD6.3 SP1 "Tools- Preference to point to the correct SQL.ini" I am able to connect!

I have SYBASE ASE 16.0 and SYBASE ASE 15.7.
When I try to use the Database Explorer to connect to SYBASE ASE 15.7 - I can view all of the tables!

However with the SYBASE ASE 16.0, Explorer is not able to display proper name of all of the SYBASE tables. Do you have any ideas When the GUPTA will support and certified with SYBASE ASE 16.0. I will try to upload the screen capture with this or next Post! Thanks again

SYBASE_ASE157.jpg

SYBASE_ASE160.jpg