Differences

This shows you the differences between two versions of the page.

--- windows:connectdatabaseusingodbcwithoutdsn [2015/06/04 09:35] – created rlunaro
+++ windows:connectdatabaseusingodbcwithoutdsn [2015/06/04 10:25] – [Step 2: open it and pick an OLE DB provider] rlunaro
@@ Line 17: / Line 17: @@
 it to ''test.udl''. Open it with double click and you will have something like this:
+{{ :windows:20150604_step_1.png?direct |}}
+===== Step 2: open it and pick an OLE DB provider =====
+Move to the "provider" tab and make sure you select the proper driver, that should be "Microsoft OLE DB Provider
+for ODBC Drivers":
+{{ :windows:20150604_step_2.png?direct |}}
+===== Step 3: create a new connection string =====
+Click on "Use connection string" and then on "Build...":
+{{ :windows:20150604_step_3.png?direct |}}
+In the window that will appear, select "New":
+{{ :windows:20150604_step_4.png?direct |}}
+Pick the ODBC driver you want to use:
+{{ :windows:20150604_step_5.png?direct |}}
+Windows will request you to save this file as a "something.dsn" file. Select a file; it can be deleted afterwards:
+{{ :windows:20150604_step_6.png?direct |}}
+After that, some configuration parameters that are specific for the driver will be requested. Because I've
+the Microsoft for Oracle Driver, the usual screen requesting TNS, username and password is shown. In other
+drivers, other screens will appear.
+{{ :windows:20150604_step_7.png?direct |}}
+You will see that after this step the important information of the connection string is fullfilled:
+{{ :windows:20150604_step_8.png?direct |}}
+Fulfill the username, password and click on "Allow saving password":
+{{ :windows:20150604_step_9.png?direct |}}
+Save all the information and close the window.
+===== Step XX: open the udl file with a text editor =====
+After that, open the ''*.udl'' file with a text editor. You will see something like that:
+<code>
+[oledb]
+; Everything after this line is an OLE DB initstring
+Provider=MSDASQL.1;Password=YOUR-PASSWORD-HERE;Persist Security Info=True;User ID=YOUR-USERNAME-HERE;Extended Properties="DRIVER={Microsoft ODBC for Oracle};UID=YOUR-USERNAME-HERE;PWD=YOUR-PASSWORD-HERE;SERVER=YOUR-TNS-HERE"
+</code>
+You can use that as a connection string for your ADODB.connection objects and it won't need any DNS
+for connection.
+===== Step 3: move back to "connection" and create a new connection string =====
+Moving back to the Connection tab, you have to click on "Use connection string".