A quick way to test or generate an OLE SQL connection string for your application
For example, troubleshooting the following UniFLOW database connection string
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=<some_User>;Password=<some_password>;Initial Catalog=<Database>;Data Source=<SQL_Server>;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096
Log on to the server running the application
Right click on the desktop and choose New -> Text document
Rename the document SQLTest.udl - the UDL extenstion is the important part
Double click the new file and a Data Link Properties wizard should pop up
You can now enter the details of the database server and test the connection
Clicking OK will save the connection string into the SQLTest.udl file. Just open it with Notepad to see the connection string.
No comments:
Post a Comment