Skip to Content

connect powerbuilder app to sqlserver DB on net?

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 "

197.47.103.106\AHHP_SQL2008

where 197.47.103.106 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.DBMS = "ADO.Net"
SQLCA.LogPass = "password"
SQLCA.LogId = "id"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Namespace='System.Data.SqlClient',DataSource='197.47.103.106\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.DBMS = "OLE DB"
SQLCA.LogPass = "password"
SQLCA.LogId = "id"
SQLCA.AutoCommit = False

SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='197.47.103.106\AHHP_SQL2008',PROVIDER STRING='Database=databasename'"

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

Regards

ahmed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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?

    Regards

    Ahmed

    Add comment
    10|10000 characters needed 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.

    Add comment
    10|10000 characters needed characters exceeded