Resending without attachment.
Dick McCullough
http://mkrmke.org
----- Original Message -----
From: Richard H. McCullough
To: Clinton Jeffery
Cc: Unicon group ; Wade Bowmer ; Paola Di Maio
Sent: Saturday, July 25, 2009 11:45 AM
Subject: Re: [Unicon-group] Unicon interface to MySQL database
Attached phpinfo.pdo.jpg shows that GoDaddy PHP
was installed with PDO, and has a mysql driver.
According to Gilmore's book, the "open" equivalent is
$dbh = new PDO(DSN, username, password, driver_opts);
where DSN is a string with example format of
"mysql:host=localhost;dbname=corporate"
or the name of a file with example format
"uri:file://usr/local/mysql.dsn"
or a php.ini file alias with example format
"mysqlpdo"
User configuration info. [including pasword]
can be stored in ~/.my.cnf
Dick McCullough
http://mkrmke.org
----- Original Message -----
From: "Clinton Jeffery" <[email protected]>
To: "Richard H. McCullough" <[email protected]>
Cc: "Unicon group" <[email protected]>; "Wade Bowmer"
<[email protected]>; "Paola Di Maio" <[email protected]>
Sent: Saturday, July 25, 2009 10:51 AM
Subject: Re: [Unicon-group] Unicon interface to MySQL database
> Dick,
>
> I guess if you do all Mysql from PHP and pass the info to Unicon as
> parameters or whatever, that will work and not require any database
> capabilities from your Unicon.
>
> ODBC doesn't actually involve any OS kernel calls or hooks beyond
> generic (TCP, etc.).
> If you are using Unicon built from another machine, if that iconx
> contained statically linked libodbc.a code, or if you copied a
> libodbc.so over along with your iconx, and set your environment
> variables and odbc.ini right, you'd be in business. I note that the
> iconx &features that you listed via your iversion.php suggests it
> wasn't built with any ODBC facilities.
>
> Clint
>
> On Sat, Jul 25, 2009 at 6:39 AM, Richard H. McCullough<[email protected]>
> wrote:
>> c) I have survived by copying my old versions of icont, iconx
>> from Red Hat Linux 7.3, and using PHP scripts to compile
>> my mKE programs.
>> d) I doubt if GoDaddy would agree to installing ODBC.
>>
>> 2) I think the best possibility might be to use PHP to connect,
>> and figure out how to pass PHP info. to Unicon.
>> a) The book
>> "Beginning PHP and MySQL 5, From Novice to
>> Professional, Second Edition", W. Jason Gilmore,
>> Apress, 2006.
>> conjectures that PHP 5 would use their
>> own PDO interface to the "future" MySQL 5.
>> b) Is the use of PDO consistent with your statement
>> re "direct linking" to MySQL library?
>> c) I imagine that converting Unicon from ODBC to PDO
>> would be fairly easy.
>
> ------------------------------------------------------------------------------
_______________________________________________
Unicon-group mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/unicon-group
