Access With Unicode

[northernmonkey]

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

[PaulH]

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

[northernmonkey]

I get an:

Error Executing Database Query

Message

[Mountain Lover]

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]

[northernmonkey]

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]

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

[northernmonkey]

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!

[Jochem van Dieten - TMM]

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.

[Mountain Lover]

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]

[northernmonkey]

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

[alsaweb]

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