From: Gerardo C. <gc...@ya...> - 2004-06-24 01:51:35
|
I don't know if this is an ODBC driver or FB issue, but here it is: My application inits and successfully connects to FB server, and after a few trannsactions connection is lost and reconnection attempts randomly work. This is the error message I get: ******** Error Message: Error Nº: 1526 Message: Connectivity Error: Unable to complete network request to host "MYSERVER". Failed to establish a connection. unknown Win32 error 10055 ODBC - Message: Unable to complete network request to host "MYSERVER". Failed to establish a connection. unknown Win32 error 10055 ODBC - SQL Status: 08004 ODBC - Error Nº: 0 ODBC - Connection Nº: 44 Extra: Line Nº: 171 ******* Message ends Environment info: OS: Base Win98se, also tried on another machine with all existent patches installed and latest MDAC FB server: 1.5 build 4306 ODBC driver: 1.02.00.67 Application made with VisualFoxPro 8 sp1. connstring = "DRIVER=Firebird/Interbase(r) driver" + ";UID=myuser" + ";PWD=mypassword" + ";DBNAME=MYSERVER" + ":C:\mypath\mybase.fdb" + ";DIALECT=3" + ";CHARSET=ISO8859_1" I know there's not a VFP issue because the same app is prepared to work indifferently with either M$$QL and Firebird, and using M$$QL this doesn't happen. This only occurs if application/FB server are installed on a Win98 machine, on W2k all work perfectly. If this can be solved, great! If not it seems that my customer will ave to upgrade their server ;-) Thanks in advance, Gerardo |