Page 1 of 1
DataStage 7.5 and IQ12.6
Posted: Fri Jan 28, 2005 5:16 am
by Luk
Hi!
Did someone try to connect to sybase IQ 12.6 using ODBC or Sybase Openclient ang get Table definition in Unix!!
I was using sybase IQ 12.5 and everything was OK but with IQ 12.6 I can't do this.
LUK
Re: DataStage 7.5 and IQ12.6
Posted: Fri Jan 28, 2005 6:10 am
by peternolan9
Luk wrote:Hi!
Did someone try to connect to sybase IQ 12.6 using ODBC or Sybase Openclient ang get Table definition in Unix!!
I was using sybase IQ 12.5 and everything was OK but with IQ 12.6 I can't do this.
LUK
Hi Luk,
you might be out on the leading edge there a bit 12.6 is pretty new...I put an append up about esd 11.4 which was needed for 12.5....perhaps it is the same problem back again for 12.6?? What error message do you get?
Is it the implicit data conversion error message again?
Posted: Mon Jan 31, 2005 2:19 am
by Luk
Hi!
DS is trying to retrive information abouty tables through ODBC and it stops without any error massage.
But I have already fix it , I used libdbodbc9_n.so driver instead of libdbodbc9.so driver and ODBC is working fine !!
LUK
Posted: Mon Jan 31, 2005 3:52 am
by peternolan9
Luk wrote:Hi!
DS is trying to retrive information abouty tables through ODBC and it stops without any error massage.
But I have already fix it , I used libdbodbc9_n.so driver instead of libdbodbc9.so driver and ODBC is working fine !!
LUK
And the _n driver is????
Posted: Mon Jan 31, 2005 4:58 am
by Luk
And the _n driver is????
I don't know exactly what you mean!! With Sybase IQ 12.6 there was 3 files libdbodbc9.so, libdbodbc9_r.so, libdbodbc9_n.so!!!
When I take _n file as a ODBC driver - connection in DS works OK.
In Sybase documentation there is information only about libdbodbc9.so driver!
LUK
Posted: Mon Jan 31, 2005 5:54 am
by roy
Realy you did it in IQ 12.5???
funny we couldn't
we ended using windows ds server for imports.
please post when you resolve this.
Posted: Mon Jan 31, 2005 6:01 am
by denzilsyb
Hi Luk
Can you import table definitions using the OC? As far as I am aware, you can only import table definitions using ODBC (which is what you re doing). I ask because if you can import using OC, its a major change from IQ12.5 - and a positive one at that!
Posted: Mon Jan 31, 2005 7:51 am
by Luk
I can't import table definitions using OC
. It is only posible using ODBC!!
Realy you did it in IQ 12.5???
funny we couldn't
we ended using windows ds server for imports.
please post when you resolve this.
Both in IQ12.5 and 12.6 I can import table definitions using ODBC (both in Windows and Unix)!
LUK
Posted: Mon Jan 31, 2005 7:55 am
by denzilsyb
roy wrote:Realy you did it in IQ 12.5???
funny we couldn't
we ended using windows ds server for imports.
please post when you resolve this.
Roy
its all about setting up your .odbc.ini and dsenv with IQ. As Luk points out, OC cannot import table defs, only ODBC.
How did you do it using DS server?