UserId and password in .odbc.ini

[zulfi123786]

Hi

Below is a part of .odbc.ini

Code: Select all

 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 ?

[chulett]

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

Yes.

[priyadarshikunal]

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.

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.

[ray.wurlod]

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