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 [...]Continue Reading »
Fetching data from MS SQL Server 2008 to Oracle via ODBC: Getting ORA-28545: error diagnosed by Net8 error
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 [...]Continue Reading »
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 [...]Continue Reading »
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 [...]Continue Reading »
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 [...]Continue Reading »
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 [...]Continue Reading »
- Cron expression that runs every 5 minutes from 1:30 am – 6:00 am [duplicate]
- Understanding redundant power supplies
- Is there a way for administrators to disable users from installing Firefox extensions?
- Is there research material on NTP accuracy available?
- How to create a limited “domain admin” that does not have access to domain controllers?