Database Connection Examples

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Comparing Database Data >

Database Connection Examples

The following are some example data sources illustrative for various database kinds and connection methods. Use this syntax to create a [datasource] section in a client or server configuration .ini file. Note that there may be more than one way to connect to the same database. For example, on Windows, you can connect to a MySQL database using any of the following connections methods: ADO.NET, JDBC, or ODBC.

 

Access (ADO)

[datasource:access_data]
type = ado
connection = Data Source=C:\Users\altova\Documents\ZooDB.mdb;Provider=Microsoft.Jet.OLEDB.4.0
table = [ZooDB].[tblAnimals]

 

IBM DB2 (JDBC)

[datasource:db2_data]
type = jdbc
connection = jdbc:db2://db2server:50000/PRODUCTSDB
class = com.ibm.db2.jcc.DB2Driver
user = dbuser
pass = 75gfljh9
table = "DB_USER"."PRODUCTS"

 

IBM DB2 for i (JDBC)

[datasource:db2_i_data]
type = jdbc

connection = jdbc:as400://127.0.0.1

class = com.ibm.as400.access.AS400JDBCDriver

user = DBUSER

pass = 75gfljh9

table = "DBUSER"."PRODUCTS"

 

MariaDB (ODBC)

[datasource:mariadb_data]
type = odbc
connection = Dsn=datasource_mariadb
database = nanonull
user = dbuser
pass = 75gfljh9
table = `nanonull`.`products`

 

MySQL (ODBC)

[datasource:mysql_data]
type = odbc
connection = Dsn=datasource_mysql;
database = zoo
user = dbuser
pass = 75gfljh9
table = `zoo`.`products`

 

Oracle (JDBC)

[datasource:oracle_data]
type = jdbc

connection = jdbc:oracle:thin:@ora12c:1521:orcl12c

class = oracle.jdbc.driver.OracleDriver

user = dbuser

pass = 75gfljh9

table = "DBUSER"."PRODUCTS"

 

PostgreSQL (Native)

[datasource:postgresql_data]
type = postgresql
connection = localhost
database = zoo
user = dbuser
pass = 75gfljh9
table = "zoo"."public"."animals"

 

SQLite (Native)

[datasource:sqlite_data]
type = sqlite
path = c:\comparisons\db\Nanonull.sqlite
table = "main"."products"

 

SQL Server (ADO.NET)

[datasource:sqlserver_data]
type = adonet

connection = Data Source=SQLSERV16;Initial Catalog=NANONULL;MultipleActiveResultSets=True;Password=7hiu57;Persist Security Info=True;User ID=altova

assembly = System.Data.SqlClient.SqlClientFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

class = System.Data.SqlClient

table = [NANONULL].[dbo].[PRODUCTS]

 

Teradata (JDBC)

[datasource:teradata_data]
type = jdbc
connection = jdbc:teradata://teradata16/database=nanonull
class = com.teradata.jdbc.TeraDriver
user = dbuser
pass = 75gfljh9
table = "nanonull"."products"


© 2019 Altova GmbH