Solved

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

Posted on 2011-03-01
7
2,354 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
Comment Utility
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
Comment Utility
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 125 total points
Comment Utility
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 3

Accepted Solution

by:
loks earned 375 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

728 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

10 Experts available now in Live!

Get 1:1 Help Now