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

×

Ad

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Which database can I use with ColdFusion?


ColdFusion supports ODBC-compliant databases. With Net Nation's ColdFusion plans, you can use a Microsoft FoxPro, Microsoft Access or Microsoft SQL Server database. ColdFusion supports both DSN and DSN-less connections.

Oct 09, 2014 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Re if I need create odbc dsn for all workstation?


Use servername as the server in setup and it will autocreate servername32 in odbc

May 15, 2010 | ACCPAC Simply Accounting 2004 PRO...

3 Answers

Visual Basic and SQL


Hi,

Visual Basic 6.0 and MS Sql server 7 or 2000 are highly compatible with each other. VB.net is compatable with sql 2005 which is inbuilt as well.

Jul 07, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

I am trying to connect to a SQL Server 2005 DB from Visual Studio


You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.

Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition

1 Answer

How can i connect the data base during my project


That seems fine.

I cant assume your level of confidence in programming, however, following are some simple steps you can follow to achieve (for complex implementations, much more time and details will be needed, i can help u with them as well)

1. Create a database in Access ( i assume u r using Access 2003)
2. Create a System DSN (if aren't clear, how to create then goto administrative tools under control panel and you'll find Data Sources (ODBC), here u need to create System level DSN for Access driver (may be Jet 4.0+)
3. In java, you need to import java core libraries for sql (javax.sql package specially)
4. you are almost done, just google for database code in java, simple code will be around 5-10 lines (just for your reference, search with these keywords, ClassName(""), jdbc:odbc:YourDSN)
5. Open a connection using Connection object
6. Fetch the records (select query) using Recordset object
7. You're done.

thanks
Kuldeep

Mar 13, 2009 | HP Computers & Internet

1 Answer

ODBC


give ur add i want to check it out.

Aug 26, 2008 | Microsoft Windows Server Standard 2003 for...

2 Answers

How to configure odbc for multiple user in windows 2003 server


You can also try adding the datasource as a System DSN instead of a User DSN. Of course, all users on a given system will then have access.

Apr 03, 2008 | Microsoft Windows Server Standard 2003 for...

1 Answer

MSSQL Related Problems


Please see link below http://www.php.net/function.mssql-connect

Basic tutorial in connection PHP Language to MS SQL Server.

Please rate me SOLVED.

Nov 22, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

273 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sybase Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Sybase Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...