+ Reply to Thread
Results 1 to 3 of 3

Powerbuilder 8 Connect to SQL Server 2008

  1. Powerbuilder 8 Connect to SQL Server 2008

    I have a Powerbuilder 8 application which hits SQL Server 2000, that I'm
    rewriting in VB 2008. How do I get it to talk to SQL Server 2008 so I can
    take advantage of the new SQL features in my new VB code while using the
    older front end for the time being?

    Thanks in advance,

    Steve House

  2. Re: Powerbuilder 8 Connect to SQL Server 2008

    It's been a long time since I used PB and even longer since I used PB 8. So
    I am probably missing many things. But here are a couple of things to
    consider.

    If your app is currently using the SQL Server native mode connection, that
    is, if you have something like
    SQLCA.DBMS = "MSS"
    you will have to change it. That interface used the old dblib interface to
    SQL Server, and that is no longer available in SQL Server 2008. The easiest
    change may be to use ODBC or OLE DB interface. Your PB documentation should
    be able to tell you how to use those connection types.

    If your app does outer joins using the old *= or =* syntax, you will have to
    change them to the ANSI OUTER JOIN syntax. As I recall, PB had the ability
    to convert the old syntax to the new (I don't remember how you ran this
    tool). The version of the conversion that I used many years ago worked
    fairly well, but not perfectly. In some cases, it converted to a legal
    syntax that returned the wrong result set. And, of course, while it could
    change datawindows and datastores, it did not change anything in the PB
    scripts. Those had to be corrected manually.

    There may well be other things.

    Good luck,
    Tom

    "olorin55" wrote in message
    news:9D214E09-25AC-47D9-8094-7E0FE18E3109@microsoft.com...
    >I have a Powerbuilder 8 application which hits SQL Server 2000, that I'm
    > rewriting in VB 2008. How do I get it to talk to SQL Server 2008 so I can
    > take advantage of the new SQL features in my new VB code while using the
    > older front end for the time being?
    >
    > Thanks in advance,
    >
    > Steve House



  3. Re: Powerbuilder 8 Connect to SQL Server 2008

    I found some information about it. I use PB8 too, and i'm interested to put it to work without ODBC. Actually i use this configuration and it's working.



    DBMS=MSS Microsoft SQL Server 8.x
    Database=myDB
    UserId=
    DatabasePassword=
    LogPassword=
    ServerName=serverX
    LogId=my_login
    Lock=
    DbParm=DBTextLimit='60000',AppName='Power Builder',Host='myhost',CommitOnDisconnect='No'
    PROVIDER='SQL Server Native Client 10.0',DATASOURCE='myDB',PROVIDERSTRING='database=security_db;APP='

    I try with outer joins and works fine, in the same machine with SQL Server 2008.

    The problem is the Native Client, instaled by SQL Server 2008, and it doesn't work without this client (i try). I install the Native Client (I download that from Microsoft page), but it's not working in others machines.

    Somebody have any idea?

+ Reply to Thread