urgent: VB error " selected collating sequence not supported by the operating system"

Posted on 2004-09-29
Last Modified: 2008-03-06
I have some VB coding as below, and as i run the program it pop up an error state that "selected collating sequence not supported by the operating system".... how to solve this problem...?
Here is my code: In a module

Global cnn As ADODB.Connection
Global gblstrCnnString As String

Sub Main()
  'some code here

  gblstrCnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source="

  Set cnn = New ADODB.Connection
  cnn.Open gblstrCnnString & App.Path & "\Package.mdb" 'open connection
  cnn.CursorLocation = adUseClient
  'some code here
End Sub

The Sub Main() I put it in a Module, while in a form, this is my code:

Option Explicit
Dim Rst As ADODB.Recordset

Sub refreshPackage()
    On Error Resume Next
    '****** Move Package Number Into combobox ********'
        strSQL = "SELECT distinct[PackageName] FROM PackageConfigure"  
        Set Rst = cnn.Execute(strSQL)
        While Not Rst.EOF
            cboSearch.AddItem Rst.Fields(0)
End Sub

Why when I run this code in other computer, no problem occur, but when I run it in my computer, the error exist. Can anybody help me on this...? I need it urgent.

Question by:sawai_tan

Author Comment

ID: 12177942
some info,
when i change  the strSQL = "SELECT distinct[PackageName] FROM PackageConfigure"  
to                            strSQL = "SELECT * FROM PackageConfigure"  

no error come out.....

what is the solution?

LVL 16

Accepted Solution

jimbobmcgee earned 500 total points
ID: 12177953
Microsoft suggest this is a multilanguage issue.  There is a workaround listed at

Give that a try...

Expert Comment

ID: 12177971
Try this
strSQL = "SELECT distinct [PackageName] FROM PackageConfigure"  
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Expert Comment

ID: 12178538
The problem must be,

You are trying to open a database or an object in a database that was created in another language edition of Microsoft Access.
You are trying to open a database that was created or compacted while the New Database Sort Order was set to a value other than General.

-from Microsoft

for complete describtion see this,


Author Comment

ID: 12185891
why I run the program in other computer, no error come out, but when I run it in my computer, the error come out....?
LVL 16

Expert Comment

ID: 12188244
If it is due to the error described in the Microsoft KB article that I posted, it is probably because the Access database file was created using a language/character set/code page that is supported by the other computer but not yours.

In order for the program to work on your machine, you need to have the compatible language/character set/code page installed on your machine.

Read the posted Microsoft articles for more information.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Acccess - Update Field in Table when report is printed 6 46
Problem to With line 4 63
pop out of webbrowser1 control vba6 5 25
Formula problem with Excel attachment 6 38
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question