Steps to Reproduce Behavior
These steps demonstrate the behavior from Visual FoxPro, but this problem also occurs from other applications that use the Visual FoxPro ODBC driver.
- On Windows NT, from the Start menu, point to Settings, click Control Panel, and then double-click Regional Settings.
- From the drop-down list box, select Polish, and click to select the Set as system default check box.
- Click Apply. You will then be prompted for your Windows NT 4.0 CD. After the updated files have been copied, you will be prompted to restart your computer.
- After the restart, start Visual FoxPro.
- Run the following code from a program (.prg) file:
* Do some preparation first.
=SQLDISCONNECT(0)
CLEAR ALL
CLOSE DATABASE ALL
CLEAR
* Make database and table.
SET SAFETY OFF
CREATE DATA testdb
CREATE TABLE colltest (char1 c(7))
* Make database with Polish collating sequence.
SET COLLATE TO "Polish"
INDEX ON char1 TAG char1
FOR lni = 1 TO 2
cval = PADL(lni,7)
INSERT INTO colltest (char1) VALUES (cval)
ENDFOR
CLOS DATA ALL
* Create connection database and connection.
CREATE DATABASE conndbc
SET SAFETY ON
lcdir = SET("default") + CURDIR()
cConstr = "Driver={Microsoft Visual FoxPro Driver};"+ ;
"UID=;PWD=;SourceDB="+lcdir+ ;
"testdb.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=No;"+ ;
"Collate=Machine;Null=Yes;Deleted=Yes;"
CREATE CONNECTION conn1 CONNSTRING (cConstr)
* Connect.
lnh = SQLCONNECT("conn1")
?'Handle is ', lnh
* Try select.
?SQLEXEC(lnh ,'select * from colltest','cCursor')
=AERROR(atest)
LIST MEMO LIKE atest
=SQLDISCONNECT(lnh)
=SQLDISCONNECT(0)
- The SQLEXEC() call returns -1, indicating that it has failed.
- The contents of the error array created by the AERROR() function contain the following message:
Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Collating sequence 'POLISH' is not found.
The same behavior occurs if you select the
General collating sequence instead of
Polish.
If you use the above computer configuration and create a DSN using the Visual FoxPro ODBC driver, you will see the following items in the Collating sequence drop-down text box in the ODBC Visual FoxPro Setup dialog box:
- Czech
- Hungarian
- Machine
- Slovak
The correct list should be:
- Czech
- General
- Hungarian
- Machine
- Polish
- Slovak
You can create a cursor which contains the return the current collate sequence and codepage setting from the Visual FoxPro ODBC Driver by issuing a
SQLEXEC() call as follows:
?SQLEXEC(lnh ,'SELECT SET("collate"),CPCURRENT(),VERSION() '+ ;
'FROM <tablename> WHERE RECNO() = 1')
The table name must be substituted for
<tablename>. Note that the table must have supported collating sequences for the
SQLEXEC() call to succeed. You can use this code in the program above by changing the SET COLLATE command from "Polish" to "Machine", by using colltest for
<tablename>, and by substituting the
SQLEXEC() call above for the one in the program in step 5.
Possible affected collation sequences under various codepages include the following:
- General
- Iceland
- Nordan
- Polish
- Spanish
- Swefin
- Uniqwt
Others sequences may also be affected.