Re: Accessing a MS Sqlserver 2000 database via Perl
From: Jenda Krynicky (Jenda_at_Krynicky.cz)
Date: 02/21/05
- Next message: schnarff: "DB2 Connections?"
- Previous message: Jon Warbrick: "Possible bug in SQL-Statement: reports Bad predicate: '^1^'"
- In reply to: Shailesh Patel: "Accessing a MS Sqlserver 2000 database via Perl"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: <dbi-users@perl.org> Date: Mon, 21 Feb 2005 14:06:12 +0100
From: "Shailesh Patel" <Shailesh.Patel@henderson.com>
> I am trying to get hold of Perl modules and code examples which allow
> me to connect to a MS SqlServer 2000 database, query and manipulate
> database tables?
>
> I know I can use the Win32::ODBC module but I believe this requires a
> pre-defined ODBC DSN connection. I wanted the ability to specify the
> Server, database, login details dynamically.
You can use both Win32::ODBC and DBI+DBD::ODBC without predefined
DSNs. The docs of both modules contain examples.
I would use DBI + DBD::ODBC myself.
Jenda
===== Jenda@Krynicky.cz === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
- Next message: schnarff: "DB2 Connections?"
- Previous message: Jon Warbrick: "Possible bug in SQL-Statement: reports Bad predicate: '^1^'"
- In reply to: Shailesh Patel: "Accessing a MS Sqlserver 2000 database via Perl"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
