Accessing a MS Sqlserver 2000 database via Perl

From: Shailesh Patel (Shailesh.Patel_at_henderson.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 08:59:34 -0000
To: <dbi-users@perl.org>

Dear All,

 

I am new to the list so please forgive me if I am asking a question
already covered in the past.

 

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.

 

Has anyone used MSSQL::DBlib with Sqlserver 2000?

 

Does anyone know of any other modules or useful code examples ??

 

Kind Regards,

 

Shailesh Patel

Oracle Database Administrator (CRD Project)

T: +44 (0)207 818 6405

M: + 44 (0) 7714415255

E:Shailesh.Patel@henderson.com

 

  

 

**********************************************************************
The information provided in this e-mail is confidential and is for the sole use of the recipient. It may not be disclosed, copied or distributed in any form without the express permission of Henderson Global Investors and to the extent that it is passed on, care must be taken to ensure that this is in a form which accurately reflects the information presented here.

Whilst Henderson Global Investors believe that the information is correct at the date of this e-mail, no warranty or representation is given to this effect and no responsibility can be accepted by Henderson Global Investors to any end users for any action taken on the basis of this information.

Henderson Global Investors Limited is Authorised and Regulated by the FSA

We may record telephone calls or email for our mutual protection and to improve customer service.
**********************************************************************

image001.jpg

Relevant Pages

  • Re: Fatal error 682 and SqlDependency
    ... Cannot execute as the database principal because the ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ... SqlServer 2005 Notification Services feature to get notified about changes ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Insert between separate databases
    ... the other is a remote sql server which I can access via ip address. ... You can link the remote sqlserver database inside access if I'm not mistaken, ... If you use sqlserver, and you have both catalogs in the same server, you can do: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Access Layer that allows Multiple Data Sources
    ... I'm looking for something that allows a typical master data source for storing and retrieving data, but I'd also like it to be able send select data to other datasources. ... database server and it would be nice to be able to run these reports ... write it back in sqlserver, pull data from sqlserver A in context 1 and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Upgrading Access 97 application to dotNet
    ... for the database back-end. ... database must reside on the network server, ... like SQLServer. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Lumigent log reader
    ... you to scan for just one database at a time, ... I'm interested in have to reside on the same server, ... to be in the same version as it was when the log files were created? ... At least I am using it with SQLServer! ...
    (microsoft.public.sqlserver.server)