Sign In
A Support Engineer's Guide to the "Data Access" Galaxy
Options
Blog Home
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
.NET
64bit
ace
ado
ADO.NET
ASP.Net
bids
c#
connection manager
connectivity
DataSet
debug
denali
dsn
jet
linked server
odbc
odbcad32
oledb
package
sql server
sql server 2005
ssis
udl
visual studio
Archive
Archives
February 2012
(3)
October 2011
(2)
July 2011
(1)
March 2011
(6)
February 2011
(1)
December 2010
(2)
September 2010
(1)
June 2010
(2)
May 2010
(2)
March 2010
(1)
November 2009
(1)
July 2009
(1)
February 2009
(1)
January 2009
(2)
December 2008
(1)
November 2008
(1)
October 2008
(1)
May 2008
(1)
April 2008
(1)
January 2008
(2)
December 2007
(2)
MSDN Blogs
>
A Support Engineer's Guide to the "Data Access" Galaxy
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
A Support Engineer's Guide to the "Data Access" Galaxy
SQL Server 2012 (codename Denali) - Virtual Labs are ready. Just click and start working on a pre-installed SQL Server 2012 virtual machines for free :)
Posted
11 days ago
by
Faruk Celik
0
Comments
Virtual Labs enable you to quickly evaluate and test Microsoft's newest products and technologies through a series of guided, hands-on labs that you can complete in 90 minutes or less. There is no complex setup or installation required, and you can use...
A Support Engineer's Guide to the "Data Access" Galaxy
Join us March 7, 2012 for the Virtual Launch of SQL Server 2012 (codename Denali)! Register today
Posted
13 days ago
by
Faruk Celik
0
Comments
You can find the details here : http://blogs.technet.com/b/dataplatforminsider/archive/2012/01/26/join-us-march-7-2012-for-the-virtual-launch-of-sql-server-2012.aspx
A Support Engineer's Guide to the "Data Access" Galaxy
SQL Server Reporting Services (SSRS): Reporting Services in SQL Server 2012 (codename "Denali") will support XLSX, DOCX formats. Bye bye 65536 rows limit in XLS files ;)
Posted
13 days ago
by
Faruk Celik
0
Comments
If you hit to the 65.536 rows limitation in Excel (97-2000) XLS file format, we have good news :) As you know the 65.536 rows limit in an Excel sheet has been removed with Office 2007/2010 with the new Excel format XLSX. But SQL Server Reporting Services...
A Support Engineer's Guide to the "Data Access" Galaxy
Announcing Microsoft SQL Server ODBC Driver for Linux
Posted
3 months ago
by
Faruk Celik
0
Comments
Our Principal Group Program Manager Raghu Ram make an announcement about "Microsoft SQL Server ODBC Driver for Linux" in http://blogs.msdn.com/b/jdbcteam/archive/2011/10/13/announcing-microsoft-sql-server-odbc-driver-for-linux.aspx
A Support Engineer's Guide to the "Data Access" Galaxy
Important: ADO IID changes made with SP1 for Win7/Win2k8R2 decided to be reverted back, will be fixed!
Posted
4 months ago
by
Faruk Celik
0
Comments
Please refer to our SQL Server Escalation Services blog post for details : http://blogs.msdn.com/b/psssql/archive/2011/10/03/yes-we-made-a-mistake-and-are-finally-going-to-fix-it.aspx
A Support Engineer's Guide to the "Data Access" Galaxy
Access Database Engine 2010 Service Pack 1 released
Posted
7 months ago
by
Faruk Celik
1
Comments
If you've read my previous blog post " Accessing Excel files on a x64 machine " and you loved our ACE OLEDB Provider, I want to let you know that we released " Access Database Engine 2010 Service Pack 1 ". This update is also available in Windows Update...
A Support Engineer's Guide to the "Data Access" Galaxy
REGDB_E_CLASSNOTREG (0x80040154), E_POINTER (0x80004003), E_NOINTERFACE (0x80004002), Unable to cast COM object of type 'System.__ComObject' to interface type 'ADODB.Connection' error codes/messages
Posted
11 months ago
by
Faruk Celik
0
Comments
If you've compiled/re-compiled an ADO application on a Windows 7 Service Pack 1-based computer and the app does not run on down-level operating systems with the any of the error messages below, please see our new KB article published today (16th of March...
A Support Engineer's Guide to the "Data Access" Galaxy
.NET 4.0 update (4.0.30319.225)
Posted
11 months ago
by
Faruk Celik
2
Comments
Our RTM build number of .NET Framework 4.0 is 4.0.30319. 1 . After appyling "Visual Studio 2010 Service Pack 1" to your Visual Studio 2010, you will see that some DLLs in your .NET 4.0 upgraded from 4.0.30319. 1 to 4.0.30319. 225 . For example check...
A Support Engineer's Guide to the "Data Access" Galaxy
Visual Studio 2010 Service Pack 1 is available for MSDN Subscribers and It will be Generally Available as of Thursday, March 10, 2011
Posted
11 months ago
by
Faruk Celik
0
Comments
Visual Studio 2010 Service Pack 1 (SP1) is available for download. MSDN subscribers can download the bits now. General availability will be on Thursday, March 10. Here are the links : Download Service Pack 1 (MSDN Subscribers) Thursday's general...
A Support Engineer's Guide to the "Data Access" Galaxy
Great SQL Azure Resource page - Everything you ever wanted to know about SQL Azure, but were afraid to ask
Posted
11 months ago
by
Faruk Celik
0
Comments
You're wondering ore maybe you've already using "SQL Azure" but still have questions on your mind and don't know where to start. Here's a good resource for you. You can find our wiki about SQL Azure here . I'm pretty sure that you will like it if you...
A Support Engineer's Guide to the "Data Access" Galaxy
Use of MSXML (MSXML3, MSXML4, MSXML6 our COM component libraries) in .NET applications are not supported
Posted
11 months ago
by
Faruk Celik
0
Comments
Our KB article http://support.microsoft.com/kb/815112 clearly states this. Then, you may ask me "Why this guy is repeating the documented thing in this blog post ?". Answer is simple, we do see lots of issues coming from our customers about this and I...
A Support Engineer's Guide to the "Data Access" Galaxy
Download Microsoft JDBC Driver for SQL Server 4.0 CTP! (Community Technology Preview)
Posted
11 months ago
by
Faruk Celik
2
Comments
Though this CTP release is released on 14th of January, 2011, I noticed that I forgot adding my blog. In case if you haven't noticed that it's available already and want to "play" with the 4.0 CTP please download it from here . This technology preview...
A Support Engineer's Guide to the "Data Access" Galaxy
Why do you see grayed out GenerateDBDirectMethods checkbox in “TableAdapter Configuration Wizard”
Posted
11 months ago
by
Faruk Celik
0
Comments
In Visual Studio 2008 or Visual Studio 2010 , you've started developing your Data project and let's say you're designing your DataSet s through Visual Studio's nice DataSet Designer just by drag/dropping your entities (tables, views) into the designer...
A Support Engineer's Guide to the "Data Access" Galaxy
SSIS: How to know if the installed Oracle Client is 32bit or 64bit on your SSIS machine
Posted
over 2 years ago
by
Faruk Celik
1
Comments
In your SSIS packages, if you need to read from or write to Oracle likely that you most probably hit some Oracle Client related configuration issues. ORACLE_HOME, PATH environmental variables etc. Sometimes you may see a machine needs to run SSIS packages...
A Support Engineer's Guide to the "Data Access" Galaxy
Registration is now open for TechEd Middle East 2011
Posted
over 2 years ago
by
Faruk Celik
0
Comments
Registration is now open for TechEd Middle East 2011. Tech·Ed is Microsoft’s premier technical education event providing the most comprehensive technical training on Microsoft’s suite of products, technologies, solutions and services...
A Support Engineer's Guide to the "Data Access" Galaxy
Important: ASP.NET Security Vulnerability
Posted
over 2 years ago
by
Faruk Celik
0
Comments
On 17th of September 2010, we released a Microsoft Security Advisory about a security vulnerability in ASP.NET. This vulnerability exists in all versions of ASP.NET. This vulnerability was publically disclosed late Friday at a security conference....
A Support Engineer's Guide to the "Data Access" Galaxy
Why “Package Load error 0xC0010014 in CPackage::LoadFromXML” error appears while trying to run an SSIS Package ?
Posted
over 2 years ago
by
Faruk Celik
0
Comments
As you know an SSIS package is an XML content regardless if you're storing your SSIS package in file system (as a .dtsx file) or storing your SSIS package in MSDB (then your XML content inserted into sysdtspackages or sysdtspackages90 tables in MSDB)...
A Support Engineer's Guide to the "Data Access" Galaxy
Accessing Excel files on a x64 machine
Posted
over 2 years ago
by
Faruk Celik
40
Comments
In the old times while all the CPUs were 32bit, we were happily using JET OLEDB Provider reaching Excel or MDB files for long time without any issues. After we started using x64 CPUs and x64 Windows machines, we noticed that JET OLEDB Provider is not...
A Support Engineer's Guide to the "Data Access" Galaxy
Why my 64bit adplus.vbs is failing with "Error: 76 - Path not found" ?
Posted
over 2 years ago
by
Faruk Celik
0
Comments
I haven't touched much about debugging but I admit that sometimes you have no other chance than analyzing a post-mortem dump or live dump to troubleshoot a problem. Our "Debugging Tools for Windows" package comes with a very hand VBScript : "adplus.vbs...
A Support Engineer's Guide to the "Data Access" Galaxy
Microsoft SQL Server JDBC Driver 3.0 is released :)
Posted
over 2 years ago
by
Faruk Celik
0
Comments
Our SQL Server JDBC Driver 3.0 is released recently. If you're coming to SQL Server from Java, make sure that you're using our newest JDBC Driver : http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang...
A Support Engineer's Guide to the "Data Access" Galaxy
Why the breakpoints that I set in my “Script Task” (not “Script Component” in the Data Flow *) never hits ?
Posted
over 2 years ago
by
Faruk Celik
2
Comments
Why the breakpoints that I set in my "Script Task" (not "Script Component" in the Data Flow *) never hits ? On a Windows 2008 x64 machine, you're running SQL Server 2008 x64. Let's say you added a single "Script Task"; you wrote a very simple MessageBox...
A Support Engineer's Guide to the "Data Access" Galaxy
Where’s my good old friend DataSet visualizer ?
Posted
over 3 years ago
by
Faruk Celik
2
Comments
The Visual Studio is the primal IDE for developping .NET applications. Especially its debugging features makes it more powerful. One of those feature is the “Visualizer”s. Visualizers are UI components to show the content of some complex objects...
A Support Engineer's Guide to the "Data Access" Galaxy
SSIS 2005: Consuming a Web Service within a Script Task (without using Web Service Task or an HTTP Connection Manager)
Posted
over 3 years ago
by
Faruk Celik
4
Comments
When you read the title, I'm pretty sure that you asked "Why do I need to do this web service consuming things in a Script Task although I can use ready-to-use Web Service Task ?". Well... I faced issues for some scenarios that you will need to consume...
A Support Engineer's Guide to the "Data Access" Galaxy
Why my BIDS is slow in design mode ?
Posted
over 3 years ago
by
Faruk Celik
1
Comments
One of our customers was saying that their SSIS Project with some complex "Data Flow Task"s with lots of Lookup Transformations was opening very slowly in BIDS ("Business Intelligence Development Studio") or I don't know if I should say "Visual Studio...
A Support Engineer's Guide to the "Data Access" Galaxy
Why my windows installer hotfix/patch command line switches like /norestart /quiet are not working ?
Posted
over 3 years ago
by
Faruk Celik
1
Comments
One of our customers had reported that when they tried installing a decent Microsoft XML related patch from a Microsoft Security Bulletin, it was not allowing them to use the usual command line switches like "/norestart" "/quiet" etc. on some of their...
Page 1 of 2 (35 items)
1
2