Question about Sybase SQL Anywhere Studio for Workgroups - ( v. 9.x ) - license (1838109)
I want to run a DTS between MS SQL Server 2000 and Sybase ASE 12.5.
I have created a DSN (ODBC). However I am unable to perform the same.
Below is the query
INSERT OPENQUERY (mysybase, 'SELECT name FROM mytestdb.table1')
Whenever I run this query the system lets me add a single transaction but if I run t he query a second time I get an out of memory exception. To resolve the same I need to restart the MS SQL Server before I can insert another row. Please suggest where am I going wrong.
Below is a trace of the tasks that I am performing.
--Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
--Copyright (c) 1988-2003 Microsoft Corporation Enterprise Evaluation Edition on
--Windows NT 5.1 (Build 2600: Service Pack 2)
-- Adding linked server:
exec sp_addlinkedserver @server = 'Linked' ,
@srvproduct = 'Sybase',
@provider = 'MSDASQL',
@datasrc = 'sybase' -- dsn (Control Panel)
-- Adding linked server login:
sp_addlinkedsrvlogin @useself='f alse ', @rmtsrvname = 'Linked',
@rmtuser = 'sa',
@rmtpassword = ''
FROM OPENQUERY(Linked, 'Select * from mysybase..emp')
INSERT OPENQUERY (Linked, 'SELECT eno,ename FROM mysybase..emp WHERE 1=2')
(Both tables have the same structure)
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Oct 09, 2014 | Oracle 10g Database Standard (ODBSEONUPP0)
on Nov 12, 2010 | Computers & Internet
on Sep 07, 2010 | Computers & Internet
May 15, 2010 | ACCPAC Simply Accounting 2004 PRO...
Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition
Mar 13, 2009 | HP Computers & Internet
Apr 03, 2008 | Microsoft Windows Server Standard 2003 for...
273 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: