RE: DBI MYSQL

2003-11-13 Thread Dan Muey
ave it narrowed down eh? Cool HAGO, DMuey > Thanks for everybody's help !!! > > // Larry > > > -Original Message- > From: Dan Muey [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2003 3:59 PM > To: Tore Aursand; [EMAIL PROTECTED] > Subject: R

RE: DBI MYSQL

2003-11-13 Thread Larry Sandwick
2003 3:59 PM To: Tore Aursand; [EMAIL PROTECTED] Subject: RE: DBI MYSQL >> $dsn = "DBI:mysql:webmaster,blackhole"; This comma still throws me. Try DBI:mysql:webmaster:blackhole Also if you do this from the command line what happens after you put in the password you h

RE: DBI MYSQL

2003-11-12 Thread Dan Muey
>> $dsn = "DBI:mysql:webmaster,blackhole"; This comma still throws me. Try DBI:mysql:webmaster:blackhole Also if you do this from the command line what happens after you put in the password you have in your script? $ mysql -u yourusernamehere -p -h blackhole webmaster > What Tore said is t

Re: DBI MYSQL

2003-11-12 Thread Tore Aursand
On Wed, 12 Nov 2003 13:48:26 -0500, Larry Sandwick wrote: > #! /usr/bin/perl Always: use strict; use warnings; > use DBD::mysql; No need to. DBI will take care of this (when you declary the database type to be 'mysql'). > $dsn = "DBI:mysql:webmaster,blackhole"; my $dsn = "DBI:mysql:dat

RE: DBI MYSQL

2003-11-12 Thread Dan Muey
> > DBI connect('webmaster,blackhole','webmaster',...) failed: Access > > denied for user: '[EMAIL PROTECTED]' (Using password: YES) at > > ./data_loader.pl line 8 > > Try with a semi-column instead of the comma: > $dsn = "DBI:mysql:database=webmaster;host=blackhole"; While you're at it try: D

RE: DBI MYSQL

2003-11-12 Thread Dan Muey
> Le mer 12/11/2003 à 19:48, Larry Sandwick a écrit : > > > [EMAIL PROTECTED] mysql]$ ./data_loader.pl > > > > DBI connect('webmaster,blackhole','webmaster',...) failed: Access > > denied for user: '[EMAIL PROTECTED]' (Using password: YES) at > > ./data_loader.pl line 8 > > Does the comma stan

Re: DBI MYSQL

2003-11-12 Thread Yannick Warnier
Le mer 12/11/2003 à 19:48, Larry Sandwick a écrit : > [EMAIL PROTECTED] mysql]$ ./data_loader.pl > > DBI connect('webmaster,blackhole','webmaster',...) failed: Access denied > for user: '[EMAIL PROTECTED]' (Using password: YES) at > ./data_loader.pl line 8 Try with a semi-column instead of the c

Re: DBI MYSQL

2003-11-12 Thread Yannick Warnier
Le mer 12/11/2003 à 19:48, Larry Sandwick a écrit : > [EMAIL PROTECTED] mysql]$ ./data_loader.pl > > DBI connect('webmaster,blackhole','webmaster',...) failed: Access denied > for user: '[EMAIL PROTECTED]' (Using password: YES) at > ./data_loader.pl line 8 Does the comma standing between webmast

RE: dbi mysql question

2002-12-31 Thread Dan Muey
Answer my own question. Yes it is possible, no problem. My problem was an obscure infinite loop. So nevermind! Thanks Dan -Original Message- From: Dan Muey Sent: Tuesday, December 31, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: dbi mysql question Does any one happen to know if it's po

Re: DBI mySQL and Sybase confusion

2002-05-20 Thread bernabe diaz
You need to download DBB module client for sybase or mysql. download the instruction , go to cspan and download fromthere good luck BD JASON CANNEY wrote: >I admit my newness first off. I am trying to connect to two databases. One is local >which is a mySQL database, and the other is a remo