I need to turn on Multiple Active Result Sets for an ODBC data source, but I can not figure out how to set it. And the end of the wizard I see this in the configuration summary: Multiple Active Result Sets(MARS): No It’s best to enable MARS in an app’s connection string when that app is specifically designed to make use of this feature. That said, you can edit the registry entry for the DSN [...]

Background: I am fetching data from a database on SQL Server 2008 (SQLA ) over to Oracle (ORCLA) . The data is pulled using a database link, via HS ODBC connection. Both the SQL and Oracle databases were 32-bit editions. Now, we moved the Oracle database onto faster 64-bit servers(ORCLB), the 32-bit Oracle database remained on the older system, and this system (ORCLA) was still used as the “gateway” between the 2 databases. Today, the [...]

Easy question this time…. I have a installation file, and a registry edit in my script. How do I set up a ODBC-connection as well, actually I need to script up 2 ODBC-connections. Any advice for me? System ODBC settings are stored in the registry under: HKEY_LOCAL_MACHINESOFTWAREMicrosoftODBC I would suggest configuring the ODBC connections manually then exporting the registry values. You can then either script a registry merge or write the values explicitly. Remember to [...]

I have a legacy application that installs fine in Windows XP mode on Windows 7 64 bit, but it requries an ODBC connection. Is it possible to have the XP mode application use the host Windows 7 ODBC configuration (and Oracle drivers)? No. They are considered separate systems, coincidentally running on the same hardware at the same time. Check more discussion of this question. Bookmark on Delicious Digg this post Recommend on Facebook share via [...]

I used to use below registry to import some settings for setting up odbc on Windows Server 2003 32-bit. Now I want to do the same on a Windows Server 2003 64-bit for 32-bit odbc driver not the 64-bit one. Is there any way to modify the registry? Since this one will create entries for 64-bit odbc driver. Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIMY_DB] “Driver”=”C:\WINDOWS\system32\SQLSRV32.dll” “Server”=”10.1.1.1″ “Database”=”MY_DB” “LastUser”=”db_account”[HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIODBC Data Sources] “MY_DB”=”SQL Server” If you want to [...]

I am trying to set up an ODBC connection on Ubuntu. I’ve been swimming in various config files. Could someone please remind me the directory in which the odbc config file is stored? It is called the odbc.ini file, correct? And is there another config file I have to add or that is the only file that controls ODBC? Thanks, Alex usually in /etc/odbcinst.ini , /etc/odbc.ini and ~/.odbc.ini ubuntu manpage Check more discussion of this [...]