[DBNMPNTW]Specified SQL server not found.

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
LVL 3
MemorixAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hujiCommented:
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
MemorixAuthor Commented:
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
hujiCommented:
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
ee_ai_constructCommented:
Question answered by asker or dialog valuable.
Closed, 100 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.