How do I take all the data in a database in range from 01-01-01 00:00:00 to 01-02-01 00:00:00 i have a column with dates+time in it, and i only need to take some data from a specific timerange Is it something like this:
Select * FROM table where Date = "01-01-01 00:00:00 " to "01-02-01 00:00:00"
In has to be in ASP.
Is there a way to import XML data into mySQL on a daily basis using some sort of automatted process?
View Replies View RelatedI use ASP to create reports by interacting with a mySQL database..
View Replies View RelatedI'm writing ASP/mysql apps, and I'm almost clueless about mysql. Can someone tell me how to insert data into fields using ASP? Code:
View Replies View RelatedCurrently i working on a project using ASP.net and mysql. these are the classes i imported:
<%import Namespace="System.Data" %>
<%import Namespace="MySql.Data.MySqlClient"%>
Sub Page_Load(sender As Object, e As EventArgs)
Dim myConnection As MySqlConnection
Dim myDataAdapter As MySqlDataAdapter
Dim myDataSet As DataSet
Dim strSQL As String
Dim iRecordCount As Integer
myConnection = New MySqlConnection("server=myserver; user id=XXX; password=XXXX; database=XXXX; pooling=false;")
when i try to test it out on my localhost, i got this error compiler page:
(warning BC40056: Namespace or type specified in the Imports 'MySql.Data.MySqlClient' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
or
Dim myConnection is not defined. ....
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me.
The scenario is as follows:
Windows 2000 SP3
MDAC 2.7 SP1
IIS5
MySQL 3.23
MyODBC 2.50
If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield")
If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k.
This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back.
The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield")
I have also tried putting the binary data into a variable first before inserting it into the stream:
set x=myrecordset("blobfield")
picturestream.write x
The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary.
The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak.
So the questions are:
1. Has anyone come across this before or fixed it?
2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile?
I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
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.?
I'm working with MySQL both locally and on a live server but empty text (memo) fields error out (Exception) when on PWS but not IIS. -Even if I'm just checking to see if there's a value (if rs("mytxtfield") <> "" then..)
Both are win2k boxes (Pro vs server) with the same drivers (3.51)
I've googled it, but no luck. Has anyone else run into this or is it just me?
I'm trying to connect to a MySql datbase, which is version 4.1.21. This is the connectionstring I am using: Code:
strConnectionhg = "driver={MySQL ODBC 3.51 Driver};server=67.159.10.***;uid=dan_anope;"
strConnectionhg = strConnectionhg & "pwd=******;database=dan_anope"
However, whenever i run this script, I get the error:
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
I've used the exact same script on MySQL 5, and it works perfectly. So what must I change to make it work on 4.1.21? it's not possible for me to upgrade the MySQL client.
I'm using PHP. So, i want exporting my Data to Word or Excel. However, PHP can't. And i must write one ASP page to do it. and ASP can connecting to mySQL ?
View Replies View Relatedasp is compatible with MySQL as a backend? Further can anyone also help provide me user groups for MySQL? Is PHP a better option than ASP?
View Replies View Relatedhow to connect to MySql Database using IASP .
View Replies View RelatedHow create site with webmatrix with MySql ?
View Replies View RelatedI am using mysql as my database and which to use a datetime field, for both displaying the data and time and using it to sort the recordsets.
And although when you look at the Db it shows the data and time like this
yyyy-mm-dd hh:mm:ss
however if you simply display the field it displays like this
mm/dd/yyyy hh:mm:ss am (or pm)
I want to sort the data out so that it displays dd/mm/yyyy and there is no time, i can do this but wanted to know if there is a better way of doing it
My problems being I first have to work out if the date is below 10 then us a split function according, then the same with the month, then i have to use a massive if statement, to get it to display in words, and then I have to us the queries before so i can split the year, even if i use to fields in the db to store time and date i would still have the same problems, what is the best way to do this, Plus i may have more than one record to do, will this make a big different in processing my page if i say have 20 records to do.
and just to make sure is the timedate field suitable to sort my record sets out.
I have been using Access and ASP for about one year. I'm getting verty comfortable with this now.
I want to pull some data out of a mySQL database for my ASP pages. It's the database for my PHBBB forum. I'm a bit overwhlemed on where to start. Boy is it difference.
I have made the DB connection and see the tables. As I said it's very different.
Any advice on getting started with mySQL so I can start getting some results?
I m using windows 2003 server, mysql and asp for my web site, I can select, insert, delete data from mysql, but I cannot update, this is the error that I get
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
and this is where the error is in the script:
objNotas.Open SQL, DBConn, 1, 3
I am looking for a way to use an ASP.NET button in order to start a backup of a MySql database..
View Replies View RelatedI am running some websites and would like to take a full backup of my websites every morning at 5 AM.
Because of my server permissions I need to make some kind of database dump (script I think?), that can be started by a cronjob.
Problem is, I'm a little stuck with this and can't find anything on google..
I'm as the topic notes, having some problems with recieveing decimal values from my database(MySQL). I'm pretty sure its a simple misstake, but since im pretty new to asp-syntaxes, I dont get it.
What I have is a table with a float(30,30) (yes, 30 decimals, its an experiment so I wanto "be safe"). I can take a variable, fill it with a jibberish numeric value say 1.111111111111 and write it in, works like a charm if I check the database manualy, however, I cant get it out!
Whenever I read from that database and into a value, I only get the first 5 decimals and the rest is left out, even if I display the database-value directly I cant get it to work!
If I do response.write MyResult("value") it still displays 1.11111 even if the actual value in the database is 1.1111111111->etc.
What could be wrong here?
If I do a little .....
how do i export a MYSQL table to an ACCESS table using ASP code.
View Replies View RelatedI'm coming to the conclusion it isn't possible, because I can't find any reference to it anywhere on the web after a good deal of searching. Let me explain my position, I'm writing an admin area which will access and update a large MySQL database. When the asp code runs the update (about once a week), there will be a high potential for things to go wrong, and as a precautionary measure I wanted to perform a database backup before it ran the database updates.
What I wanted to do was similar to the PHPMYADMIN "Export" function, but in ASP, and save the file on the server for me to download at a later date if needed. If I could create the file, I figured that I could save it to a directory with write priveledges on the server using FSO. The problem is actually creating a dump of the structure of all of the tables using an ASP script. I have no idea how PHPMYADMIN manages to do it, but I don't know any PHP whatsoever, and I would far prefer to make it work automatically through the admin area I am scripting in ASP. All the references I could find in the MySQL manual were to creating the backup using telnet access, which we don't have at my host for security reasons, so I wondered if anyone else had come accross this problem before and had a possible solution that could help me [], or whether anyone can say that it definitely is not possible.
is there anyone i can pay (that has time) to help redo
a few asp scripts that are present set to use a mysql database,
to use a ms sql database instead?I can give you a nice amount asp jobs if interested.
My database is being converted from Access to MySQL. My question is how do I maintain the database once the switch has taken place? Are there freeware MySQL administration GUI's or something? I'm a little clueless here.
View Replies View RelatedMy hosting account gives me a lot of MySQL databases but I usually just stick with MS SQL Server because it gives me fewer troubles.Now I want to challenge MySQL again. I use connString "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver; DATABASE=mybase; UID=myID;PASSWORD=myPwd; OPTION=3"
And the conn and recordset objects connects smoothly with the database. I can even get the things i want out of it. But every time I try to update the database such as:
rs("Content")="Cool"
rs.update
'or
names=array("Content")
values=("Cool")
rs.update names, values
It just wouldn't work...why? Content field is a text field.
I used to have a tutorial that showed you how to create an excel spreadsheet and them show you the asp that allowed you to upload it to a mysql database, now I will be dambed if I can find it or anything as good.
View Replies View Related