DSXchange

Posted: **Mon Apr 22, 2013 8:56 am**

Hi

Below is a part of .odbc.ini

 55  [Informix]
    56  Driver=/apps/ETL/IS/8.5/Server/branded_odbc/lib/VMinf24.so
    57  Description=DataDirect Informix driver
    58  Database=db
    59  LogonID=uid
    60  Password=pwd
    61  ServerName=informixserver
    62  HostName=informixhost
    63  Service=online
    64  Protocol=onsoctcp
    65  EnableInsertCursors=0
    66  GetDBListFromInformix=0
    67  CursorBehavior=0
    68  CancelDetectInterval=0
    69  TrimBlankFromIndexName=1
    70  ApplicationUsingThreads=1

From the above LogonID and Password are invalid values, Is there any special meaning for the keywords uid and pwd ? are these overriden by values provided in the ODBC stage when it actually connects?

Couldnt find full format description for .odbc.ini file, If there is any documentation could some please help in finding it ?

Posted: **Mon Apr 22, 2013 9:07 am**

zulfi123786 wrote:are these overriden by values provided in the ODBC stage when it actually connects?

Yes.

Posted: **Mon Apr 22, 2013 11:16 am**

zulfi123786 wrote:From the above LogonID and Password are invalid values, Is there any special meaning for the keywords uid and pwd ?

No, You can leave them blank.

zulfi123786 wrote:Couldnt find full format description for .odbc.ini file, If there is any documentation could some please help in finding it ?

Check for the option is ODBC configuration of that database on that vendor's site, like for SQL server on Microsoft's site for effect of those options Or search for DataDirect odbc configuration for that particular database.

Posted: **Mon Apr 22, 2013 4:37 pm**

I never put password in .odbc.ini, and rarely username.

DSXchange

UserId and password in .odbc.ini

UserId and password in .odbc.ini

Re: UserId and password in .odbc.ini

Re: UserId and password in .odbc.ini