Help! - OS/2 client set up 
Author Message
 Help! - OS/2 client set up

I have to set up an OS/2 client to be able to access a database on a 6.5
server.  What do I need to intall on that client for it to be able to
connect to the database?  I haven't found anything in client set up
utilities that talks about OS/2 clients.  Is there a third party product
I can use?

--

 - J. Piscioneri
   new mode Communications
    http://www.***.com/



Fri, 05 Nov 1999 03:00:00 GMT
 Help! - OS/2 client set up

I'd look for a visigenic odbc driver...
--
Richard Waymire, MCT, MCSE, MVP (SQLServer)
Principal Engineer, ARIS Corp.
President, Pacific NW SqlServer User Group - http://www.pnwssug.org
Visit us at http://www.aris.com



Quote:
> I have to set up an OS/2 client to be able to access a database on a 6.5
> server.  What do I need to intall on that client for it to be able to
> connect to the database?  I haven't found anything in client set up
> utilities that talks about OS/2 clients.  Is there a third party product
> I can use?

> --

>  - J. Piscioneri
>    new mode Communications
>    http://www.new-mode.com



Fri, 05 Nov 1999 03:00:00 GMT
 Help! - OS/2 client set up

With release 6.0 of SQL Server, Microsoft removed the drivers to
support clients running OS/2.  While the old drivers from 4.2 still
work, they are becoming very out of date and limited.  Microsoft's
policy is to suggest using ODBC for SQL Server connectivity from all
non-Microsoft operating systems.  (Come to think of it, that isn't
much different from what they say to do for any Microsoft OS too.)
The one I have heard of comes from Visigenic.

Roy

Quote:

>I have to set up an OS/2 client to be able to access a database on a 6.5
>server.  What do I need to intall on that client for it to be able to
>connect to the database?  I haven't found anything in client set up
>utilities that talks about OS/2 clients.  Is there a third party product
>I can use?

>--

> - J. Piscioneri
>   new mode Communications
>   http://www.new-mode.com



Fri, 05 Nov 1999 03:00:00 GMT
 Help! - OS/2 client set up

Thanks for the info.

Since I'm new to this, there's something I don't understand about what's
necessary for a client to connect to a db server.  If you want to
connect via ODBC is there anything else you need to install on a client
besides the ODBC drivers?  Don't you also have to also install some sort
of db server specific driver?  This sounds contradictory to what ODBC is
supposed to be all about, but reading the client setup instructions for
SQL Server, it sounds like you need ODBC and the net-lib drivers as
well.

        - Confused

Quote:

> With release 6.0 of SQL Server, Microsoft removed the drivers to
> support clients running OS/2.  While the old drivers from 4.2 still
> work, they are becoming very out of date and limited.  Microsoft's
> policy is to suggest using ODBC for SQL Server connectivity from all

> non-Microsoft operating systems.  (Come to think of it, that isn't
> much different from what they say to do for any Microsoft OS too.)
> The one I have heard of comes from Visigenic.

> Roy


> >I have to set up an OS/2 client to be able to access a database on
> a 6.5
> >server.  What do I need to intall on that client for it to be able
> to
> >connect to the database?  I haven't found anything in client set up

> >utilities that talks about OS/2 clients.  Is there a third party
> product
> >I can use?

> >--

> > - J. Piscioneri
> >   new mode Communications
> >   http://www.new-mode.com

--

 - J. Piscioneri
   new mode Communications
   http://www.new-mode.com



Sat, 06 Nov 1999 03:00:00 GMT
 Help! - OS/2 client set up

You'll need an ODBC driver which is enabled to connect to sqlserver, which
will understand the specifics of the database.  What ODBC will do is, from
the CLIENT's perspective, make it transparent.  The driver translates the
calls to the appropriate dialect to talk to the database.
--
Richard Waymire, MCT, MCSE, MVP (SQLServer)
Principal Engineer, ARIS Corp.
President, Pacific NW SqlServer User Group - http://www.pnwssug.org
Visit us at http://www.aris.com



Quote:
> Thanks for the info.

> Since I'm new to this, there's something I don't understand about what's
> necessary for a client to connect to a db server.  If you want to
> connect via ODBC is there anything else you need to install on a client
> besides the ODBC drivers?  Don't you also have to also install some sort
> of db server specific driver?  This sounds contradictory to what ODBC is
> supposed to be all about, but reading the client setup instructions for
> SQL Server, it sounds like you need ODBC and the net-lib drivers as
> well.

>         - Confused


> > With release 6.0 of SQL Server, Microsoft removed the drivers to
> > support clients running OS/2.  While the old drivers from 4.2 still
> > work, they are becoming very out of date and limited.  Microsoft's
> > policy is to suggest using ODBC for SQL Server connectivity from all

> > non-Microsoft operating systems.  (Come to think of it, that isn't
> > much different from what they say to do for any Microsoft OS too.)
> > The one I have heard of comes from Visigenic.

> > Roy


> > >I have to set up an OS/2 client to be able to access a database on
> > a 6.5
> > >server.  What do I need to intall on that client for it to be able
> > to
> > >connect to the database?  I haven't found anything in client set up

> > >utilities that talks about OS/2 clients.  Is there a third party
> > product
> > >I can use?

> > >--

> > > - J. Piscioneri
> > >   new mode Communications
> > >   http://www.new-mode.com

> --

>  - J. Piscioneri
>    new mode Communications
>    http://www.new-mode.com



Sat, 06 Nov 1999 03:00:00 GMT
 Help! - OS/2 client set up

Confused,

Quote:
>Since I'm new to this, there's something I don't understand about what's
>necessary for a client to connect to a db server.  If you want to
>connect via ODBC is there anything else you need to install on a client
>besides the ODBC drivers?  Don't you also have to also install some sort
>of db server specific driver?  This sounds contradictory to what ODBC is
>supposed to be all about, but reading the client setup instructions for
>SQL Server, it sounds like you need ODBC and the net-lib drivers as
>well.

ODBC has two layers.  One layer is the interface to your application
program.  At least for the various Windows operating systems this is
supplied by Microsoft.  The other layer is specific to the data
source, be it SQL Server, Oracle, btrieve, or whatever.  This layer is
generally provided by the vendor that created the data source.  In the
case of the Microsoft SQL Server driver, this layer replaces the DBLIB
layer of the conventional (non-ODBC) library.  Regardless of whether
the SQL Server connection is via ODBC or DBLIB, you also need a netlib
layer to deal with the protocol-specific problems of communication.

Let me try to say it another way...  With ODBC your application talks
to the ODBC front end, which talks to the SQL Server ODBC layer, which
talks to the netlib layer, which talks to SQL Server.  With DBLIB
instead of ODBC, your application talks to DBLIB, which talks to
netlib, which talks to SQL Server.

The details of how this all works for an ODBC application anywhere but
Windows is outside my experience.

Roy



Sat, 06 Nov 1999 03:00:00 GMT
 Help! - OS/2 client set up

Quote:

> Fine, but I emailed Visigenic asking for an OS/2 ODBC driver for SQL
> Server,
> and they said they didn't have one.  Same thing for Intersolv, which
> according to
> a lot of posters makes such a driver.  Has anyone actually succeeded
> in connecting
> an OS/2 application via ODBC to SQL Server (as opposed to having
> second- or third-
> hand information about some third party that supplies drivers)?
> Switching the clients
> to NT is not an option; it would probably be easier to reprogram the
> SQL Server application
> for DB2 or some other RDBMS that can actually serve multiple
> platforms.

> -Mika

I spoke with someone at Visigenic who said they did have an OS/2 to SQL
Server ODBC package.  This person said that it hasn't been certified for
6.5 yet, but has been for 6.0 and there shouldn't be any problems using
it.

My situation doesn't require an ODBC connection so I'm not sure if our
solution is useful to you.  We used an old OS/2 client set up disk from
SQL Server 4.2.  We were able to connect to our 6.5 server from this
OS/2 client with ISQL which is good enough for our application.

Since using this old set of drivers worked, it might be useful to call
Intersolv to see if they'll sell a older version of their ODBC package
for OS/2 clients.  I think that last version of DataDirect that
supported OS/2 for MS SQL Server was version 2.12.

Good luck.
--

 - J. Piscioneri
   new mode Communications
   http://www.new-mode.com



Tue, 09 Nov 1999 03:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Help setting up OS/2 Client for NT 4.21A

2. Multi-Protocol Set Ups

3. Need referrals for Business Set Ups

4. HELP: Informix 7.x and OS/2 clients....

5. HELP - How do I connect an OS/2 Client to NT 4.21A

6. Help regarding setting up a remote client

7. Help regarding setting up a remote client

8. VB5 Set up need help can't run app on clients comp

9. Need help programmatically setting Client Net-Library!!

10. Help Needed with TRemote Server + Client Data Sets

11. How to set character-set NLS_language to show chinese at PC client

12. Help for Look Ups


 
Powered by phpBB® Forum Software