>>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.