467,867 Members | 1,345 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,867 developers. It's quick & easy.

Constant ODBC Call Fails

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
  • viewed: 1407
Share:
1 Reply
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.

Similar topics

4 posts views Thread by Andreas Lauffer | last post: by
5 posts views Thread by Zlatko Matiś | last post: by
6 posts views Thread by niklaus | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.