Error '80040e14' when using non english characters in column n

This topic is locked

Error '80040e14' when using non english characters in column n	2/6/2008 7:25:15 AM
ASPRunnerPro General questions
M mkrle author Hello, I am trying to work with a database with non english letters in column names. I could not get past the "Edit SQL query" screen until i changed regional settings for non-unicode programs in windows XP to Serbian(Latin). With that i could complete the wizard, build the pages and then I get the following: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'MatiÃ¨ni broj'. /apr/privredna_drustva/Finansijski_izvestaji_list.asp, line 596 It's clearly because of incorrect column name which is in fact 'Matični broj' not 'MatiÃ¨ni broj' as the error message suggests. Could this be an IIS/ASP related problem?


	Sergey Kornilov admin 2/6/2008
	According to this error message ODBC driver for SQL Server is having problem with non-English characters in field names. I recommend to use English characters only in field names.