>Hi
>Anybody see whats wrong with following connection string:
>Driver=SQL Server;Server=MYSErver\MyName;Database=MyDatabaseUser Id=myname;Password=mypassword;Trusted_connection =yes
>
>Gives me Invalid Connection String
>
>I have this in a VFP app, when it gives an eror, I manually type in Server name, User name and Password and app runs fine
>
>I think I have the syntax of above wrong , but nit sur..gone onto ConnectionSrtings.com and still dont know whats wrong
>
>I tried a few variayions if UserID UID etc but nne worked
>Tia
>Ger
First off you are missing a semicolon before userID.
Second, you either use a trusted connection OR use a username/password. Not both.
Good examples at
www.connectionstrings.com. Make sure you use what is correct for your version of SQL.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________