Question about Sybase SQL Anywhere Studio for Workgroups - ( v. 9.x ) - license (1838109)

1 Answer

DTS MS SQL 2000 to Sybase

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')
VALUES ('abc')

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.

SELECT @@version
--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)
GO


-- Adding linked server:
exec sp_addlinkedserver @server = 'Linked' ,
@srvproduct = 'Sybase',
@provider = 'MSDASQL',
@datasrc = 'sybase' -- dsn (Control Panel)
GO

-- Adding linked server login:
sp_addlinkedsrvlogin @useself='f alse ', @rmtsrvname = 'Linked',
@rmtuser = 'sa',
@rmtpassword = ''
GO

EXEC sp_linkedservers
GO

SELECT *
FROM OPENQUERY(Linked, 'Select * from mysybase..emp')
GO

INSERT OPENQUERY (Linked, 'SELECT eno,ename FROM mysybase..emp WHERE 1=2')
VALUES (4,'Tom')

(Both tables have the same structure)

Posted by on

  • ahead Mar 17, 2008

    Thanks mcc99,

    Main issue is to link MS SQL Server to Sybase.
    If aay one can help me on this.

    Regards

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

Try using a transaction block.

Posted on Mar 15, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

14 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

6 Answers

How to recover SQL server mdf files?


RecoveryFix for SQL database recovery software is recover and repair MDF files components from corrupted SQL server database. This software compatible with Windows 7, Server 2008, Vista, Server 2003, XP and 2000. More details see this site: http://www.en.repairsqlserver.net/ or download this tool from http://www.en.repairsqlserver.net/free-trial.html

May 06, 2014 | Microsoft Database Software A5K-02817 SQL...

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | Compilers & Programming Tools

5 Answers

Need Help to backup SQL database in safe mode


kindly choose the option safe mode with networking and then try.

Sep 10, 2009 | Microsoft Compilers & Programming Tools

1 Answer

How to make a connection with sybase using jtds driver


hi,

the first thing you need is the correct JDBC driver, that must be included with your database.
Then you need to create a connection using the driver.

This link could help.

http://www.redmountainsw.com/wordpress/archives/jdbc-connection-urls

regards

Mar 13, 2009 | Sybase SQL Anywhere Studio for Workgroups...

1 Answer

Unable to create database from within VWD 2005 Express


try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

Dec 01, 2008 | Compilers & Programming Tools

1 Answer

I want to install SQL server2000 free!


you cant get sql server 2000 free, but you can get sql 2005 express edition free. http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en this is the link to download SQL 2005 express edition. This is same as SQL 2000 if you just want to work on queries.

Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...

1 Answer

Need sloution for ---


plz change replce the name of Data provider object ODBC with OLEDB.
i hope the exception will be vanished.

Oct 07, 2008 | Compilers & Programming Tools

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

272 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sybase Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Fred Block
Fred Block

Level 2 Expert

289 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Are you a Sybase Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...