Solved

mySQL Inquiry

Posted on 2004-08-06
4
375 Views
Last Modified: 2010-04-06
Hi I have a problem. I am creating a ala mini local e-commerce site. My customer wants to upload a database file to our server to update his catalog. I have created a flow of my program and settled on using Access, so that they will upload only their products.mdb to our server and I will be using ASP.net. But here is my problem. They have their database file on a Clipper and they will convert it to mySQL file. If I am going to use mySQL Server will I still be upload their files ala Access files? or they will still attach their DB files ala SQL Server?

Thanks and please email me the answer at <removed by PashaMod for users privacy>
0
Comment
Question by:juggernux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 8

Accepted Solution

by:
dds110 earned 50 total points
ID: 11736119
juggernux

Normally, the members at EE will not send comments to personal email addresses.  This prevents everyone from seeing the proposed solutions and this site is all about helping people.  I've posted a question in the Community Support (CS) Topic Area (TA) in order to get you, AND me, more guidance on this.  Perhaps a few more Experts can chime in here.

As for you question:

So long as your web server supports both db engines (i.e.  MS Access and mySQL), then it shouldn't be a problem to "grab" the data from mySQL and "throw" it into the access database.  You will need to set up at least two ADODB (or DSN) connections to handle the transfer.  1 for Access and 1 for mySQL.  You shouldn't have too much trouble writing the code necessary to:

1. Upload the mySQL file
2. Open mySQL file
3. Open Access
4. Transfer Records from mySQL to Access (with the before mentioned ADODB connections)
5. Close both files

If you do need help with the code, we'll be more than happy to help you out.......Just ask.

HTH
0

Featured Post

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
There are two main kinds of selectors in CSS: One is base selector like h1, h2, body, table or any existing HTML tags.  For instance, the following rule sets all paragraphs (<p> elements) to red: (CODE) CSS also allows us to define our own custom …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question