[Solved] Connect to IBM DB2 without DSN
lazarus / 16-Databases

----------------------------------------------------------------------
schumi · 2022-01-12 08:41

Hi,
it's possible to connect to IBM DB2 with ODBC driver without DSN ?
with ZeosLib it's possible?

windows or linux

thank's

----------------------------------------------------------------------
dsiders · 2022-01-12 14:59

Quote from: schumi on January 12, 2022, 09:41:29 amHi,
it's possible to connect to IBM DB2 with ODBC driver without DSN ?
with ZeosLib it's possible?

windows or linux

thank's

Did you know that Zeos has their own support forum?
https://zeoslib.sourceforge.io/

----------------------------------------------------------------------
Zvoni · 2022-01-17 11:28

No idea about Zeos, but i connect to a DB2 without DSN using
TODBCConnection just fine.
The pitfall i noticed is the connection-String.
Don't use the SERVER-Variable, but SYSTEM

"DRIVER={iSeries Access ODBC
Driver};SYSTEM=10.1.1.2;UID=myUsername;PWD=myPassword"

----------------------------------------------------------------------
schumi · 2022-01-19 17:09

with ZeosLib 8.0 it should be possible to connect to IBM DB2 using
ODBC or OLEDB.

with TODBCConnection
conn.UserName := 'user';
conn.Password := 'password';
conn.Driver := 'iSeries Access ODBC Driver';
conn.Params.Add('SYSTEM=10.0.x.x');
conn.Open ;          

thanks to all