Connect to INTERBASE 7.5

[lio33]

Hi.

(Sorry for my English )

I want to connect to an INTERBASE Database with Labwindows/CVI 7.1.1 .

I suppose that I must use the SQL TOOLKIT and an ODBC Driver.

Does the SQL ToolKit provides an ODBC Driver for all Databases or Borland must provides it ?

I read that Database access through SQL Toolkit and ODBC Driver doesn't compatible with DATE, TIME; TIMESTAMP ... types ?

It's True ?

What's the mean to read DATE, TIME, TIMESTAMP types from à Database ?

Thanks for your answers !

[Jattie]

The SQL Toolkit has some basic drivers included, but not specialised databases.

Download the Interbase ODBC Driver and install on your PC: http://www.easysoft.com/products/data_access/odbc_interbase_driver/ after subscribing and paying or try the open source equivalent: http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc

Then create a new connect string for SQL Toolkit. http://www.jattie.co.uk/software/cvi/help/sqlstring.htm

and use the SQL Toolit to connect to your database. Thete's lots of samples after that, the difficult part is connecting successfully.

[lio33]

Thank you for your response.

I had effectively try the SQL ToolKit with Firebird Database and Firebird ODBC Driver.

It works fine.

Now I want to try different way to improve performance.