Skip to Content

connect powerbuilder app to sqlserver DB on net?

Oct 14, 2016 at 08:56 AM


avatar image

Hi all

My app connect to sqlserver DB in our local network

Now I try to connect DB that is in web using IP of server DB is on it

i make router setting , firewall inbound rules , .....

all is OK

I can connect using microsoft sql server mangment

with server name like "\AHHP_SQL2008

where is actual IP for my server and ahhp_sql2008 is the name of sqlserver instance

from my pb app i also connect by using ado net as follow

SQLCA.LogPass = "password"
SQLCA.LogId = "id"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Namespace='System.Data.SqlClient',DataSource='\AHHP_SQL2008',Database='databasename'"

my question is

Q1 is ado net have best performance for connection?

Q2 is ado net allows multi userto conect -? i can connecr insert row , edit .....when only if i am the only user connecting

when i coonect from other machine -while the first machine is still connected - the two user now can not make any activities on DB -retrieve insert edit ...... why?

Q3 i try to connect with ole db - i can connect but with no table on database??

my connection is as follow

SQLCA.LogPass = "password"
SQLCA.LogId = "id"
SQLCA.AutoCommit = False


what is error

Q4 -it is general Q for SAP

where OLD SCN discussion had gone?the old is much better than this

how i put my Q in powerbuilder developer discussion?

how can i comment on old discussion?how can i follow my previous discussion



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

ahmed tawfik Oct 17, 2016 at 06:03 PM

Hi all

Now i can connect using ADO Net and OLE

but in both cases the performance is very very poor

so how can my desktop application (client-server) app connect to DB over net (I use PB11.5 )

If i convert it to win form can improve the performance?

is there is any parameter set in string connection to improve the performance(in desktop app?



Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ahmed;

Have you tried SNC or ODBC (with native support) over to SS?

FWIW: I still use SNC and its super fast.

regards .. Chris

avatar image
Former Member Oct 26, 2016 at 02:10 PM

SNC or ODBC might be a little faster but I would think that the speed of the Internet connections at both ends would have the most impact on performance.

10 |10000 characters needed characters left characters exceeded