------------------------------------------------------------
revno: 279
committer: Jason P. Pickering <jason.p.picker...@gmail.com>
branch nick: dhis2-docbook-docs
timestamp: Wed 2011-03-23 10:04:11 +0200
message:
Added a section on creating an ODBC connection on Win7
added:
src/docbkx/en/resources/images/odbc/
src/docbkx/en/resources/images/odbc/odbc_screen_1.PNG
src/docbkx/en/resources/images/odbc/odbc_screen_2.PNG
src/docbkx/en/resources/images/odbc/odbc_screen_3.PNG
modified:
src/docbkx/en/dhis2_implementation_guide_installation_detailed.xml
--
lp:~dhis2-documenters/dhis2/dhis2-docbook-docs
https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs
Your team DHIS 2 developers is subscribed to branch
lp:~dhis2-documenters/dhis2/dhis2-docbook-docs.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs/+edit-subscription
=== modified file 'src/docbkx/en/dhis2_implementation_guide_installation_detailed.xml'
--- src/docbkx/en/dhis2_implementation_guide_installation_detailed.xml 2011-03-22 06:34:33 +0000
+++ src/docbkx/en/dhis2_implementation_guide_installation_detailed.xml 2011-03-23 08:04:11 +0000
@@ -136,6 +136,84 @@
<para>Save and exit.</para>
</section>
<section>
+ <title>Setting up ODBC Connections to the Postgresql server</title>
+ <para>Some implementations may require users to connect directly to the database with external software such as Excel, Stata, R or other analysis software. Using ODBC, a connection to the server can be established over the Internet or LAN, between the server and the clients computer. </para>
+ <section>
+ <title>Setting up a Windows 7 (32 bit) ODBC connection</title>
+ <orderedlist>
+ <listitem>
+ <para>Download and install the current ODBC driver from this <ulink url="http://www.postgresql.org/ftp/odbc/versions/msi/";>location</ulink>.</para>
+ </listitem>
+ <listitem>
+ <para>Execute from Start->Run this command to open the ODBC Data Source Administrator</para>
+ <screen>%windir%\system32\odbcad32.exe</screen>
+ </listitem>
+ <listitem>
+ <para>Click "Add" and choose the "Postgresql UNICODE" driver type and click "Finish".</para>
+ </listitem>
+ <listitem>
+ <para>Fill in the values in this dialog box.</para>
+ <screenshot>
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="resources/images/odbc/odbc_screen_1.PNG" width="30%" align="center"/>
+ </imageobject>
+ </mediaobject>
+ </screenshot>
+ <itemizedlist>
+ <listitem>
+ <para>Data Source: The name of the ODBC data source.</para>
+ </listitem>
+ <listitem>
+ <para>Database: The name of the database to connect to.This should be the name of the DHIS 2 database in most cases.</para>
+ </listitem>
+ <listitem>
+ <para>Server: This should be the fully qualified domain name or the IP address of the server.</para>
+ </listitem>
+ <listitem>
+ <para>User Name: The user name which has properly configured permissions to connect to the database. The user will need to have the correct security settings (at least SELECT privileges) on the required tables.</para>
+ </listitem>
+ <listitem>
+ <para>Description: You can include a description of the ODBC connection here.</para>
+ </listitem>
+ <listitem>
+ <para>SSL mode: Determines whether to use an encrypted connection or not.</para>
+ </listitem>
+ <listitem>
+ <para>Port: The connection port for the database server.</para>
+ </listitem>
+ <listitem>
+ <para>Password: The password for the user which will be used to connec to the database.</para>
+ </listitem>
+ </itemizedlist>
+ </listitem>
+ <listitem>
+ <para>Click the "Datasource" button, and be sure that the "Use Declare/Fech" option is enabled. </para>
+ <screenshot>
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="resources/images/odbc/odbc_screen_2.PNG" width="30%" align="center"/>
+ </imageobject>
+ </mediaobject>
+ </screenshot>
+ </listitem>
+ <listitem>
+ <para>ClickOK to exit this dialog box, and the click "Test" to see if the connection works.</para>
+ <screenshot>
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="resources/images/odbc/odbc_screen_3.PNG" width="20%" align="center"/>
+ </imageobject>
+ </mediaobject>
+ </screenshot>
+ </listitem>
+ <listitem>
+ <para>Click save to save the ODBC connection. The connection should be available to client applications such as Excel now. </para>
+ </listitem>
+ </orderedlist>
+ </section>
+ </section>
+ <section>
<title>Performance tuning</title>
<para>If you want to increase the performance of PostgreSQL, you can do some changes in some configuration files.</para>
<section>
=== added directory 'src/docbkx/en/resources/images/odbc'
=== added file 'src/docbkx/en/resources/images/odbc/odbc_screen_1.PNG'
Binary files src/docbkx/en/resources/images/odbc/odbc_screen_1.PNG 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/odbc/odbc_screen_1.PNG 2011-03-23 08:04:11 +0000 differ
=== added file 'src/docbkx/en/resources/images/odbc/odbc_screen_2.PNG'
Binary files src/docbkx/en/resources/images/odbc/odbc_screen_2.PNG 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/odbc/odbc_screen_2.PNG 2011-03-23 08:04:11 +0000 differ
=== added file 'src/docbkx/en/resources/images/odbc/odbc_screen_3.PNG'
Binary files src/docbkx/en/resources/images/odbc/odbc_screen_3.PNG 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/odbc/odbc_screen_3.PNG 2011-03-23 08:04:11 +0000 differ
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
