Oninit cdi / Archive
Talk to an expert →

Re: .odbc.ini and .scrc with Informix/AIX

Posted in 2000

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Server Administration, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

katherinec — — source: Informix-list mailing list archive (1991-1998)

For the .scrc file: METACUBE/<<<<METACUBE's Password went here>>>>@my_data_source Note that METACUBE is the ID I am using For the odbc.ini file: [my_data_source] Driver=/as/informix/lib/iclis09a.so Description=Informix 7.x ODBC Driver Database=<<<<MY DATABASE NAME WENT HERE>>>> HostName=<<<<MY HOST NAME WENT HERE>>>> LogonID=METACUBE pwd=<<<<MY PASSWORD FOR METACUBE WENT HERE>>>> Service=<<<<MY SERVICE WENT HERE>>>> Protocol=onsoctcp Servername=<<<<MY SERVNAME WENT HERE>>>> [ODBC Data Sources] Informix7=Informix 7.x ODBC Driver Ifmx9=Informix 9.x ODBC Driver demo=Driver for DEMO Apps could be any driver ; ; Define ODBC Database Driver's Below - Driver Configuration Section ; [Informix7] Driver=/work/informix7/lib/cli/iclis09a.so Description=Informix 7.x ODBC Driver Database=stores7 HostName=clipper LogonID=odbc pwd=odbc Service=turbo Protocol=oltlitcp Servername=ol_clipper [Ifmx9] Driver=/work/informix9/lib/cli/iclis09a.so Description=Informix 9.x ODBC Driver Database=ovs HostName=lucky7 LogonID=odbc pwd=odbc Service=turbo4 Protocol=oltlitcp Servername=lucky7_90 [demo] Driver=/work/informix9/lib/cli/iclis09a.so Description=dBase IV ODBC Driver ; Database if set informs the driver where to locate tables. Database=/work/odbc/demo [Default] ServerName=ol_clipper LogonId=odbc Database=stores7 Driver=/vobs/tristarm/odbc/iclis09a.so [ODBC] Trace=0 TraceFile=odbctrace.out InstallDir=/work/clitest Cleanup=1 Good Luck... I know setting this up was not my favorite thing to do! On Tue, 04 Jan 2000 10:01:20 GMT Patrick McDonough <PatMcDonough@earthlink.net> wrote: > Anyone have a working example of the .scrc and .odbc.ini files > implemented? > > I am running Metacube agents ( sc in particular ) on AIX 4.3.2 and have > followed and tried many different ways to get these files correct. I > get the error message " Identifier too long for this version" when > executing any Metacube agents on the AIX box. Has anyone had a similar > problem? > > AIX 4.3.2 > Metacube 4.2 > IDS 7.3 > > Patrick McDonough > -- Free audio & video emails, greeting cards and forums Talkway - http://www.talkway.com - Talk more ways (sm)

Glossary