Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: National Language Support reading Access database?


Message #1 by Andrey Chirvonets <acdelo@m...> on Sun, 16 Mar 2003 01:09:36 +0200
I'd developed some asp-pages that reads data from Acces'97 database.
All works well, but when I copied asp-files and database to hosting serve
r
all national characters (Cyrillic) converted incorrectly

For example:
"Anec Au ala ka easaccnnscsiaaku, lsi?ncna Lsaacea c ealiekcna Akzano"
instead of:
"=C5=F1=EB=E8 =C2=FB =E5=F9=E5 =ED=E5 =E7=E0=F0=E5=E3=E8=F1=F2=F0=E8=F0=EE
=E2=E0=ED=FB, =EF=F0=EE=F7=F2=E8=F2=E5 =CF=F0=E0=E2=E8=EB=E0 =E8 =E7=E0=EF
=EE=EB=ED=E8=F2=E5 =C0=ED=EA=E5=F2=F3"

but it is not browser problem, I got the same wrong characters when I
open page in Source View mode.

I got that something differ with Default Locale.
I set tried to use
    Session.CodePage=3D1251
but this didn't worked out

when I appened
    <%@  CODEPAGE =3D 1251%>
to my asp-script hardcoded russian text became normal,
but all datas I read from Access ('97) database  using ADO are still
looks invalid
the following code is used to connect to database:

     Set conn =3D Server.CreateObject("ADODB.Connection")
     conn.Provider =3D "Microsoft.Jet.OLEDB.4.0; Data
Source=3DC:\users\!webs\web174\Data\BO.mdb"
     conn.Open

setting   conn.Properties("Locale Identifier")=3D1049 (instead of 1062  -

that was default at hosting server)
also didn't help

the structure of my asp-pages is
---- set code pade used to write asp-script
<%@ CODEPAGE =3D 1251%>
---- buffering is on
<%Response.Buffer =3D True%>
----- include some libraries with functions to read datas from database; 

there is also some #include in first onr included
    <!-- #include virtual=3D/ListLv/Actions/Routine/register.asp -->
    <!-- #include virtual=3D/ListLv/Actions/ASP_LIB/reports.asp -->
    <!-- #include virtual=3D/ListLv/Actions/ASP_LIB/events.asp -->
    <!-- #include virtual=3D/ListLv/Actions/Advanced/dbscript.asp -->

----- code to process request
<%
Dim nEvent, sFormRequested, sNavigator
sNavigator=3DRegist_Request() 'regists page request in database
=2E.....
=2E. some code here
=2E.....
%>
---- now formatting output
<HTML>
<%
Call Gen_PageHeader("Primary", sTitle)
Response.Write "<BODY " & Get_PageStyle(DBLookUp("Style", "i_Pages",
"Name=3D'" & sFormRequested & "'")) & ">"

----- call function to generate output with data from database
Call GenForm(sFormRequested, sFilter, "")
%>
</BODY>
</HTML>
<%
Response.End  
%>

Once more:  everything is OK on my local PC with WIN2k-Pro 
but it works incorrectly on my hoster server




Message #2 by Andrey Chirvonets <acdelo@m...> on Sun, 16 Mar 2003 01:43:56 +0200
Some additional info

Default code page used at hosting server  IIS is 1257 (at my PC - 1251)
that is why I used
<%@  CODEPAGE = 1251%>


  Return to Index