July 9, 2002 at 6:06 pm
i've developed a system using visual basic for the application and sequel 7.0 for the data server. In my implementation phase some client encountered an error "timeout expired" currently i'm using MDAC 2.6, what would be the alternative solution...?
July 9, 2002 at 6:51 pm
Was the client connecting via Named Pipes or TCP/IP as the default library? If the client and the server are not one and the same box, often TCP/IP is faster and more efficient. We saw in our own testing when talking via Named Pipes these timeout errors which were resolved by changing network libraries. I know MDAC 2.7 switches the default network library from named pipes to TCP/IP, but I don't believe that is the case in 2.6.
One way to find out is to do a Start | Run and enter the following program name: cliconfg.exe. It'll bring up the SQL Server network client utility on the client system and you should be able to check the default network library.
Hope this helps.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply