A Support Engineer's Guide to "Data Access" Galaxy
Microsoft® SQL Server® ODBC Driver for Linux V 1.0 is released :)
As you will remember, I had mentioned about Microsoft SQL Server ODBC Driver in my earlier blog post...
Author: Faruk Celik Date: 03/07/2012
Microsoft JDBC Driver 4.0 for SQL Server is released :)
You can download it for free from the link below :...
Author: Faruk Celik Date: 03/07/2012
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 :)
Virtual Labs enable you to quickly evaluate and test Microsoft's newest products and technologies...
Author: Faruk Celik Date: 02/03/2012
Join us March 7, 2012 for the Virtual Launch of SQL Server 2012 (codename Denali)! Register today
You can find the details here :...
Author: Faruk Celik Date: 02/01/2012
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 ;)
If you hit to the 65.536 rows limitation in Excel (97-2000) XLS file format, we have good news :) As...
Author: Faruk Celik Date: 02/01/2012
Announcing Microsoft SQL Server ODBC Driver for Linux
Our Principal Group Program Manager Raghu Ram make an announcement about "Microsoft SQL Server ODBC...
Author: Faruk Celik Date: 10/24/2011
Important: ADO IID changes made with SP1 for Win7/Win2k8R2 decided to be reverted back, will be fixed!
Please refer to our SQL Server Escalation Services blog post for details...
Author: Faruk Celik Date: 10/14/2011
Access Database Engine 2010 Service Pack 1 released
If you've read my previous blog post "Accessing Excel files on a x64 machine" and you loved our ACE...
Author: Faruk Celik Date: 07/09/2011
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
If you've compiled/re-compiled an ADO application on a Windows 7 Service Pack 1-based computer and...
Author: Faruk Celik Date: 03/16/2011
.NET 4.0 update (4.0.30319.225)
Our RTM build number of .NET Framework 4.0 is 4.0.30319.1 . After appyling "Visual Studio 2010...
Author: Faruk Celik Date: 03/15/2011
Visual Studio 2010 Service Pack 1 is available for MSDN Subscribers and It will be Generally Available as of Thursday, March 10, 2011
Visual Studio 2010 Service Pack 1 (SP1) is available for download. MSDN subscribers can download the...
Author: Faruk Celik Date: 03/08/2011
Great SQL Azure Resource page - Everything you ever wanted to know about SQL Azure, but were afraid to ask
You're wondering ore maybe you've already using "SQL Azure" but still have questions on your mind...
Author: Faruk Celik Date: 03/08/2011
Use of MSXML (MSXML3, MSXML4, MSXML6 our COM component libraries) in .NET applications are not supported
Our KB article https://support.microsoft.com/kb/815112 clearly states this. Then, you may ask me "Why...
Author: Faruk Celik Date: 03/05/2011
Download Microsoft JDBC Driver for SQL Server 4.0 CTP! (Community Technology Preview)
Though this CTP release is released on 14th of January, 2011, I noticed that I forgot adding my...
Author: Faruk Celik Date: 03/05/2011
Why do you see grayed out GenerateDBDirectMethods checkbox in “TableAdapter Configuration Wizard”
In Visual Studio 2008 or Visual Studio 2010, you've started developing your Data project and let's...
Author: Faruk Celik Date: 02/23/2011
SSIS: How to know if the installed Oracle Client is 32bit or 64bit on your SSIS machine
In your SSIS packages, if you need to read from or write to Oracle likely that you most probably hit...
Author: Faruk Celik Date: 12/27/2010
Registration is now open for TechEd Middle East 2011
Registration is now open for TechEd Middle East 2011. Tech·Ed is Microsoft’s premier...
Author: Faruk Celik Date: 12/20/2010
Important: ASP.NET Security Vulnerability
On 17th of September 2010, we released a Microsoft Security Advisory about a security vulnerability...
Author: Faruk Celik Date: 09/20/2010
Why “Package Load error 0xC0010014 in CPackage::LoadFromXML” error appears while trying to run an SSIS Package ?
As you know an SSIS package is an XML content regardless if you're storing your SSIS package in file...
Author: Faruk Celik Date: 06/16/2010
Accessing Excel files on a x64 machine
In the old times while all the CPUs were 32bit, we were happily using JET OLEDB Provider reaching...
Author: Faruk Celik Date: 06/04/2010
Microsoft SQL Server JDBC Driver 3.0 is released :)
Our SQL Server JDBC Driver 3.0 is released recently. If you're coming to SQL Server from Java, make...
Author: Faruk Celik Date: 05/06/2010
Why the breakpoints that I set in my “Script Task” (not “Script Component” in the Data Flow *) never hits ?
Why the breakpoints that I set in my "Script Task" (not "Script Component" in the Data Flow *) never...
Author: Faruk Celik Date: 03/17/2010
Where’s my good old friend DataSet visualizer ?
The Visual Studio is the primal IDE for developping .NET applications. Especially its debugging...
Author: Faruk Celik Date: 11/24/2009
SSIS 2005: Consuming a Web Service within a Script Task (without using Web Service Task or an HTTP Connection Manager)
When you read the title, I'm pretty sure that you asked "Why do I need to do this web service...
Author: Faruk Celik Date: 07/17/2009
Why my windows installer hotfix/patch command line switches like /norestart /quiet are not working ?
One of our customers had reported that when they tried installing a decent Microsoft XML related...
Author: Faruk Celik Date: 01/16/2009
Why my FTP Connection Manager is not connecting to my FTP Server inside SQL Server 2005/2008 Integration Services Package ?
It has been reported by one of our customers that they have developed an SSIS package which needs to...
Author: Faruk Celik Date: 01/16/2009
How you should set your firewall rules to be able to connect to a SQL Server 2005/2008 clustered instance
Let's say you have got a SQL Server 2005/2008 cluster with two nodes. Here's the configuration in...
Author: Faruk Celik Date: 12/05/2008
The points that you should think again and again using JET Database Engine in a multi-threaded application (like a classic ASP or ASP.Net web application)
Microsoft JET (Joint Engine Techonology) Database Engine is an implementation of JET Red and it...
Author: Faruk Celik Date: 11/03/2008
Why my 32 bit applications cannot see the ODBC DSNs that I created on my 64 bit machine ?
As we all database developers know that a ODBC DSN is an entry that we created through "ODBC Data...
Author: Faruk Celik Date: 10/17/2008
What if your ODBC DSNs want to play "hide-and-seek" with you ?
One of our customers has been reporting that they cannot see their "System Data Sources" under...
Author: Faruk Celik Date: 05/30/2008
“Please take a shower before entering the connection pool” !
Sometimes pools that we should pay attention to their "hygiene" are not only swimming pools. We...
Author: Faruk Celik Date: 04/10/2008
Moving a Visual Studio 2005 project containing ADOX references from XP to Vista may fail with ADOX references
If you had developed a VS 2005 project containing ADOX references on a Win XP machine and moved the...
Author: Faruk Celik Date: 01/18/2008
How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers
Let's say you've got a SQL Server (KIRK) containing a linked server against another SQL Server...
Author: Faruk Celik Date: 01/02/2008
“UDL Test” on a 64 bit machine
“UDL Test” on a 64 bit machine Let’s say you’ve started playing with UDL files on your "32 bit"...
Author: Faruk Celik Date: 12/31/2007
Basics first : "UDL Test"
When an application failed with a database/datasource connectivity problem, the first thing to check...
Author: Faruk Celik Date: 12/31/2007