Data Access Technologies

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

Browse by Tags

Tagged Content List
  • Blog Post: Data migration of large Sybase tables may cause TEMPDB errors

    Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following error may occur: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction...
  • Blog Post: ‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator

    Problem: Sporadically, the SSMA 5.1 Oracle sequence emulator causes login failure (Error: 18456, Severity: 14, State: 8) error messages to be written to the SQL Server ERRORLOG when used from an application using SQL authentication. Steps to reproduce the problem: After migrating an Oracle...
  • Blog Post: Deploying SQL CLR assembly using Asymmetric key

    In my opinion, One of the most complex part in deploying SQL CLR stored procedure is when you need to enable it for “External_Access” or “Unsafe”. The third option is “Safe” , this is pretty straight forward and I am not going to cover that in this blog. External_Access...
  • Blog Post: Unable to do SQL Stored Procedure debugging remotely from VS2010

    This post describes an interesting scenario that I came across when working with on Visual Studio Project based issue. In this situation, customer was unable to debug stored procedures on a remote SQL Server using Visual Studio. The SQL Server was running on a Virtual Machine that was in a different...
  • Blog Post: How a DBA can confirm if Microsoft JDBC XA transactions are set

    I am from Microsoft SQL Developer Support team, we support many data access technologies. Recently I had a chance to work with SQL DBA, who was facing issue to confirm to his developers whether XA transactions were configured correctly or not. After resolving his problem thought it would be easier...
  • Blog Post: ODBC drivers not visible in the ODBC Data Source Administrator (odbcad32.exe)

    I recently had an issue where after the installation of a Third party Client side tools, we were not able view the drivers listed in the ODBC Data Source Administrator (odbcad32.exe). In order to create a DSN to use this third party driver, we had to take a backup/export of the registry key of an...
  • Blog Post: Troubleshooting “Cannot create an instance of OLE DB provider”

    Today I am going to blog about a frequent issue that we come across while creating linked server-: Cannot create an instance of OLE DB provider "MSDADASQL" for linked server "MyDB2" In this scenario I was creating a linked server to a DB2 server, but everything explained in this blog holds good...
  • 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: SSMA 5.0 for Access and the DAO requirement

    My name is Angshuman Nayak and I am a part of SQL Developer support in Microsoft and work mostly around connectivity and data access technologies. As one of my activities I am helping customers and partners to move from various data bases like Oracle, Sybase, MySQL and Access to SQL Server. Today I am...
  • Blog Post: Sync framework might fail to sync data

    Database sync might not work if we copy the same database file to all the clients after provisioning it. Recently I came across a very interesting Sync framework issue. The customer had two mobile clients connected to the server . He was making some changes on one of the Client and as expected it...
  • Blog Post: Unable to retrieve next sequence value from a migrated Oracle sequence

    Background: SSMA 4.2 emulates an Oracle sequence as a table containing an IDENTITY column. Each sequence gets its own table, prefaced by the literal “$SSMA_seq_”. Thus, an Oracle sequence named SUPPLIER_SEQ would be migrated to a table in the target SQL Server database named “$SSMA_seq_SUPPLIER_SEQ”...
  • Blog Post: SQLExceptions while trying to perform add , delete or update operation using the DataGridView control

    You may see some SQLExceptions while trying to perform add , delete or update operation using the DataGridView control in .net framework. This post will speak about Adding and Deleting rows to the relation tables using windows application using DataGridView control in .net Framework 4.0 using Visual...
  • Blog Post: Executing an INSERT statement on a View in linked server

    Consider this scenario where you have a linked server from one SQL server to another SQL Server. Both the SQL Servers are SQL Server 2008 SP2 on Windows 2008. Say the two SQL Servers are Server A and Server B. Linked server from Server A to Server B is set up using SQL Native Client 10.0 provider...
  • Blog Post: SSMA : Migrate User Defined Data Types from Sybase to SQL Server

    SSMA2008 for Sybase doesn’t inherently migrate user defined data type to SQL Server. This applies to the latest build on SSMA for Sybase v4.2.2277. A future version might have the feature to convert them implicitly but as of now we don’t do it. a) If a Table in Sybase...
  • Blog Post: SQL BULK COPY ERROR (“Operating system error code 5(Access is denied.)”)

    While there are various forms of bulk copy this blog specifically deals with copying data from a file into SQL Server. It deals about the specific error “Operating system error code 5(Access is denied.)” which might crop up under certain circumstances when doing a bulk copy. For a while now...
  • Blog Post: SSMA error ‘External variable cannot be converted’

    Today I am blogging about an error that I frequent come across while working on SSMA cases . I tried to search more information about this error in the net but it never returns any useful result. So thought of blogging it. While migrating data from access database to SQL server we sometimes...
  • Blog Post: SQL Server Import Export Wizard fails while trying to retrieve the data from Pervasive Database

    When trying to import data from Pervasive DB to SQL Server 2008 DB using import/ export wizard we get the following error message :- "Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those...
  • Blog Post: Zombie check on Transaction - Error : This SqlTransaction has completed; it is no longer usable.

    You may get intermittent error from your application saying " This SqlTransaction has completed; it is no longer usable.". This may have to do with the way connection and transaction are handled in your application. One of the most frequent reasons I have seen this error showing up in various applications...
  • Blog Post: Permissions needed to set up linked server with out-of-process provider

    When setting up linked server to third-party Databases, it is recommended to run the third-party provider in out-of-process mode, because when the provider is run in-process (within the same process as SQL Server), then any issues with the provider can affect SQL Server process which could also result...
  • Blog Post: Linked Server Performance (Heterogeneous Databases)

    Recently I was working on a problem where the scenario was as below. There are various applications connecting to SQL Server to fetch data. But the actual data was not resident on the SQL Server rather on Oracle 10g and IBM DB2 Databases. The applications were supposed to use Windows active directory...
  • Blog Post: Things to keep in mind regarding Registry while migrating a 32 bit application from Vista x64 to Windows 7 x64

    If you are migrating a 32 bit application from Vista x64 to Windows 7 x64 and your application relies on some information in registry. There are few things you should consider as following. In Windows 7, registry is virtualized. As a result, wow64 applications don’t have to explicitly...
  • Blog Post: “ORA-12154: TNS: could not resolve the connect identifier specified” error while creating a linked server to Oracle

    This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this error and possible resolutions. Full error message: OLE DB provider "MSDAORA" for linked server "LINKED_ORA" returned message "ORA-12154: TNS:could not resolve...
  • Blog Post: Issue with Microsoft Connector v1.0 by Attunity with Teradata

    Recently I was trying out the SSIS connector for Teradata by Attunity in one of my sample SSIS packages. While the installation and the registration process of the components went fine I faced an issue when I tried to run a really simple SSIS Package pulling up data from a Teradata table “AccessLogV”...
  • Blog Post: Using Network trace to troubleshoot intermittent connectivity issues

    Intermittent connectivity issues from a client machine when connecting to a remote database server can be often attributed to the network layer. By collecting the network traces and reviewing them we can tell why the connections failed to succeed or if the existing connections were getting closed. Recently...
  • 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...
Page 1 of 3 (55 items) 123