apache+windowsNT+SQL Server

[dilbertblue]

hi,
i am new to apache. i wud appreciate if anybody can guide me for the following combination.
i want to use apache+NT combination with SQL Server at the back end.
1.Wud this combination work out??
2.are JDBC drivers available with apache??
3. are there any known problems/bugs with apache/NT

Thanx in advance.

 

[jhughes96]

Hi,
i dunno why you want that particular configuration but there is no reason why you cannot run it.

The Perl:BI modules will talk to most databases (including SQL Server). Here is an example of connectin to SQL via ActiveStates Perl
$dbh = DBI->connect("dbi:ADO:xxxyourdb", $user, $passwd) or die "$DBI::errstr";

As a minor moot point though, am not sure if he above uses the faster OLEDB API or uses the old ODBC approach.

I'm more of a Perl person but I here that PHP is also very good for talking easily to DBs.

As far as JDBC drivers are concerned, dunno - this would be via Jserv/tomcat or someother Java addon though I think..

Apache is now pretty good on Win32. Latest versions are multithreaded I think.

joel