I may have posted part of this before, but have more information on it.
Using VB6, Sql Server 7 on a W2K machine.
I am trying to set up an ADO control and need to set up a Data Link file.
1st) From VB, I right click on the control, go to properties, select "Use Data Link File", go to Browse, right click in the list window, and select New.
There is supposed to be a "Microsoft Data Link" as a choice from the pop-up menu, but it isn't there - lot's of other choices, but not that one.
2nd) Was told to create an empty file with .udl extension and just double click the file and the properties files would come up.
I tried that and I can open and close it with a text editer no problem. The file says it is a Microsoft Data Link file and the icon has changed. It is an empty file. I also tried creating a couple of others. But when I try to double click it, I get the following message:
"Properties you entered cannot be saved because the Data Link file is inaccessable. Ensure that the hardware drive or network share is still available"
First of all, this is not the case, as I can open it fine with the text editer (and any other file) and there is no network share to deal with here.
When I right click the file it says that the program that opens it is "Microsoft Data Access - OLE DB Core Services". The location of the file is "C:\Program Files\Common Files\System\Ole DB\Data Links".
3rd) Now I am really confused. There must be something missing or corrupted.
I have another W2K machine and I tried to create an empty file with the extension tfs.udl on it with my text editor. I then double clicked the file and it opened it fine with the correct properties window asking for provider etc.
I went back to my first machine and did the same thing (in both machines I put the file in the root). It gave me the same error message I got before. So it is nothing I am doing.
The machine it worked on used to be a Winnt 4.0 machine that I upgraded to W2K and the one it didn't work on was a W2K machine I created clean.
Does anyone know what the problem is? I have been trying to solve this for over a month.
Thanks,
Tom.
Using VB6, Sql Server 7 on a W2K machine.
I am trying to set up an ADO control and need to set up a Data Link file.
1st) From VB, I right click on the control, go to properties, select "Use Data Link File", go to Browse, right click in the list window, and select New.
There is supposed to be a "Microsoft Data Link" as a choice from the pop-up menu, but it isn't there - lot's of other choices, but not that one.
2nd) Was told to create an empty file with .udl extension and just double click the file and the properties files would come up.
I tried that and I can open and close it with a text editer no problem. The file says it is a Microsoft Data Link file and the icon has changed. It is an empty file. I also tried creating a couple of others. But when I try to double click it, I get the following message:
"Properties you entered cannot be saved because the Data Link file is inaccessable. Ensure that the hardware drive or network share is still available"
First of all, this is not the case, as I can open it fine with the text editer (and any other file) and there is no network share to deal with here.
When I right click the file it says that the program that opens it is "Microsoft Data Access - OLE DB Core Services". The location of the file is "C:\Program Files\Common Files\System\Ole DB\Data Links".
3rd) Now I am really confused. There must be something missing or corrupted.
I have another W2K machine and I tried to create an empty file with the extension tfs.udl on it with my text editor. I then double clicked the file and it opened it fine with the correct properties window asking for provider etc.
I went back to my first machine and did the same thing (in both machines I put the file in the root). It gave me the same error message I got before. So it is nothing I am doing.
The machine it worked on used to be a Winnt 4.0 machine that I upgraded to W2K and the one it didn't work on was a W2K machine I created clean.
Does anyone know what the problem is? I have been trying to solve this for over a month.
Thanks,
Tom.
