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