We've done a bit of experimenting with SQL Server 7.0 Linked
Servers and DTS working against Image/SQL databases.
The results are not heartening.

Linked Servers are a great idea but don't even work properly with
SQL Server 6.5.
DTS is much more stable, it seems, but is multi-threaded, and
ODBCLink/SE is single.  There is an option in DTS to set actions
to run on the main thread, so this may work, but the best approach
would be to upgrade to a multi-thread ODBC driver on your HP3000.


Tim Ericson <[log in to unmask]> wrote in message
news:F4B1826B1A21D211AEC5006008207AF40302DE46@dogbert.csillc.com...
> Hi everyone!
>
> I received this e-mail from Gilles Colmant
<[log in to unmask]>,
> who has a question about ODBC.  If anyone can answer his
> question, please contact him directly.
>
> Thanks!
>
> -----Original Message-----
>
> > Hello,
> >
> > I had your e-mail surfing on the Web. I've seen that you have
> > experienced systems like HP3000 and TurboImage.
> > Here's my problem. I have a SQL Server 7.0 running on Windows
> > NT 4.0 (SP5) and I'm accessing a HP3000 system with TurboImage.
> > Right now, we use ODBCLink/SE-32 Driver as a ODBC provider but
> > we experience some issues. As we use DTS on SQL 7.0, it needs
> > OLE DB to access it. So we have a OLE DB provider for ODBC
> > above the ODBC provider.
> >
> > Using Openrowset commands, select are OK but big issues with
> > Insert/Update. Ever tried before ?
> >
> > Or may be you know others ODBC providers, or maybe OLE DB ?
> >
> > Thanks for your help.
> >
> > Gilles Colmant

--=--=--
Bob Walker, Computer Centre  --  [log in to unmask]
Capilano College, North Vancouver, BC, CANADA.
------
'No one is listening until you make a mistake.'