database support

Ok, so I finally got around to it. Drupal 5.0 (6.0-dev) MS SQL support. I am hoping this thread can be a sort of 'behind the scenes' working group with official patches posted to Drupal.org.

NOTE: This has been tested with:

• PHP 5.1.6
• SQL Server Standard 2005
• ntwdblib.dll v. 2000.80.194.0 (you will need this updated version and not the one that comes with your php install)

With that said, on to the patch. It is definalty a hefty one at 51KB. So, a quick over-view of what it does.
First, a few files have been added:

<

ul>

So I have 2 Oracle installations running great on 4.7.3, and 4.7.4.

So I thought 5.0 would be easy to tackle....totally wrong.

I was on the phone with Oracle late tonight. I'll try and keep this rant short. But, the reason that Oracle will work with 4.7 and not 5.0 is that in 4.7, you have to run your SQL statements manually, and in 5.0 Drupal does this for you. This is a really nice feature. However, that's where the problem comes in:

Currently, the Oracle implementation use sequences and triggers to simulator auto_increment and serial fields. The problem is that you can not create a trigger from PHP, you much run a trigger DDL from Oracle's SQL+ (or if you have Java). For some reason, it's a bug in the oci8 module.

I have started some "step-by-step" handbooks on running drupal on alternative databases (those that are non-standard-drupal).
So far, I have just started Oracle. When I have time, I will try and do the MS SQL one also. I'd love some crituqes on getting this polished off and included in the Drupal.org handbooks.

http://eb3it.com/oracle_handbook

Ok, today I am going to start to consolidate all of these diff. db support tasks into my sandbox for a pre-release and discussion setup. Right now, there are about 5 different, and very good, threads about Oracle and MS-SQL support. However, there is still no central place for everyone to consolidate their code and work on the DB's. This needs to happen so no one goes off and re-invents the wheen. So, today I am going to sift through the threads, integrate as much as the code togather as I can, and commit them to my sandbox.

I personally currently have an Oracle installation and a MS-SQL installation working very well.

Note:I welcome others to join the effort and I will provide some tablespace on an Oracle 10g database server to test and implement an Oracle driver for Drupal upon request

I have begun Oracle Support in full gear. After this, I plan to do the same with MS-SQL. I shall start to release my findings here. I am starting with some code from this ( http://drupal.org/node/39260 ) drupal thread. I'm testing against Oracle 10g.

I have installed Drupal 4.7.3, and I am using the database.oracle.inc, and database.oracle.sql very well. I have full funcitnality thus far.

The New York State Senate Minority Leader's office is looking for two bright and politically adventurous technologists. Please send all correspondence to nysd.tech@gmail.com

+++++++++++++++++

TITLE: Database Administrator
DEPARTMENT: Minority Information Services Unit
OFFICE: Office of Senate Minority Leader David Paterson

Summary:
Candidate will be responsible for maintaining and supporting contact and constituent databases and other technology infrastructure for the Minority Information Services Unit (MIS).

Job Responsibilities (include but are not limited to):

The issue of supporting more databases has been around for a while. It was rescently brought up today on the development thread. I personally think that more database support is needed also. The more flexilble that Drupal is, the healthier it is in general. My currently list to implement is MS-SQL, and then Oracle. This list is definatly going to grow, but I believe that those two are a good start.