[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

what does this error mean???????????????

Hello
I get the following error
-2147467259[Microsoft][ODBC dBase Driver]Selected collating sequence not supported by operating system
on this line of code
 pvStrRecordSource = "SELECT `INDEX`, NUMMER, HGRUPPE, KNAME, KNAME2, KNAME3, KNAME4, SPKARTE, SPKARTE2, SPKARTE3, SPKARTE4, PREIS, FOLGE, FESTPREIS, BONZIEL, NOTALON, NOGUTSCH, NORECH, DOOVERVIEW, RABATT, PROVISION, BEILZWANG, BEILGRP, BEILSEITE, AUSWERT1, AUSWERT2, AUSWERT3, AUSWERT4, AUSWERT5, REZEPTUR, EINSTPR, SCHANK, CHGPREIS, HANDY, MWSTIN, MWSTOUT, CHTIME FROM HISTSPEI ORDER BY `INDEX`"

 pvOptEnmCursorTypeEnum = 2
 '\\OPEN SOURCE RECORDSET
 '\\ERROR HAPPENS HERE
 prDB_ADORecordset_Srce.Open pvStrRecordSource, prDB_ADOConnection_Srce, pvOptEnmCursorTypeEnum, adLockPessimistic, adCmdText

what does that error mean?
Cheers T
0
visualbasic
Asked:
visualbasic
  • 2
1 Solution
 
corvanderlindenCommented:
I suppose INDEX is a table column and not a literal. So do not use single qoutes because ORDER BY INDEX is not valid if INDEX is a litteral
0
 
corvanderlindenCommented:
I suppose INDEX is a table column and not a literal. So do not use single qoutes because ORDER BY INDEX is not valid if INDEX is a litteral
0
 
timytleeCommented:
Please try to use [] instead of '' for Index field
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now