Connection to SQL Server issues
-
I have a web site that I'm writing for a client but am thus far unable to connect to the server via my ASP pages. All the information I can get from the help center at the hosting provider is the DSN, IP address, Username, Password, and the database name. I've been to connectionstrings.com, which is a pretty useful site, and have attempted to use the available resources but to no avail. Here is the connection string I'm currently using,
Sub ConnDB() Set DataConn = Server.CreateObject("ADODB.Connection") DataConn.Open "Provider=sqloledb;Data Source=190.190.200.100,1433; Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;" End SubAny help with this would be greatly appreciated. Cheers :beer:
An American football fan - Go Seahawks! Lil Turtle
-
I have a web site that I'm writing for a client but am thus far unable to connect to the server via my ASP pages. All the information I can get from the help center at the hosting provider is the DSN, IP address, Username, Password, and the database name. I've been to connectionstrings.com, which is a pretty useful site, and have attempted to use the available resources but to no avail. Here is the connection string I'm currently using,
Sub ConnDB() Set DataConn = Server.CreateObject("ADODB.Connection") DataConn.Open "Provider=sqloledb;Data Source=190.190.200.100,1433; Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;" End SubAny help with this would be greatly appreciated. Cheers :beer:
An American football fan - Go Seahawks! Lil Turtle
Is the firewall enabled? If so, is it allowing access to port 1433?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
-
I have a web site that I'm writing for a client but am thus far unable to connect to the server via my ASP pages. All the information I can get from the help center at the hosting provider is the DSN, IP address, Username, Password, and the database name. I've been to connectionstrings.com, which is a pretty useful site, and have attempted to use the available resources but to no avail. Here is the connection string I'm currently using,
Sub ConnDB() Set DataConn = Server.CreateObject("ADODB.Connection") DataConn.Open "Provider=sqloledb;Data Source=190.190.200.100,1433; Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;" End SubAny help with this would be greatly appreciated. Cheers :beer:
An American football fan - Go Seahawks! Lil Turtle
I think QueryAnalyzer might use NamedPipes and hence pass through. How about ASP and ASP.NET? I think TCP should be enabled in server configuration. Isn't it?
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson -
I think QueryAnalyzer might use NamedPipes and hence pass through. How about ASP and ASP.NET? I think TCP should be enabled in server configuration. Isn't it?
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis LevinsonThis is the first time that I've worked with an outside hosting company, and they do support ASP. I've been writing the server side code in ASP and using VBScript for the included connection functions and some page load events. As far as I can tell the connection string shouldn't be blocked by the firewall and since the SQL server is running at the hosting complex, I assume, I'm not sure what else could be causing the problems. Thanks for the reply, Cheers
An American football fan - Go Seahawks! Lil Turtle
-
Is the firewall enabled? If so, is it allowing access to port 1433?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
I'm fairly certain that the hosting company I'm working with has some kind of firewall enabled but it's also their SQL server that I'm trying to access. How would I check to see if port 1433 is open? Thanks for replying, Cheers
An American football fan - Go Seahawks! Lil Turtle
-
I'm fairly certain that the hosting company I'm working with has some kind of firewall enabled but it's also their SQL server that I'm trying to access. How would I check to see if port 1433 is open? Thanks for replying, Cheers
An American football fan - Go Seahawks! Lil Turtle
Chris McGlothen wrote:
How would I check to see if port 1433 is open?
You could try to ping it. Most likely your web host won't allow traffic in and out of the port over the web. My web host doesn't. Out of curiosity, who is the web host?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
-
Chris McGlothen wrote:
How would I check to see if port 1433 is open?
You could try to ping it. Most likely your web host won't allow traffic in and out of the port over the web. My web host doesn't. Out of curiosity, who is the web host?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
Paul Conrad wrote:
You could try to ping it.
I should've realized that the simplest answer is usually staring you in the face :-D The site is being hosted by Network Solutions. And I've figured out the connection, I was using the wrong connection string format. Sometimes it just takes that second cup of coffe and a quick chat about the playoffs at the water cooler to realize your obvious simple mistakes. Thanks for the help, mate.
An American football fan - Go Seahawks! Lil Turtle