You are not logged in.

Advantage ODBC (Sybase)

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

koloe01

Trainee

  • "koloe01" started this thread

Posts: 2

Date of registration: Aug 10th 2010

  • Send private message

1

Tuesday, August 10th 2010, 9:04am

Advantage ODBC (Sybase)

Hi everyone!

I'm desperately trying to get relational extracts from an odbc-connection I've set up in ETL-Manager.
The odbc-connection uses a 32bit driver (Advantage ODBC Driver 9.10) from iAnywhere Solutions to connect to a Sybase database. PaloSuitePremium 3.1 is installed on a 64bit WinServer 2008R2.

Setup of System-DSN and setup of connection in ETL-Manager works fine (well, at least the testbutton says everything's fine).

The problem starts, when I try to set up an extract (relational). Well, one can not do much here, eh? Just fill in the connection an press test or preview and whenever I do this, I get the following error-message:
[iAnywhere Solutions][Advantage ODBC Driver]Option value changed".
Filling in SQL-statements doesn't help either.

On the other hand I can use the set up System-DSN to connect to the data tables via MS Access, so the actual ODBC-Setup seem to be working.

Any hint is appreciated!

Thanks,

David

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Tuesday, August 10th 2010, 11:27am

RE: Advantage ODBC (Sybase)

maybe this helps:
http://support.microsoft.com/kb/942976/en-us

could you report back please?

I am successfully talking from a 32bit ETL-server on Windows XP and Linux via JDBC (genericDB) to the RDBMS EXASOL on 64bit Linux. Maybe JDBC is an option for you.

I'm too having my problems on 64-bit Linux, trying to use OpenOffice Addin on the client side (nogo) and trying to talk from ETL-client to another ETL-server: just silence, no error, no data ...

koloe01

Trainee

  • "koloe01" started this thread

Posts: 2

Date of registration: Aug 10th 2010

  • Send private message

3

Tuesday, August 10th 2010, 11:33am

RE: Advantage ODBC (Sybase)

... unfortunately this doesn't apply to my problem since I was already using the 32bit ODBC Administrator tool.
Thanks anyway!

gonzo

Beginner

Posts: 1

Date of registration: Oct 22nd 2010

  • Send private message

4

Friday, October 22nd 2010, 11:03am

RE: Advantage ODBC (Sybase)

Hello,

I have the same problem (ADS with ODBC). The ODBC-Connection works fine with MS-Query. The connection in the ETL-Server seems to be ok (Test works).
The error occurs while trying to start a SQL-Query (Query is correct).
"Option value changed"

Did you find a solution or do you still have the problem?

Regards
Gonzo

This post has been edited 1 times, last edit by "gonzo" (Oct 22nd 2010, 11:09am)

kais

Master

Posts: 64

Date of registration: Mar 4th 2009

  • Send private message

5

Thursday, February 10th 2011, 9:34am

Even on 64-bit machine, when using 32-bit ODBC, one should use 32-bit java (which means also 32-bit Tomcat). 32-bit tomcat differs from 64-bit tomcat in only the palotomcat6.exe.

32-bit palotomcat6.exe is 56 KB
64-bit palotomcat6.exe is 72 KB

32-bit palotomcat6.exe can be copied from 32-bit installation of palosuite.

Regards,

Kais
Rate this thread