Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 can connect to sql2k from one ISP, but not another

Author  Topic 

aspapp
Starting Member

1 Post

Posted - 2001-12-20 : 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!







   

- Advertisement -