[Gambas-user] Cannot find driver for database: postgresql

[johnf]

On Wednesday 04 January 2006 21:20, johnf wrote:
> On Wednesday 04 January 2006 20:56, Karl Martindale wrote:
> > johnf wrote:
> > > On Wednesday 04 January 2006 18:16, Karl Martindale wrote:
> > >>Hi Guys,
> > >>
> > >>I've compiled and installed gambas v1.9.23 on a Slackware Linux 10.0
> > >> box. A project that runs on another machine fails with the error:
> > >> Cannot find driver for database: postgresql
> > >>
> > >>When I compiled gambas the postgresql driver was compiled and wasn't
> > >> listed as 'disabled' after ./configure
> > >>
> > >>This install will successfully talk to a MySQL host running on the same
> > >>machine. The postgres driver appears to be in the lib directory:
> > >>
> > >>root at ...56...:/usr/local/lib/gambas2# ls -l gb.db.*sql*
> > >>-rwxr-xr-x  1 root root   905 2006-01-05 01:29 gb.db.mysql.la*
> > >>lrwxrwxrwx  1 root root    20 2006-01-05 01:29 gb.db.mysql.so ->
> > >>gb.db.mysql.so.0.0.0*
> > >>lrwxrwxrwx  1 root root    20 2006-01-05 01:29 gb.db.mysql.so.0 ->
> > >>gb.db.mysql.so.0.0.0*
> > >>-rwxr-xr-x  1 root root 74376 2006-01-05 01:29 gb.db.mysql.so.0.0.0*
> > >>-rwxr-xr-x  1 root root   879 2006-01-05 01:29 gb.db.postgresql.la*
> > >>lrwxrwxrwx  1 root root    25 2006-01-05 01:29 gb.db.postgresql.so ->
> > >>gb.db.postgresql.so.0.0.0*
> > >>lrwxrwxrwx  1 root root    25 2006-01-05 01:29 gb.db.postgresql.so.0 ->
> > >>gb.db.postgresql.so.0.0.0*
> > >>-rwxr-xr-x  1 root root 73938 2006-01-05 01:29
> > >> gb.db.postgresql.so.0.0.0*
> > >>
> > >>I have logged on to that database using the same credentials as in the
> > >>project using the CLI program psql.
> > >>
> > >>Does anyone have a suggestion as to what I'm doing wrong?
> > >>
> > >>Thanks in advance,
> > >>Karl.
> > >
> > > I'm not sure but can you create a small project on the new computer and
> > > make sure the db property is checked - then check for access?
> > > John

> >
> > This fairly minimal project behaves in the same way:
> >
> > PUBLIC SUB Form_Open()
> > DIM conn AS NEW connection
> > DIM connected AS Boolean
> >
> > WITH conn
> >          .Type = "postgresql"
> >          .Host = "localhost"
> >          .Login = "karl"
> >          .Name = "growl"
> >          '.Password = "karl"
> >      END WITH
> >
> >      TRY conn.Open
> >      IF ERROR THEN
> >          Message("Failed to open DB connection." & Error.Text)
> >          connected = FALSE
> >      ELSE
> >          connected = TRUE
> >      END IF
> > END
>
> OK just to be sure you enabled the 'DB' property - right?
>
> Does the message fire in your example? "Failed to open DB connection" ?
>
> Do you have pgAdminIII on the system?  You could use it to insure that you
> have a running postmaster and you are allowed access to the localmachine.
> Also try "ps -efa | grep postmaster" to see if your postgres is running as
> root.
>
> What happens from the example database? Can you get a connection and run a
> simple SQL statement from the example?
> John

You did install the postgres development package on the new computer?
John