I'm trying and failing to get the builtin ODBC32 to work with Visual FoxPro: after SQLDriverConnect() VFP hangs for a couple minutes, finally crashing with a Fatal Error C0000005.
I can tell by the unixODBC trace file that it gets no further than SQLDriverConnect(). Here is the unixODBC trace:
[ODBC][16848][__handles.c][421] Exit:[SQL_SUCCESS] Environment = 0x3c0ad198 [ODBC][16848][SQLAllocHandle.c][338] Entry: Handle Type = 2 Input Handle = 0x3c0ad198 [ODBC][16848][SQLAllocHandle.c][462] Exit:[SQL_SUCCESS] Output Handle = 0x3c0ad918 [ODBC][16848][SQLSetConnectOption.c][255] Entry: Connection = 0x3c0ad918 Option = SQL_ATTR_LOGIN_TIMEOUT Value = 15 [ODBC][16848][SQLSetConnectOption.c][408] Exit:[SQL_SUCCESS] [ODBC][16848][SQLSetConnectOption.c][255] Entry: Connection = 0x3c0ad918 Option = SQL_ATTR_PACKET_SIZE Value = 4096 [ODBC][16848][SQLSetConnectOption.c][408] Exit:[SQL_SUCCESS] [ODBC][16848][SQLSetConnectOption.c][255] Entry: Connection = 0x3c0ad918 Option = SQL_ATTR_AUTOCOMMIT Value = 1 [ODBC][16848][SQLSetConnectOption.c][408] Exit:[SQL_SUCCESS] [ODBC][16848][SQLSetConnectOption.c][255] Entry: Connection = 0x3c0ad918 Option = SQL_ATTR_ODBC_CURSORS Value = 0 [ODBC][16848][SQLDriverConnect.c][646] Entry: Connection = 0x3c0ad918 Window Hdl = 0x10026 Str In = [DSN=pkmcalendar][length = 15 (SQL_NTS)] Str Out = 0x407824f4 Str Out Max = 255 Str Out Ptr = (nil) Completion = 1 UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
Attached is the (trimmed) output returned from the command: wine --debugmsg +relay -- vfp8.exe (200 lines or so)
I trimmed from the original loading of odbc32.dll until a point where it looks as if Wine is loading all over again (cannot stat drive d:, etc.)
The command from VFP is: ? sqlstringconnect("DSN=pkmcalendar")
I'd appreciate any assistance in fixing this. TIA!