Thanx George,

You've been a big help as always!

Bob :-)

>>KB #Q155304
>Hi Bob,
>
>Here's how I translated the VB to VFP. Note the alias in use for the SQLConnect function. This has to be used because of the native command. My VB's pretty rusty, but I think these are right. You might want to compare them to what you've done.

>DECLARE INTEGER SQLAllocEnv IN "odbc32.dll";
>  INTEGER @phenv
>DECLARE INTEGER SQLAllocConnect IN "odbc32.dll";
>  INTEGER henv, INTEGER @phdbc
>DECLARE INTEGER SQLConnect IN "odbc32.dll" AS SQLConnect2;
>  INTEGER hdbc, STRING szDSN,;
>  INTEGER cbDSN, STRING szUID,;
>  INTEGER cbUID, STRING szAuthStr,;
>  INTEGER cbAuthStr
>DECLARE INTEGER SQLFreeEnv IN "odbc32.dll";
>  INTEGER henv
>DECLARE INTEGER SQLFreeConnect IN "odbc32.dll";
>  INTEGER hdbc
>DECLARE INTEGER Function SQLError IN "odbc32.dll";
>  INTEGER As Long, INTEGER hdbc As Long, INTEGER hstmt,;
>  STRING szSqlState, INTEGER pfNativeError,;
>  STRING szErrorMsg, INTEGER cbErrorMsgMax,;
>  INTEGER pcbErrorMsg

>hth,