>>>>Hi all,
>>>>
>>>>I am tring to open a SQL connection via VFP. But when I execute the SQLStringConnect function, I get the DSN dialog. It is requesting tkat I choose a DSN. Here is example of the connection string.
>>>>
>>>>
>>>>"Data Source=servername;Initial Catalog=cbana;User ID=user;Password=mypassword;"
>>>>
>>>>
>>>>I am missing something from the string?
>>>
>>>You use OLEDB connection string. You should use ODBC one :-)
>>
>>Example?
>
>"Driver={SQL Server};Server=ServerName;DataBase=cbana;UID=user;PWD=mypassword;"
thanks
Greg Reichert