RE: Connecting to a Microsoft SQL Server
>> >> From: "Marcus Willemsen" <[EMAIL PROTECTED]> >> > Has anyone experience with using Perl together with a Microsoft SQL >> Server 2000? >> >> Yes >> >> > Do I need anything else apart from the DBI-ODBC Module? >> >> I guess you meant DBI and DBD::ODBC. >> You need the ODBC drivers, but I bet you already have them. >> BEsides you may download them from Microsoft's site (part of the MS >> Data Access Components or whatevr they call it now). > > Get at least MDAC 2.7. 2.6 and earlier had issues. -- if you are on a > Windows client, that is. Slightly off-topic, but be sure you get either a patched version of MDAC or download MDAC and go back to Microsoft and get the patch. John
RE: Connecting to a Microsoft SQL Server
> > From: "Marcus Willemsen" <[EMAIL PROTECTED]> > > Has anyone experience with using Perl together with a Microsoft SQL > > Server 2000? > > Yes > > > Do I need anything else apart from the DBI-ODBC Module? > > I guess you meant DBI and DBD::ODBC. > You need the ODBC drivers, but I bet you already have them. > BEsides you may download them from Microsoft's site (part of the MS > Data Access Components or whatevr they call it now). Get at least MDAC 2.7. 2.6 and earlier had issues. -- if you are on a Windows client, that is. > > > Is there even a special database driver, although I haven't > found one > > on CPAN. > > DBD::Sybase should work to some extent. > (MS SQL used to be Sybase) > > > And finally can anybody point me to a documentation on the ODBC > > Module? The stuff on CPAN wasn't too enlightening. > > Sorry don't know of any better docs. > Just ask :-) The DBI docs are what you want, while the DBD::ODBC docs are there to note any special functionality supplied (or not supplied) by DBD::ODBC that are part of the ODBC spec (More Results, etc). Other than that, DBD::ODBC follows the DBI spec. Regards, Jeff
Re: Connecting to a Microsoft SQL Server
From: "Marcus Willemsen" <[EMAIL PROTECTED]> > Has anyone experience with using Perl together with a Microsoft SQL > Server 2000? Yes > Do I need anything else apart from the DBI-ODBC Module? I guess you meant DBI and DBD::ODBC. You need the ODBC drivers, but I bet you already have them. BEsides you may download them from Microsoft's site (part of the MS Data Access Components or whatevr they call it now). > Is there even a special database driver, although I haven't found one > on CPAN. DBD::Sybase should work to some extent. (MS SQL used to be Sybase) > And finally can anybody point me to a documentation on the ODBC > Module? The stuff on CPAN wasn't too enlightening. Sorry don't know of any better docs. Just ask :-) Jenda = [EMAIL PROTECTED] === 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