Re: Getting external data ODBC connect errors when connecting with Access

From: oj (nospam_ojngo_at_home.com)
Date: 03/09/04


Date: Mon, 8 Mar 2004 22:26:34 -0800

You probably have better luck getting solution from Sybase newsgroup.

Here's a quick search on google.
http://groups.google.com/groups?q=sybase+odbc+access

-- 
-oj
http://www.rac4sql.net
"bc" <bcraw@adelphia.net> wrote in message
news:OUXf$VUBEHA.3712@tk2msftngp13.phx.gbl...
> Connecting to a Sybase 11.9 system via W2K to export some data to pipe
> delimited for use in another location. Sybase bcp only allows me to export
> an entire table. isql -s\| doesn't seem to delimit fields in the right
> places. Don't have a problem with ODBC with Excel works fine but I run into
> some sort of 64K limit with Excel on the *** and can only get 65K rows of
> data imported. Last ditch effort uses ODBC to Access but it fails using
> either Machine DSN, File Data Source or Linking db's. All with the following
> error:
>
> [INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect():network packet
> layer:internal net library error: Net-Lib protocol driver call to connect
> tweo endpoints failed.
>
> Any ideas. Is this some sort of ODBC driver vs problem.
>
> -regards,
> Bob
>
>
>
>