mdb: Selected collating sequence not supported

Customer Support Database Support
1

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!

2

[QUOTE=Abe]
why sql="select * from table1 " is working and no error
but sql=“select * form table1 where item1=”“candy”“” is not working

[/QUOTE]

try:

sql = “select * from table1 where item1 = ‘candy’;”

3

[QUOTE=Logan]
try:

sql = “select * from table1 where item1 = ‘candy’;”
[/QUOTE]

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!

4

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 ( Windows help and learning | Microsoft Support ), but they’d have to know server and language group.

5

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