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.
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! |
|
|
|
|