Обсуждение: How to enable ODBC?

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

Benjamin......

> 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:

In addition to allowing hosts, etc, I think pgsqld must be started with a
command line switch to allow tcp connections.  I'm not sure of it exactly,
since I'm only running web server connections, but I think you are real
close to getting it working.  You have to add it in inet.d, or however
you're distribution starts on boot up.

Sorry I'm not more specific, but I bet you almost have it... just one more
step.

brew

 ==========================================================================
                  Strange Brew   (brew@theMode.com)
     Check out my Musician's Online Database Exchange (The MODE Pages)
                        http://www.TheMode.com
 ==========================================================================

Hi,

I read that it is either neccessary to supply the --enable-odbc option to
the configure script or you can compile that later on by changing into
src/interfaces/odbc and do make and make install there. But I don't even
have this directory. But that is chapter 7 of the 7.2 documentation.

I found some more information, but that was for pgsql 6.x!!

1) You have a working Pgsql installation
    - done
2) You have modified pg_hba.conf to allow connections from hosts other than
the server itself
 - done
3) You have started pgsql with the i flag

    - I tried ./10.pgsql.sh start -i, but that did not help

4) You have created a sandbox database you have create table rights to.

    - What is a sandbox db?
    - I have granted full access to all dbs I have created.



I installed unixODBC, but I couldn't find the software afterwoods! So, I
don't know how to set up a DSN, just because I don't know how to start the
unixODBC-manager. The unixODBC documentation did not help a bit. I had the
hope whether it is possible to connect locally via odbc.



Benjamin


> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of brew@theMode.com
> Sent: Friday, April 11, 2003 3:00 PM
> To: pgsql-novice@postgresql.org
> Subject: Re: [NOVICE] How to enable ODBC?
>
>
>
> Benjamin......
>
> > 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:
>
> In addition to allowing hosts, etc, I think pgsqld must be started with a
> command line switch to allow tcp connections.  I'm not sure of it exactly,
> since I'm only running web server connections, but I think you are real
> close to getting it working.  You have to add it in inet.d, or however
> you're distribution starts on boot up.
>
> Sorry I'm not more specific, but I bet you almost have it... just one more
> step.
>
> brew
>
>
> ==========================================================================
>                   Strange Brew   (brew@theMode.com)
>      Check out my Musician's Online Database Exchange (The MODE Pages)
>                         http://www.TheMode.com
>
> ==========================================================================
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>