How to enable ODBC?

From: "Benjamin Thelen" <benjamin(dot)thelen(at)ccgis(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: How to enable ODBC?
Date: 2003-04-11 12:16:26
Message-ID: NFBBKAPGHIAOFFHLCCODKEAFFEAA.benjamin.thelen@ccgis.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi,

I have pgsql 7.3.2 running on FreeBSD 4.7. It was installed by mistake
during the php4 Installation. There was a dialogue at the beginning of the
php4 installation where I could enable some options (mysql, gd, pgsql,
domxml...). As I want to use php4 and pgsql I thought, that this option
would be important. But it was not only an option, pgsql was completely
installed. So now I don't know which server-side encoding is set and
according to the pgsql docs this seems to be important for odbc. That may a
problem now, I don't now. From MS-SQL I know I have to reinstall the
software to change this...so I have to find out which encoding is set an I
hope I don't have to reinstall pgsql!!
Can anybody tell, whether the encoding is important for odbc, how to find
out the encoding and whether it is possible to change the encoding after
pgsql installation!?

On a Windows 2000 machine I installed the pgsql-odbc driver from gborg and
tried to connect to the pgsql-server. Before that I added via
webmin-web-interface "192.168.2.0/255.255.255.0/All databases/All users/No
authentication required" to the allowed hosts.

I tried to connect via MS-Access, but it failed:

---------------------------------
Could not connect to the server
Could not connect to remote socket
---------------------------------

I guess, pgsql is not listening oder does not know what to do with the
odbc-request, or both...

Of course I tried to find some information. I found a chapter about odbc in
the pgsql 7.2 documentation, but not in the 7.3 documentation. And what is
described for 7.2 seems not to work for 7.3. All the other information
wasn't helpful as well. Can anybody tell, how to enable odbc access on pgsql
after installation?

Thanks very much!
Benjamin

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message brew 2003-04-11 13:00:28 Re: How to enable ODBC?
Previous Message Ville Jungman 2003-04-11 09:44:03 Thank You for help with postgres