ODBC driver

Discussion about communication protocols (configuration, functions, hardware required).
Post Reply
user1

ODBC driver

Post by user1 »

I have problem with ODBC driver - I can't read a block of gate for column from Access table :
SELECT ValueSp,id FROM Tabela1 ORDERED BY id ASC
The status of gates is always KO, but the read a block of gates for row works fine.
The second problem is how to connect to SQL database. I use SQL server express 2008.
The ODBC Client's Communication error file reports "Invalid object name 'Table_1'. The cursor was not declared." .
Any suggestion?
Lorenzo
Posts: 11
Joined: Tue Nov 17, 2009 3:52 pm

Re: ODBC driver

Post by Lorenzo »

SELECT ValueSp,id FROM Tabela1 ORDERED BY id ASC (Wrong)
SELECT ValueSp,id FROM Tabela1 ORDER BY id ASC (Correct)
If you still have problem with ODBC communication use the ODBC protocol Configuration window and click on Errors to see the last error messages.
Attachments
Immagine2.png
Immagine2.png (106.83 KiB) Viewed 5146 times
Post Reply