Hot answers tagged

23

Just a small note to Zorodache answer, if you use the search box from the start menu type the whole path to get the correct version c:\Windows\SysWOW64\odbcad32.exe. Otherwise, you will get the 64-bit version, even if you enter odbcad32.exe in the search box.


20

They are defined in the registry under \ODBC\ODBC.INI\ in various places depending on if the definition is System User: HKEY_CURRENT_USER\Software\ODBC\ODBC.INI 32-bit: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI 64-bit: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI To delete a data source, you have to delete the data source key under ODBC.INI ...


6

Yes, you can. Download MySQL ODBC driver: https://dev.mysql.com/downloads/connector/odbc/ and install Go to ODBC Data Source Administrator > User DNS > Add..., and fill all the fields wit the right informations. Then test if the connections works Go to ODBC Data Source Administrator > System DNS > Add..., and fill all the fields wit the right informations. ...


5

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe): The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder. The 64-bit version of the Odbcad32.exe file is located in the %...


5

It is likely that I uninstalled the MS database drivers when I uninstalled the older version of Office (and not related to the recent Windows update) and the new one must not come with the drivers as standard. The drivers I needed were within the 'Microsoft Access Database Engine 2010 Redistributable' that is currently available at the following address: ...


4

It is a bug in the connector version 8.0.27 which will be fixed in 8.0.28 https://bugs.mysql.com/bug.php?id=105503 As 8.0.28 is not yet released, I downgraded to 8.0.26 which seems not to suffer from this crashes.


3

Rajesh S' answer can already satisfy your requirement. However, the weakness on his answer is that your parameter is dependent on its location on the table. I am suggesting a better solution: Just as Rajesh suggested, create a table with proper headers: Make sure that your cursor is within the table, on the "Data" tab, click "From Table/...


3

Confirm you have access to authenticate Based on your screen shot showing the use of Integrated Authentication and it failing, you will want to confirm the account which you are signed on as and running the ODBC connection test as has appropriate permission to connect the applicable SQL Server instance. Note: You may need to confirm this SQL security is in ...


3

It's possible to copy the files, but to actually use the drivers is a bit more complicated than that. You would need to not only copy them into the correct directory, but you'd have to register them as well. The best way to do this is to find and run the installers. Most of these drivers will be free from the company website and if they're not free no one ...


3

I've had exactly the same issue a couple of years ago... There are 2 versions of odbcad32 on a 64-bit Windows system. And they are both called odbcad32. The default version is the 64-bit version, which will only work for 64-bit ODBC drivers. You must use the 32 bit version because the FoxPro ODBC drivers are 32 bit only. (And only work together with 32-...


3

ODBC is a utility on the client that connects back to the SQL server. It uses a user's credentials to gain access to the SQL server. SQL server has two types of login, either "SQL Authentication" or "Windows Authentication". "SQL Authentication" means the user and password exist in the SQL server (vs. at the Windows/OS-level). Since you say you have ...


3

I had same issue here. But I found my 32 bit entries under: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI


2

I had this same issue and here's how I fixed it for my System DSN. For reference, here are the two paths in the registry for whether the ODBC is 64-bit or 32-bit on a Windows OS. 64-bit: \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI 32-bit: \HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI In the ODBC.INI folder there was a sub-folder with the ...


2

Try the "Microsoft Query". I haven't used MySQL with it but it ought to work if you've set up an ODBC. In Excel 2007 (the version I'm using), "Microsoft Query" is available under "Data", "Get External Data", "From Other Sources". In later Excel versions there's probably a similar structure. Select your ODBC connection, and click "OK". Here's the "non-...


2

To check : Verify the registry at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI, subkey of your driver, if the listed files do exist. For a 32-bit program the folder C:\Windows\System32 is inaccessible and is automatically substituted to C:\Windows\SysWOW64. So a path to System32 should be replaced with SysWOW64. You should have installed the FoxPro 9.0 ...


2

You just need to set and export the ODBCSYSINI environment variable -- export ODBCSYSINI=/opt/teradata/client/ODBC_64/ or set ODBCSYSINI=/opt/teradata/client/ODBC_64/ ; export ODBCSYSINI Note -- this environment variable must be set for php when it's running, whether php inherits the setting from its launch environment, or you add this setting to the PHP ...


2

Correlated Registry Paths 32 Bit: HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/ODBC/ODBC.INI 64 Bit: HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI The below Microsoft KB942976 may have the answer to your question. I've never noticed this myself as the x86 and x64 ODBC System DSNs in my case are always in the applicable system32/odbcad32.exe for 32-bit and ...


2

Excel stores a copy of the queried data in the spreadsheet. You can set an option whether you want it to refresh on load, or only upon some manual intervention or VBA-based event. You can use Excel query data the same as you would any other data in Excel. In the absolute worst case, if there is some kind of limitation, you could copy your queried data to a ...


2

I would use the Power Query Add-In for Excel to tackle this. It can handle appending results from a SQL query to an existing table. http://office.microsoft.com/en-au/excel-help/append-queries-HA104149760.aspx?CTT=5&origin=HA103993872 If you store the data in the Excel Data Model format (not in an Excel Table), the data is highly compressed - there are ...


2

Check /etc/odbcinst.ini, /etc/odbc.ini, ~/.odbc.ini and $ODBCINI to see what rights are assigned. I believe the user running the command may not have rights to one of those files, or may not even have the data source defined if it was created under a different user. Taken from Common Error Messages and What's an odbc.ini and what do I put in it? Further ...


2

ODBC relies on host name resolution capabilities, so the Data Source argument needs to be an expression that the host can lookup, via its available mechanisms. In Windows this involves resolution via SMB/CIFS, WINS, HostFile, DNS, mDNS, etc. The VPN underscores that you are using SMB or DNS naming (with a short name, not FQDN), as both of those generally ...


2

if drivers are installed, you could use the following PowerShell Script: $OldDsn = Invoke-Command -ComputerName OldServer { get-odbcdsn } | % { $splat = @{} if ($_.PropertyValue) { $splat['SetPropertyValue'] = $_.PropertyValue } Add-OdbcDsn -Name $_.Name -DsnType $_.DsnType -Platform $_.Platform ` -DriverName $_.DriverName @...


2

You want to make sure you have an existing odbc driver in order to do this. And tick the following box (mind the french system language) Change your code with the following: DRIVER={PostgreSQL UNICODE};DATABASE=dw;SERVER=mydb.postgres.database.azure.com;PORT=5432;UID=sqladmin@username; And everything should be working. Connection string source Helpful ...


2

Is there any way to use a 32-bit ODBC driver with a 64-bit application? No. You absolutely cannot mix 32bit application and 64bit driver (or vice-versa). Basically, an ODBC driver is, typically, a dll (windows) or a shared object (linux...) which is loaded by its parent application. All executables, dlls, etc that share the same process ...


1

I think there's a better and friendlier approach to both other answers, which is both dynamic and doesn't create extra entries other than the parameters themselves: In Excel: Create a table of parameters: Go to the Table Tools tab and rename the table to Parameters. Then in Power Query: Choose From Other Sources => Blank Query Go to View => ...


1

ISCORP needs to make sure that they have enabled SQL connections on the database broker and that there have enough server slots for SQL connections to come in. An alternative is to export the data you want into a MSSQL database and report from there. There are tools available in the data dictionary to help this and products (pro2SQL) available to do this ...


1

After much wrangling, the thing to do is to reboot the machine / server. As @Ben-N mentioned, comm_log and debug are both set to zero as you can see in the screen capture above. So the regedit was not the issue Finally, because msaccess created a lock file and I could not run msaccess, I've decided to reboot to get rid of that lock file. Once the reboot ...


1

Your only choice here is to either run a 32-bit OS or a 32-bit VM on a 64-bit host (via VirtualBox, VMware, Hyper-v, etc.). You can, however, have more than 4GB of RAM on 32-bit Windows IF you run a server version of the OS (i.e. Windows Server 2012, 2008 R2, or 2008). These OSes allow you to use up to 128GB of RAM. Microsoft has not made PAE available on ...


1

The problem is your connection string. Note that you mentioned UID, password, etc. information in your question, but this info appears nowhere in your code. To connect to the database, you must supply this information in the connection string. Try the following: Connection.ConnectionString = "DSN=sgdv;UID=l8qc1;PWD=l8qc1;" Connection.Open I can't ...


1

Technology used: Windows 7, UFT 32 bit, Data Source ODBC pointing out to 32 bit C:\Windows\System32\odbcad32.exe, Oracle client with both versions installed 32 bit and 64 bit. What worked for me: Start -> search for “Edit the system environment variables” System Variables -> Edit Path Place the path for Oracle client 32 bit in front of the path for Oracle ...


Only top voted, non community-wiki answers of a minimum length are eligible