----- Original Message -----
From: "Rodrigo Ordonez Licona" <rodrigo (at mark) xnet.com.mx>
To: <coba-e (at mark) bluequartz.org>
Sent: Sunday, May 14, 2006 9:31 AM
Subject: [coba-e:05176] Re: Casp + Mysql
> Hi Emmanuel,
>
> I had Michael Stauber Install mysql 5 at solarspeed.net.
>
>
> He installed PHP5 and Mysql 5
> After some yum update Chiliasp DSN Interface stopped functioning,
> So now I use these connection String
>
> WHAT I NOTICED IS THAT SPECIFYING LOCALHOST
> TO THE MYSQL CONNECTIONS PRODUCED STRANGE ERRORS
> AND TCP CONNECITONS TO BUILD UP ENDING UN ANOTHER ERROR
> SEVER POP SERVER FAILURE
> (In Chilisoft logs ASP Engine simply died killing all sessions)
>
> Long story short this connection string worked for us...
>
> <%
> ConnString ="Driver={Mysql}; Database=test; UID=test; PWD=test"
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open ConnString
> Conn.Close
> Set Conn = Nothing
> %>
>
> I Bet there's are a lot of people who had great application running on
> ASP,
> and have severe problems porting the to Bluequartz, its terrible to have
> several applications with several hours of programming time, so
> frustrating
> having to port them to PHP which would take ages.
>
> In our case Interbase database was used also and now, Chilisoft dropped
> support we were forced to change to MYSQL, but MYSQL stored procedures
> arent
> even near Interbase's, and Postgress isnt as portable when using
> standalone
> databases.
>
> Good Luck
>
> Rodrigo O
>
> -----Original Message-----
> From: e.a (at mark) post.com [mailto:e.a (at mark) post.com]
> Sent: SáÃado, 13 de Mayo de 2006 06:17 p.m.
> To: Rodrigo Ordonez Licona
> Subject: [coba-e:05162] Re: Casp + Mysql
>
>
> ROL> I have it (Mysql 5 and Chiliasp-NUONCE PKG)working on my Centos BQ
> ROL> 4.2 But had to do a symbolic link on the opensource folder, Also
> ROL> check that ks is missing for Chiliasp it to start (yum -install
> ROL> pkdshell) When I got this problem At
> ROL> /home/chiliasp/odbc/opensource/lib
> ROL> I did a
> ROL> ln -s libmyodbc.so libmyodbc-2.50.39.so It worked fine for me
> ROL> However there are Ugly problems using special datatypes Such as
> ROL> decimal on your Mysql Tables, Output data gets mixed up using these
> ROL> datatypes.
> ROL> Try to stick with float,int,varchar,text if you want to keep hair
> ROL> on your head (no offense to bald people).
>
> Thank you !
> I already had the symbolic link defined.
> The CASP works but not the MySQL connections.
> I use this test with an existing Mysql 'test' database :
> <%
> ConnString
> ="Driver={MySQL};SERVER=localhost;DATABASE=test;UID=test;PASSWORD=test"
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open ConnString
> Conn.Close
> Set Conn = Nothing
> %>
> And get :
> HTTP Error 507
> 507 Unexpected
> The Web server encountered an unexpected error while communicating with
> the ASP service.
>
> I'm not an expert. I don't know what is pkdshell.
> When I do : yum list | grep pkd , i don't have any output.
>
> Can you help me ?
>
> Regards,
> Emmanuel
>
For me the pkdshell was already installed, but I did have to create a
symbolic link
cd /home/chiliasp/odbc/opensource/lib
ln -s libmyodbc-2.50.39.so libmyodbc.so
----
Ken Marcus
Precision Web Hosting, Inc.
http://www.precisionweb.net