Skip to Content
Oct 14, 2016 at 08:56 AM

connect powerbuilder app to sqlserver DB on net?

682 Views Last edit Oct 14, 2016 at 11:58 AM 2 rev

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