Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Connecting to PostgreSQL (Read 7823 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Connecting to PostgreSQL
05.10.05 at 17:19:47
 
I have successfully performed connection tests to a PostgreSQL database through an ODBC driver. I have added screen prints and instructions to the help site: http://www.oraxcel.com/projects/sqlxl/help
 
How to connect to PostgreSQL through ODBC:
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/postgresql_odbc .html
 
Adding an ODBC DSN for PostgreSQL:
http://www.oraxcel.com/projects/sqlxl/help/techniques/odbc_data_source_administr ator/create_data_source.html#postgresql
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Connecting to PostgreSQL
Reply #1 - 06.10.05 at 15:22:05
 
I also managed to connect to PostgreSQL through OLE DB.
 
I have added the following pages to the help system regarding connecting to PostgreSQL
 
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/postgresql_oled b.html
 
http://www.oraxcel.com/projects/sqlxl/help/techniques/data_link_properties/index .html#dl_postgresql
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Steve Taylor
YaBB Newbies
*




Posts: 4
Re: Connecting to PostgreSQL
Reply #2 - 07.10.05 at 14:41:05
 
Are there any plans to offer an interface to MySQL?
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Connecting to PostgreSQL
Reply #3 - 07.10.05 at 15:02:25
 
SQL*XL already works well with MySQL.  
 
You need to download the MySQL ODBC driver called - MyODBC:
http://dev.mysql.com/downloads/connector/odbc
 
An example on how to login with SQL*XL can be found at:
http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/mysql_odbc.html
Back to top
 
« Last Edit: 07.10.05 at 15:03:39 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Connecting to PostgreSQL
Reply #4 - 21.10.05 at 09:56:37
 
The PostgreSQL support is available from SQL*XL 4.0.24. It will be released soon.
 
Note that you can check the version of SQL*XL in the SQL*XL About dialog.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1