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)
a 6ya Technician can help you resolve that 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 09, 2014 | Oracle 10g Database Standard (ODBSEONUPP0)
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: