Solved

PB and Sybase11 Connectivity Problem

Posted on 1998-12-01
8
944 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

706 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

22 Experts available now in Live!

Get 1:1 Help Now