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