I am having problem regarding utf8 (used by MySQL) and utf16 (used by WinXP)
I want to store the CJK string into both MySQL and use the string to create a new file name. The problem here is,if the string is in utf8, MySQL can accept it, but the filename will have strange character.
If the string is in utf16 format, MySQL will store as '???', and the filename will be created correctly in WinXP. Code:
I am having problem regarding utf8 (used by MySQL) and utf16 (used by WinXP)
I want to store the CJK string into both MySQL and use the string to create a new file name. The problem here is，if the string is in utf8, MySQL can accept it, but the filename will have strange character.
If the string is in utf16 format, MySQL will store as '???', and the filename will be created correctly in WinXP.
I have attached my code. Notice that, If I set @CodePage=65001 'UTF-8'
WinXP/IIS will convert all the UTF8 string in the asp file to UTF16 for internal processing. MySQL can only accept utf8 for client connection, so aftｅｒ UTF16 converted to UTF8, ??? will appear. Code:
Trying to send mail with ASp and CDO, but my local (croatian) characters are
completely left out from the message! It's not like some strange chars are
shown, but nothing. like they are ignored.
The ASP page has <%@language="vbscript" codepage="65001"%>.
What parameters of the CDO object do I have to set to get my mails show all
the chars of subject and body in 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?
View Replies View RelatedI have an oracle database where I store my html files on. While uploading I call the server.HTMLencode function to encode the blog but that's not enough. Once that is called I would like to encode the rest of the text through UTF8. Is there a predefined function that I can use to do this?
View Replies View RelatedIt appears that after installing SP2 for WinXP, previous configurations are changed. to be more specific, it seems that the redirect function no longer apply. That is, before installing SP2 a certain function worked proparly, but now, I guess for some security reasons, it does not any more, IIS is refusing to go out of its localhost loop
View Replies View RelatedI found a really good ASP.NET tutorial and thought that I would try to learn some ASP.NET.
I spent ages trying to find IIS or PWS on my computer but i cant. I was then told that as i have WinXP Home i cant run either of these on my computer.
Does anyone know why this is or how i can get around this, cos i would like to learn ASP.NET.
for some reason, when i run my website through my browser as a local host (IIS) to test the asp, the asp works but the javascript doesnt, when i run the website through the browser normally, obviously the asp doesnt work but the javascript does!!!!
is there a reason for this?? is it a problem if i when live with it??
or is this just what happens???
I have an ASP 2.0 Web site I'm building and I'm adding Atlas to one of the pages. I've created a simple Web Service as a separate project and compiled it. The Web Service has a class to connect to our SQL Server to get data. The service takes two strings and an array of SQL Parameters. I have added the Web Service reference to my Web site app in the App_WebReferences folder.
when I create an instance of the Web Service it attaches the local namespace of the Web Service to the SQLParameter type and gives me an error like: "Value of type '1-dimensional array of System.Data.SQLClient.SqlLParameter' can not be converted to '1-dimensional array oflocalhost.SqlParameter'.because 'System.Data.SqlClient.SqlParameter' is not derived from 'localhost.SqlParameter'.Why is it doing that?
I have created a Membership Directory that is sorted alphabetically using ASP/VBS/Access (although the access was converted to mysql before loading to remote server). It runs perfectly on my local server, but I cannot run when loaded to remote server.
Tech support for webhost sent me a "test.asp" w/working connection string, but putting it into the connection include file causes an "empty connection string" error in my asp doc. I don't know how to clear up the conflict. Code:
I want to install IIS 5.1 on my WindowsXP machine. I do not have my WinXP CD. Does anyone know where I can download the necessary software to complete this installation?
Also, I would like to update a webpage that is built with either asp or asp.net. (I did not make this webpage, and am new to both asp and .net) Is there a simple way to find out which was used to create this website?
Can I use a WinXP Pro SP2 504MB of RAM as a server to host an ASP Application that would be allowed about a thousand people around the world to access to it?
How about WinNT 4.0 server? Can it handle that much people? Which one is better?
Probably way off the mark here, but I have IIS running on my WinXP machine
and I thought I could host multiple domains over the old Win98 method where
I could only have the one?
All I can see at the moment is that I have a Default Web Site, which is
associated to MyPC, and all I can create is virtual directories/folders
within this default location. This means that instead of me being able to
create the desired effect of: Code:
I have some problems with my IIS
1. If I execute a script sometimes I got a "server busy" error from IIS, but there's only me accessing the site in my pc (localhost)!
2. Sometimes after execute a script that connect with msaccess db the protect file *.ldb don't desapear, for a long time, how can I remove without restart windows?
I have coded an application on an XP Platform with a Microsoft Access backend.
1. On my development system I have successfully ran the application using Internet Explorer where I type: http://localhost/sad.
2. The customer wants this application to be self contained and working off a CD. So, I burned the application on a CD, created a virtual directory and in IE typed: http://dhurtu/testapp/sad and again no problem worked beautifully.
3. I took the CD, went to my IBM laptop it is configured the same way as my development machine. Again it worked flawlessly.
4. I went on machine similar to the customer's configured with Windows 2000 Professional and IIS 5.0. We created a virtual directory, put in the CD and the application worked beautifully.
5. At the customer site I wasn't so lucky! I put the CD in, created the virtual directory. Fired up Internet Explorer got the greeting screen, made a search and from the search made a selection to get further details ... AND CRASH ... ADODB.Recordset ......
My question is simple. Why would this application work on three different machine and then fail on another.
Customer machine runs Microsoft Windows 2000 (5.00.2195) Service Pack 4. IIS was not installed when I first got there and therefore I installed it. The install CD was not of SP4 vintage but of year 2000 vintage. It seems to me that the IIS version on the client machine is 5.0. Code:
i got this error message
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/searchresults.asp, line 21
from the code in my site
Code:
I have an simple ASP form and I am using the following statement to get the
values:
emailFrom = Request.Form.Item("ctrl:EmailFrom")
emailTo = Request.Form.Item("ctrl:EmailTo")
However, after I added attribute ENCTYPE="multipart/form-data" to the HTML
tag <Form> for uploading files (not implemented yet). The above code doesn't
work and the value of Request.Form.Item("...") become "Undefined".
How to solve the problem?
Has anyone succesfuly sent emails from Windows XP using localhost and if so can you please post a functional code?
My codes work fine on Win2000, but after upgrading to XP, I get all kinds of errors. When I correct the first one, another one creeps up. The latest am now getting is "send using ..... is invalid'
I know I can solve this peoblem by registering CDONTS. DLL on my XP box, BUT I want to use CDOSYS and not CDONTS. CDONTS is being phased out. Code:
I have the following codes working fine on one PC running Win2000 Server, but fails on another PC running WinXP. When I check the system log, it tells me the problem is on line 8, that is :-
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:DevelopmentFamilyTestingElouiseAccess oryProductList.mdb;"
Is there any difference between Win2000 Server and WinXP? Code:
I have created a login page for my website but I am trying to add some code to the page so that once a user has voted they can't keep on voting. Code: ...........
View Replies View RelatedIam using a filter in asp and it doesn't work with the wildcard '_' or even using IN it only works with LIKE '% (anydata) %'. In my table i have a column, which stores values as 1,23,40 etc. How do i get it to bring back all rows where X='1' and not X LIke '%1%'
I get the following error message:
'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.'
Some people are using WinXP and Win2000 for servers and are having problems with CDONTS, so im gonna post a little code sample on sending emails with CDOSYS because it works better for WinXP and Win2000 and is also a better email compenent. Code:
View Replies View RelatedI am using WinXP Pro and IIS. For some reason, I can not get any ASP pages to work. All I get is this error below. I have even removed all sites on the server, but I still get the error. Html pages work just fine. All permissions are in order. How do I fix this? When I view same pages on Win2000 machine, they work fine
Active Server Pages error 'ASP 0134'
Invalid ProgID attribute
//global.asa, line 1
The object has an invalid ProgID of 'MSWC.MyInfo'.
My OS is XP Pro
I'm trying to connect a dbase but an error appear. This is the error type:
"ADODB.Recordset(0x800A0BB9) arguments are of the wrong type are out of acceptable range or are in conflict"
I used the code for example:
rs.Open "SELECT * FROM table1", db, adOpenStatic, adLockPessimistic
The microsoft ASP documentation says that adOpenStatic, adLockPessimistic, equals to 3,3 notation. I used first the code above then the error appears. But when I change it to 3,3 it runs ok.
I am trying to connect to a Mysql database in the following manner:
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=myserver;PORT=3306;DATABASE=mydatabase; USER=myusername;PASSWORD=mypassword;OPTION=3;"
however I am getting an error:
visual basic run-time error microsoft [odbc driver manager] data source name not found and no default driver specified.
How do you add data to the tables from asp website using C# (for mysql)
View Replies View RelatedOur website is currently developed in ASP/Mysql 4.
The dedicated servers on which it is currently hosted arrive at saturation.
Here is their configuration:
- 1 server PIV 2,8Ghz 1GB RAM with IIS 5 on Windows 2000
- 1 server Bi-xeon 3Ghz, 512 MB with MySQL 4 on Windows 2003
The website makes approximately 10.000.000 of pages seen and 310.000
visits each month (given by an external statistics tool), increasing by
10% each month.
The database is approximately 60 MB.
I made, I think, most of the optimizations on the database (cache,
indexes...).
According to our current web hoster, this saturation is due to a bad
management of connections between ASP and MySQL and recommends to us:
1/ to put the site on Windows 2003/IIS 6.
2/ to change our database from MySQL to SQL Server.
3/ to change our PIV to a second Bi-xeon.
er...i dont know if this belongs in here, so apologies if it shouldnt...
Im working on a programme in VB6 that allows people to add news to my site. I was just wondering how can you connect to MySQL with VB and how can you add records
i need to compare against the database if the user input the correct username and password otherwise to send the user to another page.. but still lets sign in even if the username and password does not match.. here's an example of my code:
View Replies View RelatedI was having trouble with access because it was far too slow and the site kept crashing as too many people were accessing the database at the same time (servers errors because of the lock file kept cropping up).
So, I converted the Access Database to mySQL, used the connection string:
Conn.Open "DRIVER={MySQL ODBC 3.51 Driver};database=dhsweb;server=localhost;uid=root;password=chadwick;option=3;"
And it connects ok. However, I get the following error on the main page: Code:
How can i make ASP read a table and view its content from mysql ?
any xamples or a site i can refer to ?
1 more thing .. how to view the Database entries as URL or Links ?
I am trying to create a website in ASP with a database back-end.
I am ok when using MS Access, but I have recently read articles saying that Access is no good for dealing with multiple users accessing it at the same time, so I am worried that it will not be able to cope.
As an alternative, I am looking at MySQL.
I am completely new to MySQL, and even installing it seemed complex. I have installed it to the directory C:mysql, and using 'mysql front' I have managed to create a database with a few tables.The database is in the 'data' subdirectory along with the mysql database. Code:
I have a not so now small application where I am using an Access database as the backend and ASP. Since the size of the database and the complexity of the app are growing I am looking for a "stronger" database.
I have checked MSSQL but can't afford it, that's why I am thinking to use MySQL instead. Do you have any experience using classic ASP and MySQL, comments, etc.?