Mar 04, 2009 11:33 AM|TATWORTH|LINK
You should investigate what the connection string should be like:
1) Create an empty text file in windows explorer and rename it to X.UDL
2) Double click on it and the data-link provider dialogue will appear.
3) Select the provider tab. Find the provider for SQL Server and click next.
4) Select your database
5) Test the connection and save it.
6) Compare the contents of X.UDL with your connections string.