SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL/CF Express/MyODBC

    Hi all,

    I'm working on databasing part of our intranet at work. We're running Win2k and were going to be on SQL Server. However due to the NASDAQ and general tech downturn, the IT budget has been slashed so my database options are now as follows:

    - Access
    - MySQL

    CF Express is the development platform (all simple stuff). I'm happy with Access and have used it before for this sort of thing, but in this case I just don't think it will scale well enough.

    Anyway I'm having a prob with MyODBC, specifically ColdFusion won't connect to it. Now I don't know MySQL all that well, so I'm learning as I go along here For example, I have just discovered that DSNs are aparently supposed to be all uppercase using MyODBC

    But I don't think case is the problem. I think it might be UID/password. At the moment I'm on a test Win2k box with everything installed under one account. When I go into MySQL I don't even get prompted - just drops me straight into a client session (as 'ODBC@localhost' apparently).

    Should I somehow be specifying this UID (or a different one) in the MyODBC setup? Do I need to add another user account to MySQL?

    Any ideas?

    cheers
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  2. #2
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Aha....

    A check of the Macromedia forums reveals that the statement "ColdFusion Express supports any ODBC database" is not strictly true

    Back to ASP for this one I guess.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •