January 25, 2005 at 12:56 pm
I am running SQL7 standard on a W2k server.
A vb6 program is getting the following Run-time Error.
Run-time Error -2147467259 ([Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.)
Anybody else seen this?
-Mat
January 25, 2005 at 1:17 pm
Are the server and workstation on same Domain? IF NO are the domains trusted? IF yes can you run the SELECT from QA without a problem?
Are you using TCP/IP or named pipes? Go to Client Network utility in the SQL programs folder to see. Try changing them around...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
January 26, 2005 at 11:26 am
We have several vendor applications that issue similar messages for login failures (as opposed to' 42000 login failed', the norm). To diagnose these we've have to extract the user/password from the applications and use ODBC administrator to verify the account and connectivity from the affected workstations/servers before contacting vendor software support. Hope that this helps.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
January 26, 2005 at 4:13 pm
The error messge you're getting has to do with a Database connection error.
I had a similar problem a few years back.. and it turned out being some kind of WINS/DNS issue with the Domain Controller (if I'm remembering correctly).
Try running NBTSTAT from a command prompt. Running it without any parameters will give you the list of options.
You can run
NBTSTAT -a svrname
and it will show if the server is resolving. I think NBTSTAT -r svrname will force a refresh on the WINS for that server but check the NBTSTAT options... Our network guys say it won't take long.. and won't hurt anything.
Back when I had the problem, we used some other windows utility to fix the problem and it had to do with the Domain Controllers not picking up the correct address for the server in question.
Anyway... we had a rebuild on our computer room since then.. and it hasn't been an issue since.
Hope this helps...
Mark Gelatt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply