Sybase And SQLServer2005 Connection Problem

Aug 6, 2007

Dear all,

Installed sybase adaptive server Enterprize version 12.5.1 on Win2k3.

Database is working fine and started on Port No 2638.

While connecting to Sybase from Diver Sybase ASE ODBC Driver i am not able to connect to the database and getting error "connection time out" and "Verify Host Name and Port Number".

When i create a Connection from Integration Services 2005 i can connect to the Sybase Database and retive the table name but when i try to preview the table information i get the following error.

"Unable to retrieve column information from the DataSource".

Do i need to any other ODBC Driver to connect to sybase database.


regards,

sufian

View 2 Replies


ADVERTISEMENT

SSIS Project Failing To Run Even Though I Verified Remote Sybase Connection Via Connection Manager

Apr 7, 2008



When running the project in debug mode or non-debug mode, I get the following error from MS Visual Studio:

TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Package [Connection manager "SYBASE_CONNECTION"]: The connection manager failed to defect from the transaction.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------

Any ideas???

View 8 Replies View Related

Problem Of Connection With Sqlserver2005

Jul 18, 2006

Hello,I installed sqlserver2005_express on my PC (localhost) and I try to execute a sql query with ASP.NET.Here's my page :Dim mySqlConnection as SqlConnection = new SqlConnection("server=JOE10155SQLEXPRESS;Trusted_Connection=yes;UID=sa;PWD=xxxx;database=xxxx")    Dim mySqlDataAdapter as SqlDataAdapter = new SqlDataAdapter("SELECT * FROM Entreprise WHERE (EntrepriseNr =999)", mySqlConnection)    Dim myDataSet as DataSet = new DataSet()    mySqlDataAdapter.Fill(myDataSet,"Entreprise")The problem is :System.Data.SqlClient.SqlException: Autorisation SELECT refusée sur l'objet 'Entreprise', base de données 'xxxx', schéma dbo'.if someone have an idea?

View 1 Replies View Related

How To Connect Domain SQLSERVER2005 To WORKGROUP SQLSERVER2005

May 12, 2007

hi



COMPUTER-1



IP ::::: 129.100.100.5

COMPUTER NAME IS ::::: HASH

MEMBER OF DOMAIN

in this computer sqlserver express edition is installed, i want to remove this express becoz in configuration manager it show two SQLSERVER'S are running. when i browse from COMPUTER - 2 for network servers it show server name as HASH/SQLEXPRESS, but not the main SQLSERVER.





COMPUTER -2



IP::::129.100.100.142

COMPUTER NAME::: FEROZ

MEMBER OF WORKGROUP



can anyone help me how to connect these two computers and remove this express edition



iam new to sqlserver configuration



thanks in advance



waiting for eager reply

View 1 Replies View Related

Linked Server Connection To Sybase

Mar 11, 2004

Has anyone had problems using an OLEDB linked server connection to Sybase ASE 12.5? I'm having major performance problems when I use string criteria in the where clause. Queries that return 1 row and execute in less than a second using a native Sybase connection take 40 seconds to run using the linked server OLEDB connection. If I use ints in the where clause performance is almost exactly the same between native and linked connections.

Any ideas???

View 9 Replies View Related

How To Create A Connection Into Sybase Database

Sep 12, 2007

Hi, i already create a connection to sybase(ASA) with odbc from ssis (from "data sources" section). but when i try to make data flow source it cann't. so i try to make a connection using "data source views" but when the process comes to end, it becomes error. from my analysis, the Sybase db cannot accept sql command with "[]", because in the fase "data source views" i have to select one or more table, and the default microsoft is using "[]", like: select * from [dbo].[customer], but sybase db cannot handle this. does anyone have the solution for this? Thanks.

Sincerely

Yugicm

View 1 Replies View Related

Sybase Connection In Xml Config File - Help

Jan 31, 2007

Hi all

I'm trying to connect to a Sybase DB using an OLE DB connection. Now, it works fine when I run the project without the package config enabled, but when I add the Sybase connection to the xml config file, & enable it the connection fails.

This is the error I see in the progress Tab

[Connection manager "AcidPrd.basketUser"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80004005 Description: "Login Failed. Check for valid user ID, server name and password.". An OLE DB record is available. Source: "ASE OLE DB Provider" Hresult: 0x80004005 Description: "[Native Error code: 4002] [DataDirect ADO Sybase Provider] Login failed. ".

Can anyone help.

Thanks,

Jon

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

Can I Use Sqlserver2005 With Asp.net 1.1 ?

Feb 9, 2006

hie
can i use sql server 2005 along with asp.net 1.1 as my front end ?
any idea of doing this ?

View 1 Replies View Related

SqlCacheDependency With SQLServer2005

May 21, 2007

I have implemented a caching strategy using the sqlcachedependency and sql server 2005 backend using the broker service.This works fine and well when i am connecting to the SQL Server 2005 under service account that is in the role db_owner. In a production enivironment i am reluctant to do this so i created another service account that only has execute permissions on the stored procedures.When i use this limited service account for my ASP.net web application, the broker service does not send any messages to the web app to invalid the cache. When checking the event log and SQL profiler i get errors all relating to the user not having access to the SqlQueryNotificationService queue. So i did a lot of googling and tried running the grant scripts below with no luck using this limited service account. Keep in mind everything works fine if i use an account with db_owner priviledges. These are the grants i have tried based on numerious articles  GRANT CREATE PROCEDURE TO three_d_ss_loginGRANT CREATE QUEUE TO three_d_ss_loginGRANT CREATE SERVICE TO three_d_ss_loginGRANT SUBSCRIBE QUERY NOTIFICATIONS TO three_d_ss_loginGRANT RECEIVE ON QueryNotificationErrorsQueue TO three_d_ss_loginGRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO three_d_ss_login These are the grants i have tried that does not work GRANT SEND ON SERVICE::SqlQueryNotificationService TO three_d_ss_loginGRANT RECEIVE on SqlQueryNotificationService_DefaultQueue to three_d_ss_loginCan some one suggest what i need to do to get sqlcacheddependencies to work with a sql2005 backend under a limited priviledged service account?  ThanksJim 

View 4 Replies View Related

Xquery Help SqlServer2005

Nov 22, 2006

I have the following XML in an XML column in a SQL 2005 Database.<DeliveryList xmlns="http://schemas.adventure-works.com/DeliverySchedule"><Delivery SalesOrderID="43659"><CustomerName>Steve Schmidt</CustomerName><Address>6126 North Sixth Street, Rockhampton</Address></Delivery><Delivery SalesOrderID="43660"><CustomerName>Tony Lopez</CustomerName><Address>6445 Cashew Street, Rockhampton</Address></Delivery></DeliveryList>I need to query that column using the value method to retreive the addressof the first delivery. I come up with this,SELECTDeliveryList.value('data((/DeliveryList/Delivery/Address)[1])','nvarchar(100)')DeliveryAddressFROM Sales.DeliverySchedulebut it tells meXQuery [Sales.DeliverySchedule.DeliveryList.value()]: There is no elementnamed 'DeliveryList'I have tried every permutation of the path and I can not seem to get it towork? Any ideas?

View 2 Replies View Related

Upgrading To SQLServer2005

Feb 9, 2007

hi,

I'm using custom authorization in reporting services 2000 to restrict the users. To do this we created a dll customauthorization.dll and placed it in reportserver bin folder and performed changes in rsreportserver.config, rssrvpolicy.config, and web.config files. Now its time to upgrade our servers to SQLServer 2005. Now in SQLServer2005 what new enhancements were done with respect to security and what all extra steps should i follow to perform the upgradation with custom authorization. Please give me suggestions how to upgrade my reports to SQL2005 so that my custom authorization still works.

waiting for ur valuable inputs

uday

View 1 Replies View Related

Requirements For Sqlserver2005 Installation

Feb 23, 2008

hello,
What are the requirements to install sqlserver2005 in my pc.I am using windows xp sp2 in my pc.
One of my friend said, windows server2003 is compulsory(to get data base functionality in sqlserver 2005 and other features) in local pc .Is it correct?
And i am not getting database features in xp sp2.
Can any one help me?

View 2 Replies View Related

Filling A Table In Sqlserver2005

Apr 9, 2008

hello everyone
i have created a table in sqlserver2005  named "Departments" - in this table different departments of a telephone ( landline ) company are to be stored,which deals with complaints registered to them by there users.
i want to know the name of these different departments which deals with complaints assigned to them like if i do have complaint from a user who has problem with his handset then that complaint will be assigned to "Maintance dept."
as i was never in indusrty , i need the help in filling the table.
just do write me name of departments and the nature of complaints wh they deal with!!!
thanks for the consideration

View 1 Replies View Related

Sample Database About Sqlserver2005

Apr 26, 2005

I had installed the sample database " AdventureWorks ",but i couldn't find it in SQL Server Management Studio,and I noticed than it was installed into "Microsoft SQL Server 2005 Samples" directory,but not "Microsoft SQL Server" directory,what can I do to find the datebase.
I am a beginner,and learning sqlserver by using tutorials,someone help me?
many many thanks.

View 1 Replies View Related

Sending Mail From Sqlserver2005

Jun 29, 2007

Hi,

I have 0 experience with SQLMail, and I don't want to go too deep into it as I already am trying to learn more than I can with the other parts :) I'm wondering, is there an easy way to have SQL Email me when anything strange happens with the SQL server? It would be awesome to get alerts to my phone.

Thanks very much
mike123

View 4 Replies View Related

No Local Instance With SQLServer2005 Dev. Ed.

Oct 20, 2006

(New to SQL Server Installs)I installed SQL Server 2005 Developer Edition on a WinXP-SP2workstation and can see some enterprise databases on the network justfine.My problem is I cannot register a local database on the local drive fortesting/education purposes.(I accepted all of the defaults on the install and thought all waswell.)There are a couple of small databases that are in development in ourgroup and I need to work on when offline from the network.Short of uninstalling the whole product and doing it over, what stepscan I take to remedy this so I will be able to work with DB's locally?Thanks.

View 3 Replies View Related

Regarding Sqlserver2005 Clientserver Installation

May 6, 2006

How to install sqlserver2005?

View 3 Replies View Related

Remove SQLserver2005 Problem

Nov 11, 2007

hi all,
what is the best way to remove SQLSERVER2005 from my computer running XP-sp2
when i try to remove from tha ADD and Remove program from the control panel
it's start the wizard but going to stuck..

thankx

View 4 Replies View Related

Upgrade To Sqlserver2005 From Sqlserver2000

Dec 18, 2007

There is no prompt ' UPGRADE' when I install SqlServer2005
Also check select @@version after installed
Still be 'Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) '
Why does this happened?
OS is Windows2003 Server
Thanks

View 1 Replies View Related

How Can I Connect To Sqlserver2000 From Sqlserver2005

Sep 11, 2007



Hi,
Can any1 tell me how to connect to Sqlserver2000 from sqlserver2005 ...I cant see sqlserver2000 instance name when i try to search in database engine

With regards
mahender

View 1 Replies View Related

Order By In A View In Sqlserver2005

Feb 11, 2006

Hi,

I've a problem with a created view in sqlserver2000 that I'm now using in sqlserver2005.

This is the view :

CREATE VIEW hsarti01_VD1 AS
SELECT TOP 100 PERCENT *
FROM hsarti01 WITH(index(hsarti01_PK))
ORDER BY 1,2 desc,3,4


When I do the "select * from hsarti01_VD1" in sql server 2000, I see in the result that the order by is been using. but in sql server 2005 it's just using the order of the primary key and not the order by !



Has anyone have a solution for it ?

Thanks

View 16 Replies View Related

Migration Sql Server 2000 To SqlServer2005

Jan 8, 2007

hi,
i must convert my SqlServer2000 to SqlServer2005. I just do it on my Computer and i run a component "SQL Server upgrade wizard" it convert my SQLServer. But now  i must do it on my Server Web and if i run that component it give me an error : "must run SQL 6.5" and  i don't installed it.
Can i download it with all right migration?
thank you

View 1 Replies View Related

Activating Database Mail In Sqlserver2005

Jan 24, 2008

i am using sqlserver2005,in that i am not getting database mail even after enabling in surface area configuration of configaration tool.
what is the problem with my sqlserver.
Can any one help me ...

View 1 Replies View Related

How To Writing CLR Store Procedure In C# Using SQLSERVER2005

Feb 19, 2008

hi,
i am new in asp.net.
.i have used sqlserver2005.
in VS2005 file->new project->visual c#->Databse then select sqlserver project templates and click ok..
it shows new database reference dialog box
in that i selected server name,use sqlserver authentication and database file.
then click ok butoon it will shows the error that is
"The Sql Server specified by this connection properties does not support managed objects.please choose another Sql server"
suppose if u not able to understand above steps please refer this link
http://www.sqlteam.com/article/writing-clr-stored-procedures-in-charp-introduction-to-charp-part-1
please don't mistake me..
thanks
  

View 1 Replies View Related

Placing A LOCk On The Table In SqlServer2005

Apr 17, 2008

Hi,
 I am using Sql Server 2005.
I want to place a LOCK, insert something in the table then return back to the code (with the ID of the inserted item) and then call FUNCTION_A and then based on the outcome of the function I either want to

I want to keep the inserted item and release the lock or
I want to delete the inserted item and release the lock
Any suggestion is greatly appreciated.
Regards
naimulah

View 3 Replies View Related

How Can I Change Password Of SQLServer2005/Expres ?

Dec 13, 2005

ow can I change password of SQLServer2005/Expres ?

View 1 Replies View Related

Ow To Append Rows In Dts Package Of Sqlserver2005

Mar 23, 2007

hello sir,

as u explained very well transfered data through Import& Export Wizard for creating destination table but sir i want append rows in the

destination table example. how should i append data in the destination table while copying or transfering data in the exsisting destination table

is there any specfic type of table structure or any setting is require for that if sir yes pls. let me know by my above email add.

as delete rows in the destination table option working properly in IMPORT & EXPORT Wizard only problem in append rows in the destination

table every time i am transfereing data or copying its showing double of exsisting rows its not appending exsising rows & as i want each time

the already exsist rows data should append & insert only new row below that exsisting one .

i hope sir u got my query if u have answer, sir pls revert back with soluntion on my above email add.

thanks & regards
Tamanna Shaikh

View 1 Replies View Related

How To Change 32bit To 64bit Using SqlServer2005

May 26, 2008

I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005.

my problem is:-

My project is running on SqlServer2005 which is 32 bit support.
But i want to change my project on SqlServer2005 which will be support to 64 bit .
What are the steps i follow to change 32 bit to 64 bit.

can anybody help me?

View 4 Replies View Related

Changing Windows/SqlServer2005 Password

Jun 3, 2008

I have changed my windows password on my workstation, and the result is that I cannot now access the local databases and services resident on my workstation. I can still access all remote servers, but all attempts to access the local machine have failed. I even changed the password back to the original password, but this has had no effect.

Has anyone had any experience similar to this one? I am at a loss for things to try at this point.

View 12 Replies View Related

Doubt At Retrieving Database In Sqlserver2005

Oct 5, 2006

hi,
here i had created a database named "books" and it contains 8tables in sql server 2005. now i want to take a copy of this "books" database in another system which also have sql server2005 as a back end to asp.net. so where i can get this "books". i.e in which folder it will be saved. is it possible to svae this databse or have to svae each queries by which i created tables?

One can never consent to creep,when one feels an impulse to soar
RAMMOHAN

View 3 Replies View Related

Support For The Hindi Language In Sqlserver2005

Jan 14, 2007

i wanted my database to support hindi language.
how will i implement that? i mean i don't see the hindi_bin for the collation options.
do i have to install extra unicode support for the hindi language?
or is there anyother way i could implement that?

View 1 Replies View Related

Updating Multiple Rows At Once In To SQlServer2005

Sep 25, 2007

Hi,

I have a table called "tblProducts" with following fields:-

ProductID(Pk, AutoIncrement), ProductCode(FK), ProdDescr.

So to the above table I have added a new field/column named "ProdLongDescr(varchar, Null)"

So, I need to populate this newly added column with specific values for each row depending on "ProductCode" which is different forevery row. The problem is that I have 25 rows.So instead of Writing 25 individual update scripts, is there a way in which single query will do the same job instead of writing one update query for each row ?. If so can some one guide me how to achieve that OR point to me a good resource.

Below are a couple of Individual update scripts I Wrote. "ProductCode" is different for all 25 rows.

Update tblValAdPackageElement SET ProdLongDescr = 'Slideshows' WHERE ProductCode = 'SLID'
And szElementDescr='Slideshow'
if @@error <> 0
begin
goto ErrPos
end

Update tblValAdPackageElement SET ProdLongDescr = 'CategorySlideshows' WHERE ProductCode = 'SLDC'
And szElementDescr='CategorySlideshow'
if @@error <> 0
begin
goto ErrPos
end

Thanks,

View 2 Replies View Related







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