CF5 vs MySQL on windows 2000

[disch]

I'm having trouble connecting from ColdFusion5 to MySQL.

I've already downloaded and installed the Myodbc 3.51 driver and still
nothing. When I login to the CF Administrator's page and go to data sources
under odbc I'm left with these choices:


Microsoft Access Driver (*.mdb)
Microsoft SQL Server Driver
Microsoft dBase Driver (*.dbf)
Microsoft Visual FoxPro Driver
Microsoft Excel Driver (*.xls)
Microsoft Text Driver (*.txt, *.csv)
Merant dBase/FoxPro Driver
Merant Paradox Driver
Merant Text Driver
Merant Excel Workbook Driver
Merant IBM DB2/UDB Driver
Merant Informix 7.x/9.x Driver
Merant Informix Dynamic Server Driver
Merant Progress Driver
Merant Oracle 8 Driver
Merant SQLBase Driver
Merant Sybase ASE Driver



Nothing pertinent to MySQL, any help much appreciated!

I know I can change and use Access, but as a newbie to ColdFusion, I wanna
stick with the database I already know.

Thanks

[Mountain Lover]

You'll have to set up a ODBC datasource through the ODBC Datasource
manager in windows, then it *should* appear under ODBC datasources in CF
admin.
HTH,
Tim

--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[disch]

okay... excuse my "newbiness" but, where is the ODBC datasource manager to configure the new datasource ?

Thanks

disch

[Hi There]

Go to 'Start' > Settings > Control Panel > Adminstrative Tools > Data Sources

[disch]

:Q
It works now!!! thank you both for your help...

Disch

[Brad]

This worked for me, up until I tried to verify the newly created datasource
from within Coldfusion. I can use the datasource to link tables in MS
Access and perform other ODBC related tasks, however, I cannot get CF to
connect. :-(


"disch" <webforumsuser@macromedia.com> wrote in message
news:d2cjap$96s$1@forums.macromedia.com...
:Q
It works now!!! thank you both for your help...

Disch

[Brad]

Ok, figured it out, I had to create an account in MYSQL called ODBC and once
I did that it all worked!

"Brad" <webforumsuser@macromedia.com> wrote in message
news:d2fb95$cge$1@forums.macromedia.com...
This worked for me, up until I tried to verify the newly created datasource
from within Coldfusion. I can use the datasource to link tables in MS
Access and perform other ODBC related tasks, however, I cannot get CF to
connect. :-(


"disch" <webforumsuser@macromedia.com> wrote in message
news:d2cjap$96s$1@forums.macromedia.com...
:Q
It works now!!! thank you both for your help...

Disch

[disch]

Well, I fixed mine the cheesy way.... Upgraded lol ;)