Where 'examples' is the user DSN created before and 'EXAMPLE.tps' is the. Url = 'jdbc:odbc:Driver= DSN=examples DBQ=//C:/EXAMPLE.tps/!' I tried to connect my java app to a TopSpeed table, in order to do that i created a 'user dsn' using the Topspeed ODBC and the JDBC-ODBC bridge, the source code for my url is as follows: I was looking harder for someone who could help me out, but there is not much information about it. Hi Joel, I'm one of those unfortunated people who has to use Topspeed. The insert statement follows (it's long, but not complex):
We got 3 of the four files to go in OK, but the Users file is causing us grief. So I scripted the data and am trying to insert it through a SQL Query interface (Aqua Data Studio). tps file, but the DTS in SQL Server produced the same error message. We are trying to export data from SQL Server to a Clarion/Topspeed. TPS file, but I'm receiving the following error:Įrror: Expected lexical element not found: This is a long shot, but does anybody here have Topspeed/Clarion experience? I'm trying to write an insert statement to insert data into a TopSpeed.
