Solved

mySQL Inquiry

Posted on 2004-08-06
4
355 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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
XSL Grouping 7 42
Web Development Tools for MVC 3 98
Does a Google search find images with the word being searched? 11 84
Create animated movies for web page 18 85
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

838 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