User ID/password authentication
- Last Updated: March 1, 2022
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Informix 6.0
- Documentation
This example includes the properties used to connect with the user ID/password authentication.
jdbc:datadirect:informix://servername:port;
InformixServer=informixserver;DatabaseName=databasename;
User=userID;Password=password;[property=value[;...]];
where:
- servername
-
is the IP address or name of the computer that is running the database server to which you want to connect.
- port
-
is the number of the TCP/IP port.
- informixserver
-
is the name of the database server to which you want to connect.
- databasename
-
is the name of the database to which you want to connect.
- userID
-
specifies the user ID that is used to connect to the Informix database.
- password
- specifies a password that is used to connect to your Informix database.
- property=value
- specifies connection property settings. Multiple properties are separated by a semi-colon.
Note: The User and Password properties are not required to be stored in the connection string.
They can also be passed separately by the application.
The following example connection string includes the properties required for connecting with the user ID/password authentication.
Connection conn = DriverManager.getConnection
("jdbc:datadirect:informix://myserver:1526;
InformixServer=myinformixserver;DatabaseName=account;
User=jsmith;Password=secret;");