Where is odbc connection stored

Active Oldest Votes. Improve this answer. ComputerVersteher 2, 1 1 gold badge 8 8 silver badges 19 19 bronze badges. Gord Thompson Gord Thompson k 27 27 gold badges silver badges bronze badges. I was too late; but you should add the odbcad INI was there. Is it possible that the keys would be invisible to me at this location because of lack of privileges? Do you not get a UAC prompt when you launch regedit.

I do get the UAC prompt. Actually, it makes sense that nothing is there because it was intended to be a User DSN. When I go into Access and try to click on a linked table which references this DSN, it shows the old incorrect connection info This seems to have overwritten the phantom datasource.

But I still don't know what the hell it was referencing before and possibly still referencing Show 3 more comments. Hope this helps! Jeff H Jeff H 46 1 1 bronze badge. I have no "ClickToRun" folder. Any idea what is going on there? No real clue I guess I shouldn't complain because I don't like Google either. Maybe it's a version issue? How did I find this place in the registry? So maybe you can find yours if they exist in the registry , by creating an obviously unique SQL ODBC data source using Access, then search the registry for it.

It would be much more fun if Microsoft just documented things better. Yeah still couldn't find it DSN file? What does DSN mean? Defense Switched Network. A User DSN is only accessible by the user who created it on the workstation. A System DSN is accessible by any user logging into the workstation. A File DSN is shared between all users that have the same drivers installed. Click the Windows "Start" button and then click "Control Panel.

Click the DSN you want to test. Click the "Test Connection" button. Why is ODBC needed? How does DSN work? Once you create a DSN for a particular database, you can use the DSN in an application to call information from the database.

How does ODBC connection work? Driver Manager, which loads drivers for the application. Why is it called Bay Area? Click Test Connection to verify connectivity. Running the odbcad32 command in the Command Prompt or in the Run dialog box will start the bit version of the ODBC administrator on the bit Windows by default, therefore your best option is to select the bit version of the administrator in the search results of the Windows search box.

Note though that if you have both versions bit and bit of the driver installed and you have configured a User DSN in contrast to a System DSN , you will be able to use the same DSN for bit and bit applications see the Platform column in the screenshot below. In a situation where you need to use an application that is available only in bit, the bit ODBC driver does the trick.

An example is Apache OpenOffice, which is distributed as a bit application. How To. ODBC Drivers. What is an ODBC driver and a data source? Author Recent Posts. DAC Team.