connect to sql DB from net?

[powerbuilde]

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

 

[mbalent]

Have you tried the SQL native driver?

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com