Replies Back to Article

How to generate an ADO Connection String

I do not follow

February 17, 2001 by tomo

1 go to your desktop. I do not really follow and wonder how other went about this process.

RE: I do not follow

February 17, 2001 by George Test

I mean that you should just right click on the desktop and from the popup menu choose the option NEW and then from the expanded menu with options you choose Microsoft Data Link (or Text Document if it does not exist).

Is this still very unclear? Maybe my English is not so well. I this case rewite the FAQ and send it back to me (e-mail)

RE: RE: I do not follow

February 19, 2001 by tomo

Actually I got what you meant right after I posted a comment. But after creating a file with .udl, nothing happens with double-clicking. Is there anything else that should be done?

RE: RE: RE: I do not follow

February 19, 2001 by tomo

I went into the control panel and just added udl as a new MIME type, and still can not launch Microsoft Connection wizard (Data Link Properties).

Am I on the right track?

RE: RE: RE: I do not follow

February 19, 2001 by George Petrov

Are you sure you put extension .UDL? Did you changed the .TXT extension to .UDL? Or there was no TXT extension? When known extensions are hidden you don't get to see them in Windows Explorer/Desktop.

Do you saw the icon change? What version of Windows do you have?

Suggested change to your procedure

July 24, 2001 by Ron Polak

May I suggest the following:

Create an shortcut to Notepad in your SendTo folder. This will enable you to right click any file and select Notepad from the Send To flyout submenu.

Having done this, right-click the UDL file and select Send To > Notepad to see the connection string.

HTH

error

October 3, 2002 by kathy van de gaer

When I test the Connection String in Ultradev, it works.
When I upload it and test this in IE 6 I get this error message !

Help wanted !
THX !

Microsoft VBScript compilation error '800a0401'

Expected end of statement

Connections/ConnSoepen.asp, line 7

MM_ConnSoepen_STRING = provider="MSDASQL".1;
---------------------------------------^
Persist Security info="False;User" id="kvandegaer;"
Extended Properties="DSN=MS Access Database;
DBQ=C:\Mijn documenten\soepen\data\soepen.mdb;
DefaultDir=C:\Mijn documenten\soepen\data;
DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

Online tool to generate connection string

March 22, 2011 by James Crowley

You might also want to try the SQL Connection string generator on Devfusion. It's only for SQL Server/Express right now but makes things nice and easy.