Database Connection via UDL

[netmatt]

Is there a way to connect to a SQL Server database using a pre-existing UDL file? Only one post in here with any mention of using a UDL, and that not helpful. Thanks!

[DaRam]

Is there a way to connect to a SQL Server database using a pre-existing UDL file? Only one post in here with any mention of using a UDL, and that not helpful. Thanks!

ConnectionObject.ConnectionString = "File Name=C:\Path\To\UDL_File.UDL;"

[netmatt]

ConnectionObject.ConnectionString = "File Name=C:\Path\To\UDL_File.UDL;"

Great thanks! I was missing the semi-colon...

[Bossie]

When I try this it returns an error. What am I doing wrong

$sqlCon = ObjCreate("ADODB.Connection")
$sqlCon.ConnectionString = "File Name=C:\Path\To\UDL_File.UDL;"
$sqlCon.Open

Before trying I downloaded the latest version, hopefully somebody can help me.

Thanks!

[PsaltyDS]

When I try this it returns an error. What am I doing wrong

$sqlCon = ObjCreate("ADODB.Connection")
$sqlCon.ConnectionString = "File Name=C:\Path\To\UDL_File.UDL;"
$sqlCon.Open

Before trying I downloaded the latest version, hopefully somebody can help me.

Thanks!

Exactly what is the error?

Do you have a COM error handler in your script? If so, what does it show?

[Bossie]

Exactly what is the error?

Do you have a COM error handler in your script? If so, what does it show?

I didn't had a COM error handler yet. After adding this I saw the problem allready. "Error: Login failed for user '<user>'".

Stupid me forgot to save the password in the UDL file, it's working fine now.

Thanks for the quick advise.