onedownfiveup Posted September 24, 2008 Share Posted September 24, 2008 I'm having trouble with os commerce connecting with a MS SQL 2008 database. Will it work with this database? It won't connect to the supplied database hostname I was given. I have sent an email to help desk and am waiting on a reply. Link to comment Share on other sites More sharing options...
onedownfiveup Posted September 24, 2008 Author Share Posted September 24, 2008 I contacted help desk on the host and they said all the information I had was right and it had to do with the software I was using. OS Commerce said it couldn't connect to the database. Link to comment Share on other sites More sharing options...
arietis Posted September 24, 2008 Share Posted September 24, 2008 I'm having trouble with os commerce connecting with a MS SQL 2008 database. Will it work with this database? It won't connect to the supplied database hostname I was given. I have sent an email to help desk and am waiting on a reply. php does support connecting to a ms sql database. but osc is written to expect an mysql database. in order to get it to work, you'd have to change the catalog/includes/functions/database.php and the catalog/admin/includes/database.php functions so that they use ms sql. also, i've noticed that the sql syntax is slightly different between mysql and mssql. at the very least, you would have to change every insert that uses the 'set' syntax, as opposed to the parenthetical lists of columns and values. osc also makes heavy use of auto_increment columns. the mechanism for retrieving the value of the added column is very different in mssql - you have to make another query to the database to get the value. there may be other syntax that doesn't work, like anything that is altering tables or querying database schema. it will be a lot of work, not to mention a lot of testing to ensure proper behavior. if you're not adept at php and sql, i'd suggest using mysql rather than trying to get osc to work with mssql. Link to comment Share on other sites More sharing options...
yustis_83 Posted September 24, 2008 Share Posted September 24, 2008 YEs in fact is a hell lot of work trying to connect to ms you'll be better in a linux server and using mysql ! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.