We have a program written in C# using Visual Studio 2012 and .NET 4.0 / .NET 4.5. It rapidly executes many queries in Microsoft SQL Server 2008 R2 and then exits. Executed query count varies from several hundred to many thousand. Today, when executed particular task with very many queries, I noticed an error in …
Category Archives: Databases
Executing very large script on Microsoft SQL Server 2008 R2 fails
I was trying to execute very large .sql script in Microsoft SQL Server 2008 R2, that runs on Microsoft Windows Server 2008 R2. First I tried to copy/paste script into Microsoft SQL Server Management Studio. The server has plenty of memory about 5 GB RAM, and script file is about 150 MB in size and …
Continue reading “Executing very large script on Microsoft SQL Server 2008 R2 fails”
No ODBC driver after installing Oracle 11g R2
Today, after installing Oracle Database 11g R2 Client there was no ODBC driver listed under Data Sources (ODBC) window. First I tried to change Setup type to Administrator, then Instant Client, etc… noting worked. Then I remembered my last issue with Same / different file problem on 64-bit / WoW64. As you remember, you cannot …
Continue reading “No ODBC driver after installing Oracle 11g R2”