On Tue, 26 Mar 2002, Xavier Prelat wrote:
> Even if you are using the CFServer 5.0 you will not be able to edit any
> MySQL DSN with the ColdFusion DSN web admin tool. First install the MySQL
> ODBC on your server, then create any DSN you need using the ODBC Sources
> tool (administrator tool on Win 2000).
> Once you created the DSN you want, the CF let you manage the DSN through the
> web admin interface!
Hmmm, that is odd. We have had no problem editing MySQL DSN's with the
Merant drivers, although where you are asked for the MySQL server's
hostname (and the MySQL server is on the same system as Cold Fusion), you
must give the full hostname, not just "localhost". If you use 'localhost'
it will work initially but if you need to restart cfserver for any reason,
then it will not be able to verify the DSN again, unless you have used the
full Internet address of teh MySQL server.
Andy
> -----Message d'origine-----
> De : andy thomas [mailto:[EMAIL PROTECTED]]
> Envoye : mardi 26 mars 2002 13:14
> A : [EMAIL PROTECTED]
> Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Objet : Re: Coldfusion,Mysql,Myodbc
>
>
>
>
> On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote:
>
> >
> >
> >
> > Hi there .
> > I am new to Mysql.I have to access mysql from coldfusion..and we dont get
> > myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am
> > not able to compile the myODBC bit...its giving compilation problem..Any
> > suggetions from you guys.
>
> ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL
> and you should be using these. Note that the cfodbc45.so driver shipped
> with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib)
> is broken and you can download a fixed version from Macromedia's web site.
>
> Andy
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
