mdb: Selected collating sequence not supported

[Abe]

Please help: It shows: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system. file.asp line x

my asp access problem:
table1
item1 price1 quanty1
candy -- 3 ---- 100
box ---- 2 ---- 150
why sql="select * from table1 " is working and no error
but sql="select * form table1 where item1=""candy""" is not working
how to add where statement??
when ever I add where the error will show
set rs=conn.execute(sql)<----this is line x !!!!??? problem here

This is also very strange : the where statement does work for another hosting plan but not work for JodoHost hosting plan. Why? Please help!

 

[Logan]

why sql="select * from table1 " is working and no error
but sql="select * form table1 where item1=""candy""" is not working

try:

sql = "select * from table1 where item1 = 'candy';"

 

[Abe]

try:

sql = "select * from table1 where item1 = 'candy';"

I did try
sql = "select * from table1 where item1 = 'candy';"
and
sql = "select * from table1 where item1 = 'candy' "

but it shows same error

Please Help! Help! Help!

 

[SubSpace]

http://support.microsoft.com/kb/184988

According to Microsoft the database was probably made using some non-standard language version of Access. What language version are you using? Possibly you could use an English version or you could try asking JodoHost to install the proper language support (http://support.microsoft.com/kb/177561/EN-US/), but they'd have to know server and language group.

 

[jcoder]

when you run into "collating" issue with database, it is suggesting that your SQL string comes with too much brackets, most likely the "[" & "]". Just remove those brackets and it should fix the problem.

example:

SELECT *
FROM [tbl_products Query]

now change to:

SELECT *
FROM tbl_products Query