ConnectionRead(recv()) Error exporting to SQL Server from Excel 1

[AccessHelp123]

Hi,

I created a tool using Excel VBA which imports excel and text files into SQL Server, runs stored procedures and creates a report. I am having no issues running the tool from my computer but when users from another location try to run the tool it takes a long time for them to run the tool half way and get the error [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead(recv()). This message seems to occur while the tool is importing a text file into sql server. Can anyone help me with this issue? Thanks.

 

[xlbo]

Database permissions?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AccessHelp123]

Geoff,

The tool first exports excel files and then a text file(both located on the user's local computer) into SQL server(remote). The excel files import fine, even the text file is imported partially before they get this error message. So this does not sound like a permission issue.

 

[xlbo]

Googled the error message and the general consensus seems to be that this error is a connection timeout error - which links in with your statement that it takes a long time to run through

Would suggest that if it takes longer to run on their machines than yours, there is something else going on here...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AccessHelp123]

The connection timeout is set to zero. It is porbably a network issue. I will need to do some more research.