Windows 10: How to copy definition of ODBC Data Sources easily?

Discus and support How to copy definition of ODBC Data Sources easily? in Windows 10 Network and Sharing to solve the problem; I have defined 8 "ODBC Data Sources 32-bit" on a Windows10 64 bit.I use them in a machine user interface and every time I create a new user interface I... Discussion in 'Windows 10 Network and Sharing' started by Jake104E, Jun 15, 2021.

  1. Jake104E Win User

    How to copy definition of ODBC Data Sources easily?


    I have defined 8 "ODBC Data Sources 32-bit" on a Windows10 64 bit.I use them in a machine user interface and every time I create a new user interface I have to define these ODBC data sources from scratch. It is not complicated, but it is tedious and there is the risk of manual error, so I would like to import the definitions from a file or similar.Can I locate a once made definition of these data sources and simply copy/import them on my new installation?If so - where do I locate these definitions, and how do I do that?

    :)
     
    Jake104E, Jun 15, 2021
    #1
  2. MesPia Win User

    ODBC Data Sources (32-bit and 64-bit) seem to be the same

    There are two applications under Windows Administrative Tools called ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit). But their shortcuts both point to the same file: %windir%\syswow64\odbcad32.exe. I would expect the 64-bit file to have a name
    like odbcad64.exe. Why is the same file used for both 32-bit and 64-bit?

    BTW, Windows topics (selected below) should have an "Other" selection when the listed selections don't seem to fit the topic being questioned about.

    ***moved the thread to the nearest category by query.***
     
    MesPia, Jun 15, 2021
    #2
  3. File DSN are slow to scan when opening ODBC Data Source Administrator

    *Sigh* I swear I spent an hour googling. I figured it out myself. To describe the symptom again:

    • If you open the ODBC Data Sources Administrator, and it is very slow to load the File DSN tab (e.g., a few minutes), and/or if when you select an ODBC export from Microsoft Access, and Access becomes unresponsive for a few minutes before opening the ODBC
      connection window, then...
    • Your File DSN directory may not be set. The default is a location in Program Files; mine was scanning my Documents directory, which is huge. I don't know why it was set that way. Anyway, I set it to an empty local folder (I never use File DSN), and now
      it opens lickity-split.
     
    BrendanHemens1, Jun 15, 2021
    #3
  4. DanFlak Win User

    How to copy definition of ODBC Data Sources easily?

    Set up a Network Directory a an ODBC Data Source for Excel Files

    I have a folder on a network drive in which I download Excel files produced by other reports and "data dumps."

    These Excel Files are used, in turn, by my own reports. sometimes connecting to them by MS-Query.

    What I would like to do is set this directory up as an ODBC Data source, so I can navigate to it and then select the Excel file as I would a table from another database.

    I know that it is possible to set up a directory as an ODBC source for text files and I've done that in the past.

    I doubt that it is possible to set up a directory as an ODBC source for Excel Files, but I have to ask. It would be just too convenient to do this How to copy definition of ODBC Data Sources easily? :).
     
    DanFlak, Jun 15, 2021
    #4
Thema:

How to copy definition of ODBC Data Sources easily?

Loading...
  1. How to copy definition of ODBC Data Sources easily? - Similar Threads - copy definition ODBC

  2. Configure MS Access Driver in ODBC Data Sources to be read only

    in Windows 10 Gaming
    Configure MS Access Driver in ODBC Data Sources to be read only: Without getting too deep in the weeds, I have an MS Access database .accdb and I needed to create a System DNS connection to it in ODBC Data Sources. Did that it works can connect to it and query it, get results all gravy.However, it is kinda demanding to get the first...
  3. Configure MS Access Driver in ODBC Data Sources to be read only

    in Windows 10 Software and Apps
    Configure MS Access Driver in ODBC Data Sources to be read only: Without getting too deep in the weeds, I have an MS Access database .accdb and I needed to create a System DNS connection to it in ODBC Data Sources. Did that it works can connect to it and query it, get results all gravy.However, it is kinda demanding to get the first...
  4. Using NTFS Mount as an ODBC Data Source

    in Windows 10 Gaming
    Using NTFS Mount as an ODBC Data Source: We have a Windows 10 Pro PC running on a VM that has a mounted NFTS drive, just using the anon switch to not require credentials. The drive letter is Z and net use shows it as an NFS Network drive mount. We can browse and interact with it just fine in explorer.However, one of...
  5. Using NTFS Mount as an ODBC Data Source

    in Windows 10 Software and Apps
    Using NTFS Mount as an ODBC Data Source: We have a Windows 10 Pro PC running on a VM that has a mounted NFTS drive, just using the anon switch to not require credentials. The drive letter is Z and net use shows it as an NFS Network drive mount. We can browse and interact with it just fine in explorer.However, one of...
  6. Using NTFS Mount as an ODBC Data Source

    in Windows 10 Network and Sharing
    Using NTFS Mount as an ODBC Data Source: We have a Windows 10 Pro PC running on a VM that has a mounted NFTS drive, just using the anon switch to not require credentials. The drive letter is Z and net use shows it as an NFS Network drive mount. We can browse and interact with it just fine in explorer.However, one of...
  7. New data source ODBC driver could not be loaded due to system error 126

    in Windows 10 Gaming
    New data source ODBC driver could not be loaded due to system error 126: Hello,I have an error when i want to add User DSN in ODBC data administrator 32 bit after clicking the related driver.. "The setup routines for the CSI RBM 4.02 ODBC Driver ODBC Driver could not be loaded due to system error code 126: The specified module could not be found....
  8. Set up a Network Directory a an ODBC Data Source for Excel Files

    in Windows 10 Drivers and Hardware
    Set up a Network Directory a an ODBC Data Source for Excel Files: I have a folder on a network drive in which I download Excel files produced by other reports and "data dumps." These Excel Files are used, in turn, by my own reports. sometimes connecting to them by MS-Query. What I would like to do is set this directory up as an ODBC...
  9. How to installing Microsoft Excel Driver for ODBC data source 64bit

    in Windows 10 Drivers and Hardware
    How to installing Microsoft Excel Driver for ODBC data source 64bit: HI I want to add a new ODBC data source but when I go to add it the Microsoft excel driver isn't there? [ATTACH] https://answers.microsoft.com/en-us/windows/forum/all/how-to-installing-microsoft-excel-driver-for-odbc/f41aa82f-a14d-4335-88e3-446419f8b07a
  10. File DSN are slow to scan when opening ODBC Data Source Administrator

    in Windows 10 Drivers and Hardware
    File DSN are slow to scan when opening ODBC Data Source Administrator: When I trigger the opening of the 32-bit or 64-bit ODBC Data Source Administrator, and select File DSN, it takes forever to show the tab. I see this when I export a table from Microsoft Access to a SQL Server db. That I can discern, this is because the first tab the...