1
tedsmith
MS SQL Server 2005 & Xoops
  • 2006/1/26 15:15

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


The 'About Xoops' page says "- Database-driven
XOOPS uses a relational database (currently MySQL) to store data required for running a web-based content management system."


Does that mean I can only use MySQL with it or could I use MS SQL Server 2005?

Thanks

Ted

2
tedsmith
Re: MS SQL Server 2005 & Xoops
  • 2006/1/27 9:32

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


*bump*

3
samer
Re: MS SQL Server 2005 & Xoops
  • 2006/1/27 9:37

  • samer

  • Just popping in

  • Posts: 46

  • Since: 2005/3/24


Well the only supported DBMS currently is MySQL as far as I know.

4
tedsmith
Re: MS SQL Server 2005 & Xoops
  • 2006/1/27 14:10

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


But I thought SQL was a 'standard' language used by all SQL databases and that XOOPS effectively just sends and receives SQL commands? If that's the case, surely as long the username and password are correct that is given to the SQL server (whatever that may be) by PHP, then I would have thought it will work?

Ted

5
samer
Re: Universal DBMS & Xoops
  • 2006/2/6 20:40

  • samer

  • Just popping in

  • Posts: 46

  • Since: 2005/3/24


Well yes in theory that is true.
But when you write php, each function queries a certain database.
For example mysql_connect(x,y,...) connects to a MySQL database server.
Therefore the programmers should write different code for different DBMS .
Moreover, each DBMS has its own syntax (they differ slightly)

It would be interesting to know if such a solution exists

6
wtravel
Re: MS SQL Server 2005 & Xoops

It would be possible indeed to add a MS SQL database class and use that instead of the MySQL class. The query strings differ slightly from MySQL in some cases as far as I know. For XOOPS I have not seen a MS SQL class file so far.

Perhaps you can find out what the differences are exactly and translate that into a new database class file.

Login

Who's Online

128 user(s) are online (96 user(s) are browsing Support Forums)


Members: 0


Guests: 128


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits