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
Solved

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

Posted on 2011-03-01
7
2,434 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 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

829 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