sql Connection UDL equivalent
- Thread starter Bartee
- Start date
Nerseus
Danner
I think UDL is a Datalink file, to replace the DSN for ODBC connections, right? If so, you should still be able to open the UDL (just a guess) by specifying it in the connection string when using the OleDB provider...? Just a guess and I dont have a datalink file to test with 
You could, of course, use a custom XML file to store whatever you need to know about the connection string. Youd have to manually extract the elements you need and piece them together into a connection string. This would be similar to an INI file but would be a little more self-documenting and could, with some extra effort, also be easily validated with XSL (if you so-desired).
-nerseus
You could, of course, use a custom XML file to store whatever you need to know about the connection string. Youd have to manually extract the elements you need and piece them together into a connection string. This would be similar to an INI file but would be a little more self-documenting and could, with some extra effort, also be easily validated with XSL (if you so-desired).
-nerseus
Ended up using an XML file and XML code in the program to read it.
I am seen examples of UDLs being used in OLE connection but not in SQL specific connnections.
I tried it but the connection string method did not recognize FILE NAME= parameter.
The 100 MS examples are proving to be very helpful. There is a lot more to learn in each one other than the named example...
I am seen examples of UDLs being used in OLE connection but not in SQL specific connnections.
I tried it but the connection string method did not recognize FILE NAME= parameter.
The 100 MS examples are proving to be very helpful. There is a lot more to learn in each one other than the named example...