ODBCConnection Execute Select

[gb]

Hello,
I am trying to execute Select using ODBCConnection. I constructed sql string and then tried to execute it.

sqlstr = "SELECT [Order].order_status_id, Claim.claimstatus_id FROM [Order] INNER JOIN Claim ON [Order].claim_id=Claim.claim_id AND [Order].order_id=999999";

I get this error message. Does anybody know why?

Message (18:53:36)
1952621871 999999 19526218
Cannot read a record in ().
The SQL database has issued an error.
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.

If I execute just this:

sqlstr = "SELECT [Order].order_status_id, Claim.claimstatus_id FROM [Order] INNER JOIN Claim ON [Order].claim_id=Claim.claim_id";

I don't get the error.

Thanks in advance.