PowerBuilder Sqlserver connectivity

[Former Member]

Hi,

I am using 11.2 powerbuilder and I want to connect sqlserver 2008 . What is the best method of giving connectivity with powerbuilder and Sqlserver

Please can you send a sample code to set up the connection with database.

Kind Regards

Polachan

[Former Member · Accepted solution]

Hi Polachan;

  Personally for the best speed and access to SS functionality, I would recommend using SQLServer Native Client (or SNC for short).

Example:

SQLCA.DBMS = "SNC"

SQLCA.LogPass = <************>

SQLCA.ServerName = "<yourserver>"

SQLCA.LogId = "DBA"

SQLCA.AutoCommit = False

SQLCA.DBParm =  "Database='CIPTest',Provider='SQLNCLI10',DelimitIdentifier=1,TrustedConnection=1"

HTH

Regards ... Chris

[Former Member · Accepted solution]

Thanks Chris,

When I am applying SNC connection the following message is coming

"SqlNative Client not installed" . How I can install   SNC

My computer windows 7, PowerBuilder 11.2

[CobyKako · Accepted solution]

Hello,

Check that MS link to get the native client: Get the SQL Server Native Client

P.S: For PB 11.2, we advised to use SNC V 2005: Supported versions for SQL Server

HTH

Jacob

[Former Member · Accepted solution]

Just run the SS "client" part of the SS installation.

Make sure that you select the 32bit drivers as PB is still only 32bit. 

[Former Member · Accepted solution]

Many Thanks Chris and Jacob , It is working fine

[Former Member · Accepted solution]

Excellent news!  

Please mark your question as "answered" though.  

[CobyKako · Accepted solution]

Great news indeed