|
aspapp
Starting Member
1 Posts |
 Posted - 12/20/2001 : 18:01:18
|
Hi,
I'm attempting a connection to my sql server (running off broadband) from a page I have hosting at my new ISP.. just a standard conn string in .asp..
cn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=24.10.XX.XXX.UID=sa;PWD=mypwd;DATABASE=d_app;"
and i get "[DBNMPNTW]Specified SQL server not found."
From my older host I have no problems connecting with the same string... so I assumed it must be something at my new host, but I'm able to connect to other remote sql servers from my new isp(for example I can connect from my new ISP to the old ISP's SQL server w/o a problem), but for some reason I can't from the new host connect to mine.. is there a setting on mine that needs to change?
newhostwebsvr to oldhostsql works... oldhostwebsvr to mylocalsql works.. newhostwebsvr to mylocalsql doesn't work??
thx!
|
|
can connect to sql2k from one ISP, but not another
