Hi guys,
Not a big effort but keeping all info together for quick check of driver details in blog site...
Not a big effort but keeping all info together for quick check of driver details in blog site...
Oracle
10g
Driver
class
|
oracle.jdbc.driver.OracleDriver
|
URL
|
jdbc:oracle:thin:@localhost:1521:orcl
where orcl is SID
|
User
Name/password
|
system/manager
|
Download
driver at
|
PostgreSQL
Driver
class
|
org.postgresql.Driver
|
URL
|
jdbc:postgresql://
|
User
Name/password
|
postgres/postgres
|
Download
driver at
|
MySQL
Driver
class
|
com.mysql.jdbc.Driver
|
URL
|
|
User
Name/password
|
root/password
|
Download
driver at
|
Driver
class
|
com.microsoft.sqlserver.jdbc.SQLServerDriver or MSSQLServer (com.merant.datadirect.jdbc.sqlserver.SQLServerDriver) |
URL
|
|
User
Name/password
|
Username/password
for ms-sql server
|
net.sourceforge.jtds.jdbc.Driver
|
|
Syntax:
jdbc:jtds:sqlserver://<host>:<port>/<database_name>
Eg:
jdbc:jtds:sqlserver://127.0.0.1:1433/test
|
|
Download
driver at
|
Open
source database client Tools
DB
Visulizer
|
Download
at : https://www.dbvis.com/download/
|
Squerriel
|
Download
at : http://www.squirrelsql.org/#installation
|
Thank you.
Sadakar
BI developer
No comments:
Post a Comment