By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,477 Members | 1,383 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,477 IT Pros & Developers. It's quick & easy.

Constant ODBC Call Fails

P: n/a
Ok, I have an Access 97 GUI with SQL 7.0 backend. On one database I'm
constantly getting a call fail. I'm not sure why. From the user
accounts it seems to happen mostly when they have the form open, but
are static...doing something else. They begin to enter a record and
when they go to move to another record or save they get the error, but
not everytime. When the error occurs, they have to close out of the
database and open it back up.
I have mdac 2.8 on all the comps, and it's not just one user, but not
everyone gets the error. I get the errors on NT 4.0 and on win 2k. I
have a copy of the same database (only converted to AccessXP) with the
same SQL backend but have yet to get any errors on that copy.

Any ideas?

-charles
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Charles wrote:
Ok, I have an Access 97 GUI with SQL 7.0 backend. On one database I'm
constantly getting a call fail. I'm not sure why. From the user
accounts it seems to happen mostly when they have the form open, but
are static...doing something else. They begin to enter a record and
when they go to move to another record or save they get the error, but
not everytime. When the error occurs, they have to close out of the
database and open it back up.
I have mdac 2.8 on all the comps, and it's not just one user, but not
everyone gets the error. I get the errors on NT 4.0 and on win 2k. I
have a copy of the same database (only converted to AccessXP) with the
same SQL backend but have yet to get any errors on that copy.

Any ideas?

-charles


This may help track it.

(air code from memory)
Sub Form_Error(Errnum as integer, Response as integer)
Dim e as Error, strMsg As String
If ErrNum = 3146 Then ' < (Check this is ODBC call failed number)
strMsg = "ODB Errors"
For each e in DbEngine.Errors
strMsg=strMsg & vbCrLf & e.number & " - " & e.Description
Next
MsgBox strMsg, vbCritical
Response = DataErrContinue ' < (Check this constant)
Else
Debug.Print "Error: " & e.number & " - " & e.Description
End if
End Sub

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.