Skip to main content

Examples of Connection Strings

Oracle:

"InfoportConnection_Oracle" fill in:

  • "DATA SOURCE=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1536)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dedicated)));User Id=ip;Password=test;",

MS SQL:

"InfoportConnection_SqlServer" fill in and change a password:

  • "Server=127.0.0.1;Database=eainfoport;User id=****;Password=***;",

MS SQL trusted connection:

If the database has integrated security for the domain, use the connection string below:

  • "Server=XXXXX;Database=YYYYY;Trusted_Connection=True"

MySQL:

InfoportConnection_MySql, fill in:

  • "Server=127.0.0.1;port=3306;Database=test_eainfoportt3;Uid=EaInfoportT3;Pwd=info;"

 MariaDB:

"InfoportConnection_MySql":

  • "Server=127.0.0.1;port=3306;Database=test_eainfoportt3;Uid=EaInfoportT3;Pwd=info;"

Other examples