This discussion is archived
4 Replies Latest reply: Dec 18, 2012 1:04 PM by 978763 RSS

Cannot get ODBC to work with Instant Client

978763 Newbie
Currently Being Moderated
Hi,

I am having problems getting ODBC working with instant client. This is what I have done so far:

1. I installed Instant Client from this page: http://www.oracle.com/technetwork/topics/winsoft-085727.html

The file I downloaded was: instantclient-basic-win32-10.2.0.3-20061115.zip

2. Next, I installed SQL*Plus with this file: instantclient-sqlplus-win32-10.2.0.3-20061115.zip

Now I have SQL*Plus working with instant client.

3. After that I downloaded instantclient-odbc-win32-10.2.0.3-20061115.zip for ODBC.

4. I unzipped the odbc zip file into the Instant Client folder and ran odbc_install.exe. Now I have 'Oracle in instantclient 10_2' showing up in the drivers tab of ODBC Data Source Administrator.

5. Now, if I try to add add a DSN and choose 'Oracle in instantclient 10_2' as the data source, I get an error "ODBC Administrator has stopped working" (http://i50.tinypic.com/jifl2g.png)

I can add DSNs using any other data source without problems. The aforementioned error comes up only when I use 'Oracle in instantclient 10_2' as the data source.

Can someone please let me know how to resolve this?

I am running Windows Vista Business edition 32-bit.

Thanks & Regards,
Ubaidullah Nubar.

Edited by: unubar on Dec 17, 2012 9:42 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points