Rebooting does not change things. I am definitely getting the data and it matches that which is returned by MSQuery. Maybe I'm gettig a rouge error from ODBC.

Most odd.

I could just ignore this specific error as long as my cursor is created I guess. Doesn't explain what's happening though.

Any ideas???

Regards
Geoff Scott


>Are they free tables or belongs to DBC?
>
>>

?SQLGETPROP(gnConnHandle,"ConnectString")
>>
>>"DSN=SageLine50v8;UID=manager;PWD=;"

>>
>>Sorry, misunderstood
>>
>>>>Hi Sergey
>>>>
>>>>>Can you post connection string? You can use SQLGETPROP(gnConnHandle,"ConnectString") to get it. Did you try with another table?
>>>>
>>>>yes, yes and now yes
>>>>
>>>>all three sqlexec and the sqltables return the same error
>>>>
>>><snip>
>>>
>>>So, where is connection string?