>>>>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
>
>I am not sure, because I never worked with Clarion Tables, what is 12345? Is this a Database name or this is a table name?

12345 is just the table name. Is is a "top Speed" table which contains multi-tables within it. Kind of a DBC container.