>>>>>>>>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.
>>>
>>>What happens if you use:
>>>

>>>IF SQLTABLES(YourODBCConnectionHandler,['TABLE'],[crsTables]) < 0
>>>   AERROR(laError)
>>>   MessageBox(laError[1,2])
>>>   RETURN
>>>ENDIF
>>>BROW NORMAL
>>>

>>Yes !!!!!
>>I get a list of all of the Tables within each TPS file in the directory.
>>
>>This is great - I feel we have made so much progress - thank you -
>>
>>Still - I am lost as to how to utilize this info in my CA situation.
>>
>>thanks again
>>bill
>
>
>Run the builder, choose ODBC, Then Use Connection String. In the connection string edit box paste the connection string you use for YourODBCConnectionHandler :-), Test Connection. Then if the connections is successful go to Data Access tab and build the Select statement.
---------

Yes - I have been trying various methods of this, however I have had no luck so far. Your help has been invaluble - but I am very new at this remote odbc access stuff.

when doing testing from the command prompt my connection string was
STORE SQLCONNECT('BestCase') TO gnConnHandle

This will not work, nor will any variation of it work, with in the builder. The error is Datasource Not Found, and no default driver specified.

I have been able to get a remote view to pick up the fields names, and I have been able to update the table.

My problem with the View is that each record in the Clarion/TPS system is self contained in a TPS file. So - when I want to access the Clarion data I must be able to update my connection and select statments on-the-fly as I will be passing the name of the tps file.

thanks again for your help -
bill