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 configured sqlhosts and onconfig - this is quite straightforward. I've made some progress in the meantime: I've used testconn20 utility. I've got succesfull connection. Unfortunatelly I've got -23104 error. It seems that non-default locale doesn't work (we are using pl_pl.8859-2 on a production, and pl_pl.CP1250 on my developer's instance on windows). DB2 drivers do not allow to specify DB_LOCALE. Also GL_USEGLU=1 doesn't help (see description to -23104). With ODBC now I have a message that conversion from 1250 to "UNKNOWN" is not possible.