TD 6.0 SP1 and Sybase Router

General discussion forum about all databases other than SqlBase.
Brian Howard

TD 6.0 SP1 and Sybase Router

Post by Brian Howard » 08 Feb 2011, 22:58

Hi All,

Using the sybase router

sql.ini
[win32client.dll]
comdll=sqlsyb32

if you also enable the router log

sql.ini
[win32client.syb32]
log=i:\router.log /FD /Ld

Then the application will crash on the first SqlConnect. If the router log entry is removed then SqlConnect will work.

The router log setting works on TD 3.1 & TD 5.2 but not TD 6.0. This router.log is an extremely important dubugging tool for us.

This has been reported via Jim Cowan, but Anna requested I raise issues via this forum.

Please do not ask for a repro case as there is only 4 line of code required.
On SAM_AppStartup
Set SqlDatabase = 'SBDDEV4'
Set SqlUser = 'sa'
Set SqlPassword = '*****'
Call SqlConnect( hSql )

cheers

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 09 Feb 2011, 11:39

Hello,

For the moment I don't reproduce your issue with TD6.0 + SP1 against Sybase 15.

Hervé

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 09 Feb 2011, 12:07

Hello,

Here is the sybase section in my sql.ini:
[sybgtwy]
remotedbname=NATIVESYBASE15, LAPTOPHERVE, TDHD, 0
remotedbname=fraix12,fraix12, pubs, 0

[win32client.syb32]
log=g:\router.log /FD /Ld


The application doesn't crash and the router.log is generated on The G: file system.
I join my application.

Regards

Hervé

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 09 Feb 2011, 12:09

Here is my application.

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 09 Feb 2011, 12:12

Sorry, here is the test case.

Hervé
You do not have the required permissions to view the files attached to this post.

Brian Howard

Re: TD 6.0 SP1 and Sybase Router

Post by Brian Howard » 15 Feb 2011, 04:47

Hi Herve,

Thankyou for your response. I have tried this again and still it fails, I have attached my app ( which is pretty much identical to yours). Also attached is my sql.ini. If with the addition of your remotedbname this works for you, then there has to be some other envronmental issue, possible codepage or some such.

cheers
You do not have the required permissions to view the files attached to this post.

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 22 Feb 2011, 14:57

Hello,

I am looking at your sql.ini but could you tell me which error/message you get when the crash ?

Regards

Hervé

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 22 Feb 2011, 15:15

Hello,

I have just added :
[sybgtwy]
;add here
remotedbname=NATIVESYBASE15, LAPTOPHERVE, TDHD, 0 <=== my sybase BD
remotedbname=sbdDEV1,SBDSUN,sbdDEV1
remotedbname=sbdDEV2,SBDSUN,sbdDEV2
remotedbname=sbdDEV3,SBDSUN,sbdDEV3
remotedbname=sbdDEV4,SBDSUN,sbdDEV4
remotedbname=sbdDEV5,SBDSUN,sbdDEV5

I can connect.

Here is the router.log created:
2/22/11 14:59:27 0> SQLRouter LOG Utility - version 2.1.0
2/22/11 14:59:27 0> SQLRouter/Sybase - version 4.0.0
2/22/11 14:59:27 0> Sybase Client-Library/15.0/P-EBF14167 ESD #7/PC Intel/B
2/22/11 14:59:27 0> UILD1500-093/OPT/Wed Dec 13 20:04:04 2006
2/22/11 14:59:27 0> [show environ] SYBASE=C:\sybase
2/22/11 14:59:27 0> [show environ] PATH=C:\Program Files\Unify\Team Develop
2/22/11 14:59:27 0> er 6.0\axis2c\lib;C:\Program Files\Unify\Team Developer
2/22/11 14:59:27 0> 6.0;C:\ProgramData\Unify\Team Developer 6.0\;C:\Progra
2/22/11 14:59:27 0> mData\Unify\Team Developer 6.0;C:\Program Files\Unify\T
2/22/11 14:59:27 0> eam Developer 5.2\axis2c\lib;C:\Program Files\Unify\Tea
2/22/11 14:59:27 0> m Developer 5.2;C:\app\herve\product\11.2.0\dbhome_1\bi
2/22/11 14:59:27 0> n;C:\Program Files\Ingres\IngresII\ingres\bin;C:\Progra
2/22/11 14:59:27 0> m Files\Ingres\IngresII\ingres\utility;C:\sybase\DataAc
2/22/11 14:59:27 0> cess\ODBC\dll;C:\sybase\RPL-15_0\bin;C:\sybase\Shared\S
2/22/11 14:59:27 0> ybase Central 4.3;C:\sybase\UAF-2_0\bin;C:\sybase\OCS-1
2/22/11 14:59:27 0> 5_0\lib3p;C:\sybase\OCS-15_0\dll;C:\sybase\OCS-15_0\bin
2/22/11 14:59:27 0> ;C:\sybase\ASE-15_0\dll;C:\sybase\ASE-15_0\bin;C:\Windo
2/22/11 14:59:27 0> ws\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Prog
2/22/11 14:59:27 0> ram Files\Microsoft SQL Server\90\Tools\binn\;C:\Window
2/22/11 14:59:27 0> s\System32\WindowsPowerShell\v1.0\;C:\Program Files\Tor
2/22/11 14:59:27 0> toiseSVN\bin;C:\Sun\SDK\bin;C:\sybase\DBISQL\bin;C:\PRO
2/22/11 14:59:27 0> GRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:
2/22/11 14:59:27 0> \PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Program Files\IBM\
2/22/11 14:59:27 0> Informix\Connect\bin;C:\Program Fi
2/22/11 14:59:27 0> remotedbname=NATIVESYBASE15, LAPTOPHERVE, TDHD, 0
2/22/11 14:59:27 0> remotedbname=sbdDEV1,SBDSUN,sbdDEV1
2/22/11 14:59:27 0> remotedbname=sbdDEV2,SBDSUN,sbdDEV2
2/22/11 14:59:27 0> remotedbname=sbdDEV3,SBDSUN,sbdDEV3
2/22/11 14:59:27 0> remotedbname=sbdDEV4,SBDSUN,sbdDEV4
2/22/11 14:59:27 0> remotedbname=sbdDEV5,SBDSUN,sbdDEV5
2/22/11 14:59:27 0> longbuffer=32650
2/22/11 14:59:27 0> locktimeout=0
2/22/11 14:59:27 0> sybautocommit=on
2/22/11 14:59:27 0> yieldonservercall=0
2/22/11 14:59:27 0> sybworkstationname=workstation_name
2/22/11 14:59:27 0> sybapplicationname=CENTURA Sybase App
2/22/11 14:59:27 0> checkexists=off
2/22/11 14:59:27 0> fetchrow=20
2/22/11 14:59:27 0> sybmaxmessages=100
2/22/11 14:59:27 0> enablemultipleconnections=on
2/22/11 14:59:27 0> Each call to SqlConnect will create a new connection
2/22/11 14:59:27 0> closecursorateof=on
2/22/11 14:59:27 0> IF CCP IS OFF, Cursor will be closed at EOF
2/22/11 14:59:27 0> defaultselectforupdate=on
2/22/11 14:59:27 0> All ct-lib cursors will be opened for update
2/22/11 14:59:27 0> sybtracefile=E:\trace\trace.log
2/22/11 14:59:27 1> [connect] dbname = NATIVESYBASE15 username = sa
2/22/11 14:59:27 1> CLIENTMSG: 147:1 ct_debug(): user api layer: external e
2/22/11 14:59:27 1> rror: This routine can be used only with the debug vers
2/22/11 14:59:27 1> ion of Client-Library.
2/22/11 14:59:28 1> SERVERMSG: 5704:10 Changed client character set setting
2/22/11 14:59:28 1> to 'iso_1'.
2/22/11 14:59:28 1> SERVERMSG: 5701:10 Changed database context to 'TDHD'.
2/22/11 14:59:28 1> SERVERMSG: 5703:10 Changed language setting to 'us_engl
2/22/11 14:59:28 1> ish'.
2/22/11 14:59:28 1> TDS version - 7364
2/22/11 14:59:28 1> TDS packet size - 2048
2/22/11 14:59:28 1> DBMS version - Adaptive Server Enterprise/15.0.2/EBF 14
2/22/11 14:59:28 1> 332/P/NT (IX86)/Windows 2000/ase1502/2486/32-bit/OPT/Th
2/22/11 14:59:28 1> u May 24 04:10:36 2007
2/22/11 14:59:28 1> SERVERMSG: 5701:10 Changed database context to 'TDHD'.
2/22/11 14:59:28 1> CLIENTMSG: 155:1 ct_results(): user api layer: external
2/22/11 14:59:28 1> error: This routine cannot be called when the command
2/22/11 14:59:28 1> structure is idle.
2/22/11 14:59:28 1> ASSERTION FAILURE: file ..\..\sqlsyb32\c\sqscpr.cpp : l
2/22/11 14:59:28 1> ine 99
2/22/11 14:59:28 1> [get database parameter] param = 1004
2/22/11 14:59:28 1> [set database parameter] param = 5106 value = 0
2/22/11 14:59:28 1> [set database parameter] param = 3018 value = 1
2/22/11 14:59:28 1> [get database parameter] param = 5517
2/22/11 14:59:28 1> [ERROR] 196 Invalid GET parameter
2/22/11 14:59:33 1> [compile] Select read_only from ov_control
2/22/11 14:59:33 1> SERVERMSG: 208:16 ov_control not found. Specify owner.o
2/22/11 14:59:33 1> bjectname or use sp_help to check whether the object ex
2/22/11 14:59:33 1> ists (sp_help may produce lots of output).
2/22/11 14:59:33 1> [ERROR] 20208 ov_control not found. Specify owner.objec
2/22/11 14:59:33 1> tname or use sp_help to check whether the object exists
2/22/11 14:59:33 1> (sp_help may produce lo
2/22/11 14:59:37 1> [disconnect]


Regards

Hervé

Brian Howard

Re: TD 6.0 SP1 and Sybase Router

Post by Brian Howard » 22 Feb 2011, 22:20

Hi Herve,

Please excuse my ignorance, but I don't know how to embed images here, so I have attached a zip file. Hopefully this will help.
The zip file also contains the textthat would normally be sent to MS.

cheers

Brian Howard

Re: TD 6.0 SP1 and Sybase Router

Post by Brian Howard » 22 Feb 2011, 22:21

Oh dear, and here is the attachment
You do not have the required permissions to view the files attached to this post.

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 24 Feb 2011, 10:23

Hello,

Do you have another version of TD installed on your computer. Do you have verified your PATH ?
One thing which can be done is to simplify your sql.ini in order to keep only what concerns the sybase connection.

Regards

Hervé

Brian Howard

Re: TD 6.0 SP1 and Sybase Router

Post by Brian Howard » 16 Mar 2011, 01:00

Hi Herve,

There is no other version of SQLWindows on this PC. It is a brand spanking new virtual machine running XP SP 3. It is a clone of the virtual machine that had TD 5.2 installed. TD 5.2 was uninstalled and TD 6.0 was installed.

I think you have lost sight of the fact that when the router.log is turned on in the sql.ini it crashes, when the router.log is turned off it does not crash.

I have run the app in the SQlWndows install directory and the behaviour persists.

I have simplified the sql.ini and the above behaviour is persistant.

cheers and regards

Brian

herve

Re: TD 6.0 SP1 and Sybase Router

Post by herve » 17 Mar 2011, 14:28

Hello,

I am going to look at this issue again.

Regards
Hervé

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests