Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Kelley » Connecting With Perl Using Win32 : ODBC
Add to briefcase
14 posts, Page 1 of 2
12»»

Connecting With Perl Using Win32 : ODBC Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
K. Brian Kelley
Posted Saturday, November 30, 2002 12:00 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Saturday, June 15, 2013 11:04 AM
Points: 6,584, Visits: 1,795
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/connectingtosqlserverusingperlwin32odbc.asp

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #8509
Terry Grignon
Posted Monday, December 02, 2002 1:54 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 8:13 AM
Points: 91, Visits: 48
I enjoyed your article very much. Can you tell me the name of the book you mention which is "out for those researchers in the biological sciences who want to use Perl to help process some of their data." Thanks.


Post #48157
K. Brian Kelley
Posted Monday, December 02, 2002 2:09 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Saturday, June 15, 2013 11:04 AM
Points: 6,584, Visits: 1,795
Sure. The book is called Beginning Perl for Bioinformatics and its available from O'Reilly. Here's the O'Reilly page on it:

http://www.oreilly.com/catalog/begperlbio/

The first sentence of the description reads:

quote:
This book shows biologists with little or no programming experience how to use Perl, the ideal language for biological data analysis.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #48158
Klaas-Jan
Posted Tuesday, December 03, 2002 2:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2002 12:00 AM
Points: 135, Visits: 1
great article it gives me a good start on using perl. I have one question is it also posible to create a dsn less connection. This makes it easier to move the script to an other server. maybe for pearl this is less needed because perl is more a server then a client language.


Post #48159
K. Brian Kelley
Posted Tuesday, December 03, 2002 3:31 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Saturday, June 15, 2013 11:04 AM
Points: 6,584, Visits: 1,795
Yes. The next couple of articles should talk about doing just that.



Most of the scripts I have written where I work use Win32:LE which gives me access to standard COM objects like ADO. Since, from a supportability perspective most of the developers are familiar with ADO even if they're not familiar with Perl, I've used Win32:LE and ADO to make database connections, although DBI is more "Perl." In those cases I specify a standard ADO ConnectionString, to include specifying provider, server, initial catalog, etc.



I'll be focusing on using Win32:LE and ADO in my next article in the series.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #48160
gundapaneni
Posted Wednesday, December 04, 2002 10:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 27, 2007 12:35 AM
Points: 97, Visits: 1
Hi,
I dont know anything about PERL when I was reading your article. It has given very good idea about PERL, thanks for writting this article. Could U suggest a good book that covers all info about PERL. I would greatful to U.

Regards,
Madhu.

madhusudannaidugundapaneni


Madhu
Post #48161
K. Brian Kelley
Posted Wednesday, December 04, 2002 10:50 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Saturday, June 15, 2013 11:04 AM
Points: 6,584, Visits: 1,795
I have a Getting Started page on Perl. I've also listed some of the books you'll want to look at to get started. The Learning Perl in Win32 Systems is where you should start in the literature.

http://www.truthsolutions.com/perl/getting_started.htm

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #48162
Raymond Chew
Posted Thursday, August 25, 2005 4:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 05, 2005 2:11 AM
Points: 1, Visits: 1
I couldn't thank you more !
I am new to Perl-ODBC and this article really get me started !
Thank you once again.
Post #213778
colin.Leversuch-Roberts
Posted Friday, July 28, 2006 8:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:10 PM
Points: 2,668, Visits: 688

Well written article and an interesting read, I still don't see what advantage I might gain from it however, and as far as users are concerned the last thing I'd ever want is any form of ad-hoc query or access to database tables.

That said I only use SQL Server, it's years since I was using unix, so maybe for a windows only person like me it has less value and has more value working in multiple platforms.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #298087
K. Brian Kelley
Posted Saturday, July 29, 2006 9:58 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Saturday, June 15, 2013 11:04 AM
Points: 6,584, Visits: 1,795
With respect to scripting languages on the Windows platform, Perl gives a person more options than VBScript and JScript (even with WScript). For administrators and DBAs, there's a lot of flexibility with going with Perl. As for ad hoc access, I agree, this doesn't tend to be something we allow the normal person to do. However, when we want a quick script to pull something out of a database or insert some info, we may not go through the trouble of building out the full security model because the risk is relatively small.

Also, Win32-ODBC (replaced the :: with a - to avoid the smily) is kind of the "entry point" into database access with Perl. There are better options available, I just haven't gotten around to writing about them. One example is the following from SQL Server MVP Erland Sommarskog:

Win32::SqlServer

Also, check out the book Real World SQL Server Administration with Perl

SQL Server MVP Linchi Shea gives a whole book of uses for Perl with SQL Server.

K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #298229
« Prev Topic | Next Topic »

Add to briefcase
14 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.