Re: How to enable ODBC?
От | Benjamin Thelen |
---|---|
Тема | Re: How to enable ODBC? |
Дата | |
Msg-id | NFBBKAPGHIAOFFHLCCODIEAMFEAA.benjamin.thelen@ccgis.de обсуждение исходный текст |
Ответ на | Re: How to enable ODBC? (brew@theMode.com) |
Список | pgsql-novice |
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 > >
В списке pgsql-novice по дате отправления: