Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Access With Unicode

    For some reason ODBC for coldfusion isn't working so I have to use the unicode driver. None of my quieries are working do I have to write them differently when using Access with Unicode?

    Thanks
    northernmonkey Guest

  2. Similar Questions and Discussions

    1. Problem with Access with Unicode
      I just installed CF 7. In Coldfusion Admin, the databases I created using Access are Ok. But the samples databases using Access with Unicode do not...
    2. MS Access unicode compression
      Using both CF 5 and 6 with MS Access 2002 as the database. Trying to create and maintain tables through a ColdFusion app, and running into...
    3. Access + Unicode
      Hi, I require the use of an Access 2000 DB with windows 2000 and CF MX 6. I would like to be able to provide information in multiple languages...
    4. Connecting to microsoft access with unicode
      I am trying to Connect my database to microsoft access with unicode connection So when this box appaers it ask for Cf data Source name which is...
    5. Coldfusion MX 7.0 with 'Access with Unicode'
      I used to use Coldfusion 5 with Access DB (Using ODBC DSN) under IIS, everything works fine. Now I upgraded Coldfusion 5 to Coldfusion MX 7.0 with...
  3. #2

    Default Re: Access With Unicode

    access for unicode is probably a better choice. what exactly isn't working?
    PaulH Guest

  4. #3

    Default Re: Access With Unicode

    I get an:

    Error Executing Database Query

    Message

    northernmonkey Guest

  5. #4

    Default Re: Access With Unicode

    It uses the OLEDB driver rather than ODBC, so you might have to change
    some syntax. However, the end result is much better as the ODBC-JDBC
    bridge can't handle more than a few users. Post the code if you have any
    more problems
    HTH

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

  6. #5

    Default Re: Access With Unicode

    It doesn't seem to like my where clause

    <cfquery name='get_headlines' datasource='myDsn'>
    SELECT * FROM content
    WHERE section = news
    ORDER BY date_modified desc
    </cfquery>
    northernmonkey Guest

  7. #6

    Default Re: Access With Unicode

    if there are a lot of differences does anyone know a website that can give me more info
    northernmonkey Guest

  8. #7

    Default Access With Unicode

    Please can someone tell me how you write queries that work with Acess with
    unicode for example how would this be written: <cfquery name='get_headlines'
    datasource='myDSN'> SELECT * FROM content WHERE section = 'news' ORDER BY
    date_modified desc </cfquery> Any websites that give more info woul be much
    appreciated. Thanks!

    northernmonkey Guest

  9. #8

    Default Re: Access With Unicode

    northernmonkey wrote:
    > Please can someone tell me how you write queries that work with Acess with
    > unicode for example how would this be written: <cfquery name='get_headlines'
    > datasource='myDSN'> SELECT * FROM content WHERE section = 'news' ORDER BY
    > date_modified desc </cfquery>
    What you might want to try is replacing the * with the list of
    fields you are interested in. That occasionally gives problems
    which appear to be related to some security setting in the Access
    database, but I don't know which one. (I try to avoid Access.)

    Jochem

    --
    Jochem van Dieten
    Team Macromedia Volunteer for ColdFusion, beer and fun.
    Jochem van Dieten - TMM Guest

  10. #9

    Default Re: Access With Unicode

    It *might* be the word "section" as it's listed as a reserved word in M$
    Access. [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q209187[/url]
    You can get around reserved words by 1) not using them and 2) escaping
    them with brackets e.g. [section] = 'news'
    Also, are you searching within "section" for 'news'? If so use single
    quotes around your search term 'news'

    HTH

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

  11. #10

    Default Re: Access With Unicode

    really apprecite the help if you where hear i would probably kiss you ..................................... maybe not!
    northernmonkey Guest

  12. #11

    Default Access with unicode

    I just finished to install CF 7.
    There are samples databases using access with unicode already installed- like
    cfartgallery
    If I click on Verify all connections I am getting this error:
    ---->>Connection verification failed for data source: cfartgallery
    com.inzoom.adojni.ComException: Provider cannot be found. It may not be
    properly installed.
    The root cause was that: com.inzoom.adojni.ComException: Provider cannot be
    found. It may not be properly installed. in ADODB.Connection code=0 Type=1<----
    However if I create a new datasource with access driver (not access with
    unicode driver) and using the same database (cfartgallery.mdb) from the same
    folder, there is no error and the connection indicates OK.

    Question: what to do, what to install to solve this problem.
    Thanks a lot
    alsa

    alsaweb Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139