June 27, 2005 at 7:54 am
Hi
I'm experiencing problems connecting to a database in New York from EM here in the UK. Typically if I try to export a large table from the NY db to my local db I get "General NetWork Error" and the export fails. Similar errors occur if I use an application to insert rows in the NY db.
I've been through all the troubleshooting stuff on the MS website and it all checks out OK. The only clue I have is that a sniffer trace indicates that my pc is trying to authenticate by both SQL and Windows. I'd expect it only to use SQL authentication as that's how the ODBC DSN is configured.
Julian
June 28, 2005 at 9:08 am
general network error could mean anything. If you can authenticate against the DB in NY, then its likely that you are encountering a network or bandwidth issue which is causing your export to fail.
You might consider using BCP to export that table to local disk on the NY server, that is presumming you have access to the box itself. Then zip it up or rar it and then FTP it over to your UK location.
June 28, 2005 at 9:48 am
If it is network blips causing the problems, then I've found robocopy a great tool. It can recover and keep copying a file when file copies can't make it intact in one attempt.
June 28, 2005 at 3:02 pm
... another point of view ... SQL Server and EM are client/server tools. By definition client/server tools are meant to be utilized over a LAN. You are attempting LAN operations over a WAN.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
February 3, 2006 at 7:46 am
Turned out to be a networking problem - some kind of mismatch between UK and NY - works fine now. Thanks all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply