[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
RE: [mv] Interface to SQL
...
> Database products products.asc DBI:Pg:sample:localhost:5432
>
> All returns this
>
> MiniVend V3.14
> Configuring catalog sample...sample config error: DBI connect
> failed: ERROR: PQconnectdb()
> - Missing '=' after 'sample:localhost:5432' in conninfo
>
...
> So I try an equals sign and get this
>
> Database products products.asc SQL
> Database products DSN DBI:Pg:dbname=sample:localhost:5432
>
> OR
>
> Database products products.asc SQL
> Database products DSN dbi:Pg:dbname=sample:localhost:5432
>
> OR
>
> Database products products.asc
> dbi:Pg:dbname=sample:localhost:5432
This looks more like a Perl/DBI problem to me.
But note that the error message said that a '=' is missing _after_
'sample:localhost:5432' and you are putting the '=' in _front_ of it....
Try putting it after, maybe it works.
If I were you I would make sure I have the latest DBI, make sure it passes
all the tests on the install, and try to write a simple perl script that
connects your Pq database and see what syntax you need to use for that.
perldoc DBI.
I hope this helps.
Otis