Re: DBIx::DBH - Perl extension for simplifying database connections

From: Jonathan Leffler (jonathan.leffler_at_gmail.com)
Date: 12/08/04 

Date: Tue, 7 Dec 2004 22:36:58 -0800
To: ron@savage.net.au

On Wed, 8 Dec 2004 09:00:36 +1100, Ron Savage <ron@savage.net.au> wrote:
> On Tue, 07 Dec 2004 09:57:38 -0500, John Siracusa wrote:
> > As one earlier post said, the simplest solution is to accept a
> > hashref instead of a string as the DSN argument to connect()

With great self-restraint, I'm simply going to refer to my other
posting this evening ("the grump message"), in the other branch of
this thread (as Gmail files things). The simplest thing is to leave
well alone.

> Well, this idea has been kicked around a bit, so I suggest it's time to do something concrete.
>
> Is there an on-line doc specifying all possible parameters within a DSN for each and
> every database supported by DBI?

One - no. Multiple - yes.
Each DBD module should document the connection strings it supports.
Which one doesn't?

> If not, then I volunteer to maintain a HTML table (of some sort) cross-tabulating database
> (vendors) against connection string options. [...]

Google Mail does occasionally produce a gem of an advert!

ConnectionStrings.com - Forgot that connection string? You will ...
www.connectionstrings.com - All connection strings in one place! Here
you'll find the syntax for ...

It seems like someone else has already done it :-)

(No, I didn't visit the site.) 

-- 
Jonathan Leffler <jonathan.leffler@gmail.com>  #include <disclaimer.h>
Guardian of DBD::Informix - v2003.04 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

Relevant Pages

  • Re: Question re MailMerge and VB.NET
    ... There is an ODBC API call to create a DSN which you should, in theory, call ... ' lpszDriver is a string containing the Driver name /exactly/ as it appears ... Private Const ODBC_CONFIG_DSN = 2 ... ' an example showing how to make a SQL Server DSN ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Run-time error 3011 using Foxpro ODBC
    ... it is enough to just mention the DSN. ... -The constant acTable is ignored unless the database source type is MS ... Dim strConnect As String ... DoCmd.TransferDatabase acImport, "ODBC Database", strConnect,, ...
    (microsoft.public.data.odbc)
  • Re: Linked Table Properties - using ODBC trying to rmv DATABASE NA
    ... the connect parms after creating a link table. ... The relink is executed by calling the refreshLink method. ... The DSN setup also has the appropriate signon and password. ... I tried resetting the connect string in the refreshLink method but it does ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Edit ODBC settings
    ... simply hard-coding the new DSN for each), but found that it was failing ... because my ProvideX ODBC connect string exceeds 255 characters when I use the ... T:\DBFolder to C:\Data\Apps\DBFolder so that it will work on the server. ... can I now edit the path in the ODBC-linked table to reflect the local path in ...
    (microsoft.public.access.queries)
  • Re: Word 2003 MailMerge with SQL Server 2000 problem
    ... Okay, I switched the way I was connecting, and started using a DSN ... If I could either create a DSN-less connection string for Mail Merge, ... Personally I wouldn't use the 1=1 workaround on the grounds that the query ... SQL Server does but I once did this with Oracle to get around some problem ...
    (microsoft.public.word.mailmerge.fields)