From: "Dwayne Smurdon @ DNA Media Pro" <smurdon@...>
Date: 2003-01-29T05:59:36+09:00
Subject: Connecting to a database..

This is a multi-part message in MIME format.

------=_NextPart_000_00B9_01C2C6E5.CE5E4450
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I did a lot of googling and looking around the related Ruby websites, but I
still cannot find a concreate example of how to connect to a database using
a DSN and/or a DSN-less connection.

If I do this with win32ole -- it seems to me that sort of means my code is
not really crossplatform.  So, I think I would like to do it with a general
odbc library...but maybe this is more trouble than it's worth?

I do have a near-term need to grab 100,000+ contacts from a MS SQL Server
and place them into Outlook contacts.  So my needs are win-specific.

Basically, if someone can tell me how to connect to the server, prepare and
execute a sql statement and then iterate over a result-set, I could probably
get this done.  :)

Can anyone help with this?

-Dwayne

------=_NextPart_000_00B9_01C2C6E5.CE5E4450
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DWindows-1252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.6249.1">
<TITLE>Connecting to a database..</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->

<P><FONT SIZE=3D2>I did a lot of googling and looking around the related =
Ruby websites, but I still cannot find a concreate example of how to =
connect to a database using a DSN and/or a DSN-less =
connection.</FONT></P>

<P><FONT SIZE=3D2>If I do this with win32ole -- it seems to me that sort =
of means my code is not really crossplatform.&nbsp; So, I think I would =
like to do it with a general odbc library...but maybe this is more =
trouble than it's worth?</FONT></P>

<P><FONT SIZE=3D2>I do have a near-term need to grab 100,000+ contacts =
from a MS SQL Server and place them into Outlook contacts.&nbsp; So my =
needs are win-specific.</FONT></P>

<P><FONT SIZE=3D2>Basically, if someone can tell me how to connect to =
the server, prepare and execute a sql statement and then iterate over a =
result-set, I could probably get this done.&nbsp; :)</FONT></P>

<P><FONT SIZE=3D2>Can anyone help with this?</FONT>
</P>

<P><FONT SIZE=3D2>-Dwayne</FONT>
</P>

</BODY>
</HTML>
------=_NextPart_000_00B9_01C2C6E5.CE5E4450--