                                                                                                                                                                                                                                                                
Received-SPF: pass (google.com: domain of pasa...@gmail.com designates 209.85.214.44 as permitted sender) client-ip=209.85.214.44;
MIME-Version: 1.0
In-Reply-To: <CAOwECd+ZeR20ahX9DU6K79wi5iPdGnaPFbLa+gmRf=J8dGQ...@mail.gmail.com>
References: <23707204.2413.1335321164998.JavaMail.geo-discussion-forums@ynmm10>
 <CAOwECd+ZeR20ahX9DU6K79wi5iPdGnaPFbLa+gmRf=J8dGQ...@mail.gmail.com>
From: Sam Moffatt <pasa...@gmail.com>
Date: Tue, 24 Apr 2012 20:33:11 -0700
Message-ID: <CABYB9+AbKf4gxATcJ9SCDJRfZTMb1SmhRK4z4pxQ1xHQn2F...@mail.gmail.com>
Subject: Re: [jplatform] MS SQL Server and JDatabase
To: joomla-dev-platform@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, Apr 24, 2012 at 8:27 PM, Louis Landry <louislan...@gmail.com> wrote=
:
>>
>> Does the JDatabase solution require an ODBC driver?=A0 Or, does it use a
>> native SQL Server driver?
>>
> The JDatabase drivers use the sqlsrv extension for PHP. =A0My understandi=
ng is
> that Microsoft now has an ODBC driver for MSSQL on Linux that could be
> leveraged through an ODBC drive that isn't yet written. =A0Other than tha=
t if
> you are on Linux you'll need to setup=A0http://www.freetds.org/ to use al=
ong
> with the JDatabaseSqlsrv driver at the very least. =A0On windows itself I=
'm
> not sure, but I'd assume that it would just sort of "work".

SQLSRV is a specific driver that Microsoft wrote for PHP on Windows,
you can't use FreeTDS with it but instead need to use a Sybase powered
connector to use FreeTDS (which isn't in the platform IIRC, there was
one a while back in one of the many branches). If you're running
everything on Windows, using the Web Platform Installer is probably
the best way of getting the entire stack set up and will help out with
getting the SQLSRV PHP driver connected up and IIS as well as a few
other things as well.

>>
>> What do you use for Data Modeling if you are an MS SQL Server DBA?
>>

You might wish to look into the SQL Server Management Studio Express
product. Again, the Web Platform Installer can help you install that
along with the MSSQL database.

Cheers,

Sam Moffatt
http://pasamio.id.au