ACCESS DB USERS! PLZ, help me...

Customer Support Database Support
1

Hi, Access DB users?
First of all, I made an asp page(inserting new records) in Dreamweaver with MS-ACCESS. This page is for contact information including name, email and comments. It is working well in my PWS.
When I tried it in Jodoshared server, I got the following error message.

==============================================
(** I used DSN-less connection string**)
“DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=” & Server.MapPath(“mydb.mdb”)

=========================
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’

[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system.

/test.asp, line 115

=============================================

I can see the below in line 115 of test.asp,

MM_editCmd.Execute

also, in test_view page, I got a similiar error in line

MM_editCmd.Open()

Can anyone help me?

Thanks in advance.

mannaka.

2

[QUOTE=mannaka]
Hi, Access DB users?
First of all, I made an asp page(inserting new records) in Dreamweaver with MS-ACCESS. This page is for contact information including name, email and comments. It is working well in my PWS.
When I tried it in Jodoshared server, I got the following error message.

==============================================
(** I used DSN-less connection string**)
“DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=” & Server.MapPath(“mydb.mdb”)

mannaka.
[/QUOTE]

I’m using a connection string like this:

“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MYDATABASE.MDB;”

3

I’ve tried that code already. I had a same error.

Does this support DSN-less string?

4

[QUOTE=mannaka]
I’ve tried that code already. I had a same error.

Does this support DSN-less string?
[/QUOTE]

I have never setup a DSN so this should work.

I found this KB article.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q202150

Don’t know if it helps. What language(s) are you using?

5

I’ve changed from Japanese to General in Access option menu.
But it’s not working.
I guess it should work even in Japanese as long as OS is English version.

6

isn’t this related with web-server configurations?
for example, write permissions…

but, SalesRep told me that they gave all dir full permissions.

7

[QUOTE=mannaka]
isn’t this related with web-server configurations?
for example, write permissions…

but, SalesRep told me that they gave all dir full permissions.
[/QUOTE]

I don’t think this is a rights issue. Everything I have found searching the internet on Selected collating sequence not supported by the operating system has been related to language.

8

Thanks, brawney. Are you working for JODOHOST? just curious…

According to your KB article you showed me,
we don’t need to touch language settings and windows registry as long as the connection is OK.
I found out that my problem came from the different configurations between Win2003 and MSSQL server.
I spent valuable 3 days to figure it out.

Thanks again.

P.S. I can go with jodo hosting, finally.

9

Glad to hear you got it working. I don’t work for JodoHost. Just a customer. :slight_smile:

[QUOTE=mannaka]
Thanks, brawney. Are you working for JODOHOST? just curious…

I found out that my problem came from the different configurations between Win2003 and MSSQL server.
I spent valuable 3 days to figure it out.

[/QUOTE]