Re: can't connect to database with client
On 11 Wrz, 20:05, Ian <ianb...@mobileaudio.com> wrote: > Robertwrote: > > 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? > > You will probably have better luck posting this to question to > comp.databases.informix. I don't think so. 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.
"Robert" <robsosno@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: <jhardin@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. ------------------------------------------------------------------------