Oct 21, 2012 ADO Text File Connection String. Scripting The Official Scripting Guys Forum! I'd rather not set the path in the connection string that way. So, if you provide an example could we do something like this: objConn.Open 'Provider=Microsoft.Jet.OLEDB.4.0.
Common issue generally every developer faces in his initial days of development is how to generate connection string that connects my application to the database. Especially when we don’t have sql management studio installed or if we are facing licensing issues.
![Asp Asp](http://3.bp.blogspot.com/-KlrNjCvBu3U/VO6P9ZlAqHI/AAAAAAAAGYM/PHgGEJS4jVs/s1600/connection%2Bstring%2Bproperty%2Bcannot%2Bbe%2Binitialized.png)
Well, a text file can come to a rescue.
To overcome such issues and generate connection strings we need to follow these simple steps:
- Create a text file with any name eg. connections.txt
![Connection Connection](http://www.ozekisms.com/attachments/171/string_database_connection.gif)
- Rename the extension of the file from .txt to .udl
- Double click and open the connections.udl file in the default app
- Set the relevant details in the data link properties manager and if you are using sql authentication then check the checkbox for ‘Allow saving password’ then click ‘OK’ after testing the connection
- Open the connections.udl file in a text editor.
Post comments if this helps