[GENERAL] ODBC linked table in access on second pc
Hello, I have a pgsql db (v.6.5.3) with some tables. On my pc1 I have created a MS access front end (with ODBC) with these tables linked. When I start the MS access front end from my pc2 (same ODBC driver/setup) I get access denied while trying to open the linked tables. I can link the tables again from pc2 and open them within the same front end. This let me open the tables on pc2 but not on pc1. There only works the first links. In summary: The links I created (in the same Access front end) works only on the pc where they have been created. Where am I wrong? How can I correct this behaviour? TIA C.
Re: [GENERAL] pg_id: command not found
Thank you Tom, Is /usr/lib/pgsql/bin in your PATH? Very easy. I mus have been blind... Maentime I found SuSE Linux supplies a package called pg_data???.rpm which includes the database files. Installing this seams to be the same as running initdb. After I installed the package I found the new database directory in /var/lib/pgsql/ btw. I found somethings seams to be wrong with the and package rpm say nothing needs to be updated or so but there are some files missing from pg_ifa. After reinstalling the files I can run postgres now without problems. C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
[GENERAL] pgsql setup
Hello, I am runing pgsql with suse linux v.6.4 I have installed pgsql with rpm. When I start initdb as user postgres I get the following error: /usr/lib/pgsql/bin/initdb: pg_id: command not found Unable to determine a valid username. If you are running initdb without an explicit username specified, then there may be a problem with finding the Postgres shared library and/or the pg_id utility. What can I do do fix this? TIA C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
Re: [GENERAL] FATAL 1: Database dbname=template1 does not exist in pg_database
Tom Lane schrieb: Read it again: the error message is complaining because you tried to access a database named "dbname=template1". Better check the syntax on the connection subroutine you are using --- looks like a confusion between positional parameters and keyword-style connect strings... In the meantime I figured out, was was going wrong with my postgresql installation. I made a big mistake configuring the config.inc.php3 file There I had wrong entries for user and stduser. After correcting this phpPGadmin work quite well. C.
[GENERAL] Re: [NOVICE] Postgres with php3
I haven't played with apache so am not sure what php3 is. But I'm sure you first need to get postgres running. Go to /usr/doc/ and read the README postgresql runs. I have created a sample of dbs for testing with some tables. It runs perfekt at this point. I can see the db files in the PGDATA directory. It seems to be allright. under your version of postgres. It tells you how to turn on postgres and pgsql v6.5.x get the postmaster running. You want it to turn on each time you boot Linux. Bye C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
Re: [GENERAL] Postgres with php3
Date sent: Wed, 21 Jun 2000 09:36:26 +0200 From: "Poul L. Christiansen" [EMAIL PROTECTED] To: Carsten Huettl [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject:Re: [GENERAL] Postgres with php3 I don't think Postgres is started by default. Open linuxconf and make it start every time your Redhat starts. In this situation of testing I start postgresql or the postmaster manually. It works. I can login. Create dbs and a smple of tables. But I cannot connct via the phpPGadmin thats the point of trouble. PgAdmin requires ODBC drivers on the windows machine, have you got them? There is no Windows in the game. Bye C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
[GENERAL] Postgres with php3
Hello, I have setup a RH 6.2 box with postgres. The httpd (apache) has support for php3. But I don't know if the rh installation builds in the php3 support in postgres. I installed the pgadmin 2.0.2 but it did not find any database. Maybe this is becuase rh installs in different directories then recommended. The pgphp package is installed as I see from rpm -q How do I check if the postgres installation is correct with support for php3. TIA C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
[GENERAL] Re: pgsql odbc
Carsten Huettl schrieb: Hello, After I altered a table in my database I am not able to connect the Database with the postgresql-odbc-driver (v.6.40.00.09) What I get is: ODBC--call failed. The Access-Table only shows col-names but nothing else. It is a RH6.1Linux with PostgreSQL 6.5.2 ... It seems the postmaster runs out of memory. I checked the postmaster with top while I tried to connect via odbc an it grabs more and more memory. The system has only 32megs and 96megs swap. When postmaster grabs 110megs the odbc-call fails and postmaster releases the memory. How do I correct this behaviour? TIA
[GENERAL] user authentication failed (#210)
Hello, I tried to connect to my postgres db via odbc-Driver from within MSAccess. But I can not connect. I recieve an error: DB Access failed user authentication failed (#210) the following entry are in the odbc driver in Win95 Data Source: PostgreSQL Description: PostgreSQL Test Database: Mydb Server: 192.168.10.123 Port: 54332 Name: postgres Password: postgres #this is postgres' fbsd password #not pgsql password What is wrong here. TIA C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
Re: [GENERAL] ld.so failed
From: [EMAIL PROTECTED] (Jim Mercer) Subject:Re: [GENERAL] ld.so failed To: [EMAIL PROTECTED] (Carsten Huettl) Date sent: Fri, 15 Oct 1999 09:59:09 -0400 (EDT) Copies to: [EMAIL PROTECTED], [EMAIL PROTECTED] you can make the change permanent by adding the path to the ldconfig parameter int /etc/rc.conf. How do I make this permanent if I need the "-aout" option with ldconfig ? C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
Re: [GENERAL] ld.so failed
Hello, Did you add your pg libraries path into /etc/ld.so.conf (/usr/local/postgres/libs is mine) and run ldconfig? I searched the whole tree from / for ld.so.conf but did not find one. Add the path in /etc/rc.conf to ldconfig_paths. Then reboot. Did not help. :-( C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
Re: [GENERAL] ld.so failed
Hello, From the command line as root run the following: /sbin/ldconfig -m /usr/local/pgsql/lib/ Did not help C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request
Re: [GENERAL] ld.so failed
Hello, I searched the whole tree from / for ld.so.conf but did not find one. freebsd doesn't really use one. you can manually add the path with "ldconfig -R /path" you can make the change permanent by adding the path to the ldconfig parameter int /etc/rc.conf. alternately, you can include the ldconfig -R command in your /usr/local/etc/rc.d/pgsql.sh script, if you have one. Did not help. :-( C. -- Carsten Huettl - http://www.ahorn-Net.de pgp-key on request