Errors in the ole db provider

Submitted by Asif Nowaj, Last Modified on 2019-11-22

I have encountered this below error while I was trying to connect SQL Server Analysis Services cube using Microsoft Excel 2010.
Errors in the ole db provider: an error occurred while loading the connection dialog box component for prompting.
I remember it was working fine couple of month ago.
Now, this is how I have resolved the issue by re installing SQL server 2008 AS OLEDB drivers:
1. Go to https://www.microsoft.com/en-us/download/details.aspx?id=6375
2. Click “Download”

How to automate deployment using msbuild through command prompt

Submitted by Asif Nowaj, Last Modified on 2019-11-22

Pre-requisite is .NET framework

Assuming that .net framework is already installed in your machine.

Now follow the below instruction whether MSbuild command is working or not.
1. Open command prompt
2. Write msbuild /? and hit Enter

If you are getting below message, then it is certain that correct path is not configured to recognize the command.
'msbuild' is not recognized as an internal or external command, operable program or batch file.

Microsoft SQL Server - Find all the executed queries related with a table

Submitted by Asif Nowaj, Last Modified on 2019-11-22

Microsoft SQL Server - Find all the executed queries related with a table

In this tutorial, we’ll discuss on how to find all the executed queries related with a table in one database.

To get the all the queries that are executed in the database and related with a particular table, use below script.

Microsoft SQL Server - Find Row Count of all the tables

Submitted by Asif Nowaj, Last Modified on 2019-11-22

In this tutorial, we’ll discuss on how to find row count of all the table in one database.

To demonstrate this topic, SQL Server 2008 R2 Express version is being used. The exact version information is

Microsoft SQL Server - Find a particular text within Stored Procedure, View and Function or as Column name in a table

Submitted by Asif Nowaj, Last Modified on 2019-11-28

SQL server find text in stored procedure sql server 2008 r2, SQL server find text in stored procedure sql server 2012, SQL server find text in stored procedure sql server, SQL server find text in stored procedure, SQL server get stored procedure containing text SQL Server, sql server find procedure containing text, sql server find column name in all stored procedures, sql find text in stored procedure, find stored procedure in sql server, sql query to find column name in all stored procedure, search sp containing text, sql query to find stored procedure containing text, stored procedure containing text, search column name in stored procedure sql server, sql server find stored procedure containing text, sql query to find stored procedure using a table, sql find stored procedure containing text

Different Types of Trim Functions in Delphi

Submitted by Asif Nowaj, Last Modified on 2019-11-20
Delphi-trim-functions

Delphi Trim removes leading and trailing spaces and controls characters from the given string in SysUtils unit. Some customized useful trim functions like to strip of trailing occurrence of character present in the strip chars in string or widestring. Trim, TrimLeft, TrimRight, TrimAll. delphi cut string, can also used to remove character from string

Different String Types in Delphi

Submitted by Asif Nowaj, Last Modified on 2019-11-22

In Delphi, String is a sequence of characters. There different types of string available in Delphi for different purposes.
Types of string are:
1. ShortString
2. AnsiString
3. WideString
ShortString
Maximum length can be 255 characters. Memory required for this type of string is 2 to 256 bytes. Generally, this is used for backward compatibility.
AnsiString

Bee Dance (Waggle Dance)

Submitted by Mousumi Sepai, Last Modified on 2019-12-19

Dance Language of the Honey Bee. Waggle dance is communication system is defined as connect or communicate with other people, i.e. means that “any sharing of information”. Honey bee dance is of two types 1. Round dance 2. Waggle dance.

Pages

Subscribe to everyEthing RSS