Solved

PB and Sybase11 Connectivity Problem

Posted on 1998-12-01
8
978 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

 
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
 
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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Getting to know the threat landscape in which DDoS has evolved, and making the right choice to get ourselves geared up to defend against  DDoS attacks effectively. Get the necessary preparation works done and focus on Doing the First Things Right.
The recent Petya-like ransomware attack served a big blow to hundreds of banks, corporations and government offices The Acronis blog takes a closer look at this damaging worm to see what’s behind it – and offers up tips on how you can safeguard your…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

632 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