ACCESS DB USERS! PLZ, help me...

Discussion in 'Database Support' started by mannaka, Jan 25, 2004.

  1. mannaka

    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.
  2. brawney

    brawney Perch

    I'm using a connection string like this:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MYDATABASE.MDB;"
  3. mannaka

    mannaka Guppy

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

    Does this support DSN-less string?
  4. brawney

    brawney Perch

  5. mannaka

    mannaka Guppy

    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. mannaka

    mannaka Guppy

    isn't this related with web-server configurations?
    for example, write permissions...

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

    brawney Perch

    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. mannaka

    mannaka Guppy

    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. brawney

    brawney Perch

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

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services