Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problems to remove Oracle ODBC aliases from ODBC GUI


Problems to remove Oracle ODBC aliases from ODBC GUI

Author
Message
WilburSmith
WilburSmith
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 234
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)
WilburSmith
WilburSmith
SSC-Enthusiastic
SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)SSC-Enthusiastic (129 reputation)

Group: General Forum Members
Points: 129 Visits: 234
Hi,

after uninstalling everything again and cleaning the register 00> ok

v
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search