Re: [GENERAL] perl access

2004-06-14 Thread Tom Allison
Jim Seymour wrote: Like this: my $data_source = "dbi:Pg:dbname=mydatabase"; ^^^ thank you very much. Now if I could just authenticate correctly... ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [GENERAL] perl access

2004-06-14 Thread Joshua D. Drake
Hello, I do not believe that to be the case. DBD::SPI is experimental but DBD: Pg is quite stable and I believe DBD is a requirement that works WITH DBI. Sincerely, Joshua D. Drake Tom Allison wrote: I'm used to using the DBI modules in perl. The online docs mention DBD as expiremental. I'm think

Re: [GENERAL] perl access

2004-06-14 Thread Jim Seymour
Tom Allison <[EMAIL PROTECTED]> wrote: > > I'm stuck on something stupid. > > I'm trying to use perl to open up a database handle and I can't find the > right database dsn string. > > my $data_source = "dbi:Pg:mydatabase"; > my $username = "mydatebasereader"; > my $auth = "secret"; > > my $dbh

[GENERAL] perl access

2004-06-14 Thread Tom Allison
I'm stuck on something stupid. I'm trying to use perl to open up a database handle and I can't find the right database dsn string. my $data_source = "dbi:Pg:mydatabase"; my $username = "mydatebasereader"; my $auth = "secret"; my $dbh = DBI->connect($data_source, $username, $auth); DBI connect('p

[GENERAL] perl access

2004-06-14 Thread Tom Allison
I'm used to using the DBI modules in perl. The online docs mention DBD as expiremental. I'm thinking of sticking with DBI, unless there's some compelling reason to do otherwise. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, plea