Re: can't connect to database with client
On 12 Wrz, 00:05, "John Hardin" <jhar...@epicor.com> wrote: > "Robert" <robso...@gmail.com> wrote in message > > news:99b51f1c-549b-4326-a7a8-b45cf72ccf88@j4g2000yqa.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). > > > Informix 11.5 (I'm just testing this new version, it > > is not a production instance) should act (according to available > > documentation) as a database server fully understanding DRDA protocol > > (similarly as DB2 server). > > I don't have a problem with a server - it is running and it is > > listening on a port which I've give for DRDA connections. The issue is > > with configuring client side. This area is competely new for me. > > (low-hanging fruit) I assume that the Informix server _is_ using the DRDA > protocol on that port? What does your sqlhosts file on the server contain? > > I assume you have to use DRDA rather than the native Informix network > protocols for some reason? > > -- > John Hardin KA7OHZ > Senior Applications Developer, BI Specialist > EPICOR Retail > web:http://www.epicor.com > voice: (425) 245-1800 > fax: (425) 670-1810 > email: <jhar...@epicor.com> > 20818 44th Ave. W., Suite 270 > Lynnwood, WA 98036 USA > Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA > ------------------------------------------------------------------------ > The first time I saw a bagpipe, I thought the player was torturing an > octopus. I was amazed they could scream so loudly. > ------------------------------------------------------------------------ I've forgot to answer your question: No, I don't have to use DRDA. In our company we will migrate from IDS 10 to 11.5. As IBM favors DRDA I'm trying to verify this option. It seems for me that we will use IDS 11.5 with standard CSDK client.
On Sep 13, 5:56 pm, Robert <robso...@gmail.com> wrote: > On 12 Wrz, 00:05, "John Hardin" <jhar...@epicor.com> wrote: > > > > > "Robert" <robso...@gmail.com> wrote in message > > >news:99b51f1c-549b-4326-a7a8-b45cf72ccf88@j4g2000yqa.googlegroups.com... > > > >> > Hello, > > >> > I'm new todb2. I haveInformixdatabase on AIX and ODBC application > > >> > on Windows. I'm trying toconnecttoInformixdatabase 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, > > >> > thendatabasealias. > > >> > Here is the issue: the list of aliases is empty and Ican'tadd > > >> > anything under "Add" option (it seems that it is for different > > >> > purposes). > > > > Informix 11.5 (I'm just testing this new version, it > > > is not a production instance) should act (according to available > > > documentation) as adatabaseserver fully understanding DRDA protocol > > > (similarly as DB2 server). > > > I don't have a problem with a server - it is running and it is > > > listening on a port which I've give for DRDA connections. The issue is > > > with configuringclientside. This area is competely new for me. > > > (low-hanging fruit) I assume that the Informix server _is_ using the DRDA > > protocol on that port? What does your sqlhosts file on the server contain? > > > I assume you have to use DRDA rather than the native Informix network > > protocols for some reason? > > > -- > > John Hardin KA7OHZ > > Senior Applications Developer, BI Specialist > > EPICOR Retail > > web:http://www.epicor.com > > voice: (425) 245-1800 > > fax: (425) 670-1810 > > email: <jhar...@epicor.com> > > 20818 44th Ave. W., Suite 270 > > Lynnwood, WA 98036 USA > > Worldwide Headquarters 18200 Von Karman, Suite 1000, Irvine CA 92612 USA > > ------------------------------------------------------------------------ > > The first time I saw a bagpipe, I thought the player was torturing an > > octopus. I was amazed they could scream so loudly. > > ------------------------------------------------------------------------ > > I've forgot to answer your question: No, I don't have to use DRDA. > In our company we will migrate from IDS 10 to 11.5. As IBM favors DRDA > I'm trying to verify this option. It seems for me that we will use IDS > 11.5 with standard CSDKclient. Finally I've got working db2 client. Yesterday I've used 11.1. Today I'm in the office and I've repeated tests with 11.5 on AIX. There were no connection issues at all.