Creating UDL...
-
Hello everyone... I'm presently creating an application using a customized DLL from our original system. the said DLL uses UDL directly from "C:\" root directory to connect to MSSQL server... The new application will process the data through the said DLL and will connect to different MSSQL servers but will only use 1 UDL. My 1st attempt was to create a UDL directly using "StreamWriter" so that the new application can dynamicaly change the server name but it did not work... I compared the UDL created from a streamwriter against the one created in notepad but i found no diferences between the two..... How can i make a dynamic UDL file that can be used by the said DLL? thank you in advance ang more power...
xxx
-
Hello everyone... I'm presently creating an application using a customized DLL from our original system. the said DLL uses UDL directly from "C:\" root directory to connect to MSSQL server... The new application will process the data through the said DLL and will connect to different MSSQL servers but will only use 1 UDL. My 1st attempt was to create a UDL directly using "StreamWriter" so that the new application can dynamicaly change the server name but it did not work... I compared the UDL created from a streamwriter against the one created in notepad but i found no diferences between the two..... How can i make a dynamic UDL file that can be used by the said DLL? thank you in advance ang more power...
xxx
Isn't it possible that the .DLL loads the UDL once and won't reload it on every access to the database? If that's the case, you've got a big problem. The .DLL won't unload until the app closes and relaunches.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
Isn't it possible that the .DLL loads the UDL once and won't reload it on every access to the database? If that's the case, you've got a big problem. The .DLL won't unload until the app closes and relaunches.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...I load and unload the DLL everytime i change the server. the steps are: 1. Load DLL calling the UDL. 2. Process and store the data locally using XML format. 3. Unload DLL. 4. Change UDL server. 5. Load again the DLL...go step 2....
xxx