ODBC Sybase ERROR
3 September, 2010
Hi,
Using Yellowfin 5.0 and ODBC Sybase Connection, we are tyring to make a view using freehand SQL but everytime we validate the SQL Statements we encounter this error " [DataDirect][ODBC Sybase Wire Protocol driver]Sybase does not allow more than one active statement when retrieving results without a cursor."
We also tried to copy and paste the SQL Statements from the drag and drop builder and encounter the same error. Querying simple statements also output the same error.
What can be the possible reason for this? Do you have any suggestions on how we can fix this?
I also attached the Yellowfin Log file.
Thanks,
Albert
Using Yellowfin 5.0 and ODBC Sybase Connection, we are tyring to make a view using freehand SQL but everytime we validate the SQL Statements we encounter this error " [DataDirect][ODBC Sybase Wire Protocol driver]Sybase does not allow more than one active statement when retrieving results without a cursor."
We also tried to copy and paste the SQL Statements from the drag and drop builder and encounter the same error. Querying simple statements also output the same error.
What can be the possible reason for this? Do you have any suggestions on how we can fix this?
I also attached the Yellowfin Log file.
Thanks,
Albert
Hi Albert,
There seems to be an issue connecting to the DB with the ODBC drivers.
There are 2 things worth trying;
- Try using the JDBC drivers.
To do this, add the database connection and select
'com.sybase.jdbc3.jdbc.sybdriver'.
-Try changing the number of connections
This is also within the Datbase connection Screen.
Under Connection Management, enter "1" as the 'Max Connections' value.
Can you also tell us if you have run the latest updates?
Regards,
David
There seems to be an issue connecting to the DB with the ODBC drivers.
There are 2 things worth trying;
- Try using the JDBC drivers.
To do this, add the database connection and select
'com.sybase.jdbc3.jdbc.sybdriver'.
-Try changing the number of connections
This is also within the Datbase connection Screen.
Under Connection Management, enter "1" as the 'Max Connections' value.
Can you also tell us if you have run the latest updates?
Regards,
David
Hi David,
The ODBC driver was our last resort to connect the Sybase ASE.
Because there's this exception that we found this exception:
"Using jConnect and Adaptive Server
If you are using jConnect with Adaptive Server on HP, the server?s default character set cannot be roman8. There is no corresponding Java character set converter for roman8 and jConnect cannot connect to the Adaptive Server."
Our client is using HP UX. So for us to be able to connect to the sybase server, we used ODBC.
We haven't run the updates yet but we'll keep you posted. (=
Thanks,
Julie Ann
The ODBC driver was our last resort to connect the Sybase ASE.
Because there's this exception that we found this exception:
"Using jConnect and Adaptive Server
If you are using jConnect with Adaptive Server on HP, the server?s default character set cannot be roman8. There is no corresponding Java character set converter for roman8 and jConnect cannot connect to the Adaptive Server."
Our client is using HP UX. So for us to be able to connect to the sybase server, we used ODBC.
We haven't run the updates yet but we'll keep you posted. (=
Thanks,
Julie Ann
This issue has been resolved with a work-around.
The sybase server has been transfered to the 'localhost' instead of using ODBC.
The sybase server has been transfered to the 'localhost' instead of using ODBC.