Re: Database Model - Class, objects and interaction [LONG]

On Dec 4, 2:33 pm, S Perryman <q...@xxxxx> wrote:

If there is an ODBC client C, and a database server S with ODBC
capability, then if a developer is using a C provided by vendor V1
(C-V1) , then they must also use the S provided by V1 (S-V1) ??

Well, I just ran a perl script this morning, it has these lines in it,

my $snapshot_dbh = DBI->connect($snapshot_datasource, $snapshot_user,
$snapshot_password) or die ...

my $datamart_dbh = DBI->connect($datamart_datasource, $datamart_user,
$datamart_password) or die ...

I regard the perl script as my ODBC client, it's a free version of
perl from the company ActiveState.

$snapshot_datasource is the name of an ODBC driver registered as a
Windows datasource, it's a SQL Server ODBC driver, written by
Microsoft, I obtained that driver by downloading a DLL from
Microsoft's site. $datamart_datasource is the name of an ODBC driver
also registered as a Windows datasource, it's a Sybase driver, written
by Sybase, I obtained that driver by downloading a DLL from Sybase's
site. So I downloaded these drivers and registered them in Settings-
Control Panel->Administrative Tools -> Data Source (ODBC) ... The
company ActiveState did not write either of these drivers, nor does
ActivePerl come with any native Microsoft or Sybase database support.

My perl script contains stunningly beautiful perlish lines like

my $sth = $datamart_dbh prepare("select myattribute1,
myattribute2 from mytable") or die ...
$sth->execute() or die ...

my($myvariable1, $myvariable2);
\$sth->bind_columns( undef, \$myvariable1, \$myvariable2);

if ($sth->fetch())
{

It seems to work.

If you wrote a backend server, and provided an ODBC driver, I could
also use your backend server from within perl.

-- Daniel

.

Relevant Pages

  • RE: Error from FoxPro connection in Visual Basic 6
    ... Try installing the VFP ODBC driver on the server. ... Microsoft FoxPro Technical Support ...
    (microsoft.public.fox.vfp.dbc)
  • RE: ODBC-Server Middleware
    ... We have the need to use ODBC. ... see only those datasources which were configured on the server. ... animal with the combination of Sequelink and Informix though the conception ... The ODBC driver usually is used by the application. ...
    (comp.databases.informix)
  • Re: ODBC drivers for MSSQL
    ... There are at least two ways, and you may or may not need an ODBC driver ... both Sybase and MS SQL Server speak dialects of. ... letting it know that unixODBC is its driver manager at build time, ...
    (comp.os.vms)
  • Re: call failed 3146
    ... I have a vb program that connects to odbc to an sqlexpress server. ... the latest 'n greatest video/sound driver for your card is generally a wise ...
    (comp.lang.basic.visual.database)
  • Re: SSIS package Informix to SS 2005
    ... I am using Avaya Openlink driver 4.2 and after much trial and error I have ... picking data from ODBC and pushing it to SS 2005 Database through SSIS ... Multi-tier ODBC Driver forInformix. ...
    (microsoft.public.sqlserver.odbc)