[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.

Cheers,
Diwa

-- 
Semua rasa ada disini
http://www.teoteblung.co.cc



More information about the Lazarus mailing list