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


ADVERTISEMENT

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 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

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

View 6 Replies View Related

SQL Server 2000 & Sybase Replication

May 20, 2002

Hi all,

I'm trying to configure replication between a Sybase ASE Database Server and SQL Server 2000. Sybase ASE Database will be the Publisher and SQL Server will be the Subscriber. Can anyone advise me on how I can go about setting up the replication for this?

Thanks!

View 1 Replies View Related

Conversion From Sybase To SQL Server 2000

Oct 15, 2004

Hi,
Could anyone refer me any kind of tools or process to convert from SYBASE to SQL SERVER 2000.
My complany is trying to migrate from SYBASE to SQL SERVER 2000.
Any help is greately appreciated!
Thanks.

View 2 Replies View Related

Synchronize Sybase And SQL Server 2000

Nov 29, 2005

Hi All,

Could anyone please let me know which is the best way to Synchronise a Sybase database with a MS SQL Server 2000 database.That is , the changes made in the Sybase database should be reflected in the SQL Server database.

Thanks in advance !!

regards,

Hari Haran Arulmozhi

View 3 Replies View Related

Sync Sybase And SQL Server 2000;

Mar 15, 2006

Hi all,

I have a module in power builder with Sybase database as its backend. The other modules related to the same application are running on Delphi with SQL server as backend.

My requirement is to sync between the Sybase database and SQL server (2000) in order to update the SQL server with all the transactions ( online ) done in the Sybase database.

Thanks in advance ,

Hari Haran Arulmozhi

View 2 Replies View Related

Migrating Sybase To SQL Server 2000

Feb 25, 2008

Hi all

I try to migrate sybase to SQL Server 2000, but found a los of trouble, please, some can help me to resolve this???

May many of that are easy to resolv, but is mi fist time with SQL Server 2000... plz, help :(

Object : Procedure
Error : Sintaxis incorrecta cerca de la palabra clave 'cursor'.
Code :

Create Procedure ABA_CenResul
as
Begin
declare @EST_CEN_Codigo char(8),
@EST_CEN_Descripcio char(100),
@n char(100),
@name char(100),
@salida char(8),
@vble int,
@ini int,
@ter int,
@indice int,
@aux_descripcion char(100)
declare sonido cursor
for
select EST_CEN_Codigo, EST_CEN_Descripcio
from EST_CenResul
open sonido
fetch sonido into @EST_CEN_Codigo,@EST_CEN_Descripcio
select @EST_CEN_Descripcio = @EST_CEN_Descripcio + " "
select @aux_descripcion = @EST_CEN_Descripcio
while @@sqlstatus !=2
begin
select @indice = 1
while @indice <> 4
begin
select @vble = patindex("% %",@EST_CEN_Descripcio)
select @ter = @vble - 1
select @name = substring(@EST_CEN_Descripcio,1,@ter)
if @indice = 1
select @n = @name
else
select @n = @n + "/" + @name

select @ini = @vble + 1
select @EST_CEN_Descripcio = substring(@EST_CEN_Descripcio,@ini,100)
select @indice = @indice + 1
end
print @n
exec sdxsrvr...soundex @n, @salida out
update EST_CenResul
set EST_CEN_Soundex = @salida
where EST_CEN_Codigo = @EST_CEN_Codigo
fetch sonido into @EST_CEN_Codigo, @EST_CEN_Descripcio
-- select @EST_CEN_Descripcio = @EST_CEN_Descripcio + " "
-- select @aux_descripcion = @EST_CEN_Descripcio
end
close sonido
deallocate cursor sonido
end



Thnx in advance

View 2 Replies View Related

Import Sybase Db To Sql Server 2000

Mar 3, 2008

How can import sybase db (sql any where) to sql server 2000 ?
sybase can be imported to sql server how ?

I try to import but there is no option to import sybase db
by tool -> data transformation services -> import / export data

Regards
Mateen

View 2 Replies View Related

Upgrading From Sybase Sql Anywhere 5.5.04 To SQL Server 2000

Jul 20, 2005

Has anybody had any experience of this??We have over 2000 stored procs to convert from Watcom SQL to SQLServer 2000. Any automated tools would be much appreciated!!Also any known issues.

View 1 Replies View Related

Migrating Sybase Databases To SQL Server 2000

Apr 27, 2004

Just a quick question, does anyone know any major issues with Migrating Sybase Databases to SQL Server? Just wondering if their any oddities I should be aware of? Thanks nixies

View 2 Replies View Related

Control Transaction In Sybase Database Using Sql-server 2000

Apr 20, 2004

Can anyone help me with this scenario!!!!
I have a sybase database and a sqlserver 2000 database.
I want to insert data into sybase database table thru sql-server 2000 using distributed queries
When i execute the following the transaction


Create procedure myCurrentDataBaseProcedure
as
begin

begin tran
insert into mytable values(1)
if @@error <>0
begin
rollback transaction
return
end
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
if @@error <>0
begin
rollback transaction
return
end
commit transaction
end

The procedure is created in sql server database
trying to execute this procedure..shows error
The first part of the procedure is executed.

But the error is here
insert into sybasedatabaseserver.databasename.dbo.tablename values(1)
The data is succesfully inserted in the local database
I am unable to insert data into the remote database
Can anyone suggest me wht shd i do in this scenario
Are there any drivers to be loaded to commit this transactions

Pl.Help

View 5 Replies View Related

Is SQL Server 2000/5 Compatible With Sybase 15 OLEDB Drivers?

Apr 10, 2008



I have been having tremendous trouble getting OLEDB connections to Sybase that I use within SQL Server 2000 and SQL Server 2005 to work properly - they always seem to revert to the older, third party Sybase drivers if they are installed on the machine and just generally cause problems - I have given up on using them within an SSIS package all together and gone down another route.

Can anyone confirm to me whether or not this is because the version 15 native drivers that Sybase provide are not supported by SQL Server, please?

Thank you

View 1 Replies View Related

Linked Server From SQL Server 2000 To Sybase 12

Apr 26, 2004

:confused:
How do I tap advanced functionality like #temptable and @var from openquery? There is a linked server from SQL Server 2000 to Sybase 12 using Sybase.ASEOLEDBProvider.
Executing an openquery statement from MS SQL will retrieve Sybase data; however, I have no advanced functionality available. When I try to use temporary #tables or declare @vars it returns this error...
Server: Msg 7357, Level 16, State 2, Line 1, Could not process object '…OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='Sybase.ASEOLEDBProvider', Query=…

Linked Server configuration:
Provider options: AllowInProcess is checked
Server options: Collation Compatible, Data Access, RPC and RPC Out are checked

Does anyone have a suggestion or alternative for this functionality? Thank you very much for your input.

View 6 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

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

Connecting To Sql Server 2000 In A Lan

May 22, 2007

Hi there,
I have 2 servers on our compny'ssql server does not exist or access denied lan, one with fixed ip and the other one with internal ip. I installed SQL server 2000 on the one with internal ip and I want to access it from the other server. when I want to register sql server instanse , I can see the name of that instance in the list but I can't register it. I keep reciving this error  : sql server does not exist or access denied!
Could any one told me what to do?

View 2 Replies View Related

Connecting To SQL Server 2000

Dec 23, 2005

Hi
I am running Visual Studio 2005 Visual Web Developer Standard Edition on a machine with SQL Server 2000.   Could you please teach me how to modify the connection string below so that it connects to SQL Server 2000 with the database called "VisualWebDev".
Thank you.
Jim
 
<connectionStrings>
<add name="Personal" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Personal.mdf" providerName="System.Data.SqlClient"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf"/>
</connectionStrings>

View 12 Replies View Related

Connecting To SQL Server 2000

Jul 23, 2005

Hi,I am total newbie to SQL Server. My new host tells me I can connect throughAccessXP or 2002. I have Access 2000. Can I not connect with that also?Thanks, JA

View 4 Replies View Related

Urgent!!! Migrate Sybase To MSSQL 2000

Jun 15, 2001

I've try to use DTS to import data from Sybase 11 database to MSSQL2000 database. After the import process completed, I found that all the Keys, triggers disappeared. How do I solve the problem???


Kung Wu

View 1 Replies View Related

Connecting To The Database In SQL Server 2000

Jan 31, 2007

I am developing a system using VS 2003 with database SQL Server 2000.
In web.config,  I have added the following code in it
    <sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=127.0.0.1;Database=grandb;Trusted_Connection=yes"
            cookieless="false"
            timeout="60"
    />
 
Actually I don't know if the above code is correct. My database is stored in the SQL Server 2000 and named as grandb.
Thank you.

View 3 Replies View Related

Connecting To MS SQL Server 2000 From The Different Domains Using Asp.net

Jul 24, 2007

Hi,
      My problem is somewhat like this that, i want to connect my all applications (developed in asp.net)  to one database. In other words i want to make a centralised database that can be accessible from the application running at the different domains. When i did so  by using the same username, password, database and server...i recieve an error that, "connection cannot be establised".
If any body have the solution for this problem. then please do write the "connection string"  for me that can be efficiantly used on the applications running on differnt domains.
Thanks and Regards,
Steve Dcosta
 

View 1 Replies View Related

Connecting Aspx To SQL Server 2000

Jul 24, 2007

Hello All,
 I am just getting started on aspx, coming from an asp background.
I created the following connectionString in my web.config file:<connectionStrings>
<add name="OuWebDB"
connectionString="server=OurServer;database=OurDatabase;uid=TheUser;pwd=ThePassword"providerName="System.Data.SqlClient"
/>
</connectionStrings>
 
when I run this aspx file, from a machine, I get the following error:
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Help!!
 
thanks

View 3 Replies View Related

Connecting To Northwind On SQL Server 2000

Jan 14, 2004

I've just installed SQL Server 2000 on my local machine. I'm using the following element in my web.config file for my connection string.

<add key="SqlNWind512" value="server=(local)141.705.84.745;database=Northwind;
user id=sa;pwd=h3fe8eq7;packet size=512;" />

Unfortunately, I'm getting the following error on my aspx page:

SQL Server does not exist or access denied.

I had no problem writing a connection string to connect to the MSDE installed on my computer, but making a connection to the Northwind database on my newly installed SQL Server 2000 Developer edition has been elusive to me.

I'm sure my IP address is correct. The authentication mode for logging into the database via Enterprise Manager is setup to require a password for sa. Therefore, I assume it's required in the connection string???

Maybe not so coincidentally, while I have been able to open this database through the Server Explorer in VS.NET, I'm not able to access it via Enterprise Mananger (no response, it just hangs) or my aspx pages.

I'm dying here!!! Is my connection string wrong? Any insights would be greatly appreciated!

View 3 Replies View Related

Problem Connecting To SQL Server 2000

Mar 15, 2004

We have installed SQL Server 2000 in our new server running on Microsoft Windows Server 2003.

We tried to connect to the database in the Server where it is installed. We are able to connect when we give server name. We are unable to connect when we give IP Address of the server.

We have latest SP3a of SQL Server 2000 installed.

Could anyone help us in resolving this issue?

Thanks in Advance.

View 1 Replies View Related

Connecting To SQL Server 2000 On Another Subnet

Jul 23, 2005

Hi Folks,I'm very new to SQL Server. I have a home network. My primary connectionto the internet is using "Gateway 1" a linksys router, of which, my serveris a LAN node on that router. I have another LAN node connecting to the WANnode of the "Gateway 2" a wireless USR router to use with my laptop. Usingthe wireless laptop, I am on a different subnet than the Server. I'd liketo make a connection to the server through Visual Studio.net but I can'tseem to do it. I'm using TCP/IP with a port different than the default port(let's call it port 2110, even though it's not). I do have port forwardingon Gateway1 and I've tried everything from just the server internal IPaddress, the external IP address, IP address with port designation, URL withport designation, nothing seems to work. Any ideas?Thanks!Rick

View 1 Replies View Related

I Need Help Connecting Access 97 To SQL Server 2000

Jul 23, 2005

I have an Access 97 database that I connect to a SQL Server 2000through ODBC. I have to manually set up the ODBC connection on eachuser's machine if I want them to be able to use the application though.Is there a way to store the connection string within the Access DB soI don't have to touch the ODBC settings on each user's machine? Or isthere a different solution that I'm missing? There are way too manyfor me tosetup. Thanks in advance.

View 1 Replies View Related

Connecting SQL Server 2000 From Different Domain.

Apr 24, 2007

Please help to connect SQL server 2000 on different domain.
Please correct if I m wrong.

System details as follows

Client
Domain : DomainA
System : System1
IP Address : 10.10.225.19
SQL server 2000 installed


SQL Server
Domain : DomainB
System : System2
IP Address : 10.108.22.19
SQl Server : System2inst2 ( My database is under inst2 instance)
SQL login : TestUser1
Password : Users123


I have Opened firewall port to access 10.108.22.19 from 10.10.225.19

While connecting the SQL server €śSystem2inst2€? from the client machine enterprise manager with the SQL authentication, I am getting error Login failed for user €śTestUser1€?

And I have noticed in the SQL server log the login attempt shows under System2 default instance ( no instance). Actually I want to connect system2inst2.

Please let me know the steps to connect.

Thanks in advance.

View 3 Replies View Related

Sybase 9.0.2 + MS Reporting Services 2000 - RS Missing Parameters

Aug 15, 2007

People, help me with this? Already broke my brain.

I have some data on Sybase 9.0.2.3198,
i'm tryin to render report with MSSQL ReportingServices 2000 Eval SP2.


the report designer is fyiReportDesigner 3.0 - and I can do preview with it.

after deployment I'm tryin to render it, RS gives me an error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'Data'. (rsErrorExecutingCommand) Get Online Help
Column '@start_date' not found


I tried connect through ODBC and OLEDB both - same result.


ps I'm gonna kill somebody real soon.


the sql:

WHERE PERIOD.BEGINDATE between CAST(@start_date as timestamp) and CAST(@end_date as timestamp)

these are the RDL-file pieces:

<QueryParameters>
<QueryParameter Name="@start_date">
<Value>=Parameters!start.Value</Value>
</QueryParameter>
<QueryParameter Name="@end_date">
<Value>=Parameters!end.Value</Value>
</QueryParameter>
</QueryParameters>


<ReportParameters>
<ReportParameter Name="start">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2007-08-15</Value>
</Values>
</DefaultValue>
<Nullable>false</Nullable>
<AllowBlank>false</AllowBlank>
<MultiValue>false</MultiValue>
<Prompt>Start</Prompt>
</ReportParameter>
<ReportParameter Name="end">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2007-08-15</Value>
</Values>
</DefaultValue>
<Nullable>false</Nullable>
<AllowBlank>false</AllowBlank>
<MultiValue>false</MultiValue>
<Prompt>End</Prompt>
</ReportParameter>
</ReportParameters>

View 5 Replies View Related

Issue Connecting To A Remote SQL Server 2000

Mar 11, 2007

I get the following error message in quotes. I have a web application written in ASP.NET 2.0 through which I am trying to connect to a remote SQL Server 2000. My operating system is Windows Vista .
I looked at many different sites to find a solution for this but without any luck. I am sure someone would have seen this issue here and I expect them to shed some light. 
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).
The connection string is located in my web.config file which looks like
 <add name="AMSConn" connectionString="Data Source=xxxx;Initial Catalog=testdb;User ID=sa;Password=xxxx" providerName="System.Data.SqlClient" />
I want to get this issue resolved and I need you guys help.
Please let me know if you need any more information.
Thanks
Bharat 
 

View 3 Replies View Related

Getting When Connecting To SQL Server 2005 Error Using MS SQL 2000?

Jun 8, 2007

I'm new to using VS2005 and this is my first project connecting to our MS SQL 2000. App worked fine on my dev PC, connection to the same MS SQL Server. Published the web site to the web server (same server running MS SQL Server) and getting the below error. Is this a permission setup problem on SQL Server or does it really think it's connecting with a MS SQL 2005 database?
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

View 16 Replies View Related

Error Connecting To Remote SQL Server 2000 From ASP.NET 2.0

Jul 11, 2007

My environment is Windows Server2003, ASP.NET 2.0, SQL Server 2000 using SQL authentication (names of DB's, sql id's, passwords are identical on both servers)
My web application successfully connects to my database  the web app and the DB are both on the same server (10.144.25.9).This connection string works:
<add name="DefaultDataTierConnectionA" connectionString="Data Source=10.144.25.9,1433; Network Library=DBMSSOCN; Initial Catalog=9D_SQL; User ID=******; Password=******" providerName="System.Data.SqlClient"/>
PROBLEM:
The problem occurs when the DB is mpved to the remote  SQL Server (10.144.25.10). I use almost the identical connection string except for the IP address which is changed to the remote machine. The db name, user, password is same on remote machine as on the local, so everything should work but does'nt. This connection string fails:
 <add name="DefaultDataTierConnectionA" connectionString="Data Source=10.144.25.10,1433; Network Library=DBMSSOCN; Initial Catalog=9D_SQL; User ID=******; Password=******" providerName="System.Data.SqlClient"/>
error (odd error in that I'm connecting to SQL 2000?)  -
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
There is no DBA on this project, I'm not sure this is a SQL Server set up problem?  
 
 

View 1 Replies View Related







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