Microsoft stores the 32 bit odbcad32.exe in the syswow64 directory and the 64 bit odbcad32.exe in the system32 directory. You can launch the Admin applet from the command line (or a Shortcut) so you get the 32-bit version of the ODBC configuration tool. Both actually have the same name (odbcad32.exe). There has been quite a bit of confusion about using the 32 ODBC Administrator and 32 Bit ODBC drivers in 64 bit Operating Systems so I thought I would put together some information to help when using 32 bit ODBC drivers, such as the TopSpeed ODBC driver.įor 64 bit Operating Systems, there is a 64 bit and a 32 bit ODBC SourceĪdministrator. If you have any questions, you can post them here or even email us at support AT softvelocity DOT com Thanks.Note: This blog was written by Robert Ricketts, who is a Senior Support Representative at SoftVelocity. If you could help me i will really appreciate it. but just the connection, because i can't do anything with the data.
The curious thing is that even if i don't create any DSN the connection to the ODBC succeeds. The connection seems allright, but when i want to make a simple SELECT statement like "SELECT * FROM pacientes", the application throws the exception "ISAM Table Not Found". 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.
0 kommentar(er)
