Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Connection Problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01054056
Message ID:
01054058
Views:
29
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




>When I try to connect, SQL is prompting me for a server login
>on the SQLSTRINGCONNECT line
>
>My code:
>
>
>
>sSqlConnString= "DRIVER={SQL Server};SERVER=(DSERVER3);database=Euro_Mig_subset;uid=sa;password=''"
>
>._iConnHandle = SQLSTRINGCONNECT(._sSqlConnStr)
>
>IF ._iConnHandle < 0
>
>  AERROR(aErrInfo)
>  iErrNo = aErrInfo[1]
>  sErrMsg = aErrInfo[2]
>	
>  .sMessage = "Unable to connect to SQL database" + CHR(13)+;
>              "Error " + TRANSFORM(iErrNo) + CHR(13)+;
>              sErrMsg
>							
>ENDIF
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform