PowerBuilder 6.5 with SQL Server 2000

[zeevf]

Could some one know how could i work with
PowerBuilder 6.5 with MS SQL Server 2000 as native connection.

[clayk0he]

All you need to do is go to the Database Profiles set up the database type that you wish to connect to (SQL SERVER 2000)

Once that is installed and set up then you need to Configure the SQLCA connection string to connect to the database. ( this is the default Transaction object in PB, You can create your own if you wish.

For help on setting up the SQLCA transaction look into the powerbuilder books on line they have plenty of examples.

[zeevf]

Is it the way to connect as Native to SQL server 2000. ?
PB 6.5 sugest only SQL SERVER 6.X
Sql server 2000 was public after PB 6.5 was public ?
I try but i get some error
regards
zeev

[clayk0he]

Yes that is the native connection to SQL server 2000. You do have to add the 2000 drive to the database types and make the connection to it. Then in the code you should be able to use the SQLCA trasaction