Solved

osCommerce & MS SQL?

Posted on 2006-07-15
2
666 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
2 Comments
 
LVL 9

Accepted Solution

by:
cristi_2112 earned 250 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Encode a password 2 38
Link SQL table to Webpage 9 38
Jquery Autocomplete PHP script 3 21
two tables one button 11 10
Introduction Many web sites contain image galleries; a common design for these galleries includes a page with a collection of thumbnail images.  You can click on each of the thumbnail images to see the larger version of the image.  This is easily i…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
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.

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now