Hola Esparta

Thanks a lot Esparta

Is there a way to retrieve from the MSDE-SQLServer the SECURITYMODE?

Is there a way to set this mode to SQL once it is installed

Regards

Oscar

>Inline response.
>
>>Hi all
>EP->Hi Oscar...
>
>>I´m trying to connect to the MSDE engine included with Visual FoxPro 7.
>>After creating the instance for the SQLServer object through:
>

>oConn = createobject("SQLDMO.SQLSERVER")
>

>>I would like to use the connect method to establish the required communication to the SQLServer engine.
>

>oConn.connect(“Localhost”, "user", "Password")
>

>>What would be the default administrator to run the connect method accordingly?
>EP->You will be the user as you define in the second parameter
>
>>Where do you tell the connection the DSN to be used?
>EP-> You don't need it, SQLServer is omnipresent!! :-D
>>I would appreciate any advise about where to get documentation about “Trusted connection” an all its details. The error I’m receiving when trying to connect has to do with “Trusted connection”, but I do not understand what is it about.
>EP-> You need to set up as MixedMode, SQLServer has the ability of accept to valid the connections via Windows Security, Internal user-password security of both as MixedMode. See the articles in the BOL (Books on Line), you can see spanish FAQs about it.
>http://www.helpdna.net/bosqlfaq.htm
>
>>Thanks in advance
>EP-> You are welcome!.
>HTH