Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problems to remove Oracle ODBC aliases from ODBC GUI Expand / Collapse
Author
Message
Posted Thursday, June 6, 2013 12:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 7, 2014 7:08 AM
Points: 103, Visits: 200
Hi,

(I know this not SQL 12 matter but I'm in a hurry and did not spot a better spot for this)

The new SqlServ2012 64bit server was installed with Oracle 11g client but later it was found out that they still had a source of version 8.x ==> NO GO and another source that did not function.

They uninstalled 11g and installed 10g - both 64/32 bit clients because I need 32 with SSIS.

BUT after the 10g, I was not able to remove the 11g ODBC entries from the 32 bit ODBC. It was calling after 11g drivers and a NO GO. Did not help even though I deleted the entries from ODBC.INI and from the register and rebooted.

So I tried and created another alias with 10g 32 bit home but it gave error messages, connection was established and DB metadata was readable but when trying to run with SSIS (32 bit)

"The specified DSN contains an architecture mismatch between the Driver and Application"

...that is related in configuration situation in the topic below

http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362%28v=vs.85%29.aspx


What should I try? I think I should reinstall 10g 32 client (64 bit ODBC seemed to work with Sql Agent) but how can I force tge 32 ODBC settings clean??

Ville

(The reason I'm using this source over ODBC is because it just does not function over OleDB like another 10g source functions OK...I dont' understand these Oracle features)
Post #1460533
Posted Friday, June 7, 2013 12:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 7, 2014 7:08 AM
Points: 103, Visits: 200
Hi,

after uninstalling everything again and cleaning the register 00> ok

v
Post #1460969
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse