ya tengo el driver configurado.
estoy usando el unixODBC
uso el driver v9fp7_linux_db2driver_for_odbc_cli
ya cree el driver en unixodbc:
Código:
[DB2]
Description = DB2 Driver
Driver = /opt/ibm/db2/v9/lib/libdb2.so
Setup = /opt/ibm/db2/v9/lib/libdb2.so
FileUsage = 1
DontDLClose = 1
y la odbc del sistema:
Código:
[sample]
Description = Test to DB2
Driver = DB2
System = 10.5.100.12:50000
UserID = db2admin
Password = delivery
Naming = 0
DefaultLibraries = QGPL
Database = reserva
ConnectionType = 0
CommitMode = 2
ExtendedDynamic = 1
DefaultPkgLibrary = QGPL
DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
AllowDataCompression = 1
MaxFieldLength = 32
BlockFetch = 1
BlockSizeKB = 128
ExtendedColInfo = 0
LibraryView = ENU
AllowUnsupportedChar = 0
ForceTranslation = 0
Trace = 0
aunque en el manual dice que la cree asi:
Código:
[sample]
Description = Test to DB2
Driver = DB2
(cosa que tampoco funciona)
y cuando me trato de conectar:
me dice:
Código:
[08001][unixODBC][IBM][CLI Driver] SQL1013N The database alias name or database name "SAMPLE" could not be found. SQLSTATE=42705
[ISQL]ERROR: Could not SQLConnect
por que puede ser esto?
que estoy haciendo mal!!!
gracias.