Connecting To Sybase

Jan 30, 2006

Hi,

I am assuming someone has had success connecting to Sybase from SSIS. I am having trouble. And I freely admit naivety when it comes to something like this. :-)

I installed dbConnector 6.01 which has a Sybase connector as a part of the package. I then tried to create a connection manager for Sybase using OleDb, but it was not an option in the list of OleDb connections. So, am I correct in assuming that I need to use ODBC? If so, is there an OleDb Sybase driver that can be used with SSIS?

Any help in using SSIS to connect to Sybase would be appreciated.

Thanks,

- Joel

ADVERTISEMENT

Connecting Sybase

Nov 7, 2006

Hi there

I want to pull data out of sysbase database.

Could you tell me which connection should I use to connect to sybase database?

Rahul Kumar

View 4 Replies View Related

Connecting To Sybase From SQL Server

Dec 14, 2001

Hi,
I have a situation where in I need to insert a record in sybase database table whenever there is an update on a table in my sql server database.
Can any one suggesst me hoe can I do it?
thanks In advance
Mohan

View 2 Replies View Related

Connecting To Sybase From MS SQL Server 2000

Feb 24, 2003

I've installed Sybase client 12.0 and have created the DSN (it is successful, connection is established)
but when I run this ActiveX Script from DTS Package it give me error Data Source Name not found and no default driver specified

Dim RS
Dim oConn

Set oConn = CreateObject("ADODB.Connection")
msgbox "set oConn"
Set RS = CreateObject("ADODB.Recordset")
msgbox "RS"
(I've tried both open statement in both it gives me same error)
oConn.Open = "Driver={Sybase ASE ODBC Drivers};Srvr=Server1;Uid=sa;Pwd=password"

oConn.Open="DSN=Test;Uid=sa;Pwd=password"
msgbox "open"

Can anyone guide me?

Thanks in advance

-Sejal

View 2 Replies View Related

Sybase 15.xxx Version (linking Sybase To Sqlserver 2005)

May 18, 2008

hi,

i tried the document below pertaining to linking sybase 12.5 to sqlserver 2000 and sqlserver 2005

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=311875&SiteID=17
http://www.sybase.com/content/1029118/1029118.doc

but when our company upgrade the sybase to 15.x i can't find the oledb configuration stated on the document.

so i can't linked the sybase 15.x now to sqlserver 2005. can somebody help me.!!!please...

where i can find the oledb configuration in sybase 15.xx..

tnx..

View 1 Replies View Related

SQL V Sybase

Jun 13, 2007

Hi All.

Can anyone tell me if a Sybase database will run on SQL 2000?
Can this be done?

Cheers
Phil

View 2 Replies View Related

Sybase And MSSQL

Apr 20, 2004

Hi Everyone -

I have a master database (sybase) that is in place as a company
legacy server -

I am setting up a web server to act as an intranet and data entry
terminal system.

I want to ultimately remove sybase from the picture, but
for now, i need to grab information from the sybase server
and populate the MSSQL database with the values from the
sybase database.

So my question is this -

Is there a way to setup a "auto polling" or synching between the MSSQL
and the sybase system.

If there isn't then i will need to do a DTS job to grab the values from
the sybase ODBC connection, and populate my database that way -
but there must be another way to accomplish this task.

thanks

take care
tony

View 3 Replies View Related

SYBASE To SQL Server 7.0

Jun 19, 2001

Hi all,

A question that may have been asked on many occasions, but what can be advised as the best way to migrate a Sybase 11.x DB to SQL 7.0, (without using BCP). Does DTS support such migrations and if so, where in DTS can this be done? I'd appreciate any basic help here to get me started on this exercise. MAny thanks

View 2 Replies View Related

SQL 2000 Vs Sybase On NT

Dec 13, 2000

We plan to convert our current OLTP intensive application from Sybase on NT to SQL 2000.
Which one is the winner in terms of performance. I was told that SQL Server has less tools
to tune the database especially for OLTP intensive database.

Have you done any test comparing the performance between Sybase and SQL server?
What is your opinion on this? Do you know any good third party tools to tune SQL 2000?

Thanks!

View 1 Replies View Related

MS SQL Server Vs Sybase

Mar 18, 2003

Hello,

We have Trading Applications (Equities & Portfolio written on C++) on MS SQL Server 2000. Now the management is deciding to move it on Sybase 12.5. We currently don't have any issues on any matter, but because everyone is SYbase fan here, thinks applications are critical and we need to move to Sybase. Can anyone who has worked on both knows the major pros & cons of both the system. Actually I wanted these systems to be on MS SQL Server. I need solid reasons except being cheaper than Sybase to show why we should use MS SQL Server

If anyone can share their experiences, it would be really great.

Thanks
Sejal

View 2 Replies View Related

SQL Conversion From Sybase

Aug 11, 2003

I have the following SQL statement from a Sybase 5 database and I don't know how to get it to work in a SQL 7 database. Any help much appreciated.

TIA,
DBA without the PAY

SELECT firms.id,
firms.description,
firm_mailing_addresses.firm,
firm_mailing_addresses.address1,
firm_mailing_addresses.address2,
zip_codes_a.city as mailing_city,
zip_codes_a.state as mailing_state,
firm_mailing_addresses.zip_code as mailing_zip,
firm_mailing_addresses.zip_plus4 as mailing_zip_plus4,
firm_physical_addresses.firm,
firm_physical_addresses.directory_phone,
firm_physical_addresses.address1,
zip_codes_b.city as physical_city,
zip_codes_b.state as physical_state,
firm_physical_addresses.zip_code as physical_zip,
firm_physical_addresses.zip_plus4 as physical_zip_plus4
FROM {oj {oj firms LEFT OUTER JOIN firm_physical_addresses
ON firms.id = firm_physical_addresses.firm}
LEFT OUTER JOIN firm_mailing_addresses
ON firms.id = firm_mailing_addresses.firm},
{oj firm_physical_addresses LEFT OUTER JOIN zip_codes zip_codes_b
ON firm_physical_addresses.zip_code = zip_codes_b.zip_code
AND firm_physical_addresses.zip_plus4 = zip_codes_b.zip_plus4},
{oj firm_mailing_addresses LEFT OUTER JOIN zip_codes zip_codes_a
ON firm_mailing_addresses.zip_code = zip_codes_a.zip_code
AND firm_mailing_addresses.zip_plus4 = zip_codes_a.zip_plus4}
WHERE firms.id = 120

View 4 Replies View Related

Sybase To MS SQL 2000

Apr 18, 2001

I will be migrating Sybase Databases (and Centura) to MS SQL Server Databases. While I have administered MS SQL Server for many years, I have never administrated or even saw a Sybase database. My question, can anyone suggest any books to get me up to speed on Sybase, so I can transfer all databases, including tables, procs, etc... to MS Sql Server?

Bill

View 2 Replies View Related

MS SQL And Sybase SQL Conflict

Jul 22, 2004

has anyone had sucess in troubleshooting conflicts between these two?

I need to shut down the sybase client on a machine that is running MS SQL if thats possible.

View 3 Replies View Related

DTS-Conection With Sybase 12.5

Sep 3, 2004

Good day.I have dts running every 10 minutes in a server of slqserver 2000 who is in a country and that it sends data to another country which has a data base sybase12.5.The problem is when by reasons for the WAN the connection fails from a country to another one the dts or job fails executing its processes and I must soon give click to stop and start so that it continues. That I can do so that when the connection is lost and i need to dts reconected automatically and is continued its processing?
thanks and sorry my english :)

View 1 Replies View Related

Integration With Sybase

Sep 3, 2004

If I need to have SQL Server be able to query a Sybase database on another machine (Adaptive Server anywhere 7.0.2 with an ODBC connection), what is the simplest, least expensive way to do this ?
Thanks

View 1 Replies View Related

Coming From Sybase

Oct 6, 2004

Coming from Sybase env. I would like to know the equivalent of sp_showplan. What it does is, it shows the showplan for the query being run by spid, which is passed as a parameter to sp_showplan.

Thanks for your help.

View 3 Replies View Related

Sybase + SQL Server 2K

Mar 30, 2006

Hello!

Has anyone ever experienced compatibility and/or performance issues when SQL 2K and Sybase are run concurrently on the same server? I believe the server is using Windows 2K3.

Thanks!

View 5 Replies View Related

Sybase And Eaglesun

Apr 18, 2008

My tribe is creating a central database, running Sybase 5 and Eaglesun. I’m curies if anyone has worked with Eaglesun and if you had any issues with the software or with data conversion??

Thanks for the input

US Navy - We are fueled, armed, and go for launch.

View 2 Replies View Related

Sybase Basics

May 19, 2008

Hi Gurus,

I am not sure is this the right forum to get solution to my question.

From where i can get sysbase basics.
I am posting this query in this forum coz this forum and gurus in this forum had helped me in lot critical situtions.

Hope this happens now also..

Thanks,
ServerTeam

View 2 Replies View Related

Interview On Sybase

Jul 5, 2006

Hi,

I know sql and Dataware housing.I got a job offering for sybase sql but I don't anything about sybase.Will it be in programming in Actually what we will do in sybase? What will be the nature of work? and I just want to know what type of question will be asked ? Please do reply.

Regards,
Raji

View 1 Replies View Related

SQL Everywhere Is A Sybase Trademark

Apr 30, 2006

It's all well and good that Microsoft has finally entered the well-established mobile database market (the market that iAnywhere Solution's SQL Anywhere product current *owns* by a wide margin). However, it should be noted that "SQL Everywhere" is a Sybase trademark. For confirmation of this fact, see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.mro12.6.mro126ig/html/mro126ig/legal.htm

For confirmation of the fact that SQL Anywhere owns the mobile database market, note that it is the database of choice for the 500,000 mobile devices that will be used in the 2010 US Census; see http://www.internetadsales.com/modules/news/article.php?storyid=7347

Breck

View 2 Replies View Related

Write To Sybase ASE/IQ?

Nov 30, 2005

Is there a way of writting into Sybase ASE/IQ?

View 1 Replies View Related

How Connect Sybase ASE 12.0 - OLE DB????

Aug 6, 2007

Hi:

How connect Microsoft Visual Studio BI with Sybase ASE 12.0 (not 12.5.x) database via OLE DB?

I try with "Srvr=,[PORT];Catalog=[DBNAME];User Id=[USER];Password=[PASSWORD];" but error

"Error en la conexión de prueba debido a un error al inicializar el proveedor. El proveedor 'Sybase.ASEOLEDBProvider.2' no está registrado en el equipo local."

Thanks

View 1 Replies View Related

Sybase IQ As A DB Destination?

Aug 21, 2007

I found a post from over a year ago saying that Sybase IQ as a DB Destination is not supported by SSIS (there was a hack, but not something for a strategic solution).

Has there been any change to this in the mean time?

Is there anything in the pipeline?

Thanks,

A Sak

View 9 Replies View Related

Using DTS To Return Data From SyBase - Need Help !

Jan 5, 2004

Hi,

A partner company unfortunately chose Sybase SQL Anywhere v5 as their database and I have to return data from the tables for a web service that I am writing - YUCK !

The ODBC driver is riddled with errors and has no support. Third party .NET providers do not seem to support v5, so I have resorted to playing with DTS in Enterprise Manager.

After fumbling around for a while, I managed to get an "Execute SQL Task" to return data and saved the package in both SQL and VB.

Now, before I waste any more time heading in this direction, can anybody advise if DTS is supported by MSDE as the full blown SQL Server will not be an option ?

If it is supported - is this a good way to go, or is there a better solution ?

Thanks in advance.

Steve.

View 2 Replies View Related

Migrate Sybase To MSSQL 7.0

May 11, 2001

Since I'm not a native English, sorry for my poor English.

I want to migrate the current Sybase database to MSSQL 7.0, can anyone tell me the procedure to accomplish. Thank you.

Regards,

Kung Wu

View 2 Replies View Related

MS SQL 7.0 To Sybase Via Linked Server With OLE DB

Jul 5, 2001

We have created linked servers that connect to Sybase databases using the Sybase OLE DB provider and the Sybase ODBC provider.

The OLE DB provider does not allow the execution of a stored procedure. The message sounds like a permissions issue, but the id specified in the linked server has execute priv. for the stored procedure. It also does not allow the fully qualified name <server>.<db>.<owner>.<obj> to be used.

There are other issues with OLD DB and ODBC.

Anyone have any experiences making MS SQL to Sybase work smoothly?

View 3 Replies View Related

Sybase ASE ODBC Driver

Feb 8, 2005

Hello,

I would be grateful if you could show me where I can download SYbase ASE ODBC Driver. I have searched almost the whole WEB for it but so far to no avail.

Thanks in advance.

Albert

View 2 Replies View Related

Sybase Stored Proc

Sep 26, 2005

Hi,

Can anyone tell me if it is possible to use a Sybase Stored Proc as a dataset in RS? There is only the text option in the Command Type drop down list for the dataset.

I am using an ODBC driver to connect to the Sybase db, there is no OLE DB provider installed.

Cheers,

View 2 Replies View Related

MSSQL/NT Or Sybase/Unix For WEB

Dec 22, 1998

Is anyone has an experience with choosing
between MS SQL7 (or 6.5) on NT Server box
and Sybase on Unix (UnixWare 2) box to
use this server as WEB server?
Could you tell just a couple of advantages
and disadvantages of each of those systems,
or to point me at the source of useful
for this compare information.
Any help is very appreciated.
Thanks

View 2 Replies View Related

Convert The Database From Sybase 11.0.3 To MS SQL 6.5

Nov 9, 1998

Hi! We are trying to convert the database from Sybase 11.0.3 to MS SQL 6.5. Is there any quick/easy way to do the conversion without using bcp? any third party software we may use to make the conversion easier? Thank you very much!

View 2 Replies View Related

Views Pointing To Sybase

Dec 13, 2004

Hi all,

I am new to this so take it slow. I want to build views on SQL Server that points to a db on Sybase. Is this possible? Pro and cons?

View 1 Replies View Related

Connect To Sybase In A DTS Package

Mar 2, 2005

How would I connect to a Sybase ASE 12.5 Server in a data transformation step in a DTS package (MS SQL Server 2000)? I am not sure of the driver to specify, etc.

Thanks.

View 2 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved