Solved

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

Posted on 2011-03-01
7
2,466 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
[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
  • 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 125 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 3

Accepted Solution

by:
loks earned 375 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

752 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