SQL Connection

[jl280328]

I am trying to connect to a SQL database and am having some trouble here is my connection string, and I am pretty sure the IP address is correct, b/c I am using it to remotely connect to the server that the SQL database resides on. Does anyone have any idea why it cannot connect?

Conn.Open "Driver={SQL Server};Server=70.90.150.170;Database=ABSOLUTE;Uid=****;Pwd=******;"

 

[jl280328]

I do not have SQL Server on my machine locally. I am doing work for a client, and I am FTPing the page to one server, and this page is trying to connect to the SQL database on another server. I have access to remotely connect to the server that has the SQL database, are their premissions I need to change here to allow a page to connect from this other server?

 

[Chopstik]

I had to go back and re-read this thread (sorry, probably should have been more thorough the first time through) and realised that I may have misunderstood, or ignored, part of your problem. Do you know all of the changes that the client made on their server? Did they change any firewall settings or make other upgrades? Any number of issues could be the culprit here... Here's something from the MS KB to get you started but it seems to me that the crux of your issue needs to be resolved with the client to determine what changes they have made that have now negatively impacted your ability to fix an application (that they appear to have broken).

http://support.microsoft.com/?kbid=914277&SD=tech

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[jl280328]

So I just learned that Comcast came in and put in a new static IP address, the one I am currently using, but they also added a new router, would this cause problems with my connection string and does anyone have any ideas on how to fix it?

 

[jl280328]

Do I need to configure a port on the router to allow the connection to get through? Has anyone ever had or heard of this problem before?

 

[jl280328]

How would I go about configuring the router to open up a port to allow my connection through?

 

[Chopstik]

You can try one of the networking forums here in Tek-Tips or Google -

http://www.google.com/search?hl=en&q=configure+router+to+open+a+port.

You may also need to know the kind of router being used, etc.

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill