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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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"  
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.


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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
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…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

688 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