Alexander The Great

February 2, 2008

Even ASP Ancient Can Do XML With Access

Filed under: Software — alexanderthegreatest @ 9:42 pm
Tags: , , , , , , ,

Access is a baby RDBMS or Relational Database Management System. It runs SQL, stores its data in tables, provides queries (select with projection, DML, even DDL) and has code integration in the sense that VBA (Visual Basic for Applications – embedded, crappy VB Scripting) functions you write can be used in a SQL query.

In all honesty, SQL Server has allowed this forever with UDFs but only recently with the CLR. This is a unique way that Access has lead SQL Server if you simply must write your functions in Visual Basic.

But I digress. The point is that even in absolutely ancient ASP, and with Access the baby brother to SQL Server, you can generate XML. Here’s how.

This is a legacy tip – SQL Server has better support for XML by far, though, without even needing an external language like ASP. And SQL Server is free – Access is not. This defies the conventional wisdom that SQL Server is more expensive than Access (true in web hosting, and true if you buy enterprise versions of SQL Server).

Advertisements

2 Comments »

  1. Thanks for this post – i do websites using Access since I use it data to day, and most of my sites are in ASP. It aint broke so dont fix it right? Why can’t I trust what works instead of going all AJAX/PHP lol. I loved the XML tutorial thanks a bunch for that!

    Comment by Jeff Adams — February 3, 2008 @ 8:12 am | Reply

  2. No problem, Jeff, and I’m glad to hear you like the tech info! I’m pretty impressed by some of this stuff too and I’m glad other people are enjoying the tips.

    I can’t stand PHP. I’m a big fan of ASP.NET. It’s a lot like ASP Classic, enough that you really don’t have to relearn much. But it lets you do so much more.

    But I must confess, I used to do C and then C++ programming, so part of my ASP.NET over ASP preference is that I can do it in C. The other part is that even in VB I can create and use objects directly, without going through Server.CreateObject and late binding everything. It makes pages run more quickly, and it lets an application be more stable. Plus you get access to all the service that come with Windows – you can do your logging and instrumentation on background threads, and you can cache things in HashTables.

    Comment by alexanderthegreatest — February 3, 2008 @ 11:37 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: