Clarion TopSpeed ODBC Connection

Wed, 24 Aug 2016 01:59:10 GMT

New user of Qlik View Personal Edition (QlikView 11.20 SR13) on Windows 7 Pro, 32bit.

I have a DSN, let’s call it SMEG. This DSN works fine with MS Query/MS Excel or OpenOffice. It is using the Clarion TopSpeed read only driver to connect to the SMEG database.

I am trying to connect to this DSN in Qlik.

I have created an additional user DSN as well as the existing system DSN with no success.

I create a new blank file and edit the script. I use ODBC and hit the connect button. I have tried with both force 32bit on and off. I can select SMEG from the data source. Test connection is successful. Press OK.

Press the select button to select my tables and fields. This is where the problem is. The data source is listed, SMEG.

The database and fields drop down menus are grayed out, I can’t select any tables or fields. The driver button reports many details relating to the Clarion driver.

I am sure that I am missing something basic.

The support button from the connection statement window reports the following:

====================DataBase====================

SQL_DATA_SOURCE_NAME SMEG

SQL_SERVER_NAME

SQL_DBMS_NAME TOPSPEED

SQL_DBMS_VER 01.00.0000

SQL_DRIVER_NAME C4OTRX.DLL

SQL_DRIVER_VER 5.00.0008

SQL_DRIVER_ODBC_VER 03.00

SQL_ODBC_VER 03.80.0000

Does anybody have an idea where I am going wrong?

Re: Clarion TopSpeed ODBC Connection

Wed, 24 Aug 2016 23:47:56 GMT

Would it help to show my connection string?

I have tried:

ODBC CONNECT TO [Smeg;DBQ=C:\Smeg\Data\];

And:

ODBC CONNECT32 TO [Smeg;DBQ=C:\Smeg\Data\];

I downloaded MS Power BI Desktop for comparison and I had a similar issue, the ODBC connection had issues, so I copied and pasted my MS Query connection string and it worked:

ODBC (dsn=Smeg;dbq=C:\Smeg\Data\;description=Smeg ODBC;extension=tps)

And here is the start of my MS Query connection string:

DSN=Smeg;DBQ=C:\Smeg\Data\;Description=Smeg ODBC;Extension=tps;

Or course I have tried variants of these connection strings that work with other software in Qlik, however I must be getting the syntax wrong or perhaps there is another issue.

topic Clarion TopSpeed ODBC Connection in QlikView

Clarion TopSpeed ODBC Connection

Re: Clarion TopSpeed ODBC Connection