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