Solved

VB6 application gives ODBC Drivers error '80004005'

Posted on 2004-04-17
10
325 Views
Last Modified: 2008-02-01
Hi there,

I'm using a vb6 application on my win2k machine which connects to a remote sql server. When I run the application I get the following error:

Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC SQL Server Driver][Named Pipes] Specified SQL Server not found.

My colleague wrote this app and on a previous beta version we didnt get any such error. The datasource hasn't changed since.

My question is how can I verify a connection from my win2k client to the sql server manually. Can I run dos utility or something?  Generally how can I go about troubleshooting this error.

thanks,

John
0
Comment
Question by:jjbarnsley
  • 3
  • 2
  • 2
  • +1
10 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 10850582
So are you using a DSN on the machine?  Can you ping the SQL Server by the IP Address?  Can you ping the SQL Server by machine name?
0
 

Author Comment

by:jjbarnsley
ID: 10850703
DSN:  Not that I can tell. I checked the ODBC Administrator on my win2k client and no dsn sources are setup for sql server. I guess the dsn source is compiled in the application.

The server appears to be up, because my colleague can connect to it remotely from his site, the problem is from mine. Yes I wanted to ping the server but the details are compiled in, when I get at them I'll do just that.






0
 
LVL 34

Expert Comment

by:arbert
ID: 10850718
"Yes I wanted to ping the server but the details are compiled in, when I get at them I'll do just that."

So by that, do you mean you don't know the server name/IP address?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 10851033
Please maintain these old open questions:
1 05/15/2003 125 commercial support for deploying WAN/VPN...  Open Linux Networking
2 01/16/2004 250 spam control  Open Email/GroupWare
3 02/02/2004 500 Creating quality PDF's  Open Web Development
4 03/01/2004 500 Secure shares on Samba for different use...  Open Linux Networking
0
 
LVL 8

Accepted Solution

by:
plq earned 500 total points
ID: 10851048
Use TCPIP instead of named pipes. You can set it using the sql client network utility.

TCPIP is faster than named pipes anyway.
0
 

Author Comment

by:jjbarnsley
ID: 10851133
Yes got the sql server details. I tested setting a system dsn in the odbc administrator. When I had this set
to Named Pipes I had the sql error I outlined above. But when I followed plq's suggestion and used TCP/IP
instead the odbc connection was setup.
0
 
LVL 8

Expert Comment

by:plq
ID: 11462493
A grade C ? Normal practice would be a grade A when the solution is correct.

Also experts will not answer your questions in future if you award grade C's. It doesn't cost you any more to award an A or a B. Grade C's are generally seen as insulting or ingratitude on this site.

Please can you reconsider.
0
 

Author Comment

by:jjbarnsley
ID: 11474753
plq,

Yes you are absolutey correct. That was my mistake. I always provide a 'A' grade
where I can as I do appreciate that experts provide.

Apologies I didn't mean to cause any offense. Admin, can this be regraded to an 'A'?

thanks,

John
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 69
This query failed in sql 2014 5 30
TSQL - How to declare table name 26 30
Show Results for Latest DateTime in a View 27 25
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

770 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