[Solved] Connect to IBM DB2 without DSN

Forum > Databases

(1/1)

schumi:
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:

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

windows or linux

thank's

--- End quote ---

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

Zvoni:
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:
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

Navigation

[0] Message Index