ACCESS DB USERS! PLZ, help me...

M

mannaka

Guppy
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")
=============================================



====<this is the error message>=====================
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.
 
mannaka said:
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.
Click to expand...
I'm using a connection string like this:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MYDATABASE.MDB;"
 
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.
 
isn't this related with web-server configurations?
for example, write permissions...

but, SalesRep told me that they gave all dir full permissions.
 
mannaka said:
isn't this related with web-server configurations?
for example, write permissions...

but, SalesRep told me that they gave all dir full permissions.
Click to expand...
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.
 
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.
 
Glad to hear you got it working. I don't work for JodoHost. Just a customer. :)

mannaka said:
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.
Click to expand...
 
You must log in or register to reply here.
Back
Top