.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sybase .net connector

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :ASP.Net

Hello group,


I'am trying to connect a sybase ASE server with the advantage .net connector. I'am unable to set the port property in the connector. The ASE server is version 12.5

I'am i missing something?


Help is very appreciated


View Complete Post

More Related Resource Links

Video: The SharePoint 2010 Search Connector Framework

In this video you will see how to extend search using the search connector framework. (Length: 7:43)

select max record to join another table sybase

select a.pono,(select (user) from user where userid=a.userid having date=max(date)) as user from a inner join b on a.no=b.no  in the result , i have selected the same id and retrieve two records every thing are same except the date how can i select the record out of two record which date is max date as the where Clasuse to select correct user poid    date                name 1        12/08/2010      Mary 1        20/08/2010      Peter   now i would like to select name which id=1 and date is max and then use the name to join another table because name is foreign key  

mysql data source provider - mysql connector/net

Dear All, I having problem installing mysql connector/net 6.2.3 on my vsd 2010 because the installed went smoothly but when Im trying to use the mysql on data source provider, I cant see it on the list and when try to install/change the connector the visual studio integreation has an x mark meaning to say it was not installed on my vsd2010.  Thanks.

SSIS And Sybase Source OLEDB connectivity issue with code page for character set

Hi I am using SSIS 2008 to connect the Sybase Server version 15.0.3 64-bit. The default character set id used by this Sybase server is 4 (i.e. roman8). (http://manuals.sybase.com/onlinebooks/group-charc/chg0300e/charsets/@Generic__BookTextView/1706;pt=266) I had installed Sybase Client for Sybase OLEDB Driver (ASEOLEDB) to integrate this in OLEDB Source Editor. As per guidance from one of the past MSDN forum discussion, I tried setting property of AlwaysUseDefaultCodePage property to "FALSE"  (http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f5af9328-e1fb-48d7-a85d-1d08bb7cf0e5/). However, I am still experiencing error message as follows:- ********************************************************* Error at Package2 [Connection manager "xxxxxx.xxxxxxx"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[00000] [Native Code: 30061] [ASEOLEDB]Could not load code page for requested charset". An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[1ZZ001] [Native Code: 30016] [ASEOLEDB]Internal Error". Error at Data Flow Task 2 [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMC

Sample: Custom BCS Connector Sample

Explore the code as you learn how to create a Business Connectivity Services (BCS) connector to integrate data sources into SharePoint Server 2010.

[OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Distributed transaction enlistment fa

Ok, i have seen tons of articles on the error, but still can't figure it out. This is being executed through nested procedure calls, until it is roughly 3 levels deep, then makes a call to Sybase using dynamic SQL and OPENROWSET. The message that is returned is listed below. Yes, i looked up all I could find on it. The thing I find interesting is I can simply take the dynamic SQL and the openrowset call out and run it in query analyzer just fine. but when I run it through the procedure it generates the errors. Any thoughts?   [OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Distributed transaction enlistment failed.] Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. [OLE/DB provider returned message: [MERANT][ODBC Sybase driver]Load of XA library failed.] OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]. John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com

Mysql connector and medium trust shared hosting

Hi at all. I've a big problem with GoDaddy Shared Hosting. I've written an ASP.NET application with MySql Database, but my application can't run, with the "Security Exception" error. The problem is that mysql connector must be recompiled with some .... different option. But i can't recompile.. i got always error. So i'm asking you if someone have a link for a mysql connector version able to run in medium trust environment.Very Thanks in advance.Bye

BCS Custom Search Connector Concurrency

I wrote a custom search connector (.NET assembly) so that external ECM repositories can be indexed using either search service application (sharepoint or FAST).  However, the indexer process only calls my code one request at a time which isn't going to be fast enough in most cases.  I tried setting up a crawl impact rule, but still only a single request at a time.  If I change the impact rule to slow the crawl down, it works.  If I set the impact rule to handle 8 concurrent requests, it ignores it. Anybody have an idea on how I can get it to call my connector concurrently?Dan Hunsinger

Troubleshoot Microsoft Connector 1.0 for SAP BI

I have installed the Microsoft Connector 1.0 for SAP BI (April 2009 feature pack) on a Windows 2008 R2 server with SQL 2008 SP1 (Cum Update 6). I have established an SAP BI Connection and SAP BI Data Source. The Data Source is able identify the OHS_Destination, Process Chain, and respective Columns. Confirm that the librfc32.dll is installed correctly. The Output of the Data Source is connected to a simple OLEDB destination. When executing the package, it fails at the SAP BI Data Source with the following errors: [SAP BI Source] Error: Microsoft.SqlServer.Dts.SapBw.Connectivity.ERPException: FAILED Execution failed.    at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCFunction.Execute()    at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout) [SAP BI Source [61]] Error: Microsoft.SqlServer.Dts.SapBw.Connectivity.ERPException: FAILED Execution failed.    at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout)    at Mic

How to detect mysql connector version programatically?

Hi experts,Can I programatically find the version of mysql .net connector on the host machine from asp.net and update my web.config accordingly?Thanks in advance.

SSMA Sybase to MS-SQL Conversions

I am using SSMA to connect to sybase and get "Error collecting Data" - I have Sybase 15.5 installed and MS-SQL 2008 Express.SSMA version is 4.0.1366Any pointers would be appreciated 

WF 4 State Machine connector and state

Hi, I've got a couple of questions 1. In WF 4 State Machine connector XAML i have this   <UserControl.ContextMenu x:Uid="cxtMenu"> <ContextMenu> <MenuItem Header="Open new window"/> </ContextMenu> right after  </UserControl.Resources> However, the context menu that I see is still StateMachineDesigner contextmenu. What is wrong?  2. For catching mouse double click on connector, there is "OnConnectorMouseDoubleClick", but I can't find something similar for state mouse double click ( I see that it works because it makes the activity visual root). How is this handled? 3. How I determin the activity which has a specific outgoing connector? "GetConnectorModelItem(DependencyObject obj)" returns StateMachine. I'm interested in getting a state somehow Thank you very much

Connecting to Sybase using ODBC

Hello everyone, I am new to this forum. I am having problems connecting to Sybase Adaptive Server Enterprise 12 and was hoping someone could help. The server is set up as follows: Sybase Adaptive Server Enterprise Client .net Framework IIS 6 ODBC .net I have tried to connect a couple of different ways. First is using the following code: ------------------------------------------------------------------------------------------------------ <%@ Page CompilerOptions='/R:"C:\Program Files\Microsoft.NET\Odbc.Net\Microsoft.data.odbc.dll"' Debug="True"%> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <%@ import Namespace="Microsoft.Data.Odbc" %> <%@ Assembly Name="Microsoft.Data.Odbc" %> <script runat="server"> Sub Page_Load(Source as object, e as EventArgs) If Not IsPostBack Then Dim sConnString As String = "Driver={Sybase ASE ODBC Driver};srvr=myServer;DB=myDatabase;UID=myUserID;PWD=myPassword;" Dim conn As ODBCConnection conn = New ODBCConnection(sConnString) conn.Open() ------------------------------------------------------------------------------------------------------ With that code I get the following error: Compilation Error Description: An error

SQL Reporting Services Data Connector for Dynamics CRM 4.0 issue


I can't find a Dynamics CRM topic and I'm hoping someone here will recognize the problem that we are having with integration between Dynamics and SRS.


Dynamics CRM server deployed fine. But we are having this problem when trying to install the Dynamics SRS Data Connector (an additional component that is supposed to be installed locally on the SRS server):



Trouble is, the SQL server is a default instance, and SRS is hosted on a default web site listening on port 80. In fact, this is just a plain default install of SQL 2005 and SRS 2005 on one server. Nothing has been customized. And yet we get this error when we try to install SRS Data Connector on the local SRS machine:

"Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."


But the SRS is installed and running fine! I can even see and run reports that the Dynamics CRM Server install had created on the SRS server! And yet the setup program insists that SRS is not installed and it won't proceed with installation.

Probelms with SAP BI Connector


Hi All,

We are using SAP Bi Connector to retrieve data from SAP BW through OHS using SAP BI Connector.

However , we get errors sometimes and we are not sure whether this is a error from SSIS side or SAP side or is it becuase of some server constraints [High usgae]


Error is :

SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SAP BI Source" (1) returned error code 0x80131500. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. 

System.Exception: The component could not create a new internal table. hIT=-2097643832   at Microsoft.SqlServer.Dts.SapBw.Components.OHSExtractor.ExtractNow(Boolean InRuntimeMode, String GatewayHost, String GatewayService, String ProgramID, String ProcessChain, String DestinationName, String ExecutionMode, String PropertyRequestID, Int32 Timeout)   at Microsoft.SqlServer.Dts.SapBw.Components.SapBwSourceOHS.PrimeOutput(Int32 outputs, Int32[] o

System.Exception: The component could not create a new internal table. hIT=-2097643832   at Microsoft.SqlServer.Dts.SapBw.Connectivity.RFCFunction.Execute()   at Microsoft.SqlServer.Dts.SapBw.C

Issue with Connection of Sybase in SSIS and Linked Server in SQL Server

Iam having problem connecting with Sybase from SSIS or Link Server of SQL Server 2008.

 I have installed Sybase 12.5.1 OLE DB Driver and have also registered by running command:

 C:\sybase\DataAccess\OLEDB\dll>regsvr32 sybdrvoledb.dll

 We are also able to create System DSN from ODBC Administrator in Windows 7. I am also able to import data in the MS Access. Here is the System DSN I created, successfully.

 I would really appreciate you can help us out.

BCS Connector



I am trying to create a list based on an external content type. In that process I created a BCS to SQL Datatbase table which has more than 8000 records. When I set up the BCS connection I basically used the default settings. Now when I try to create the list based on that content type, I am getting the following error:

Database Connector has throttled the response. The response from database contains more than '2000' rows. The maximum number of rows that can be read through Database Connector is '2000'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet.

Any pointers as to how I can change the limit?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend