query db problems

[quiero mas]

Got this error and im not really sure what to do next
link
<a target=_blank class=ftalternatingbarlinklarge
href="http://healthhokkaido.com/files/index.cfm


error
">[url]http://healthhokkaido.com/files/index.cfm[/url]


error
</a> Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Selected collating sequence not supported by the operating
system.

The error occurred in
C:\Sites\Accounts\bimfire\healthhokkaido.com\www\f iles\catalog_getCategories.cfm
: line 1
Called from C:\Sites\Accounts\bimfire\healthhokkaido.com\www\f iles\index.cfm:
line 62
Called from
C:\Sites\Accounts\bimfire\healthhokkaido.com\www\f iles\catalog_getCategories.cfm
: line 1
Called from C:\Sites\Accounts\bimfire\healthhokkaido.com\www\f iles\index.cfm:
line 62

1 : <cfquery name="qGetCategories" datasource="#application.ds#">
2 : select id,name from categories
3 : </cfquery>

SQL select id,name from categories
DATASOURCE cart
VENDORERRORCODE -5026
SQLSTATE HY000

[Dan Bracuk]

This is a guess.

It might be a keyword problem with name.

[MikerRoo]

Try the following:
<OL><li> Stop all Coldfusion services
<li> Open the database in Microsoft Access
<li> Select from the menu: <b>Tools -> Database Utilities ->Compact and repair
database.</b>
<li> Restart CF.

<li> If that didn'twork then see <a target=_blank
class=ftalternatingbarlinklarge
href="http://support.microsoft.com/default.aspx?scid=http://support.microsoft.co
m:80/support/kb/articles/Q202/1/50.ASP&NoWebContent=1">Microsft KB article
202150</a>.

<li> Finally, <b>Don't use Microsoft Access for any important or revenue
generating activity!</b>
</OL>

[quiero mas]

HI guys - thanks for the reply
just wondering
This is a error i recieved from the site online
On my computer its all working fine
should i upload the files again?

[Jochem van Dieten **AdobeCommunityExpert**]

quiero mas wrote:

> HI guys - thanks for the reply
> just wondering
> This is a error i recieved from the site online
> On my computer its all working fine
> should i upload the files again?

That will not help you. The root cause is that you have specified
a collation (string sort order) on your development machine that
is not supported on the server. Uploading the file again will not
resolve the underlying issue.
First make sure your database uses the General sort order (as
explained in the KB article MikerRoo linked), then upload the
database again.

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[quiero mas]

Thakns for the great advice
just one more question
should i also becareful of which font i choose?
I am trying to display both japanese and english
should i use for example arial unicode ms?
or do you have another suggestion?
does it matter?

[MikerRoo]

The font is not the most critical thing.
What counts is that you use unicode throughtout your db, that you keep the
default utf-8 encoding on the coldfusion server and that your CF files (and any
other content is saved as utf-8).

Then you can mix and match unicode fonts and characters.

Arial Unicode MS is ok for windows. What about linux, unix, macintosh, and
portable devices?
I think Hiragino Kaku Gothic Pro covers some of those but you'll have to ask
Japanese webmasters what they use.

[quiero mas]

Thanks - i think i may be able to sort things out - I appreciate all your help
over the last year.

I have read somewhere that you aren't very famiiar with mysql - is that right?
I am about to start studying another db applaication as you suggested as soon
as i get this online -
I had thought of mysql since it has those gui that can be used with it
what do you think? Any books you can suggest?

Many thanks again Miker and crew

MArk

[MikerRoo]

<blockquote>quote:<br><hr><i>Originally posted by: <b><b>quiero mas</b></b></i>
Thanks - i think i may be able to sort things out - I appreciate all your help
over the last year.

I have read somewhere that you aren't very famiiar with mysql - is that right?
I am about to start studying another db applaication as you suggested as soon
as i get this online -
I had thought of mysql since it has those gui that can be used with it
what do you think? Any books you can suggest?

Many thanks again Miker and crew
MArk<hr></blockquote>

Hmmm....
"I have read somewhere that you aren't very famiiar with mysql" ...
"Any books you can suggest?"

Are you sure you want MY book recommendations? :P

MySQL is a good database to learn but I don't personally know a book to
recommend.
Good luck.