>>Thanks for the help
>
>You are welcome. Are this working? It sould, but just curious :-)

Hi Borislav,

I too am attempting to connect using Cursor Adaptors to Clarion via their ODBC drivers.

I created a connection string as you instructed, and I get a OK response on the the Test connection.

My next step is within the cursor adaptor builder I want to enter a select statement that will display the tables and fields available in a specific tps file.

I try variations on Select * from 12345, Select * from 12345.tps, Select * from 12345\!Debtor. All error out in the cursor adaptor builder: Message: Variable 'TABLE_NAME' is not found. Method OMEMBER.gettables.

Can anyone help?

thanks
bill