[cobalt-users] mysql pkg, myodbc driver, & chiliaspv3.6 on Raq4

["Christie" <ca@xxxxxxxxxxxxxxxxxxx>]

I originally installed mysql v3.23.40 rpms for linux on my raq 4, a friend
installed the appropriate myodbc for that version and it was a success! my
web app functioned perfectly. Unfortunatley an os restore had to be done
only days later, we are still in pro of learning the raq 4 which seems to be
a bit finicky, plus I am new to unix, although I am loving it b/c I have
issues with windows.

	After the restore, I reinstalled mysql v3.23.37 b/c I found the pkg file on
sun's website. Being that sun strongly advocates the use of .pkg's over
other forms of installation, and warns of possible warranty voids from
operating on command line I thought this would be the best.  However, there
was a  catch to the myodbc issue; appearantly the myodbc does not
automatically install from pkg on chilisoft v3.6 only v3.5. I upgraded
chilisoft simply b/c I wanted chilisoft spice pack and chilisoft told me to
get it I had to upgrade to chili v3.6???!!! The only adivce they will
support is to down grade. That means downgrading to chili v3.5 and
downgrading to mysql 3.22.23, the only version sun will support. mysql
3.23.40 has been declared stable for some time now!!!

	 The peculiar part was that my dsn worked successfully just after install
of the pkg, I ran through an asp app I was currently working and and voila
no probs. I thought there was some issue with permission levels in mysql
users or db table & made some changes, but regardless a test connection for
the root user should always work...right?

	I use my windows pc with dreamweaver ultra developer, the mysql driver i
have for windows talks DrmWv just fine using  local dsn...this is just so
Drmwv on my win pc can read the tables on my unix raq4 server, test connec
is always successful here. No luck with dsn on chili, so I figure it can
only be the driver. Although chiliasp/odbc/opensoure/lib does contain
libmyodbc-2.50.26.so & libmyodbc-2.50.38.so they are not visible through the
asp admin gui.

	please if anyone can help I am banging my head against the wall for 3 days
now and am currently considering going to php...this can't be this hard!!!!