Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (David Dreezer, nick1, Ruben Rocha), 34 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/13/06
Posts: 87
Top Posters (30 Days)
Ruben Rocha 106
Rick 80
Mark S 72
Thelockman 58
Gizmo 54
driv 35
Sirdude 34
ntdoc 32
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#210884 - 04/29/08 02:32 PM MS Sql 2005 *****
ckelpin Offline
stranger

Registered: 01/29/08
Posts: 6
just curious if UBBThreads (7.2.2) is compatible with a microsoft sql server 2005?

I just got this up and running on mysql and now management wants to use the sql software they purchased.

I assume the DB can be exported and the pathing updated in the config file to point to sql server?

Top
#210885 - 04/29/08 02:41 PM Re: MS Sql 2005 [Re: ckelpin]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
I believe that the only *officially supported* database is MySQL (which is cross platform)
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#210886 - 04/29/08 02:46 PM Re: MS Sql 2005 [Re: Gizmo]
ckelpin Offline
stranger

Registered: 01/29/08
Posts: 6
unofficially I just need to try and see if it works on test environment....thanks!

Top
#210890 - 04/29/08 03:19 PM Re: MS Sql 2005 [Re: ckelpin]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
The best people to talk to are likely ntdoc and Sirdude; NT is a windows guru and SD is a db guru... Sadly both haven't been around as of late however...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#210891 - 04/29/08 03:20 PM Re: MS Sql 2005 [Re: Gizmo]
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1667
Loc: Texas
Both were here yesterday smile
_________________________
- Allen
- ThreadsDev | PraiseCafe

Top
#210894 - 04/29/08 03:22 PM Re: MS Sql 2005 [Re: ckelpin]
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1667
Loc: Texas
Originally Posted By: ckelpin
just curious if UBBThreads (7.2.2) is compatible with a microsoft sql server 2005?

I just got this up and running on mysql and now management wants to use the sql software they purchased.

I assume the DB can be exported and the pathing updated in the config file to point to sql server?


Well, let us know how it goes - I think it takes more than that to work with MS SQL Server, the least of which the mysql commands will need to be ported to MS SQL, eh?
_________________________
- Allen
- ThreadsDev | PraiseCafe

Top
#210900 - 04/29/08 03:27 PM Re: MS Sql 2005 [Re: AllenAyres]
Gizmo Moderator Offline

***

Registered: 06/04/06
Posts: 12089
Loc: Portland, OR; USA
Originally Posted By: AllenAyres
Both were here yesterday smile
Score...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#210954 - 04/30/08 02:01 PM Re: MS Sql 2005 [Re: Gizmo]
ntdoc Offline

***

Registered: 11/08/06
Posts: 3244
Allen is correct. Out of the box is will not work.

The strings, commands, and code in general are NOT compatible with SQL 2005

Could it be ported, YES - but that would be a LOT of work and testing that currently I don't see happening as SQL 2005 is not free like MySQL is which highly restricts the customer base.

Top
#210992 - 05/01/08 12:31 PM Re: MS Sql 2005 [Re: ntdoc]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2124
Loc: SoCal, USA
assuming your DB doesn't exceed 2Gig, there is a free version of mssql out SQL express 2005.

works fine/lasts a long time..

only prob is that we are very tied to mysql-ish SQL, so there are definitely a lot of issues involved in making that work.

it's possible though -- essentially mysql.inc.php would have an equivalend mssql.inc.php (in libs)

then the offending queries would need attention and also possible some of the field types in the actual tables..

i know i ran a converter to just convert over the mysql to mssql and that succeeded a while back, but stopped there..

:2c:
_________________________


Top
#211029 - 05/01/08 05:24 PM Re: MS Sql 2005 [Re: Sirdude]
ntdoc Offline

***

Registered: 11/08/06
Posts: 3244
Yes there is a FREE MS SQL Express but they seem to imply they have the full version and want to use that so that's why I said it would have a very small user base. Even with the FREE MS SQL Express I don't see that being a universal option either as it only runs on Windows.

Quote:
management wants to use the sql software they purchased



SQL Server 2005 Express Edition

Quote:

Free to download, free to redistribute, free to embed, and easy for new developers to use immediately, a simple but powerful development environment for building data-driven applications. Easily manage your database with SQL Server 2005 Management Studio Express.


Be warned though that you can not publish to other database models with this version.


.

Top
Page 1 of 2 1 2 >


Shout Box

Today's Birthdays
GOTMYSELFA...., smilinjack
Recent Topics
New members don't get access and are not displayed in the config panel
by Yomar
Today at 03:32 AM
How to Change Link Color / Underline in styles?
by ECNet
Yesterday at 10:00 PM
Chaging the "max online" number and date
by wanted
Yesterday at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Yesterday at 10:26 AM
Custom island with sql connection
by Robje01
Yesterday at 09:13 AM
Forum Stats
4296 Members
33 Forums
30687 Topics
156011 Posts

Max Online: 978 @ 06/24/07 08:19 PM