Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

DBD for MS SQL Server More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

DBD::ODBC (Score:1)

by runrig (3385)

It took me awhile to figure out, but whenever I need to connect to several different databases of the same type through DBD::ODBC, I create a file dsn for the first one, then copy and paste the contents of the file (from c:\Program Files\Common Files\ODBC) into the program to use as a template. E.g., for SQL server (on my local machine) it was:

my $dsn=<<EOT; DRIVER=SQL Server DATABASE=$dbname APP=Microsoft Open Database Connectivity SERVER=(local) Description=paxl EOT $dsn =~ tr/\n/;/; my $dbh = DBI->con
- Re:DBD::ODBC (Score:1)
  
  by runrig (3385) <dougwNO@SPAMcpan.org> on 2004.02.05 12:33 (#28100) Journal
  
  I should also mention that you can create a system dsn and just use that name directly in the "dbi:ODBC:$dsn" string, but that gets to be a hassle when there are alot of databases, or if you need to port the code to another machine(s) where the dsn's are not set up.
  
  Reply to This
  
  Parent

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.