Peter J. Boettcher — Mon, 24 Sep 2001 22:27:20 +0000

Hey Vincent, I haven't seen you for a while!

In regards to the XML standards in SQL 2000, for a Microsoft Product, they're pretty good. The XML is well formed, without any nasty surprises.

I'm still learning most of the XML features in 2000, and how I can apply them to applications, but so far it's pretty solid.

Vincent Puglia — Mon, 24 Sep 2001 22:08:19 +0000

Hi Peter & how are u?

seeing as how I don't have sql server, I was wondering about the xml parser. Specifically, does it follow irt standards? Or, is it like Front Page (which tends to flaunt html standards and relocate javascript where ever it pleases)?

Vinny

Peter J. Boettcher — Thu, 06 Sep 2001 14:46:00 +0000

The difference between a database server (SQL Server, Oracle, etc) and a simple database (Access, text file, etc)is features & performance. A simple database just offers data storage, whereas a database server offers much more, including better performance, better security, enhanced features like stored procedures, views, triggers, the ability to schedule jobs (queries) to run.

As for the JDBC question, I don't use Java to connect to my databases so I can't really advise you on that, but from what I hear, a couple of the ones most commonly used are:

WebLogic
weblogic.com

OpenLink
openlinksw.com

Although I haven't used it, I think Microsoft provides a tool that bridges between JDBC & ODBC, you might find more on that here: microsoft.com/java

cookie — Thu, 06 Sep 2001 14:18:16 +0000

thanks once again Peter.

Could u please tell me what is the difference between a database server and database.

Also i would like to know where can i find a JDBC driver for SQL Server 2000 if possible type 4 and free.

If not free which driver to u advise me to choose.

Cookie.

Peter J. Boettcher — Wed, 05 Sep 2001 15:07:56 +0000

SQL Server 2000 has it's own built in parser, the version of the parser depends on the service packs you have installed. I think the latest version is around 3.0

You might want to check out these links:

http://www.microsoft.com/sql/evaluation/compare/discussion.asp
http://www.microsoft.com/sql/evaluation/compare/mythandreality.asp

Which database to choose

cookie — Wed, 05 Sep 2001 14:14:35 +0000

First of all thanks . Just wanted to know which database u'd advice me to choose between SQL Server 2000 and Oracle 8i.

By the way could u tell me something about XML parsers for databases . Does SQL SERVER 2000 needed and XML parser too.

Thanks again

Peter J. Boettcher — Mon, 03 Sep 2001 19:05:39 +0000

SQL Server 2000 is great with XML since it can handle it natively, I'm pretty sure the latest version of Oracle can also, I can't comment on the other ones. So instead of storing the actual document you can just store the data and the database generates the XML.