Date: Thu, 28 Mar 2024 18:10:27 +0000 (UTC) Message-ID: <1755049065.4002.1711649427633@localhost> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_4001_55535198.1711649427633" ------=_Part_4001_55535198.1711649427633 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
host |
db-host |
port |
5432 |
database |
test |
user |
postgres |
password |
test |
SQL test |
|
host |
db-host:3306 |
database |
test |
user |
root |
password |
test |
SQL test |
|
User account and accessed database must have the remote access enabled.<= /p>
Let us = assume that you are always making connection from remote IP called 202.54.1= 0.20 for database called webdb for user webadmin, To grant access to this I= P address type the following command At mysql> prompt for existing datab= ase, enter: mysql> update db set Host=3D'202.54.10.20' where Db=3D'webdb'; mysql> update user set Host=3D'202.54.10.20' where user=3D'webadmin';
host |
db-host |
port |
1521 |
driver |
V14_10_2_0_1 |
user |
tester |
password |
test |
SID |
XE |
SQL test |
|
host |
db-host |
port |
1433 |
user |
sa |
password |
test |
database |
test |
SQL test |
|
SQL Server Authentication must be enabled.
You need an SQL account to access the MS SQL remotely.
host |
db-host |
port |
2638 |
user |
dba |
password |
sql |
database |
demo |
SQL test |
|
If you see error "JZ0SJ: Metadata accessor information was not found on this=
span> database. Please install the re=
quired tables as<=
/span> mentioned in the jConnect documentation." then =
you have to allow the Sybase jCon=
nect JDBC driver to access system catalog information. Please execute SQL q=
uery "ALTER DATABASE Upgrade JCONNECT ON
" and see documentation for more details.
Some Sybase installations does not have metadata support initialized. In= this case, it is necessary to initialize the metadata by calling the store= d procedure or set the use_metadata connection parameter t= o false. Read more here.
Browse all JDBC parameters
host |
db-host |
user |
dbc |
password |
test |
SQL test |
|
Visit Teradata documentation for additional parameters = https://developer.teradata.com/doc/connectivity/jdbc/reference/current= /jdbcug_chapter_2.html#BABJIHBJ