The nice thing about using Linked Servers is that you can
logically do joins between TurboImage datasets and SQL Server
tables.  Of course you need to be very aware of the underlying
data or else you may not think your query is ever going to
come back to you :)

Regards,
Michael L Gueterman
Easy Does It Technologies LLC
http://www.editcorp.com
voice: 888.858.EDIT or 573.368.5478
fax:   573.368.5479
--


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of Dave Vorgang
Sent: Friday, March 07, 2003 10:05 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Minisoft Vs Sockets


I just use Minisoft's ODBC drivers and in my web app I import
Microsoft.Data.Odbc.  Then, just use the odbc classes to access your data.

I have tried using Linked Servers and User Defined Functions within SQL
Server 2000, but I had some problems.  I think the problems are due to the
UDFs and it would probably work using Stored Procedures.  But using the ODBC
directly from the web app is so easy and probably more efficient, so I'm
sticking with that.



Dave Vorgang
Programmer / Analyst
Medford School District - Data Processing
(541) 842-1021
mailto:[log in to unmask]

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *