sybase

[EyeTalion]

I'm getting this error when I try to connect to a Table in Sybase. It seems I'm connecting to the DB fine, but when I go to run a query I get this error...any suggestions?



[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_con_props(SET ,NETIO):
> user api layer: external error: The buflen parameter must be set to
> CS_UNUSED.

[john_murphy]

Any use


Steve Healey wrote in message [email protected]>...
In your post you neglected to mention the versions of OpenClient
and ODBC. With the 32 bit version of OpenClient 11.1 there is
a known bug, 122084, which displays the following to the screen:

"[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_con_props(SET,NETIO):
user api layer: external error: The buflen parameter must be set to
CS_UNUSED."

This is often followed by the ct_cmd_drop error. This bug is fixed
in OpenClient 11.1.1. You can get this upgrade from Sybase Customer
Service.

Steve Healey

or

Try again, setting CursorDriver Transaction's property to
WTCDSimulateIfNeeded.
Sybase TS

[EyeTalion]

john, do you have a sample of this in .NET...I found a sample in 6.0 but not sure how to convert?

With grdoSybase
      .Connect = "DSN=SBPROD;UID=" & logon & ";PWD=" & LCase(txtPassword)
      .CursorDriver = rdUseIfNeeded
      .QueryTimeout = 120
      .EstablishConnection rdDriverNoPrompt
   End With