ASP+IIS4+MSSQL: Unicode Problem
I need to make an ASP page which needs to insert and display multilingual contents like Korean, Chinese, Japanese from a MSSQL DB.
After googling, I know that by the using server-side directive
"Session.Codepage=65001" and charset UTF-8 in HTML,I can do it in IIS 5.0.
But IIS 4.0 seems doesnt support this Codepage.
Is there any solution for IIS 4.0?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
IIS4 TO IIS6 APP.
I migrated a VID6 application from Windows NT 4 to Windows 2003 Server (IIS4 to IIS6) which was developed using ASP and VBScript and I now I am getting an error message as follows: Microsoft OLE DB Provider for Visual FoxPro error '80004005' There is not enough memory to complete this operation. /hinojosa-web/iPD2.asp, line 377 The line mentioned above refers to the execution of a query to generate a recordset which will be displayed to the user who is requesting data. This issue does not always happens, it does only after accesing the web site several times.
Inconsistent Cookie Issue - IIS4
I'm having an inconsistent problem involving cookies. I have attempted to duplicate the OS/browser settings for the remote users in question but I cannot seem to duplicate the problem in any OS (Mac, Linux, Windows). I've gone over and visited one problem site and I couldn't get it to work by playing with security and privacy settings in MSIE. Obviously there is a setting somewhere but I can't find it. I can duplicate the problem by commenting out the ASP code that sets a particular cookie. I also didn't see the cookie get set on the problem system when I was trouble-shooting. I can't have the problem system with me when I code though. :( I won't post the entire project, but here are the parts that seem to be central to the problem... <% Response.Expires=-1 Response.AddHeader "Pragma", "no-cache" response.cookies("epeid") = value '40 characters response.cookies("epeid").Expires = dateadd("n", 7, date() & " " & Time()) response.redirect redirectURL %> It works fine on my systems. It redirects on the problem systems, only they act like the cookie doesn't exist. When I asked the computer to prompt me for each cookie I never saw epeid. On my system when I ask for a prompt it just stalls on that particular cookie. The above code is executed before any headers are written.
Error When Migrating From IIS4 To IIS5
Let me first apologize for anything that makes me sound stupid. I'm really not a ASP programmer, but i am the one fixing our glitch. First, let me explain whats going on. We have a company intranet signout board. And under our IIS4 server, it works just fine, but under IIS 5 its works except for one glitch. The board lets the user choose their name from a databse, and enter a date and time of leaving a arriving. On the old server, if the user just entered a time, it automatically added the current date followed by the time. Now, if the user just enters a time, that all that is displayed, and for some reason the board will only allow one name to be displayed like that. So if person A signs out with just a time, he is listed, until person B signsout and overwrites person A I think i have narrowed the problem down to this If FormatDateTime(Request("txtReturn" & intIndividualPerson),2) <> "12/30/99" Then rsUDPerson("OutReturning") = Request("txtReturn" & intIndividualPerson) Else rsUDPerson("OutReturning") = Date & " " & Request("txtReturn" & intIndividualPerson) End If The idea is, if there is a date, it wil be different then 12/30/99 so nothing is changed, but if no date if there it adds the current one. It almost acts like there is no Else statement.
IIS4 Application Variable Removal
Any way to do this from asp page in IIS4? Application.Contents.Remove is IIS 5+. Setting variable to empty string does not remove variable.
APS3 / IIS4 Session Wont Persist
Having trouble getting Session to persist. Have checked properties of the Virtual Directory in IIS4 manager and "Enable Session State" is checked, with time out set to 20 Mins. Have also checked the Project Properties in Interdev 6.0 and confirmed that "Sensionless ASP Pages" is NOT checked. When moving from one page to another within the application it starts a new session for each page : I've confirmed this both by Writing the SessionID and by adding a Variable into the On_Start of the Global.asa. Only trying to store a single digit in a Session variable.
Unicode
I have an ASP page that I want to support multiple languages. If I set the <%@ Language=VBScript CodePage=65001%> and adds a <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> meta tag it seems to work OK. Now instead of setting the codepage in every page I tried adding a global.asa (Session_onStart) file and add session.codepage=65001 and also tried to add response.charset="utf-8" (I was not allowed to set <%@ Language=VBScript CodePage=65001%> inside global.asa). This does not seems to work though. Is it possible to set a codepage in some event in a global.asa to make it global for the entire application? Is it possible to add a directive in global.asa that works like setting a <meta http-equiv="Content-Type" content="text/html; charset=utf-8">. If this is possible I don't have to recomplie my business logic that creates the html.
Unicode In Asp
the text coming from the database seems to be ok but I have a problem with the static text. I have this in asp files but I cannot save them as Unicode because the ASP engine does not support it - the error is as follows: "Active Server Pages, ASP 0239 (0x80004005) UNICODE ASP files are not supported." The Microsoft site says not to save files as Unicode ASP - which is not very useful to me. How can one have multilingual static text in websites?
ASP And Unicode
I am having trouble displaying unicode characters on the browser.I am storing unicode data (Japanese, Chinese and Korean)in the native format. I have an ASP page that runs a query to get this data and display it on my webpage. But, the output comes as junk. Any solutions for that.It is interesting for me that if i run the same query in Enterprise Manager, i get the correct data whereas running it in the Query Analyzer gives me junk.
Unicode
I have a data base (SQLServer2K) with unicode fields and in my query analyzer, I am able to correctly insert Russian, Chinese characters & Co without problem and to read them with the query analyser (N powered). The problem is that I am not able to read them in an ASP page (I work in the mode Utf-8 because I must post Chinese, Russian & Co on the same page) from sql server : I've got "??????" on my page ASP. if I want to insert Russian data for example from my ASP page. I do not have the same value in the field of my base whereas if I use the query analyzer and that I make a copy paste, it goes. On the other hand datas inserting by my asp page and read since my page ASP page are well displayed.
Mssql
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one. I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it. I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page). The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
ASP And MSSQL
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
OpenTextFile And Unicode
I'm trying to write a .txt file with OpenTextFile method. This is working alright, but since I'm using some danish characters and use Flash to read the txt file I need to save the file as UTF-8 or Unicode. Beneath is my code - how do I save the file as UTF-8 or Unicode? ---- Dim fso, f, filespec Set fso = CreateObject("Scripting.FileSystemObject") filespec = Server.Mappath("news.txt") Set f = fso.OpenTextFile(filespec,2, True) f.Write txtstring f.Close ----
Unicode Display
I use MSSQL2000 with nvarchar to store foreign language e.g. Simplified Chinese or Japanese and thse records can be well displayed via Query Analyzer. Now, using asp to select record and display. It found that the code can be in "code". I put "<meta http-equiv="content-type" content="text/html; charset="utf-8">" in the page. but fail too. I also tried to change "decode" via IE with different code but fail. I guess the problem that the unicode content is extracted from database but wrongly decoded in page so the code is modified. How to force the displayed code from database to webpage is in Utf-8?
Saving Unicode In SQL Using ASP
I have an asp application that should allow the user to enter Unicode characters. The characters appear correctly in the browser. When saved in sql 2000 thought they are converted to question marks etc. When I enter the characters directly in SQL (using enterprise manager), they appear correctly in sql as well as in the browser when the asp page retrieves them. As soon as I hit save they get overwritten in sql incorrectly.
Unicode Problem !!
I tried to copy some hebrew arial text from word to my file , Dreamweaver shows a note that the page should be converted to unicode UTF-8 ,i did so ....but the the page is unreadable font ... HOw to deal with non english font ???
UTF8>UNICODE
My ASP pages uses UTF-8 encoding. How to convert UTF-8 text from Request.Form("text") to UNICODE for searching frm MSSQL Database?
Unicode Data
My unicode data ( stored in an ncharvar field ) show differently ( like question marks ) on the asp page when restoring on another server could any one help me with this
L Unicode Compression
Can anyone give me an example of how to set a field's unicode compression attribute using ASP because I've tried and tried and I always get a database error in my SQL statement even when I copy the SQL code directly from MSDN.
Unicode Through IE Or Netscape
I have a web application designed to allow non-english characters to be entered in through a form, held in Access and displayed on another page.Each of my pages have the following meta tag: <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> My problem is this: if I go to the data entry page and enter Unicode text in Netscape, the text displays ok -- in Netscape, not in IE. Conversely, when I enter Unicode text in IE, the text displays ok -- in IE, not in Netscape.I have been testing it by copying and pasting text from the Unicode.org page such as this one for Arabic: http://unicode.org/standard/translations/arabic.html why Unicode is being treated differently here?
Unicode From Mysql
I am writing a module for a cms system, the backend has been created in asp.net, however the frontend of the module has to be created in asp. The mysql database table has the collation utf8_unicode_ci, the backend is connecting with the using MySql.Data.MySqlClient and this works fine. However I could not find the equivalent of this for asp and have been forced to use odbc this causes any two byte unicode characters to be shown as ? characters on the frontend ....
Comparing Unicode Value
Need to do a search engine to search through a bunch of static pages (html)). so uing asp. but the page is in chinese, so how do i scan each and every html file and search for the chinese word?
Unicode VB Code
I need to read Chinese text from Access and use response.write to display on a web page. However some characters are not correctly displayed, they are displayed as ?. After some rearch, this problem can only be solved UNLESS the Chinese text are written as unicode codes. e.g. response.write("<p>壮Ф</p>"). I have tried StrConv function but I always got syntax error.how to?
Unicode Issue
I am submitting a form to IIS 5.0, the CODEPAGE is set to 1252 and the charset is 'iso-8859-1'. I noticed that if I type information in a language different from English I get data from the Request.Form collection in the following Unicode format: 'stגד', i.e English characters unchanged and other characters coded as Unicode characters. If I change the charset to the one that matches the language in which I am typing (without changing the CODEPAGE) I get the data in the local character codepage code. Is it possible to get the data from the Request.Form collection in a consistent format, independent of the CODEPAGE and charset settings, i.e. always in the 'גד' format?
ASP (Javascript) And MSSQL XML
I was wondering if anyone could give me some pointers as to using ASP (Javascript, not VB) to get XML out of SQL. I have my storedProc with the FOR XML AUTO on the end, and that is returning a recordset with XML fine in query analyzer. I am lost as to how to output this as XML from an ASP page so I can transform it with XSL. My transform would be something like: Code:
Stable ASP/MSSQL CMS Out There
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.
ASP/MSSQL Version
I am currently learning ASP but have a small PHP background, With PHP I used PHPMYADMIN to work with MYSQL Is there a web based Alternative for ASP and MSSQL that provides similair functionality?
ASP/VERY COMPLEX MSSQL
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code: strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC" now I have 2 things going on here... 1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records) 2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
Update Mssql Using Csv Or Xml
Can't seem to find anything relating so forgive me if i've missed it. I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable? Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both
Connecting To MSSQL Db From Web
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it. the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view. so to connect to it, what all do i need to do?
Access Vs. MSSQL In ASP
I'm just deciding whether to use Access or MS-SQL for a web-application I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make ...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
Stored In MSSQL
I am new to programming and I managed to store images in MSSQL. The problem I have is that when I retrieve the image from the database and display it in my browser it opens a new window. I would like to use the image control, but it requires a url. Is there anyway of viewing that image in the image control or keeping it in the same page where my information is but displaying it where and when I want it
Can Run MSSQL DB In Linux
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform. But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?
Connect To MSSQL
I had used ASP about a year ago, I had connected to a *.MDB database but not MSSQL,can someone please throw me the just of it
MSSQL Connection
I am using a Windows 2000 Server and when i tried creating a simple asp application this error always appear everytime I access the database. Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'MYSERVERIUSR_MYSERVER'. /o/faculty_evaluation/add_dean_db.asp, line 22 what kind of error is this? is there something wrong with my connection string -> conn.Open "Provider=sqloledb;Data Source=MYSERVER;Initial Catalog=dog_evaluation;Integrated Security=SSPI;"
Connect To Mssql
any one have the connection string and included query on how to connect to the mssql server?
ASP Connection To MSSQL
If I create an ASP page, what do I need or how do I connect to a MSSQL database. And, is it possible to connect to a MySQL with ASP, or is it better to use MSSQL when developing a ASP page?
ASP/MSSQL To ASP/MySql
I am planning to convert an ASP/MS SQL based site into ASP/MySQL to save on monthly recurring fees. MSSQL costs additional $40 a month while MySQL is free. Are there any major technical issues?
Send An Unicode (UTF-8) Mail
How can i send an Unicode mail with ASPclassic? I want to send an email in Farsi ( or same Persian ) I use this code but this is ...
How To Get Unicode Characters To Work In URL?
I have the following reference to an image in my web page. The name of the image is simply one Chinese character followed by .jpg. <a HREF="transfer/rad0/﨨.jpg" TARGET="_blank">﨨.jpg</a> The Chinese character is HTML encoded. I'm specifically setting UTF8 encoding w/codepage 65001 in each web page. When I right click this URL and attempt to download the image to disk, I get an error saying the web server can't locate the URL. In the error message, the Chinese character is displayed as ? (question mark). It works if the URL has only ASCII characters in it. What do I need to do to be able to download images via URLs that contain Chinese (Unicode) characters?
Unicode Character Problem
I am having a problem with a forms entry using Unicode characters, specifically "smart-quotes". Under Microsoft PWS and MS-SQL 7.0 it works fine and I get the Unicode characters, such as smart-quotes, being written and read form the database. However, if I use the same code using Apache, Linux and SunONE ASP the Unicode characters don't work! Code:
Inserting Unicode Characters
I'm using ASP, VBScript and SQL Server. I'm also using UTF-8 character set and so my codepage is 65001 and SQL Server datatype nvarchar. I can insert unicode characters correctly into the database table using INSERT.... (field1) ...VALUES ......... (N'Characters'). How do I do this using Rs.Update viz-a-viz: Rs.Open ....... Rs.New Rs("Field1") = "Characters" Rs.Update
PUT Data Into A UNICODE File
I have to "PUT" data to a Unicode file... a file that has the "FF FE" mark at the beginning of the file. How do i do that. What HTTP header do i need to send so that the data is stored in the Unicode file. Right now when i "PUT" the data it sores it in a regular file. Code:
Converting Unicode To Character
How do you convert Unicode into a character? The first two examples result in a syntax error. The third example prints out the characters in the string. ASPACE = Chr(u00A0) ASPACE = ChrW(u00A0) ASPACE = "u00A0" I do realize ASPACE = Chr(160) works but I’d also like to be able to work with Unicode.
Retrieving Unicode Fonts
I'm trying to read data from an Access database and want the columns to be displayed according to the alphabet. Now I'm trying the Like statement and passing the unicode value of the alphabet through the query but it retuns no value. An example is given below: SELECT DISTINCT HindiWord FROM Database1 WHERE HindiWord LIKE 'अ%' Here I'm trying to retrieve all the words with "A" alphabet in Devanagri script. The HindiWord has data in a unicode font. However this is not working. I dont know if there is any other way in which I could filter when retrieving.
Unicode Strings From DLL To Display
I have a few sets of unicode strings I am trying to display. I can display session variables with unicode strings from a XML file, but I can't display a unicode string coming from a DLL. If I save the failing unicode string in a unicode file, I can view it fine,and the browser selects the encoding. The encoding it selects is unicode and not unicode (UTF-8).
Download Unicode Filename
IIS 6.0 ftp will replace unicode filename with '^'. If i have two unicode filename on the server, both will display as ^.txt, which after download to my local drive, it will overwrite one another. I have no control over the filename my visitors use.
|
TRACKER
