MySql Driver not in ODBC Data Sources Available to ColdFusion

[Mgreen2101]

the MySql ODBC Driver is not showing up in the ODBC Data Sources Available to ColdFusion however it is installed in my system MySQL ODBC 3.51 Driver, how do I get it so Its in the Add menu for cold fusion server 4.5.

Marc

 

[Mgreen2101]

I must update I have tried these steps

Just follow these steps - this should work.

1. Make sure you have the ODBC drivers installed for MySQL (downloadable from MySQL web site).
2. Create a system (important to ensure it's created as a system DSN) datasource.
3. Configure the new MySQL system datasource accordingly. Fill in name, password, etc as required.
4. Enter the ColdFusion administrator ODBC screen. You should see your new DSN.
5. Select the MySQL DSN and enter the password and name, if one was created.
6. Select "verify" and test your new DSN.

and it shows up but when i click verify nothing works and there is still no mysql driver on the pull down menu

 

[ecobb]

There won't be a native mysql drive in the pulldown menu unless you shell out the big bucks for CF Enterprise edition. It's the same way with Oracle, DB2, Sybase, and a few others. I guess Macromedia figures that if you're only using standard edition then you don't need to use those database systems...



Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[Mgreen2101]

So how exactly do I get MySql to work?

 

[imstillatwork]

as an ODBC socket.

make your adbc connection in your odbc manager first.

 

[imstillatwork]

no, no, no....

MySQL will work standard. I just did it last month....

download and install the odbc drivers from mysql...

 

[TruthInSatire]

imstillatwork, are you talking about version 4.5?

best thing to do is upgrade to at least 6.1 mysql drivers are included in standard.

Beware of programmers who carry screwdrivers.

 

[ecobb]

What the??? Well, I'll be! You're right! It IS included in 6.1 Standard! I never really noticed it sitting there, when did they had added it?



Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[TruthInSatire]

don't know. it's been there for as long as i've known, but i've only had CF for a little over a year and 6.1 standard is the only version i've owned.

Beware of programmers who carry screwdrivers.

 

[TruthInSatire]

I've only used one mysql db with cf. it seems to work pretty good. the largest table has a few thousand records in it and performance seems good enough...

Beware of programmers who carry screwdrivers.

 

[imstillatwork]

imstillatwork, are you talking about version 4.5?
"

ummm.... yeah... maybe thats why I was so confused...

We upgraded to MX 2 months ago (I've only worked here 3 months, took me a month to convince them to upgrade.)

MySQL works great with CFMX, even in windows.

 

[TruthInSatire]

what i don't get is the sql server driver. I've tried to use it but can only get it working as an odbc socket after setting up a dsn on the server.

That was on the intranet at work, haven't tried it on the Internet, we stopped running ss2k because of the security holes it makes. You wouldn't believe how much our hacker traffic slowed down once we removed it...

Beware of programmers who carry screwdrivers.

 

[ecobb]

Really? I've never had any problems with CF connecting to SQL2K with the native drivers, I just select it and go!

The only bad experiences I have had with setting up datasources in CF Standard was connecting to Oracle and AS/400. Those are not native to Standard, so you have to use "Other" and do everything through JDBC. It took me forever to finally get them connecting...I shudder just thinking about what I had to go through to get it!



Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher