collating sequence error???

[Scotty Parker]

hi guys... i am trying to execute an SQL query on a database created from another system. I open a connection to the dsn of the database and use db tools execute query vi. i get the following error right after this vi.

Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system.. in Conn Execute.vi->CM2 front panel.vi

help please 😃 thanks

[Russ@Davis]

I've not had that specific error. Can you execute the SQL command in the DBMS on which the DB was developed? Can you execute the SQL query in an interactive SQL editor on the Labview system? One thing you may find is the ODBC driver, which in this case appears to be for an MS Access DB, may not support all of the SQL commands that you may have used with other systems.

[Feroz]

Hi Scotty,

We need some more information from you:
1) What SQL query are you trying to execute?
2) What operating system are you using?
3) What version of Access do you have?

The database connectivity toolkit is ADO Based. Try creating a UDL for the database and feed the path to the UDL to the Database Open Connection.vi. To create a UDL, go to Tools >> Create Data link. Under Provider tab, select Microsoft Jet 4.0 OLE DB Provider. Under Connection tab, select the database you are trying to communicate to. Test the connection to make sure it is connecting ok.

Start with a simple SQL query and see if that works.

I hope this helps.

Sincerely,
Feroz
National Instruments

[Scotty Parker]

Thanks guys for the replies.

My program is to be able to query a Database that resides in the same PC that the program

is. Only point to note is the database will be generated by a different PC and this database

will be saved inside the PC where the program will reside.

I tested the program on my laptop and it works perfectly. When i transfer the program onto

the actual PC where I intended the program to run, together with the database it gave me the

error message.

here is the detail which i foresee could potentially be the problem.

The database is generated using Access 2000 on Win XP but will be transferred to another PC

where my program will be running. This PC is running Access 2002 on Win XP. COuld this be

the
problem? I would have thought 2002 would be able to run 2000 documents.

i tested with a simple SQL like "SELECT ModelID from Memory;" but it will always fail after

DB Tools Exe query VI.

Thanks for any help.

Sincerely
Parker

[Scotty Parker]

Thanks guys for the replies.

My program is to be able to query a Database that resides in the same PC that the program

is. Only point to note is the database will be generated by a different PC and this database

will be saved inside the PC where the program will reside.

I tested the program on my laptop and it works perfectly. When i transfer the program onto

the actual PC where I intended the program to run, together with the database it gave me the

error message.

here is the detail which i foresee could potentially be the problem.

The database is generated using Access 2000 on Win XP but will be transferred to another PC

where my program will be running. This PC is running Access 2002 on Win XP. COuld this be

the
problem? I would have thought 2002 would be able to run 2000 documents.

i tested with a simple SQL like "SELECT ModelID from Memory;" but it will always fail after

DB Tools Exe query VI.

Thanks for any help.

Sincerely
Parker

[Feroz]

Hi Parker,
I searched on MSDN for the error you are getting. I found a document that discusses the issue I think you're seeing.

ACC2000: "Selected Collating Sequence Not Supported" Error Message

I hope this helps.

Sincerely,
Feroz
National Instruments