|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 17th, 2005, 09:09 AM
|
|||
|
|||
|
Server Connection error, should work
Hello all,
I'm trying to connect to our SQL Server machine from an ASP page. I have an ODBC DSN that works to the server '[server ip]\SQLMIS', but I'm trying to connect using a DSN-less connection string. The string I'm using is: Code:
cst = "Provider=SQLOLEDB.1;UID=xpct;Password=xpct;Initial Catalog=xpct;Data Source=[server ip]\SQLMIS,1044" and the error output is such: Code:
Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNMPNTW]Specified SQL server not found. Any ideas? Could it be related to my DSN being connected? Thanks for whatever you can add. -Keith
|
|
#2
August 17th, 2005, 09:22 AM
|
||||
|
||||
|
DBNMPNTW is a Named Pipes network library. Try to use TCP/IP:
Code:
cst = "Provider=SQLOLEDB.1;UID=xpct;Password=xpct;Initial Catalog=xpct;Data Source=[server ip]\SQLMIS,1044;Network Library=dbmssocn;" http://msdn.microsoft.com/library/d...nsetup_2xmb.asp http://support.microsoft.com/defaul...kb;en-us;265808
|
|
#3
August 17th, 2005, 09:38 AM
|
|||
|
|||
|
Quote:
Thanks for your input, Dwarf. I tried your suggestion, of adding teh network library specification, but didn't get any further, the error that comes back now is: Code:
Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [dbmssocn]General network error. Check your network documentation. Seems it didn't like that at all. I checked out the links you suggested, but do I need to setup an alias on the server? I know the port is set to 1044, and is open. Thanks for any further ideas. -Keith
|
|
#4
August 17th, 2005, 09:52 AM
|
||||
|
||||
|
Can you connect to that server via EM or QA?
ping ip_address - ??? Can you connect to that server via telnet? telnet ip_address 1044 If no, check your network topology, possible firewalls, etc.
|
|
#5
August 17th, 2005, 10:31 AM
|
||||
|
||||
|
Quote:
I'm not sure what to ping here, pinging just the ip_address returns all 'request timed out', and pinging ip_address\SQLMIS returns 'could not find host' --- hmmmmmm, maybe we've got something here, I'll point this out to my network admin Quote:
telnet doesn't connect at all, and no error messages. Unfortunately, my admin's busy with convention prep, and won't be back until later today. I'll have to see what he says about all this, but it is probably a firewall that he installed (a couple worms went around this week, and he's being cautious). Although I'm not sure if it's the firewall, since I haven't gotten the connection to work yet, but that's probably not helping at this point. Thanks for the advice! -Keith
|
|
#6
August 17th, 2005, 10:39 AM
|
||||
|
||||
|
Quote:
Sound like you have a network problem. ip_address\SQLMIS is a name of SQL server instance, not a host name.
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Server Connection error, should work |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
