Hi, all:
In Windows98, If I click right mouse button on desktop,
the pop menu has a item for creating ADO data source file,
but I can't find it on my Windows2000, where is it?
Thanks!
by Michael Tsa » Wed, 09 Aug 2000 04:00:00
Hi, all:
In Windows98, If I click right mouse button on desktop,
the pop menu has a item for creating ADO data source file,
but I can't find it on my Windows2000, where is it?
Thanks!
by Lasse Edsvi » Wed, 09 Aug 2000 04:00:00
Michael,
Try to create a test.udl in notepad and then right-click the file and
choose properties......
hope it helps
/Lasse
by Niels Berglu » Wed, 09 Aug 2000 04:00:00
There's a registry entry missing. Unfortunately I don't have that around.Quote:>Hi, all:
> In Windows98, If I click right mouse button on desktop,
>the pop menu has a item for creating ADO data source file,
>but I can't find it on my Windows2000, where is it?
>Thanks!
Niels
--
*******************************************
Niels Berglund - ADO/OLE DB MVP
Universal Dataaccess Ltd.
http://www.universaldataaccess.com
ADO FAQ:
http://www.universaldataaccess.com/faq.asp
Code for Download:
http://www.universaldataaccess.com/code.asp
*******************************************
by Jeff Henkel » Wed, 09 Aug 2000 04:00:00
Run the attached registry file; it'll create the context menu item.
begin 666 udl.regQuote:> Hi, all:
> In Windows98, If I click right mouse button on desktop,
> the pop menu has a item for creating ADO data source file,
> but I can't find it on my Windows2000, where is it?
> Thanks!
1. ADO and UDL files - Does ADO cache UDL?
Hello,
I read in the Bill Vaughn book, ADO Examples and Best Practices, that after
an ADO connection object uses a UDL file for it's connectionstring, it somehow
caches the file so it doesn't have to go to the file system each time a new
connection is opened using the same file. He didn't go into much detail and I
haven't been able to find any other documentation about this to support his
claim. In a DevelopMentor class I attended in August 2000, Ted Pattison
suggested the same, but mentioned only that he had heard this was the case and
hadn't yet researched it to find out if it was true.
In an article on ExtremeTech.com, it is said that, "File DSNs are especially
slow and not at all recommended for high-traffic sites because of the way the
files are handled -- each transaction requires that the file be opened,
read/written, closed, and republished to the data provider."
Can anyone confirm whether or not ADO does indeed cache UDL files and if so,
include a link to some documentation? Other than Bill's book, I haven't found
any documentation to support the caching claim.
The ExtremeTech article can be found here:
http://www.extremetech.com/article/0,3396,s%253D1034%2526a%253D15262%...
3D6%2526ap%253D7,00.asp
Thank you!
- Anthony
7. Suspect (Is there any way to remove the suspect db flag)
9. Creating a UDL file from inside VB6
10. Create UDL File programmatically...
11. is it possible to create *.udl file at run time
12. Getting an error when setting up a UDL file