[Lazarus] ODBC with FreeTDS on Ubuntu 8.10

Diwakoe diwakoe at gmail.com
Thu Dec 25 02:58:42 CET 2008

On Wed, Dec 24, 2008 at 5:08 PM, Joost van der Sluis <joost at cnoc.nl> wrote:
> Op woensdag 24-12-2008 om 15:43 uur [tijdzone +0700], schreef Diwakoe:
>> Dear all,
>> I'm try to connect into MSSQL from linux using ubuntu - unixodbc -
>> FreeTDS. First connect using FreeTDS via command shell connect well
>> into MSSQL and can execute query from any table. Second is try using
>> odbc connection in lazarus 0.9.26 connect to MSSQL and get error
>> (attached).
>> Is there any guide how to use odbc on linux using unixodbc and FreeTDS?
> My guess is that you used sqldb.
> Set TSQLQuery.ParseSQL to false. Or else you could set
> TSQLQuery.UsePrimaryKeyAsKey to false.
> For some reason it can not find the primary key of the table. It could
> be that there is none defined, or the odbc-driver that you use to access
> MsSql doesn't support the retrieval of the primary key.
> Or, it's a bug in TODBCConnection, offcourse.
> Joost.

Hi Joost,

You are right I'm using sqldb, all being set and now I can access my
mssql database from linux.

Thank you.


Semua rasa ada disini

More information about the Lazarus mailing list