I don't know what ODBC driver version works. This bug is known since year 2007 (MS Excel, MS SQL-linked server).


MartinaJ

>Actually no, using SQLCONNECT() with a DSN does not work. I am getting the same c0000005 error. Here is the last statement in the trace when using the ODBC trace...
>
>

>vfp9            3238-17a8	ENTER SQLGetData 
>		HSTMT               0x00D99FE8
>		UWORD                        2 
>		SWORD                        5 <SQL_C_SHORT>
>		PTR                 <unknown type>
>		SQLLEN                     2
>		SQLLEN *            0x00000000
>
>

>
>Do you happen to know what ODBC version VFP9 works with?
>
>Thanks,
>
>G