🚀 go-pugleaf

In article <9505111936.AA22566@puffer.com>, Bob Davis  <rjd@PUFFER.COM> wrote:
>I have a question about connectivity (for lack of a better word) to
>MS-SQL Server.
>
>The environment that we have is one in which we utilize SUN
>Workstations and SUN Servers.  This is a UNIX environment where the
>applications run under Sun OS 4.1.x.  We utilize Sybase 4.9.x and will
>be converting to System 10 within the month.  Our applications are
>written in C and run under UNIX and currently access our Sybase database.
>
>We now have a new vendor provided database.  It is a MS-SQL Server
>4.21a database and we have it running under Windows NT 3.5.
>
>All of these machines sit on a TCP/IP network.
>
>What I want to do is to be able to access both my Sybase database and
>my MS-SQL Server database from my C applications.
>
>Does anybody have any suggestions on how to do this?

MS SQLServer will advertise its services on a TCP/IP socket if configured
to do so.  The SQL Setup GUI tool can be used to do this after installation
if it is not already correctly configured.  Doing so prohibits the use
of the integrated security model, leaving the standard SQL model.  This
may not be an issue for Puffer, but I'd check with the third party vendor
to see if they invested heavily in the integrated security model.

Regards,
Mike