?
Solved

osCommerce & MS SQL?

Posted on 2006-07-15
2
Medium Priority
?
680 Views
Last Modified: 2013-12-12
Hello Friends,

I'm evaluating osCommerce and wondering if it integrates with MS SQL?
It comes with MySQL, but we have already developed a content management system that uses an MS SQL database and we would definitely need to use that data with osCommerce.

We'd also want to make some extensive modifications to the osCommerce website, so that it ties in not only to our content database, but also to our MS SQL database containing periodically updated accounting data (AR, sales, inventory,...).

Does this sound possible with osCommerce?

Thanks!
0
Comment
Question by:forcedexposure
[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
2 Comments
 
LVL 9

Accepted Solution

by:
cristi_2112 earned 1000 total points
ID: 17121688
Hello,

I have heard of people doing this before.
From what I remember, there are two or three features of MySQL that have to be written using MSSQL sub-procedures, you have to change the script that creates the DB and tables, and the rest is just changing the connection strings and how the wording of some queries.
But it takes some time to do and properly test all of these.
Anyway, it's possible and it's not difficult programming. It just requires attention, testing and time :).

0
 

Author Comment

by:forcedexposure
ID: 17188808
Thanks for the info!
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

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this. Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it i…
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

801 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