Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Regarding Retrieving and Updating IN SQL SERVER 2008 using native driver from PB 11.5

15 views
Skip to first unread message

Bhavik

unread,
Feb 14, 2010, 3:13:25 AM2/14/10
to
Hi,

I have used stored procedure datawindow to retrieve and update data.
I am using SQL server 2008 Server with Pb 11.5 on Windwos XP. I have
used Native Connection Driver.


Everything is working fine when I run application from PB 11.5 IDE.
Once I build exe and try it from EXE, its not allowing me to Set
Transaction Object in datawindow and returning -1.

Connection String


Hi All,

I am using PB 11.5 with SQL server 2008.

I am facing some different issue while running Application directly
from Powerbuilder 11.5 IDE and Direct EXE after Build.

//////////// /////////
//database Connection Code
SQLCA.DBMS = "SNC SQL NATIVE CLIENT(OLE DB)"
SQLCA.ServerName = "ossws02\sql2008"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Provider='SQLNCLI1 0',Database=
'dbdvdrental' ,TrustedConnecti on=1"
Connect Using SQLCA;

////////////////////

its connecting to database, allowing me to select /insert using
embedded statement. Any Reason?

0 new messages