Cannot Open UDL File

[Scallica]

Hello all,

When I create a "test.udl" file on my desktop, and double click it, I
receive this error message..

"Properties you entered cannot be saved because the Data Link file is
inaccessible. Ensure that the hard drive or network share is still
available."

I am using W2K SP4 with MDAC 2.7 SP1. I installed the Jet 4.0 SP8
patch...same error. I also tried the patch from KB 244659...same error. I
appreciate any suggestions!

Thanks,
Scallica

[Egbert Nierop (MVP for IIS)]

Post by Scallica
Hello all,
When I create a "test.udl" file on my desktop, and double click it, I
receive this error message..
"Properties you entered cannot be saved because the Data Link file is
inaccessible. Ensure that the hard drive or network share is still
available."
I am using W2K SP4 with MDAC 2.7 SP1. I installed the Jet 4.0 SP8
patch...same error. I also tried the patch from KB 244659...same error. I
appreciate any suggestions!

If you open the .udl file to notepad, you'll see probably that it points to
a file or network location that does not exist?

Post by Scallica
Thanks,
Scallica

[Scallica]

Post by Egbert Nierop (MVP for IIS)
If you open the .udl file to notepad, you'll see probably that it points to
a file or network location that does not exist?

Nope. The UDL file is empty. On one PC, I receive this error message. On
another PC, I can open the UDL file and enter connection settings.

~Scallica~

[Egbert Nierop (MVP for IIS)]

Post by Scallica

Post by Egbert Nierop (MVP for IIS)
If you open the .udl file to notepad, you'll see probably that it points

to

Post by Egbert Nierop (MVP for IIS)
a file or network location that does not exist?

Nope. The UDL file is empty. On one PC, I receive this error message. On
another PC, I can open the UDL file and enter connection settings.

That's probably the problem, it should not be empty but look like

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=yourdb;Data Source=yourserver

Post by Scallica
~Scallica~

[Scallica]

Post by Egbert Nierop (MVP for IIS)

Post by Scallica
Nope. The UDL file is empty. On one PC, I receive this error message. On
another PC, I can open the UDL file and enter connection settings.

That's probably the problem, it should not be empty but look like
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=yourdb;Data Source=yourserver

Egbert,

On my other PC, I can create a blank text file, change the file extention to
UDL, and then double click on it to get the data link properties window.

However, on the PC I am having trouble with, when I double click on a new
created UDL file, I receive the error ""Properties you entered cannot be
saved because the Data Link file is inaccessible. Ensure that the hard drive
or network share is still available."

Is it possible that MDAC is simply broken?

~Scallica~

[Egbert Nierop (MVP for IIS)]

Post by Scallica
However, on the PC I am having trouble with, when I double click on a new
created UDL file, I receive the error ""Properties you entered cannot be
saved because the Data Link file is inaccessible. Ensure that the hard drive
or network share is still available."
Is it possible that MDAC is simply broken?

Sure, but hard to say at distance.

You might check a version difference on MDAC by looking at \program
files\common files\system\ado\msado15.dll (look at the version & build)

download a fresh one at http://www.microsoft.com/data/download.htm

Also be sure that if you use JET, that the JET drivers are installed, since
JET is not on the box by default anymore.