Data Access Technologies

(Data Access, XML, SSIS, LINQ, System.Data ...)

Browse by Tags

Tagged Content List
  • Blog Post: Syntax error, permission violation, or other nonspecific error

    While developing a package in BIDS 2008 if we use SNAC 10.0 driver in OLE DB Source connection, call to parameterized stored procedure fails parsing with error: Syntax error, permission violation, or other nonspecific error If we change the connection manager to use Microsoft OLE DB Provider for Sql...
  • Blog Post: Every Bug is a Microsoft bug until proven otherwise

    Holiday season provides us an opportunity to take a break from our hectic schedules in GTSC and ponder over some interesting cases in past few months. I had been a strong believer in the fact that a lot of bugs attributed to Microsoft are not Microsoft’s fault. We get battered, bruised and cursed...
  • Blog Post: How to verify if the issue is due to linked server or provider

    When we create a linked server to a database Other than SQL server, like Sybase , Oracle , DB2 etc ,we see some errors and we are not sure whom to contact for support. Should we contact Microsoft support or the third party support. In such an ambiguous situation we can verify ourselves, which support...
  • Blog Post: How to troubleshoot connectivity issues using Windbg

    Using the Windows Debugging tool WinDBG you can attach a live process and debug. You can set up break-points at different function calls and debug when the process hits and stops to the break-points. When you do not have the source code (which is true for most of the products that we use as end user...
  • Blog Post: Connectivity Issue with Oracle in x64 Environment “ORA-12154: TNS:could not resolve the connect identifier specified”

    When you try to develop an SSIS package in x64 Environment in BIDS that connects to a Oracle Database, you will invariably run into connectivity issues if the installed Oracle Client tools version is 10.2.0.1 (x86). You will obviously need to install the 32-BIT version of Oracle Client to communicate...
  • Blog Post: Who takes care of my database connection when I don’t close it in my code?

    A lot of customer has asked me a common question : How should I expect my connections to behave if I don’t close it properly in the code. Though it is highly recommended to close the connection in your code itself and not depend on any other ways to close it, I think there should be a clear idea...
  • Blog Post: The SSIS and Oracle Story Continued…

    In one of my previous blogs I tried to summarize the roadblocks and the ways to address them when a SSIS Package talks with Oracle Database. Apart from the Oracle Network Bug (Fixed in Oracle Client Tools version 10.0.0.3 and above), I faced another roadblock while trying to use a configuration file...
  • Blog Post: SSIS 2008 now talks to SAP BI Database..

    Microsoft now offers a connector for SAP BI in Sql 2008 Integration Services (Enterprise and Developer Editions only). The Microsoft Connector for SAP BI is a set of managed components for transferring data to or from SAP NetWeaver BI version 7.0 systems. This connector comes as a part of the Microsoft...
  • Blog Post: SSIS 2008 now talks to Teradata Server as well!!

    I was trying out the high speed connectors offered by Attunity which enables SSIS Packages to talk to the Teradata Server (version 12.0 and above, this blog post applies to version 12.0). After developing a sample SSIS Package I was quite happy to observe the following: Connectivity to Teradata...
  • Blog Post: How to create a linked server in SQL Server 2005 for Sybase ASE 12.5 database using DataDirect's ODBC Driver and OLEDB provider?

    Linked server in SQL Server 2005 to Sybase ASE 12.5 can be created with both ODBC driver and OLEDB provider. Below are the steps. A. Creating Linked server for Sybase ASE 12.5 from SQL Server using DataDirect Sybase Wire Protocol ODBC driver Install the DataDirect ODBC Driver for...
Page 1 of 1 (10 items)