?
Solved

Microsoft ODBC SQL Server Driver Named Pipes Connection Broken

Posted on 2007-07-23
4
Medium Priority
?
838 Views
Last Modified: 2012-08-13
i'm using vb6 client ap connecting to an sql server 2005 database.  on several machines i have no problems at all.  then on one particular machine, i'm getting this error
[Microsoft][ODBC SQL Server Driver][Named pipes]Connection broken

This is a new one to me.  The user can ping the server with no problem, and is using an sqlserver login that the other machines are using without problem
0
Comment
Question by:Fraser_Admin
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:Askeeto
ID: 19550356
First try to connect with tcp/ip. You can do this by putting tcp: in front of the data source of your connectionstring (ex: "Data Source=tcp:yourserver")

If you can connect with this it most likely means the named pipes traffic is being blocked by a firewall or virus scanner on the machine of the user. (I think that named pipes traffic goes over tcp port 445 in case you want to enable it.)
0
 

Author Comment

by:Fraser_Admin
ID: 19555929
thanks, i will get back to you at the first of next week on how it worked.
0
 

Author Comment

by:Fraser_Admin
ID: 19592853
We are using a text file that contains the source.

//Two Forward Slashes at Beginning of Line Means Comments
//Line 1: Scale ID Number
//Line 2: Database Server Name
//Line 3: Customer Printer Name
//Line 4: Scaler Printer Name
//Line 5: Main Server Name
//Line 6: Program Type: Manual (M)/Automatic (A)/Automatic-Simulate (S)
//Line 7: Allow Lookup Table Inserts On Server -- SET False for Truckers: True or False
//Line 8: Allow Visual Keyboard Entry of Cards -- SET True or False
//Line 9: Local User Name
//Line 10: Password
//Line 11: Debug Flag
//Line 12: Server Database Name
//Line 13: Client Database Name
//Line 14: Show Manual Screen
//
Sophia
sql_ju
Dell1700n
Dell1700n
framad18
S
FALSE
FALSE
Scales_User_Local
password
True
Scales_fpnb
Scales_client
True

So then line 5 should look like this?       tcp:framad18
0
 
LVL 3

Accepted Solution

by:
Askeeto earned 2000 total points
ID: 19614814
Indeed. Another option is to use the "Client network utility" on the webserver to configure communication over tcp/ip. But for testing I find it easier to just put tcp:
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

839 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