?
Solved

[DBNMPNTW]Specified SQL server not found.

Posted on 2004-11-18
5
Medium Priority
?
622 Views
Last Modified: 2007-12-19
Hi,

I'm developing an ASP page to connect to a remote SQL server but i'm having a few problems.  I have create the page successfully and it connects and does all it should from my machine, however when i move the script onto another webserver (where it is to eventually reside) I get presented with the following error

[DBNMPNTW]Specified SQL server not found.

Any ideas why this would working on my local machine but not the webserver?

Many Thanks

Chris
0
Comment
Question by:Memorix
  • 2
4 Comments
 
LVL 14

Expert Comment

by:huji
ID: 12616103
The second server can not connect to the SQL server of interest.
Some possible solutions gathered from the web:

Use the SQL Client Configuration utility (from the machine u are connecting)
to create alias server name for the sql server using the TCP/IP protocol
specifying IP and port number.
And use this Alias name to connect to SQL server using TCP/IP


http://p2p.wrox.com/archive/asp_databases/2002-01/18.asp
http://dbforums.com/t939903.html

Wish I can help
Huji
0
 
LVL 3

Author Comment

by:Memorix
ID: 12622728
Hi,

Thanks for your response.  I had previously tried the method you described above without any luck, however after reading another article about this issue it came to light that an incorrect version of the MDAC could also cause the same symptoms so we upgraded MDAC to 2.8 and hey presto... success

Many thanks for trying to help though
0
 
LVL 14

Expert Comment

by:huji
ID: 12622867
No! Not delete and refund! This question is answered, by the author, so I recommend "PAQ and refund" for this.
Consider this as an objection!
Wish I can help
huji
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12659724
Question answered by asker or dialog valuable.
Closed, 100 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question