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. ODBC driver inserted from registry key does not show up in Source Administration

    in Windows 10 BSOD Crashes and Debugging
    ODBC driver inserted from registry key does not show up in Source Administration: I have exported an existing PostgreSQL ODBC driver 64 bit entry from the registry at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INIAnd modified the name of the driver name.The original was[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL ODBC...
  3. Data copy to hdd and the data not visible

    in Windows 10 Network and Sharing
    Data copy to hdd and the data not visible: Hello I have one problem. I have windows 10 2 same computer. WIn 10 Prof. All update setup. When i copy a file to hdd on the first computer, and i take the hdd to another PC, my copyed file not visible on the hdd. When i take a data recovery software to the hdd, the data...
  4. 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...
  5. 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
  6. Easily copy files without changing file dates

    in Windows 10 Network and Sharing
    Easily copy files without changing file dates: Another really annoying issue. I, like so many others if not everyone, want to copy files with Explorer and keep the original file dates. So simple and basic but it seems I have use e.g. Robocopy or some other third party command line process. Why can't Explorer "just do...
  7. 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...
  8. ODBC Connectivity

    in Windows 10 Network and Sharing
    ODBC Connectivity: Hello Microsoft Forum, I am using Easysoft ODBC to allow me to connect to various Servers. The connection keeps dropping which causes various jobs to fail. Would anyone have samples of code which would allow me to check the ODBC connections so that I would know in advance...
  9. ODBC Connectivity

    in Windows 10 BSOD Crashes and Debugging
    ODBC Connectivity: Hello Microsoft Forum, I am using Easysoft ODBC to allow me to connect to various Servers. The connection keeps dropping which causes various jobs to fail. Would anyone have samples of code which would allow me to check the ODBC connections so that I would know in advance...
  10. Microsoft: An Open Source Windows Is ‘Definitely Possible’

    in Windows 10 News
    Microsoft: An Open Source Windows Is ‘Definitely Possible’: Microsoft’s software empire rests on Windows, the computer operating system that runs so many of the world’s desktop PCs, laptops, phones, and servers. Along with the Office franchise, it generates the majority of the company’s revenues. But one day, the company could “open...