Re: Insert fails on linked server to Sybase
- From: Niall Baird <Niall.Baird.2eh0xz@xxxxxxxxxxxx>
- Date: Wed, 20 Sep 2006 23:58:07 -0500
I haven't even been able to get that far - I've managed to set up sql
server 2005 on my local machine, but cannot manage to even set up the
linked (sybase) server.
I'm currently working around it by creating a new MS Access database,
importing the relevant data into there as a snapshot and now the
intention is to import that data into SQL 2005....just waiting for the
truckloads of data to come across the network, one electron at a time!
Obviously this is NOT a good workaround - anyone with any suggestions
as to how I could set it up so I could actually SEE the sybase db, I'd
be most appreciative
cheers,
niall
Soren S. Jorgensen wrote:
*Hi,
I have set up a linked server on our SQL2005 using MSDASQL that maps
to a
system ODBC dns pointing to a Sybase server.
The Sybase OLD DB Provider is very unreliable, so we have to use the
ODBC
thing.
I can select, delete and update tables in Sybase using the linked
server,
but cannot do inserts!
I have tried using the ODBC connection from another app where the
insert
goes well.
OLE DB provider "MSDASQL" for linked server "SYBASE" returned
message
"Unspecified error".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "SYBASE" could not
INSERT
INTO table "[SYBASE].[mydatabase].[dbo].[mytable]"
Has anyone seen this before ??
Kr. Soren *
--
Niall Baird
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message2491603.html
.
- Prev by Date: Connection problems to SQL2005 with odbc using port 1733
- Next by Date: ODBC: Call Failed 3146
- Previous by thread: Connection problems to SQL2005 with odbc using port 1733
- Next by thread: ODBC: Call Failed 3146
- Index(es):
Relevant Pages
|
