Connection String tool 1

[Cloonalt]

Someone posted a very clever way to create a connection string by creating a text file and then renaming it with a different file extension?

I can't remember the details. Does anyone know about this?

Thanks for any help.

 

[jbenson001]

Dim objDataLinks, strRetVal
Set objDataLinks = CreateObject("DataLinks")
On Error Resume Next ' ignore cancel
strRetVal = objDataLinks.PromptNew
On Error Goto 0
If Not IsEmpty(strRetVal) Then
InputBox "Your Connection String is listed below.", _
         "OLE DB Connection String", strRetVal
End If
Set objDataLinks = Nothing

Save as a .vbs file

 

[Cloonalt]

Terrific, thank you!

 

[gmmastros]

You are referring to a file with a .udl extension.

On the desktop, create a new text file with the .udl extension. Double click it. After creating the connection string, you can right click the udl file and open with notepad.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLDenis]

also check this out (for future references)

http://www.connectionstrings.com/

udl is on the bottom

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jbenson001]

You are welcome. Someone, not sure who, posted that, and I saved it. So the credit goes to the orignal author.

George that is a cool way too