Can someone help me with a connetcion string to an SQL2005 Database. I have tried using following string Provider=sqloledb.1; Data Source=(local); Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword;
You can build your connection string in the following way:
1) Create a blank text file 2) Rename the file to Test.udl 3) Double click Test.udl 4) Click on the Provider tab ad select OLEDB provider for SQL Server 5) On the next tab enter the connection information and test the connection. 6) Check Allow Saving password option 7) Click ok to save the file 8) Open Test.udl in notepad and copy the line that starts with "Provider="
Also, the newest build (starting 137) creates the connection string for you. Just go to Admin > Connections to make one.