Re: connect database

Don't hide errors. Use use strict; and use warnings;.
```
user=postgres
[download]
```
should be
```
'postgres'
[download]
```
As is, it means
```
'user' = 'postgres'
[download]
```
and it doesn't make sense to assign to a constant string.
You have an argument missing. While the option hash is optional, the password isn't. It must appear between the user name and the option hash, even if it's only ''.
I don't think quotes are allowed around the dbname. They're definitely not needed.
```
"DBI:Pg:dbname='five'; port=5432"
[download]
```
should be
```
"DBI:Pg:dbname=five;port=5432"
[download]
```
... or just
```
"DBI:Pg:dbname=five"
[download]
```
since port 5432 is the default.

Update: Added last two bullets.

Comment on Re: connect database Select or Download Code

Replies are listed 'Best First'.
Re^2: connect database by Bass-Fighter (Beadle) on Jan 08, 2009 at 13:06 UTC
this is only the piece of the error, there is more, so I use strict. I now changed it into this: `#!usr/bin/perl use 5.6.1; use strict; use warnings; use DBI; my$dbh = DBI->connect("DBI:Pg:dbname=five; port=5432", 'postgres', '', +{ RaiseError => 1, AutoCommit => 0 }) or die "kon de database niet openen!";` [download] and now I get this: DBD::Pg::db do failed: ERROR: parser: parse error at or near "voor" at character 94 DBD::Pg::db do failed: ERROR: parser: parse error at or near "voor" at character 94 and what is the meaning of that?	[reply] [d/l]
Re^3: connect database by ikegami (Patriarch) on Jan 08, 2009 at 13:09 UTC
`DBD::Pg::db``do failed``: ERROR: parser: parse error at or near "voor" at character 94` So it worked, cause you made it to some `$dbh->do` call further down.	[reply] [d/l] [select]
Re^4: connect database by Bass-Fighter (Beadle) on Jan 08, 2009 at 13:15 UTC
ohw... yeah I see now, I think I can get further now, Thanx	[reply]