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

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?
LVL 2
Swamp_ThingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
loksConnect With a Mentor Commented:
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
 
kotukunuiCommented:
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
 
Swamp_ThingAuthor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
kotukunuiConnect With a Mentor Commented:
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
 
Swamp_ThingAuthor Commented:
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
 
Swamp_ThingAuthor Commented:
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
 
Swamp_ThingAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.