DBD for SQL Server?

[Richard Crawford]

Is there a DBD for SQL Server so that I can connect to our SQL Server 
2000 database with DBI?  I've hunted all over CPAN but I can't seem to 
find one.

--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 

Re: DBD for SQL Server?

[Richard Crawford]

NYIMI Jose (BMB) wrote:


-Original Message-
From: Alok Bhatt [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 12, 2004 11:49 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: DBD for SQL Server?



--- Richard Crawford <[EMAIL PROTECTED]>
wrote:
Is there a DBD for SQL Server so that I can connect
to our SQL Server
2000 database with DBI?  I've hunted all over CPAN
but I can't seem to 
find one.
Windows uses the Open Database Connectivity (ODBC)
Model. You can connect to an MS-SQL server using
Win32::ODBC, available at 


Then you will no longer be using DBI API (what OP wanted) !

The advantage of DBD::ODBC (or DBD::ADO )
Is the portability of your code since you
Will be using the same api syntax regarless the
The database driver (DBD) you are dealing with behind DBI.
The connection is always
my $dbh=DBI->connect(...);
Not a new api like:
$Data = new Win32::ODBC(...);
Which obviously will not work if you need
To use your same code on a database running on unix box.
HTH,

José.
I've learned that in order to use DBD::ODBC I will still need to install 
an ODBC driver on the machine (which is actually running Solaris 9). 
Not a problem, if I can find one.

--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>

Problems with Perl CPAN on Solaris 9

[Richard Crawford]

I'm trying to use the CPAN module to install new modules on my Solaris 9
 server.  I've logged in as root, and I've tried the following:
$ perl -MCPAN -e 'shell'

cpan> install HTML::Parse

...and this is what the output looks like:

Running install for module HTML::Parse
Running make for S/SB/SBURKE/HTML-Tree-3.18.tar.gz
  Is already unwrapped into directory /.cpan/build/HTML-Tree-3.18
  Has already been processed within this session
Running make test
 Unsatisfied dependencies detected during
[S/SB/SBURKE/HTML-Tree-3.18.tar.gz] -
HTML::Tagset
HTML::Parser
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]
Running make install
  make had returned bad status, install seems impossible
  Delayed until after prerequisites
Running install for module HTML::Tagset
Running make for S/SB/SBURKE/HTML-Tagset-3.03.tar.gz
  Is already unwrapped into directory /.cpan/build/HTML-Tagset-3.03
  Has already been processed within this session
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
Running install for module HTML::Parser
Running make for G/GA/GAAS/HTML-Parser-3.36.tar.gz
  Is already unwrapped into directory /.cpan/build/HTML-Parser-3.36
  Has already been processed within this session
Running make test
 Unsatisfied dependencies detected during
[G/GA/GAAS/HTML-Parser-3.36.tar.gz] -
HTML::Tagset
Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]
Running make install
  make had returned bad status, install seems impossible
  Delayed until after prerequisites
Running install for module HTML::Tagset
Running make for S/SB/SBURKE/HTML-Tagset-3.03.tar.gz
  Is already unwrapped into directory /.cpan/build/HTML-Tagset-3.03
  Has already been processed within this session
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
Running make for G/GA/GAAS/HTML-Parser-3.36.tar.gz
  Is already unwrapped into directory /.cpan/build/HTML-Parser-3.36
  Has already been processed within this session
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
Running make for S/SB/SBURKE/HTML-Tree-3.18.tar.gz
  Is already unwrapped into directory /.cpan/build/HTML-Tree-3.18
  Has already been processed within this session
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible
Any ideas?  I have gcc installed and the CPAN configuration is pointing
to the gcc installation, so I'm not sure what the problem might be.
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 

Re: Running scripts within browsers

[Richard Crawford]

Naveen,

If you want to have Perl doing your CGI stuff on your computer, then you 
need to have a web server working on your computer and you need to have 
it configured to work with Perl.

If you're using ActiveState, then chances are that you're using PWS or 
IIS, unfortunately.  Get yourself a copy of Apache 
(http://www.apache.org), and study the documentation on how to install 
and configure it to work with Perl for CGI scripting.

Ahmed Moustafa wrote:

> Naveen,
> 
> You don't run a perl, if you mean a cgi script, in a browser. You run it 
> under a web server, which supports cgi.
> 
> Naveen Parmar wrote:
> 
>> Hello,
>>
>> My activeperl installation was fine. When I try to run my example Perl 
>> scripts within IE, the browser does not even recognize them??
>>
>> Any ideas???
>>
>> - NP
> 
> 
> 



-- 
Sliante,
Richard S. Crawford

mailto:[EMAIL PROTECTED] 
http://www.mossroot.com
AIM:  Buffalo2K   ICQ: 11646404  Yahoo!: rscrawford
MSN:  [EMAIL PROTECTED]

"It is only with the heart that we see rightly; what is essential is 
invisible to the eye."  --Antoine de Saint Exupery

"Push the button, Max!"



-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: Help me out

[Richard Crawford]

The books that Matthew suggested are excellent resources, I've found
(though I would also recommend "Programming Perl", also from O'Reilly).

Another excellent way of learning how to program is read other peoples'
code, figure out how to break it and fix it, and adapt it to your own
needs.  My father-in-law, a C/C++/Java programmer, tells me that there
has only ever been one program written.  The rest are just hacks off of
that one program.

I found it very useful, when learning the basics (as I still am,
actually), to go to free script archive sites, such as Matt's Script
Archive, download some scripts, read the documentation to learn how to
tweak them, and play with that.


On Thu, 2002-02-14 at 15:48, Naika - EV1 wrote:
> Yeah I agree, I owe about 5 perl books and have read them all but still find
> it difficult to code the most basic of things. I wish there were more step
> by step how to's out there. I'm documenting my progress and plan to do a
> site sometime that caters to the most uneducated of learners. If any sites
> like that exist already let me know. Sometimes I learn better from seeing,
> being on the artistic side of the mind.
> 
> - Naika
>   http://www.naikaonline.com
> 
> 
> 
> -Original Message-
> From: Yacketta, Ronald [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 14, 2002 8:50 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Help me out
> 
> 
> its that simple? WoW! I must have fubarbed somewhere, I have those books as
> well as several others and hell I am not even close to be a pro!/me dreams
> about the day I can be a perl gawd like Randel (spelling)
> 
> -Ron
> 
> > -Original Message-
> > From: Matthew Peter Lyon [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 14, 2002 11:49
> > To: amrinder singh; [EMAIL PROTECTED]
> > Subject: Re: Help me out
> >
> >
> > get the O'Riley learning perl book
> > get the black book
> > get the cookbook ( O'Riley )
> >
> > you'll be a pro.
> >
> > - Original Message -
> > From: "amrinder singh" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, February 14, 2002 12:24 PM
> > Subject: Help me out
> >
> >
> > > I have just started learning perl a day ago.
> > >
> > > Can anybody guide me on how to start?  I am really
> > interested in learning
> > > the language
> > >
> > >
> > > AMRINDER
> > >
> > >
> > > _
> > > Join the world’s largest e-mail service with MSN Hotmail.
> > > http://www.hotmail.com
> > >
> > >
> > > --
> > > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > >
> >
> >
> > --
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> 
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> -- 
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
-- 
Sliante,
Richard S. Crawford

mailto:[EMAIL PROTECTED]  http://www.mossroot.com
AIM:  Buffalo2K   ICQ: 11646404  Yahoo!: rscrawford
MSN:  [EMAIL PROTECTED]

"It is only with the heart that we see rightly; what is essential is
invisible to the eye."  --Antoine de Saint Exupery

"Push the button, Max!"



--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]