Port 25 - Communications from the open source community at Microsoft

Browse by Tags

• Dev Center
• Open Source
• Web

Connecting Office Applications to MySQL and PostgreSQL via ODBC

by MichaelF on April 10, 2007

In cases where business applications have been built on open source databases, it may be necessary to connect other Windows applications, such as Microsoft Access or Excel, to these databases for reporting or business intelligence purposes. One potential application of this process is to use Excel as a front-end for data analysis. Data can be pulled from views or tables and then further analyzed... more

• Tuesday, April 10, 2007
• in: Dev Center
• MichaelF

PostgreSQL on Windows: A Primer

by MichaelF on February 22, 2007

This paper will cover the installation and initial configuration of PostgreSQL 8.2 on Windows up to a point where a database is created and plpgsql is installed in it. We assume an ability to walk through the install wizard in general, though screens... more

• Thursday, February 22, 2007
• in: Dev Center
• MichaelF

HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

by admin on June 14, 2006

We have been working in the labs on doing some testing and integration of jBoss talking to a SQL server 2005 backend. We have seen some questions on how to connect a SQL Server in the Windows environment to jBoss. So I wrote a little how-to that describes just that...... more

• Wednesday, June 14, 2006
• in: Dev Center
• admin