Addserver

Syntax : addserver <PROVIDER> <ALIAS> <SERVERNAME/IP/FILENAME> <USERNAME> <PASSWORD> <ENTER>

For CSV: eg.addserver csv <ALIAS> "FOLDERPATH"

For Xero: eg.addserver xero [ALIAS]

For Files: eg.addserver files <ALIAS> "FOLDERPATH"

For ODBC: eg.addserver odbc <ALIAS> "CONNECTION STRING"

For SQLite: eg.addserver sqlite <ALIAS> "CONNECTION STRING"

For Creatio: eg.addserver creatio <ALIAS> "<URL>" "<USERNAME>" "<PASSWORD>"

Description : Add a SQL/MYSQL/POSTGRESQL/CSV/XERO/FILES/ODBC/CREATIO server to our connection list. For CSV/XERO/FILES/ODBC/SQLite USERNAME AND PASSWORD are not required or used. For Xero, first needs to authenticate and then needs to copy code value from browser address bar and paste in console app, we can also create more than one instance by giving alias with double quotes. For Files, we need to give folder path which contains any type of files and later user can upload the files to Server. For Odbc, we need to give complete connection string eg. "Dsn=MS Access Database;dbq=C:\db.accdb;". For SQLite, we need to give complete connection string eg. "Data Source=C:\SQLiteDB\test.db;Version=3; FailIfMissing=True; Foreign Keys=True;"

For Xero, first needs to authenticate and then needs to copy code value from browser address bar and paste in console app. 

For Files, we need to give folder path which contains any type of files and later user can upload the files to Server. 

For Odbc, we need to give complete connection string eg. "Dsn=MS Access Database;dbq=C:\db.accdb;".

For SQLite, we need to give complete connection string eg. "Data Source=C:\SQLiteDB\test.db;Version=3; FailIfMissing=True; Foreign Keys=True;"

---

Updating the PASSWORD

Update the password by giving the same server/alias/username with the changed password.

---

If you use >servers

you will see a list of servers

you can use

>addserver <INDEX>

eg

>addserver 3

to change to that server without having to reregister.

You can also use

>addserver <ALIAS>

In JINT you can do

  di.addserver(2);

or

  di.addserver("myserveralias");