Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sybase PowerBuilder 8.0 applications stopped working after upgrade to MS SQL 2008

Posted on 2011-03-01
7
Medium Priority
?
2,614 Views
Last Modified: 2012-05-11
We have a handfull of Sybase PowerBuilder 8.0 applications that connect to our MS/SQL Server.  They worked fine with MS/SQL 2000 but since upgrading to MS/SQL 2008 R2 we're having problems.  On my workstation, the developer workstation, the compiled image runs fine.  On other workstations however the image times out with an error about being unable to connect.  Things like Excel sheets and Crystal Reports that are linked to the database work just fine.  I've looked at installed components ( SQL Server 2008 native Client ) and don't spot anything that might be missing.  If I log onto a user workstation with my user id and pwd the applications still do not run.

Any idea where I should look?
0
Comment
Question by:Swamp_Thing
  • 4
  • 2
7 Comments
 
LVL 3

Expert Comment

by:kotukunui
ID: 35011328
Are your PB 8.0 application still using the MSS native database connector or do you use ODBC?
What values are you using for your SQLCA parameters? (anonymise any passwords)
0
 
LVL 2

Author Comment

by:Swamp_Thing
ID: 35011427
A little more:  They run fine from my workstation regardless of what user ID I log into Windows 7 with.

I inherited these from my predecessor and have no prior experiance with PB.  GLSQL2 is the Server name as well as a SQL Native Client ODBC DSN...

Here's the SQLCA stuff:

// to fill in list, someone needs to be logged in...  temp login to get the list then logout
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "quality"
sqlca.userid = "<user id>"
sqlca.dbpass = "<password>"
sqlca.logid = "<user id>"
sqlca.logpass = "<password>"
sqlca.servername = "GLSQL2"
sqlca.autocommit = True
SQLCA.DBParm             = "DateTimeAllowed='Yes',PacketSize=2048,AppName='Goldline Service Application'"
CONNECT Using SQLCA;

0
 
LVL 3

Assisted Solution

by:kotukunui
kotukunui earned 375 total points
ID: 35011902
OK. The SQLCA.DBMS parameter is indicating that the app is still using the native MSS database connector. This should still work with later versions of SQL Server like 2008, but may need older Microsoft database libraries to operate. It may be just a case of re-installing the old MS SQL Client DLLs on the workstations.

The most important file is NTWDBLIB.DLL which may need to be re-installed from the MS SQL Server 2000 Client software.

If you have some PB development resource available it would probably be worth upgrading these apps to a later version of PB (10 or 11) and using the newer database connectors like Microsoft's OLE-DB or Sybase's SNC SQL Native Client.

Good luck.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 3

Accepted Solution

by:
loks earned 1125 total points
ID: 35020947
Firstly, PB 8 should not be run on Windows 7. Kindly refer to PB 8 installation manuals.
Secondly, PB 8 does not support SQL 2005 or SQL 2008. Event though if we connect to SQL server , the results would not be accurate and would throw out errors especially for data type mismatches and outer joins.
I tried using PB 8 and SQl 2005, had confront many serious issues so I was forced to migrate the application to PB 11.5, which worked perfectly.

Regards,
Loks
0
 
LVL 2

Author Comment

by:Swamp_Thing
ID: 35057425
OK - Downloaded and installed the Trial version of PB 11.5     Converted the workspaces from 8.0 to 11.5  changed from DBMS "MSS.....   to DBMS="ODBC" and got things working.   I'll split up the points 25% / 75%  Kotukunui / Loks    Kotukunui for the pointer to DBMS options and Loks for the compatibility info.
0
 
LVL 2

Author Comment

by:Swamp_Thing
ID: 35057456
Oh yes:  Have to install the  Microsoft SQL Server 2008 Native Client  on the client machines in order for the PB applications to run.
0
 
LVL 2

Author Closing Comment

by:Swamp_Thing
ID: 35057535
A grade of "B" for "GOOD" answers is not a BAD thing.  Requiring comments for anything below "EXCELLENT" will skew results towards "A" making the grading worthless.   Perhaps a suggestion that comments be included in order to help improve the quality of future answers would garner the desired results without compromising the integrity of the rankings.

In other words: "No comment."
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Simple Linear Regression
Introduction to Processes

564 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