On Mon, 6 Oct 2003 15:17:09 -0400 (EDT) David N Murray
<[EMAIL PROTECTED]> wrote:
> In my scripts, I use 'or die "cannot connect " . DBI::errstr . "\n";'
> I'm not sure why you're not getting a message, but the above line
> always works for me (note missing $ before 'DBI::'), when I do
> something
On Oct 6, David Kramer scribed:
> Im new to using DBI, so this question is very simple Im sure. I have
> searched the web and have read through O'Reilly's Programming the Perl DBI.
> Im trying to connect to an Oracle 8.1.7 database running on Solaris 8. The
> script itself resides on my app serv
Im new to using DBI, so this question is very simple Im sure. I have
searched the web and have read through O'Reilly's Programming the Perl DBI.
Im trying to connect to an Oracle 8.1.7 database running on Solaris 8. The
script itself resides on my app server which is a Win2K box. Im using
Active
On Mon, 24 Mar 2003 05:45:59 -0800, Barlow, Neil wrote:
>That's is correct - I am attempting to connect a MS SQL7 DB that is not
>located on the Webserver.
You could start by using Windows' ODBC Data Sources control panel to
create a (system) DSN. Next, all you have to do is use the DSN name in
y
On Mon, 24 Mar 2003 05:45:59 -0800 "Barlow, Neil" <[EMAIL PROTECTED]> wrote:
> That's is correct - I am attempting to connect a MS SQL7 DB that is not
> located on the Webserver.
>
> Would you have some sample code that illustrates connecting to a remote
> DB using either DBD::Sybase or DBD::ODBC
ailto:[EMAIL PROTECTED]
Sent: 24 March 2003 13:46
To: Barlow, Neil; [EMAIL PROTECTED]
Subject: Re: DBI Newbie
On Mon, 24 Mar 2003 08:37:18 -0500 Joshua Caesar <[EMAIL PROTECTED]>
wrote:
> Since Neil is running a windows box with IIS (his script is at
> Z:\InetPub\scripts\driver.pl), I
::Sybase or DBD::ODBC. I wonder
how he decided to try using DBD::mSQL to connect instead.
> -Original Message-
> From: Michael A Chase [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 24, 2003 8:11 AM
> To: Barlow, Neil; [EMAIL PROTECTED]
> Subject: Re: DBI Newbie
>
, Neil; [EMAIL PROTECTED]
Subject: Re: DBI Newbie
On Mon, 24 Mar 2003 03:43:20 -0800 "Barlow, Neil"
<[EMAIL PROTECTED]> wrote:
> I am attempting to connect to a SQL7 DB that is on a server other than
> the webserver. I am unsure as to what the connection string will be?
Is SQ
On Mon, 24 Mar 2003 03:43:20 -0800 "Barlow, Neil" <[EMAIL PROTECTED]> wrote:
> I am attempting to connect to a SQL7 DB that is on a server other than
> the webserver. I am unsure as to what the connection string will be?
Is SQL7 a new name for mSQL?
> use DBI;
>
> my $dbh = DBI->connect ("DBD:
Hi all,
I am an absolute newbie to DBI and have read the documentation and am
still unsure.
I am attempting to connect to a SQL7 DB that is on a server other than
the webserver. I am unsure as to what the connection string will be?
use DBI;
my $dbh = DBI->connect ("DBD:mSQL:database=;host=",
"
ECT a, b, c FROM table ORDER BY a");
>
> Omitting the WHERE statement returns 1.5 million rows in 839 seconds;
> the additional rows are where field 'c' is null. The value 'XYZZY' will
> never occur in the data.
>
> Why wouldn't those rows be returned in
'XYZZY' will
never occur in the data.
Why wouldn't those rows be returned in the first query? Why does it
take so much longer to return these records?
Thanks for enlightening a DBI newbie,
Rick
In article <061601c1f511$cf6ab2d0$05c3eed4@asarianhost>,
[EMAIL PROTECTED] (Mark) wrote:
> Hello,
>
> Just branching into the whole MySQL thing. :)
>
> Does anyone know a good place for examples on how to use DBI.pm?
>
> Thanks.
>
> - Mark
>
>
I found having this handy to be VERY useful:
Yes, install the modules see README, then read their respective perldocs.
You might also want to invest in "Programming the Perl DBI".
Ilya
-Original Message-
From: Mark
To: [EMAIL PROTECTED]
Sent: 5/6/02 9:22 AM
Subject: DBI newbie
Hello,
Just branching into the whole M
O'Reilly's Programming the Perl DBI was very helpful to me when I
started out with this...
--
Barbara E. Lindsey,
Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162
"The road goes ever on and on. "
- Bilbo Baggins
Hello,
Just branching into the whole MySQL thing. :)
Does anyone know a good place for examples on how to use DBI.pm?
Thanks.
- Mark
16 matches
Mail list logo