iAnywhere Oracle ODBC driver problem

Dear forum members,

I wonder if anyone of you has experienced something similar or can help.
On a customer's server (Win 2012 64bit), I've created an ODBC Data Source using the iAnywhere Oracle ODBC driver (v.16) on top of an "Oracle instant client". "Test Connection" inside the 64bit ODBC Administrator worked, but every attempt to use the data source from an Interactive SQL session or for a remote server inside SQL Anywhere 16 failed with invalid user credentials. I tried to enable ODBC tracing but couldn't find any output.

TIA & Best regards
Volker Stoeffler
DB-TecKnowledgy

oracle sa-16 odbc

asked 19 Dec '16, 12:54

Volker DB-TecKy
545●3●7●15
accept rate: 25%

I am not sure, but could it happen that the driver is 32-bit? Or a wrong driver is registered in regsvr32?

(20 Dec '16, 08:20) Vlad

Replies hidden

Hi Vlad, thank you for your comment. I'm very sure it's 64bit since we've copied the whole instant client directory from a machine where it worked together with a v.12 64bit iAnywhere ODBC driver.
Thanks & regards
Volker

(20 Dec '16, 08:43) Volker DB-TecKy

I'm sure it's not related to a system vs. user DSN issue, right?

(20 Dec '16, 08:51) Volker Barth

flat view

One Answer:

active answers oldest answers newest answers popular answers

1	It's resolved. On other nodes, we had used Instant Client 11.2, but for Win2012 this seems to have caused problems. After removing 11.2 and setting up 12.1, it works. Sorry 4 the mess. Volker permanent link answered 20 Dec '16, 09:55 Volker DB-TecKy 545●3●7●15 accept rate: 25% flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-16 ×261
odbc ×145
oracle ×30

question asked: 19 Dec '16, 12:54

question was seen: 5,356 times

last updated: 20 Dec '16, 09:55

SAP SQL Anywhere

iAnywhere Oracle ODBC driver problem

Follow this question

Related questions