Re: DBI Newbie: Connection Failure Issue??

2003-10-07 Thread Michael A Chase
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 silly,

Re: DBI Newbie: Connection Failure Issue??

2003-10-06 Thread David N Murray
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 server

Re: DBI Newbie

2003-03-24 Thread Michael A Chase
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

RE: DBI Newbie

2003-03-24 Thread Joshua Caesar
, 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 SQL7 a new name for mSQL? use

Re: DBI Newbie

2003-03-24 Thread Michael A Chase
. 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 On Mon, 24 Mar 2003 03:43:20 -0800 Barlow

RE: DBI Newbie

2003-03-24 Thread Barlow, Neil
:[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 think it is safe

Re: DBI Newbie

2003-03-24 Thread Michael A Chase
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? There

Re: DBI Newbie

2003-03-24 Thread Bart Lateur
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

Re: DBI newbie asks ODBC query question

2003-03-08 Thread Tim Bunce
http://www.google.com/search?q=sql+null+three+value Tim. On Fri, Mar 07, 2003 at 04:36:41PM -0500, Rick Nakroshis wrote: I just installed DBI v1.34 and DBD-ODBC v1.04 on my AS build 633, and have a question about a query that I tried to test the ODBC connection to our SQL Server database:

Re: DBI newbie

2002-05-06 Thread Barbara Lindsey
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

RE: DBI newbie

2002-05-06 Thread Sterin, Ilya
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 MySQL thing. :)

Re: DBI newbie

2002-05-06 Thread Scott R. Godin
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: