Text file connection string

[danielhai]

How do I open a DSN using a text file? I can't seem to get the connection string right ....

thank you.

 

[link9]

maybe this will help. I've never used a txt file connection, but I just built this using the UDL tool in Win2k:

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DBQ=" & server.mappath(virtualPathToFile) & ";DefaultDir=" & server.mappath(virtualPathToFile) & ";DriverId=27;FIL=text;MaxBufferSize=2048;PageTimeout=5;"

If you have win2k, and would like to try to use this, just do these steps:

right click on your desktop and pick new --> text file

Once it shows on your desktop, rename it to something .udl

The icon will change once you've renamed it.

Double click on it and that will open up a little wizard thing. Just go through it specifying this and that about the data source you want to connect to. It's pretty self explanatory.

Once you're done, just click ok.

Open a blank notepad document.

Drag the icon onto the blank document.

Voila. DSNless connection string.


Paul Prewett