can't connect to database with client
in [DB2]
|
Prev: Another kind of join?
Next: Info on HIPER APAR IZ50993
From: Robert on 11 Sep 2009 09:07 Hello, I'm new to db2. I have Informix database on AIX and ODBC application on Windows. I'm trying to connect to Informix database using odbc client - I've downloaded and installed v9.5fp3_nt32_dsdriver_EN.exe (server side already configured). When adding new DSN with odbcad32 I'm executing following steps: select driver "IBM DB2 ODBC DRIVER" then filling Data source name, then database alias. Here is the issue: the list of aliases is empty and I can't add anything under "Add" option (it seems that it is for different purposes). Odbc doesn't work which is obvious as I have no place to give database or remote host name. After googling much I've found that I need to create a DB2 instance (probably) with db2icrt tool. There is no such a tool within v9.5fp3_nt32_dsdriver_EN.exe package. How to configure ODBC client correctly?
From: Ian on 11 Sep 2009 14:05 Robert wrote: > Hello, > I'm new to db2. I have Informix database on AIX and ODBC application > on Windows. I'm trying to connect to Informix database using odbc > client - I've downloaded and installed v9.5fp3_nt32_dsdriver_EN.exe > (server side already configured). > When adding new DSN with odbcad32 I'm executing following steps: > select driver "IBM DB2 ODBC DRIVER" then filling Data source name, > then database alias. > Here is the issue: the list of aliases is empty and I can't add > anything under "Add" option (it seems that it is for different > purposes). > Odbc doesn't work which is obvious as I have no place to give database > or remote host name. > After googling much I've found that I need to create a DB2 instance > (probably) with db2icrt tool. There is no such a tool within > v9.5fp3_nt32_dsdriver_EN.exe package. > How to configure ODBC client correctly? You will probably have better luck posting this to question to comp.databases.informix.
From: Mark A on 11 Sep 2009 14:29 "Robert" <robsosno(a)gmail.com> wrote in message news:e6e578b3-c83a-4d4e-9785-fe0295094ad6(a)l13g2000yqb.googlegroups.com... > Hello, > I'm new to db2. I have Informix database on AIX and ODBC application > on Windows. I'm trying to connect to Informix database using odbc > client - I've downloaded and installed v9.5fp3_nt32_dsdriver_EN.exe > (server side already configured). > When adding new DSN with odbcad32 I'm executing following steps: > select driver "IBM DB2 ODBC DRIVER" then filling Data source name, > then database alias. > Here is the issue: the list of aliases is empty and I can't add > anything under "Add" option (it seems that it is for different > purposes). > Odbc doesn't work which is obvious as I have no place to give database > or remote host name. > After googling much I've found that I need to create a DB2 instance > (probably) with db2icrt tool. There is no such a tool within > v9.5fp3_nt32_dsdriver_EN.exe package. > How to configure ODBC client correctly? No, you do not need db2icrt. Looks to me like you are the DB2 client. I am not an expert on Informix, but does the DB2 client work with Informix? If you are connecting to DB2 via ODBC, first you set up a connection with the Configuration Assistant and then register the datasource as ODBC in Windows Administrative Tools. I don't know how Informix works.
From: Robert on 11 Sep 2009 14:58 On 11 Wrz, 20:29, "Mark A" <no...(a)nowhere.com> wrote: > "Robert" <robso...(a)gmail.com> wrote in message > > news:e6e578b3-c83a-4d4e-9785-fe0295094ad6(a)l13g2000yqb.googlegroups.com... > > > > > Hello, > > I'm new todb2. I haveInformixdatabase on AIX and ODBC application > > on Windows. I'm trying to connect toInformixdatabase using odbc > > client - I've downloaded and installed v9.5fp3_nt32_dsdriver_EN.exe > > (server side already configured). > > When adding new DSN with odbcad32 I'm executing following steps: > > select driver "IBMDB2ODBC DRIVER" then filling Data source name, > > then database alias. > > Here is the issue: the list of aliases is empty and I can't add > > anything under "Add" option (it seems that it is for different > > purposes). > > Odbc doesn't work which is obvious as I have no place to give database > > or remote host name. > > After googling much I've found that I need to create aDB2instance > > (probably) with db2icrt tool. There is no such a tool within > > v9.5fp3_nt32_dsdriver_EN.exe package. > > How to configure ODBC client correctly? > > No, you do not need db2icrt. Looks to me like you are theDB2client. I am > not an expert onInformix, but does theDB2client work withInformix? > > If you are connecting toDB2via ODBC, first you set up a connection with > the Configuration Assistant and then register the datasource as ODBC in > Windows Administrative Tools. I don't know howInformixworks. Yes, I'm trying to configure DB2 client. And yes, it should work with Informix. I've found some notes about Configuration Assistant. But I just can't find this in the v9.5fp3_nt32_dsdriver_EN.exe package. Maybe I should install something else too to get Configuration Assistant? My Windows doesn't have any DB2 related software except installed v9.5fp3_nt32_dsdriver_EN.exe. And this package doesn't contain any GUI tools (except one - db2swtch).
From: Mark A on 11 Sep 2009 21:38
"Robert" <robsosno(a)gmail.com> wrote in message news:2870fa1d-69b2-4774-a2fb-9b33dc4c7440(a)s31g2000yqs.googlegroups.com... > Yes, I'm trying to configure DB2 client. And yes, it should work with > Informix. > I've found some notes about Configuration Assistant. But I just can't > find this in the v9.5fp3_nt32_dsdriver_EN.exe package. Maybe I should > install something else too to get Configuration Assistant? > My Windows doesn't have any DB2 related software except installed > v9.5fp3_nt32_dsdriver_EN.exe. And this package doesn't contain any GUI > tools (except one - db2swtch). You probably want the data server client, not just the driver. Get the regular client, not run-time client. I would get FP4, or at least FP3b. Looks like that would be DB2-nt32-client-9.5.302.513-FP003b |