Well, I can't remember everything...

Monday, 14 April 2014

Test SQL OLE Connection String

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.