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:
01054073
Views:
23
Kevin,
The password parameter should be pwd, not password.

Kurt
Try 
._sSqlConnStr = "DRIVER=SQL Server;SERVER=DSERVER3;database=Euro_Mig_subset;uid=sa;pwd=''"
._iConnHandle = SQLSTRINGCONNECT(._sSqlConnStr)
>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
>>
>>
>>
>>
>>>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
>>>
>>>
Previous
Reply
Map
View

Click here to load this message in the networking platform