Geeze... This message was sent (according to my sentbox) on 5/24/02 and just appeared
on the list on 6/7/02 (I had given up on it). I don't know whats up with that...
Next, what I asked for was a way to read the datasources, NOT connect to mysql. I
want to be able to see all the drivers(Oracle, MSSQL, etc.) in addition to the MySQL,
as well as all ther databases (NOT a single one I connect to). I just used that as an
example (my bad). Then I guess I could connect to them in the normal manner (which I
don't have an issue with since I CAN pass the username, password, and host). So, the
question still stands, is there a way to read the data sources remotely?
I am able to do it fine if I turn off all security, but as I mentioned, there seems to
be no way to pass the user name and password, let alone the host.
TIA,
Shawn
----- Original Message -----
From: "Colin Faber" <[EMAIL PROTECTED]>
To: "Shawn" <[EMAIL PROTECTED]>
Cc: "MySql List" <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 4:14 AM
Subject: Re: MySQL and DBI remote access
> Hi,
>
> Right from the "connect" section in the DBD::mysql manual:
>
> $dsn =
> "DBI:mysql:database=$database;host=$hostname;port=$port";
>
> $dbh = DBI->connect($dsn, $user, $password);
>
>
>
> Shawn wrote:
> >
> > Hello all,
> > Does anyone know if there is a way to remotely call the data_source
>[DBI->data_source('mysql')] property to pull all available databases/drivers?
> >
> > I can't seem to do it since you are not allowed to specify a host name, user
>name, or password with it. The docs mention nothing about it using the call
>remotely, but I can't believe that I am the first to have an issue with it... Any
>pointers would be greatly appreciated?
> >
> > TIA,
> > Shawn
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> Colin Faber
> (303) 736-5160
> fpsn.net, Inc.
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
