SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 can connect to sql2k from one ISP, but not another
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aspapp
Starting Member

1 Posts

Posted - 12/20/2001 :  18:01:18  Show Profile  Reply with Quote
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!







  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000