View Single Post
Old 29th February 2012, 06:46 PM
pietera pietera is offline
Junior Member
Join Date: Sep 2011
Posts: 4

I am getting this error when i try to connect to Nexus3 Server:

"Database API specific error
The query returned an error (ODBC State: Hy000

NexusDB:<unnamed TnxODBCWuery instance>:Query preparation failed: Sysntax error at line 369: <builtin_function),<stored_function>,'-','9','*',':','?',<bracketed_binary_string_literal >,<character_string_literal>,...,UNIQUE, UNKNOWN or 'X' expected: Text


It seems to me that the blob fields are the culprits here?

I agree with David Guest that attention should be given to better and/or more reliable connections to NexusDB. At this point in time i have purchased the ODBC driver but dont want to fork out more money for a unreliable ADO provider.

Like i have said earlier we are now forced to use other db systems.

Due to the time it takes to develop WEB applications struggling with database connections adds to the frustrations..

I hope that the vacancy of Hannes does not hamper the development/bug fixing in this department.