I changed the conn string to:

DRIVER=SQL Server;SERVER=DSERVER3;database=Euro_Mig_subset;uid=sa

with no PWD clause and it works fine



>There is no password on the database. Here's the error I'm getting now:
>
>The error:
>"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
>
>My conn string:
>DRIVER=SQL Server;SERVER=DSERVER3;database=Euro_Mig_subset;uid=sa;pwd='sa'
>
>
>Here's my updated code:
>
>

>HIDDEN PROCEDURE _SQLConnect
>	>LOCAL bRetVal, iErrNo, sErrMsg, aErrInfo[1]
>bRetVal = TRUE
>	>WITH This
>	>  ** Suppress ODBC error dialog
>  SQLSETPROP(0, "DispWarnings", .F.)
>
>  ** Suppres login dialog
>  SQLSETPROP(0, "DispLogin", 3)
>
>  ** Attempt to connect to the database
>  ._iConnHandle = SQLSTRINGCONNECT(._sSqlConnStr)
>
>  ** If not connected...
>  IF ._iConnHandle < 0
>	>    ** Get the error information
>    AERROR(aErrInfo)
>    iErrNo	= aErrInfo[1]
>    sErrMsg	= aErrInfo[2]
>			>    ** Format the error message
>    .sMessage = "Unable to connect to SQL database" + CHR(13)+;
>                "Error " + TRANSFORM(iErrNo) + CHR(13)+;
>                sErrMsg
>
>    ** Turn on the class's error flag
>    .bErrorOccured = TRUE
>		>    ** Set the function return value to false
>    bRetVal = FALSE
>		>  ENDIF
>
>ENDWITH	
>	>RETURN bRetVal
>
>ENDPROC
>
>

>
>
>
>
>
>>What's your question?
>>
>>>I'm now getting prompted for a password.
>>>
>>>
>>>>Try

>>>>._sSqlConnStr = "DRIVER=SQL Server;SERVER=DSERVER3;database=Euro_Mig_subset;uid=sa;password=''"
>>>>._iConnHandle = SQLSTRINGCONNECT(._sSqlConnStr)
>>>>
>>>>

See also Re: SQL Connection Error Message #835711
>>>>
>>>>
>>>>