SQl Server 2000 BIG issue - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

SQl Server 2000 BIG issue

Author

Topic

kyle.spitzer
Starting Member

3 Posts

Posted - 2006-09-20 : 23:22:46

I have webspace through 1and1.com, and I'm trying to connect to a server on my internal network from my webspace on the internet. I have a machine running windows server 2003 and sql server 2000 as my server on my internal network. The server has sqlserver.exe and port 5801 set as exceptions in the firewall. I have a wireless linksys router that has port 80 and 5801(my sql port) forwarded to my internal server. All my coding is done in asp.net. My connection code looks like this:

Dim DBConn As OleDbConnection
Dim DBCommand As OleDbCommand = New OleDbCommand
Try
DBConn = New OleDbConnection("Provider=SQLOLEDB;Data Source=external IP,5801;Initial Catalog=DataWarehouse;User Id=WEBUSER;Password=*****")
DBCommand.CommandText = "SELECT * from Users"
DBCommand.Connection = DBConn
DBConn.Open()

DBConn.Close()
Catch
Response.Write("Error:" & Err.Description)
End Try

When I run this code on my website the page hangs for 30 seconds then I get this error:

Error:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Just wondering if anyone has come across this or has any help to head me in the right direction(maybe its my web host?). Thanks in adcance for any help.

Kyle

PSamsig
Constraint Violating Yak Guru

384 Posts

Posted - 2006-09-21 : 01:42:53

Does it work when you run it in the inside?

Do you have something you can connect to on 80, does that work from outside?

-- The Heisenberg uncertainty principle also applies when debugging

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources