Connection Strings

This page provides connection string formats for every supported client and driver. Syntra ODBC listens on port 5433 and accepts standard database connection strings. The formats below work out of the box.

Common Parameters

Parameter	Default	Description
Host	localhost	Server address
Port	5433	Syntra listening port
Database	quickbooks	Database name
Username	syntra	Authentication username
Password	(none)	Password from config.toml
SSL Mode	prefer	TLS setting (disable, prefer, require)

Connection String Formats

PostgreSQL URI (libpq)

Used by pg (Node.js), pgcli, pg8000, and most PostgreSQL client tools:

postgresql://qbconnect:yourpassword@localhost:5433/quickbooks

With SSL:

postgresql://qbconnect:yourpassword@localhost:5433/quickbooks?sslmode=require

ODBC (DSN-less)

For Excel, Access, and other ODBC applications:

Driver={PostgreSQL Unicode};Server=localhost;Port=5433;Database=quickbooks;Uid=syntra;Pwd=yourpassword;

With SSL:

Driver={PostgreSQL Unicode};Server=localhost;Port=5433;Database=quickbooks;Uid=syntra;Pwd=yourpassword;SSLMode=require;

JDBC

For Java applications, DBeaver, and other JDBC-based tools:

jdbc:postgresql://localhost:5433/quickbooks?user=qbconnect&password=yourpassword

ADO.NET (Npgsql)

For C# and .NET applications:

Host=localhost;Port=5433;Database=quickbooks;Username=qbconnect;Password=yourpassword;

SQLAlchemy

For Python SQLAlchemy (using the pure-Python pg8000 dialect):

postgresql+pg8000://qbconnect:yourpassword@localhost:5433/quickbooks

Go (pgx / lib/pq)

postgres://qbconnect:yourpassword@localhost:5433/quickbooks?sslmode=disable

R (RPostgres)

con <- dbConnect(
  RPostgres::Postgres(),
  host = "localhost",
  port = 5433,
  dbname = "quickbooks",
  user = "qbconnect",
  password = "yourpassword"
)

Special Characters in Passwords

If your password contains special characters (@, :, /, %), URL-encode them in URI-style connection strings:

Character	Encoded
@	%40
:	%3A
/	%2F
%	%25

Example: password p@ss:word becomes p%40ss%3Aword:

postgresql://qbconnect:p%40ss%3Aword@localhost:5433/quickbooks

ODBC and key-value connection strings do not require encoding.

Timeouts

Most drivers support a connection timeout parameter:

• libpq / pg8000: connect_timeout=10 (seconds)
• ODBC: Timeout=10
• JDBC: connectTimeout=10&socketTimeout=30
• Npgsql: Timeout=10;CommandTimeout=30;

Network Connections

To connect from another machine on the network, replace localhost with the IP address or hostname of the machine running Syntra. Ensure port 5433 is open in the Windows Firewall.