XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / MS SQL Server 2005 & Xoops
Register
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

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

417 user(s) are online (354 user(s) are browsing Support Forums)

Members: 0

Guests: 417

more...

Donat-O-Meter

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

Latest GitHub Commits