ODBC driver

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

ODBC driver

Postby user1 » Tue Mar 09, 2010 9:36 am

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

Postby Lorenzo » Tue Mar 09, 2010 3:40 pm

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 3362 times


Return to “Protocols”

Who is online

Users browsing this forum: No registered users and 2 guests