Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Provider=SQLOLEDB
Message
From
26/06/2001 15:30:57
 
 
To
26/06/2001 15:07:37
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00437363
Message ID:
00523791
Views:
16
>>
>>Well, I was going to say it no longer works in MDAC 2.5 but apparently if you create an empty text file with a UDL extension and double-click it through the Windows Explorer it opens up the Data Link properties dialog. I tested with both 2.5 and 2.6.
>>
>>Try that and see if it works on your end.
>
>I get "Microsoft Data Link Error","File cannot be opened. Ensure it is a valid Data Link file".
>
>It is no big deal; I saw this and was curious how the UDL files work, so I tried it.
>
>I saw this thread when trying to figure out why I can't get certain sp's to work with OLEDB provider. I have started a thread in SQL forum about my problem, but probably should post it here...much more traffic in VFP forum.

I could have sworn it wasn't going to work until I tried it. At first I did get the same error message you got but then I did the following:

- opened the file in Notepad
- deleted a semicolon added when I created the file
- saved and exit, double-cliked it and voila!?

It opened the dialog. Weird.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform