Solved

PB and Sybase11 Connectivity Problem

Posted on 1998-12-01
8
950 Views
Last Modified: 2008-02-20
Hi
I am working with PowerBuilder 5.0 on WIN 95.I have got two Backened databases on SYBASE 10 on SUN OS and Sybase 11 on HP.From my PB front end.Database of SYBASE 10 gets connected using the sybase conncetivity tool choosing the platform has win in the sybase connectivity platfrom and rest is fine.But when I try to get connected to SYBASE 11 it gives me the error below as
"ct_connect():protocol specific layer.interneal Client Library error:There is a tds state machine error.An illegal tds token sequence was received."
0
Comment
Question by:ajith_29
  • 3
  • 3
  • 2
8 Comments
 

Expert Comment

by:schneid
ID: 1098454
ajith_29,

Modify the locales.dat file in the locales subdirectory where the Sybase client is installed.  Find you platform and change the character set indicator (all entries for section) from CP850 to ISO_1.
0
 
LVL 2

Author Comment

by:ajith_29
ID: 1098455
i have sybase 10 on "iso_1" as default charc set and sybase 11 on roman8.
0
 

Expert Comment

by:schneid
ID: 1098456
Can you providde the contents of sql.ini?
0
 
LVL 2

Author Comment

by:ajith_29
ID: 1098457
Hi schneid,
The coss,coss1 are working on Syabse 11 on roman8
The sunny,sunny1 are working on Syase 10 on iso_1
given below is the sql.ini file
[coss]
query=NLWNSCK,190.9.200.200,2222
[coss1]
win3_query=WNLWNSCK,190.9.200.200,2222
[sunny]
query=NLWNSCK,190.9.200.226,2000
[sunny1]
win3_query=WNLWNSCK,190.9.200.226,2000

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 9

Accepted Solution

by:
david_levine earned 100 total points
ID: 1098458
The way to get around this is in PowerBuilder, on the sqlca.dbparm= line, explicity specify the character set.

So, in your case, it would be the following for one application:
sqlca.DBAPRM='charset="roman8"'

and the following for the other application:
sqlca.DBAPRM='charset="iso_1"'

Of course, if you already had information previously specified for your PB DBPARM, you would just add the charset= parameter to it.

BTW, the suggestion for modifying the locales.dat file is fine, but only works if all the servers are using the same charset, which in your case is not true.

Let me know if that helps!
David





0
 
LVL 2

Author Comment

by:ajith_29
ID: 1098459
Hi david levine
Thanks for the perfect answer for my question.There is a small mistake not double couts a single counts work.So get the 100 points from me.
Bye
Ajith

0
 
LVL 9

Expert Comment

by:david_levine
ID: 1098460
Ajith,

Ok, so award the points :)

Glad I could help and you have found the answer.

David
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1098461
Ajith... I think you responded on a different question.

You asked about what version of PB we are...

We are currently 32-bit and have been since PB 4. We are about to release a PB 6.5 version of our application.

David
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: This is the second blog post in a series on email clearinghouses (https://www.xmatters.com/alert-management/blog-email-has-failed-us?utm_campaign=70138000000ydLoAAI&utm_source=exex&utm_medium=article&utm_content=blog-post).   Every month t…
With the rapid rise in mobile usage, mobile devices are here to stay and have become an integral part of doing business. Here are 9 great apps for your BYOD environment.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now