converting sql to udl file

[charan6066]

how to convert .sql  file to .udl file.

for using the database connection toolkit.

as the input for dbct is connection information which should be a .udl file.

please help me.

thanks...

[aputman]

A .udl file is used for storing connection information.  A .sql file is typically SQL code or queries that you wish to save to disk.  Both are text files but are not really used in the same manner.  So I don't fully understand your question.   

You can create a file on the desktop with a udl extension, double click the file and use the Data Link Properties box to establish a connection.  Then you can open the udl file with a text editor to grab the connection string.  Maybe this is useful for you.  If not, please explain your question. 

[charan6066]

ok thanks...

I got another error  

please try to solve it.

[aputman · Accepted solution]

You are using the wrong driver to connect to the database. Did you use the UDL file and data link dialog box to test the connection?

[charan6066]

thanks for helping me.

now I used the correct driver to connect the database.