Forum Post: Error with unix ODBC driver (DataDirect 6.1 SQL Server Wire Protocol)

  • Thread starter Thread starter tejasjthorat
  • Start date Start date
Status
Not open for further replies.
T

tejasjthorat

Guest
This query is perfectly running fine in sql server MS SQL server management studio client as well with windows ODBC drivers but it’s not working for me through ODBC connection in unix. Query : select COALESCE(cast (DATA as nvarchar(MAX)),'') from ABC Error: DMExpress : (COLDSNAV) information about the columns could not be retrieved for "DBSource1" (ODBC_ERROR) [DMExpress][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]sp_cursorzclose: The cursor identifier value provided (8) is not valid. I tried below queries to check which is running fine. Query: select COALESCE(cast (DATA as nvarchar),'') from ABC Anyone knows solution for this issue? Any workaround?

Continue reading...
 
Status
Not open for further replies.
Back
Top