Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Connecting With Perl Using Win32 : ODBC Expand / Collapse
Author
Message
Posted Saturday, November 30, 2002 12:00 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
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
Posted Monday, December 2, 2002 1:54 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, June 19, 2014 6:16 AM
Points: 111, Visits: 77
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
Posted Monday, December 2, 2002 2:09 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
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
Posted Tuesday, December 3, 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
Posted Tuesday, December 3, 2002 3:31 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
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
Posted Wednesday, December 4, 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
Posted Wednesday, December 4, 2002 10:50 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
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
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 5, 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
Posted Friday, July 28, 2006 8:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697

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
Posted Saturday, July 29, 2006 9:58 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Monday, August 18, 2014 8:24 AM
Points: 6,634, Visits: 1,871
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 12»»

Permissions Expand / Collapse