SQL Server To MySQL
is there a way to convert a SQLServer DB to MySQL, I want a duplicate of the SQLServer in MySQL. I did not find a free tool to do this, so I was wondering is there a way to do this by asp code?
View Complete Forum Thread with Replies
Related Forum Messages:
From PHP/MySQL To ASP/SQL Server Or Access
I have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet. The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life. Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
View Replies !
Access, SQL Server Or MySQL?
I've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly. My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
View Replies !
Can't Connect To MySQL Server
I recently got an error message from the Java release: j2rel.4.2_05 regarding c:program filesjavaj2rel.4.2_05injpiexp32.dll This message came in a .log file to my desktop, and since then, every once in a while I get this following error while trying access my pages in which I am creating. Code:
View Replies !
Asp.net Connecting To Mysql Database At Ftp Server
currently i m working on a web-based project using asp.net and mysql database. i using MySQL Connector/Net to connect my asp.net page to the to MySQL database server. My database is stored in the ftp server. In short, i m trying to connect my asp.net page to the ftp database server. Code:
View Replies !
Asp Connection To Godaddy Mysql Server Problems
I've got a UAPortal (asp freeware intranet) on a godaddy hosting package that comes with a free mysql database. I can't connect the asp site to the godaddy sql server. They give me the connection strings, but don't tell me where or how to use them! Support does no good, they tell me that is programming, get an expert. UAPortal comes with an Access database, so when installed it works fine, but its only Access. I want to use the mysql database which is faster, larger and more useful. I opened the Common.asp file and added the info from the connection strings, but now I get an error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MySQL][ODBC 3.51 Driver]Access denied for user: 'jwyss@winhostecn82.prod.mesa1.secureserver.net' (Using password: NO) /Common.asp, line 34 Does anyone know how to do this?
View Replies !
Database Connection String To MySQL-database On A Different Server
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!! Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies !
Use Mysql With VB6
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.
View Replies !
Mysql With ASP
Our 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.
View Replies !
VB And MySQL
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
View Replies !
MYSQL And ASP
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 !
MySQL With ASP
I 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:
View Replies !
ASP & Mysql
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 ?
View Replies !
ASP With MySQL
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:
View Replies !
Using MySQL
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.?
View Replies !
IIS Vs PWS W/ MySQL
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?
View Replies !
ASP And MySQL 4.1.21
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.
View Replies !
ASP And MySQL
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 !
Mysql
asp 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 !
Mysql And Datetime
I 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.
View Replies !
Getting Started With MySQL
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?
View Replies !
Asp-mysql Eror
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
View Replies !
ASP Mysql Backup
I 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..
View Replies !
Decimals From MySQL
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 .....
View Replies !
MySQL Backup
I'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.
View Replies !
Asp/mysql Scripts
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.
View Replies !
MySQL Conversion
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 !
MySQL Databases
My 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.
View Replies !
Excel Into Mysql
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 !
Page 2 - ASP + MySQL
I re-installed MySQL 4.1 since 5.0 wouldn't work together with MyODBC 3.51.. So now I'm back to square one.. Conn.Execute("SELECT * FROM pictures WHERE pid NOT IN (SELECT pic FROM votes WHERE uid = '" & strUserId & "')") Gave me syntax error..I also changed SELECT pic to SELECT pid, since thats the right fieldname.. I'm thinking that it might not be possible yet to make that kind of sub-call.. Is there a way to do it in some form of function?!? Basicly,what I want is that you'll always see a picture u never voted for before...
View Replies !
Mysql Timediff
i'm havin a pro which it can be done through mysql command editor. the problem occured when i put it in asp coding. sql = "Select timediff(now(),time2) from table" the displayed result is not what i want. it displayed the date of the day, not the difference of the time.
View Replies !
MySQL Settings
trying to connect to mySQL4...using.... set conn = server.createobject("adodb.connection") conn.open "driver=MySQL ODBC 3.51 Driver;database=kraken1" Set rs = Server.CreateObject("ADODB.RecordSet") SQL = "SELECT * FROM Access" rs.CursorType = adOpenKeyset Set rs = conn.Execute(SQL) And what i get is the error... "Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype." Is adOpenKeyset NOT the cursor to use????
View Replies !
Take Certain Data From Mysql
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.
View Replies !
Paging A MySQL
Is it possible to page a longtext field? I want to be able to input a tag to seperate pages and only call the section of the longtext field that's in between those tags. For example, when I post something I'd write a variable into the code like "age2:" and then when I call the field in sql it would display everything BEFORE the age2: variable on the first page and everything after it on the second page. Is it possible to do something like this? I was also considering only calling a certain ammount of characters in sql but I want to call entire paragraphs. Would I be able to call 1000 characters and include the entire paragraph, even if it's over 1000 characters?
View Replies !
Rs Updating With MySql
I used this code to add a record to table 'adItems' when I used access. once I added the record, I pulled the new id of it (just after it was created - bolded). Code: Set rs = Server.CreateObject("ADODB.Recordset") rs.open "select * from adItems",conn,3,3 rs.AddNew rs("catId") = catId rs("expiry") = expiry rs("adTitle") = adTitle rs.Update newid = rs("id") rs.close now, that I moved to MySql, newid remains blank. why is that? Any idea?
View Replies !
MS Access, MySql And ASP
According to �Beginning Active Server Pages 3.0� from Wrox, Data Source Names �are a largely outdated method of specifying connection details, mainly because they use ODBC drivers instead of OLE-DB providers to handle the data. We include them here only because you may come across DSNs when working with legacy systems.� Which is better: using ODBC with a mySql database or not using ODBC with this type of database? Also, based on the model below, how do you create a connection to a mySql database (using myODBC and not using myODBC)? Please note that I will be testing the database on my PC but it will also be used on a website. Code:
View Replies !
Connecting To Mysql From ASP
I am trying to connect to MySQL from ASP. Yes, i downloaded the mysql odbc driver and installed it. I have also set up the dsn correctly. connection is successful but queries are not being successfully executed. here goes the code:
View Replies !
ASP MySQL Connection
I've been messing with this for the past two days trying to get it to work. I know there's a lot missing, so if anyone would take the time to look the following code over, correct errors, add stuff where it needs to go, etc. I would absolutely be thrilled. All I am trying to do is allow a user to login, view pages only if they are logged in, and sign out. I'm not sure how to mix in the sessions and cookies with this. I've got a database "login" and a table "users" The username and password fields are "username" and "password" respectively. Code:
View Replies !
MySQL Backup With ASP
I need your help to take a backup through ASP script of a MySQL Database. The whole database need to be back up in a .sql file like backup.sql so that i can restore that through another script.
View Replies !
ASP > Mysql, Oracle
I am currently drawing up a sample server architecture for a windows environment, from ASP is there any limitation on which Database one can work with, ie are MYSQL and Oracle supported ...
View Replies !
MySQL, MyODBC & ASP
I have a Win2000 Server, IIS5 with MySQL 3.23.53 and MyODBC 2.50 If I have a table with DOUBLE 10,5 and a value of 4,69 and try to write it out with ASP, the ASP-page only shows 4, the decimals disappear. If I look at the value in MySQLFront it shows 4,69 Is this a bug in MyODBC
View Replies !
MySQL Request
I have an error "Unterminated string constant" in my SQL request.I guess my syntax is not correct mySQL1 = "SELECT * FROM viewTicket where ((TelRes = '" & NoTel & "') OR (TeleTra = '" & NoTel & "') OR (TeleCel = '" & NoTel & "') OR (NoClient = '" & NoTel & "')) AND ((ServiceName = 'MODEM') OR (ServiceName = 'UBR') OR (ServiceName LIKE '%BASE%')) " In other words, I fill a form where the variable NoTel is grabbing what was entered in the form.Then, it search for that value in the database in the fields TelRes,TeleTra, Telecel or NoClient.And, there is a second criteria that search in the field ServiceName for the value MODEM, UBR or *BASE* (whatever is in the field, as long as it find the word BASE).
View Replies !
|
TRACKER
