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 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 !
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 !
ACCESS To MySQL
I have my site hosted with uplinkearth.com which supports MySQL; they say: "We have set up your MySQL database for you." (i.e. it is ready for me to work on it). My site is a classifieds page that is small(not much code at all) but gets a lot of traffic and I want to switch from Access to MySQL. I know that some conventions are different, but on a more general note, what is the process of conversion? I have someone who will be working with the ASP code, I just need to know the basic procedure, i.e. how do I make changes to my database, etc. How will it be different than working with Access? I've heard "MySQL Front" is a good program to edit the DB.
View Replies !
Access To MySql Using .asp
Not that much experience working with .asp, but I have managed to create a project. This project currently has a DB in Access. I'm moving it over to MySql. Was able to ODBC import it and all data seems gtg. Uploaded a test folder, and modified my connection so I can test the MySQL database before I change over. Code:
View Replies !
Mysql Vs Access
other then the connection string are there any diffrences when using mysql and not access? i know mysql has more powerful tools but will the querying and searching and updating be the same syntax in asp?
View Replies !
Access MySQL
I don't hv access to install ODBC drivers on the server so trying to use SqlConnection to connect to MySQL but so far no luck. Been trying: SqlConnection conn = new SqlConnection( "Data Source=(66.79.180.140);Database =testdb;User ID=test;Password=testing"); conn.Open(); And it fails on the conn.Open() call with the exception: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
View Replies !
Convert Access To MySql
Not that much experience working with .asp, but I have managed to create a project. This project currently has a DB in Access. I'm moving it over to MySql. Was able to ODBC import it and all data seems gtg. Uploaded a test folder, and modified my connection so I can test the MySQL database before I change over. I try running the pages, and have been making changes to the code as I see errors come up. All was moving forward until now.. where I just keep getting 500 errors, and can't get it to tell me what's wrong. I use Option Explicit, and all my variables are posted. Is there any other code I can put into my pages so that it will not just generate a 500 message when there is something wrong? Or any Software programs I can get which will help me troubleshoot my code for MySQL?
View Replies !
Query / MySQL / Access
I've got a query that works fine when used in mySQL but completely fails when I try to apply it to MS Access, weird thing is that it is just a copy of a stored procedure that works fine in the same copy (with the Request.QueryString replaced by a fixed value) ! Any explaination would be great, ID is a number BTW : SELECT page_title,ID,page_content FROM content WHERE ID='" & Request.QueryString("ID") & "' ' Had a look at aspfaq.com but couldn't find anything that applys.
View Replies !
MySQL And Access Database Link
Is it possible to call fields from a MySQL Database and an Access Database on the same asp web page? If so, can someone please point me in the direction of a good guide/article/post on how to do this.
View Replies !
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 Replies !
Convertind Asp From Access Db To MYSQL Db Scripting Issues
im converting my access db to a mysql db. having issues reading int (true/false) values out of the mysql db. this is a snippet of the asp script Code: If rslogin("Master_account") = True Then Response.Write("master_account=true") else Response.Write("master_account=false") in the access db the master account field was a true/false ( yes/no) field. in mysql its an int filed with a value of 0 or 1. Code:
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 !
SQL Server Vs. Access
I have an Access DB connected to an IIS via ODBC, and use ASP pages to get info to/from the DB. My guys in IT now want to migrate the Access DB to SQL Server. Can anybody tell me what this implies in terms of : a) syntax of my ASP pages b) syntax of my SQL statements c) other problems I may not have thought of. I am told it is really easy, however, I just cannot get is to work. BTW, I have activated the "SQL Syntax" option in Access, in case that helps any.
View Replies !
ASP & ACCESS/SQL Server
This might be more of a database question than ASP. But when you create a database and then create relationships with the database, once you open an asp page say to create a new record; once the record is saved, shouldn't it also update the relationship with the table involved? Unless I am doing something wrong, it is not updating the second table; for example: rs.AddNew rs("username") = Request.Form("txtUserName") rs("password") = Request.Form("txtPassword") rs("firstname") = Request.Form("txtFirstName") rs("lastname") = Request.Form("txtLastName") rs("email") = Request.Form("txtEmail") rs.Update Response.Write("Record has been added!") Say the information is entered, because of the UserID field is "autonumber", that would be my primary key: so "1" would be related with the second table where I have: upload.id (PK) userID Upload1 date1 Upload2 date2 Upload3 date3 If on the other table I have number of uploads to generate, whenever it adds a document, it would have the relationship of the username, and the upload: But when I do that, even adding the code, it does not update the code. So what am I doing wrong? Do I have to do another Add.New at the same time for the second table?
View Replies !
Access MS SQL Server
I ask this here because as ASP Developers I figure you have more experience with windows Webhosts. I know Phpmyadmin is usually provided on Apache platforms to manipulate MySQL databases. What interface is usually provided by webhost to access and manipulate your Microsoft SQL databases?
View Replies !
Export Access To SQL Server
I have a database in MS Access and have one table in it (tblcontest) which has 30 fields in it, I want to export all the fields into Sql Server 2000, any idea how to? PS: I dnt wanna create all the fields manually one by one in SQL Server.
View Replies !
FSO Remote Server Access
Wish I'd found the thread yesterday before spending half the day fighting the same battle and finding a workaround. But at least it explains why my final approach worked.I set the remote folder as a virtual folder on the webserver, assigned web rights to a domain user and used fso.copyfile(server.mappath) to copy a file created locally.I'm not thrilled that access to the remote location can't be controlled at the user level this way but at least access to the calling script can. Strange though, the problem showed up during a migration. Server A had been hosting this asp page and connecting to server B sucessfully. I was moving the application to server C when I ran into the problem. All three machines are W2K, same service pack, same domain, same users, same access rights/method configuration. Go figure.
View Replies !
Remote Access To SQL Server
I was given the following by my host: Database name: asdfafasf IP/Host: 11.111.11.111 Server: asfafaf Username: afafdadaf Password: adfadf Every program I use (excluding Enterprise Manager - I don't have it) to connect is unsuccessful. Access Projects for example, when I try to establish a connection, it doesn't ask for IP/Host.
View Replies !
Access Remote Server
I have admin privileges on a remote server and would like to use a web interface (asp) to manipulate various files. It seems that when I access the remote web pages I only have IWAP and IWAM privileges. Is there a way to automatically send my admin username and password via the asp pages so I will have admin privilages?
View Replies !
Moving From Access To SQL Server
Im changing from Access to SQL Server and had a few questions: What is the Equivalent in SQL: Access: Memo Field Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
View Replies !
Can't Connect To SQL Server 2005 Db With Asp But Access 2k3 Is Ok.
I am about to migrate my asp web pages from a previous well functioning connection with Access 2003 to SQL Server 2005 Express Edition instead. I have created a database in SQL Server called "test_db". As far as I know I have not set any particular user id or password for the database. In this microscopic database I have onnly a single table called "name" and in this table I have two columns called "fname" and "lname". I have two records stored in the name table. What I want to achieve is simply to display these two records in my asp-page. How can I achieve this and what am I missing here?
View Replies !
Access A Method In Another Server Using Xmlhttp
Shown below is ASP Code sample that tries to access a method,CreateUser in the server called, "http://smallbutsmart.basis.com.au" using the protocol,XMLHTTP. Can you explain to me why this Code does not work and showing the correct Code Sample?
View Replies !
SQL Server Does Not Exist Or Access Denied.
I have an ASP page which has commands to access a SQL Server 2000 database. Ex: rsDatabase.ConnectionString = "Provider=SQLOLEDB;Data Source=xx.xxx.xx.xxx,yyyy;Initial Catalog=ABCDEF;uid=john;pwd=smith" This line returns the following error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. 1. There is not much load on both the web and sql server and this is the only connection which I'm trying to open with the database. 2. I have tried connecting to the database using the System DSN, but it won't connect 3. On some days and at some times, the page works perfectly with no complaints.
View Replies !
SQL Server Does Not Exist Or Access Denied.
I have a web form to publish data to a ms sql database. Everything works great on my local machine which I use for development. When I uploaded the form and connection file to our web server, I receive the following: Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /psc/Connections/psc_lms_db.asp, line 5 Here is the connection string I am using: Code:
View Replies !
Server.CreateObject Access Error
i am using persists mail component for sending emails. all my pages were working fine 2 days ago, but suddenly it started giving me error as below: Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /contest/thankpage.asp, line 183 The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
View Replies !
Access Variables From Asp Server To Client?
isit possible to access variables (code) from ASP server script to ASP client page?? take for example the code supplied below: 'server script <%@ Language=VBScript %> <% dim svalue svalue="access me" %> 'client code <HTML> <BODY> <SCRIPT LANGUAGE="VBScript"> dim x x = svalue 'svalue isfrom server script response.write x </SCRIPT> </BODY> </HTML>
View Replies !
Asp/access Sql Page Works In Xp But Not In Server 2000?
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2 The SQL statement is as follows: Code:
View Replies !
Changing Access Code Page On Web Server
When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
View Replies !
Question About Access Database From The Server Through Asp Website?
I've published my asp file to the website. I've uploaded all the asp files including access database and it works fine. But the record is not updated until i upload the latest database. Actually the updated database stored in the my local server. Is it possible to access the database on my local server? It means, user can access all the updated directly.
View Replies !
Server.CreateObject("Access.Application")
i have an asp file with the following source code.... ****** Set r_ = Server.CreateObject ("Access.Application.10") s1 = "DoAnything()" with r_ .visible = false .OpenCurrentDatabase "D:SP5DataSPIS_LUPK_Vers.mdb" sApp = .Eval(s1) .CloseCurrentDataBase .Quit acQuitSaveNone End With ****** my problem is, that the createobject on my iis 15sec. goes....that is not normally, or ???? what is the problem ? IIS settings ? DComCnfg ?? ASP Problem ??? Wrong Settings ?
View Replies !
Access 2000 Or SQL Server 2000
I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me). Now the question is should I use: 1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet or 2) SQL Server 2000 ? Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is that a general rule or is it about many people writing to the DB? In other words, if an Access DB has hardly any writes and 99.9% reads can it be used as efficiently as it would be used on SQL Server 2000?
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 !
|
TRACKER
