can't connect to database with client
in [DB2]
|
Prev: Another kind of join?
Next: Info on HIPER APAR IZ50993
From: Sawan on 11 Sep 2009 22:29 On Sep 11, 6:07 pm, Robert <robso...(a)gmail.com> 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? I suggest you probably move to v95fp4. IBM Data Server Driver Package should be sufficient for ODBC connectivity purpose. http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com..ibm.swg.im.dbclient.install.doc/doc/c0022612.html While you are creating the DSN, in the Advance properties, add the parameters such as Hostname, Port, Protocol, Database, etc. Regards, Sawan Gupta
From: Mark A on 12 Sep 2009 20:54 On Sep 11, 10:29 pm, Sawan <sawangupta...(a)gmail.com> wrote: > I suggest you probably move to v95fp4. IBM Data Server Driver Package > should be sufficient for ODBC connectivity purpose.http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=... > > While you are creating the DSN, in the Advance properties, add the > parameters such as Hostname, Port, Protocol, Database, etc. > > Regards, > Sawan Gupta- Hide quoted text - Yes, the driver is probably sufficient, but since the OP needs a little help with the connection, the Client Configuration GUI comes with the client software,
From: Robert on 13 Sep 2009 11:31 On 12 Wrz, 03:38, "Mark A" <no...(a)nowhere.com> wrote: > "Robert" <robso...(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 Your suggestion was very helpful. I've downloaded ibm_data_server_client_win32_V97.zip . Then I've used db2ca (Connection Assistant). This tool asked me for things like protocol, port, database name, etc. Then it created "c:\Documents and Settings \All Users\Application Data\IBM\DB2\DB2COPY1" where all this information is written and it seems necessary (odbcad32 is using it, especially db2cli.ini file). I wonder how one can configure ODBC not using db2ca? It looks like server client is the only correct choice (other packages don't have db2ca). I've got also yet another unexpected problem. ODBC client and db2ca allows database name length up to 8 characters. How to use database with longer name? I've renamed database as this is test only database (however I can't do this on a production system). Unfortunately this is not the end. While trying ODBC connection I've got error SQL0332N, SQLSTATE=57017 that conversion from 1250 codepage to "UNKNOWN" codepage is not supported. I've used today Informix server developer version on Windows (earlier I had on AIX but on weekend I don't have access to it). Windows codepage is CP1250, also Informix database was created using CP1250. I've tried also .Net Provider : testconn20 database=northwind;server=komputer: 50000;userid=informix;password=****** Results: connection succeeded, fetch from system tables succeeded, GetSchema got following errors: IBM.Data.DB2.DB2Exception: ERROR [IX000] [IBM][IDS/NT32] SQL0969N There is no message text corresponding to SQL error "-23104" in the message file on this workstation. The error was returned from module "IFX11100" with original tokens "". SQLSTATE=IX000 An error -23104 is an Informix error code meaning "Error opening required code-set conversion object file." I've found exactly the same case here: http://www.nntpnews.net/f1893/connecting-informix-11-5-net-error-6673513/ without solution. This codepage issues seems for me to be too difficult to tackle so I've give up. It is also Informix rather than DB2 issue. It's my guess based on past experience with codepage issues in Informix itself. In summary: - we will be migrating in my company from IDS 10.00 to 11.5 with DRDA support; - IBM favors DRDA over SQLI (Informix) protocol; - I've made a short research if our ODBC and .NET clients can use DRDA; it seems that not yet because we are using non-default code page in database. Thank you for your help.
From: Sawan on 13 Sep 2009 23:01 On Sep 13, 8:31 pm, Robert <robso...(a)gmail.com> wrote: > On 12 Wrz, 03:38, "Mark A" <no...(a)nowhere.com> wrote: > > > > > "Robert" <robso...(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 > > Your suggestion was very helpful. I've downloaded > ibm_data_server_client_win32_V97.zip . Then I've used db2ca > (Connection Assistant). This tool asked me for things like protocol, > port, database name, etc. Then it created "c:\Documents and Settings > \All Users\Application Data\IBM\DB2\DB2COPY1" where all this > information is written and it seems necessary (odbcad32 is using it, > especially db2cli.ini file). I wonder how one can configure ODBC not > using db2ca? It looks like server client is the only correct choice > (other packages don't have db2ca). > I've got also yet another unexpected problem. ODBC client and db2ca > allows database name length up to 8 characters. How to use database > with longer name? > I've renamed database as this is test only database (however I can't > do this on a production system). > > Unfortunately this is not the end. While trying ODBC connection I've > got error SQL0332N, SQLSTATE=57017 that conversion from 1250 codepage > to "UNKNOWN" codepage is not supported. > I've used today Informix server developer version on Windows (earlier > I had on AIX but on weekend I don't have access to it). Windows > codepage is CP1250, also Informix database was created using CP1250. > I've tried also .Net Provider : > testconn20 database=northwind;server=komputer: > 50000;userid=informix;password=****** > Results: connection succeeded, fetch from system tables succeeded, > GetSchema got following errors: > IBM.Data.DB2.DB2Exception: ERROR [IX000] [IBM][IDS/NT32] SQL0969N > There is no message text corresponding to SQL error "-23104" in the > message file on this workstation. The error was returned from module > "IFX11100" with original tokens "". SQLSTATE=IX000 > An error -23104 is an Informix error code meaning "Error opening > required code-set conversion object file." > I've found exactly the same case here:http://www.nntpnews.net/f1893/connecting-informix-11-5-net-error-6673... > without solution. > This codepage issues seems for me to be too difficult to tackle so > I've give up. It is also Informix rather than DB2 issue. It's my guess > based on past experience with codepage issues in Informix itself. > > In summary: > - we will be migrating in my company from IDS 10.00 to 11.5 with DRDA > support; > - IBM favors DRDA over SQLI (Informix) protocol; > - I've made a short research if our ODBC and .NET clients can use > DRDA; it seems that not yet because we are using non-default code page > in database. > > Thank you for your help. Hi Robert, Data Server Drivers support database name longer than 8 characters. Here are the two APAR fixed. http://www-01.ibm.com/support/docview.wss?uid=swg1JR28628 http://www-01.ibm.com/support/docview.wss?uid=swg1JR30850 Regarding the conversion error, you might consider setting GL_USEGLU to 1 before starting the server. http://publib.boulder.ibm.com/infocenter/idshelp/v111/topic/com.ibm.admin.doc/admin155.htm Hope that helps. Regards, Sawan Gupta
From: Robert on 14 Sep 2009 08:52
On Sep 14, 5:01 am, Sawan <sawangupta...(a)gmail.com> wrote: > On Sep 13, 8:31 pm, Robert <robso...(a)gmail.com> wrote: > > > > > On 12 Wrz, 03:38, "Mark A" <no...(a)nowhere.com> wrote: > > > > "Robert" <robso...(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 > > > Your suggestion was very helpful. I've downloaded > > ibm_data_server_client_win32_V97.zip . Then I've used db2ca > > (Connection Assistant). This tool asked me for things like protocol, > > port, database name, etc. Then it created "c:\Documents and Settings > > \All Users\Application Data\IBM\DB2\DB2COPY1" where all this > > information is written and it seems necessary (odbcad32 is using it, > > especially db2cli.ini file). I wonder how one can configure ODBC not > > using db2ca? It looks like server client is the only correct choice > > (other packages don't have db2ca). > > I've got also yet another unexpected problem. ODBC client and db2ca > > allows database name length up to 8 characters. How to use database > > with longer name? > > I've renamed database as this is test only database (however I can't > > do this on a production system). > > > Unfortunately this is not the end. While trying ODBC connection I've > > got error SQL0332N, SQLSTATE=57017 that conversion from 1250 codepage > > to "UNKNOWN" codepage is not supported. > > I've used today Informix server developer version on Windows (earlier > > I had on AIX but on weekend I don't have access to it). Windows > > codepage is CP1250, also Informix database was created using CP1250. > > I've tried also .Net Provider : > > testconn20 database=northwind;server=komputer: > > 50000;userid=informix;password=****** > > Results: connection succeeded, fetch from system tables succeeded, > > GetSchema got following errors: > > IBM.Data.DB2.DB2Exception: ERROR [IX000] [IBM][IDS/NT32] SQL0969N > > There is no message text corresponding to SQL error "-23104" in the > > message file on this workstation. The error was returned from module > > "IFX11100" with original tokens "". SQLSTATE=IX000 > > An error -23104 is an Informix error code meaning "Error opening > > required code-set conversion object file." > > I've found exactly the same case here:http://www.nntpnews.net/f1893/connecting-informix-11-5-net-error-6673... > > without solution. > > This codepage issues seems for me to be too difficult to tackle so > > I've give up. It is also Informix rather than DB2 issue. It's my guess > > based on past experience with codepage issues in Informix itself. > > > In summary: > > - we will be migrating in my company from IDS 10.00 to 11.5 with DRDA > > support; > > - IBM favors DRDA over SQLI (Informix) protocol; > > - I've made a short research if our ODBC and .NET clients can use > > DRDA; it seems that not yet because we are using non-default code page > > in database. > > > Thank you for your help. > > Hi Robert, > > Data Server Drivers support database name longer than 8 characters. > > Here are the two APAR fixed.http://www-01.ibm.com/support/docview.wss?uid=swg1JR28628http://www-01.ibm.com/support/docview.wss?uid=swg1JR30850 > > Regarding the conversion error, you might consider setting GL_USEGLU > to 1 before starting the server.http://publib.boulder.ibm.com/infocenter/idshelp/v111/topic/com.ibm.a... > > Hope that helps. > > Regards, > Sawan Gupta Hi, I've finally solved my connection issues. It was very simple: yesterday I've used IDS 11.1 on my laptop (Windows). Today I'm in the office and I have access to IDS 11.5 on AIX. All connection issues dissappeared. Apparently there where some bug fixes since I've installed version 11.1. Regarding database name I have a different issue than described in APARs. Connection Manager just dosn't allow me to give longer name. Editing db2cli.ini manually doesn't work. |