Why my 64bit adplus.vbs is failing with “Error: 76 – Path not found” ?
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”. It simplifies lots of things for us. I was working on a customer scenario. […]
Read More → Why my 64bit adplus.vbs is failing with “Error: 76 – Path not found” ?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 sure that you’re using our newest JDBC Driver : http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en If you don’t know the current SQL Server JDBC Driver version you’re using, please compile my tiny little a few lines java console app below and run on […]
Read More → Microsoft SQL Server JDBC Driver 3.0 is released :)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 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.Show(“Hello World”); line and put a breakpoint to […]
Read More → Why the breakpoints that I set in my “Script Task” (not “Script Component” in the Data Flow *) never hits ?Where’s my good old friend DataSet visualizer ?
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 when debugging. The best example is the built-in “DataSet Visualizer”. Let’s assume you put a breakpoint […]
Read More → Where’s my good old friend DataSet visualizer ?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 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 the web service in a Script Task […]
Read More → SSIS 2005: Consuming a Web Service within a Script Task (without using Web Service Task or an HTTP Connection Manager)Why my BIDS is slow in design mode ?
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” … The very first thing that I check was “validation” part. As you know, […]
Read More → Why my BIDS is slow in design mode ?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 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 machines. As you know “Windows Installer” is a windows service running(1) on all […]
Read More → Why my windows installer hotfix/patch command line switches like /norestart /quiet are not working ?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 connect to an FTP Server on their internal network to download some files and take some data from the files to put it into some destination like a SQL Server table after doing some conversions/calculations […]
Read More → Why my FTP Connection Manager is not connecting to my FTP Server inside SQL Server 2005/2008 Integration Services Package ?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 detail : Cluster name : MYCLUSTER Cluster IP : 192.168.0.10 Node 1 (active node) hostname : NODE1 Node 1 IP : 192.168.0.11 Node 2 (passive node) hostname : NODE2 Node 2 IP : 192.168.0.12 The SQL Server Instance […]
Read More → How you should set your firewall rules to be able to connect to a SQL Server 2005/2008 clustered instanceThe 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 should not be mixed with the JET Blue ESE (Extensible Storage Engine) which is the core of Microsoft Exchange and Active Directory. We had released the first versions of the JET OLE DB Provider and JET ODBC Drivers in […]
Read More → 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)