Re: Getting external data ODBC connect errors when connecting with Access
From: Den (nomail_at_nowhere.com)
Date: 03/10/04
- Next message: Mike M: "Re: Help concatenating records to a field"
- Previous message: Aaron Weiker: "Re: Triggers + inserting into other table"
- In reply to: bc: "Getting external data ODBC connect errors when connecting with Access"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Mar 2004 13:41:20 -0800
It appears you are using an SQL server driver to connect to a Sybase
database, you need a Sybase driver.
Dennis
"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
>
>
>
>
- Next message: Mike M: "Re: Help concatenating records to a field"
- Previous message: Aaron Weiker: "Re: Triggers + inserting into other table"
- In reply to: bc: "Getting external data ODBC connect errors when connecting with Access"
- Messages sorted by: [ date ] [ thread ]
