How do i connect to sybase?
are there are any connectors available?
Thanks in advance. . .
there are two options: using ODBC or OLE DB driver. Both are provided by the Sybase.
Do those work with Sybase IQ, a columnar DB?
I don't have experience with Sybase IQ (it seems it does not have relational structure); maybe if someone else can answer on this question.
Even though Sybase IQ is a columnar database, it is still fully relational, ODBC and JDBC work fine with Sybase IQ (don't know about OLE DB since I don't use this).
Sybase IQ fully supports ANSI SQL.
Use proper drivers version from Sybase (sybase website) and connect through ODBC. It work out fine. I have tested with sybase 12.5.
Thank u all . . :-)
Retrieving data ...