I want to learn how to use a database but I don't know what database platform is best to use as a first timer. I am looking for a platform that is easy to understand and easy to use for people without prior knowledge about using a database like me. Could you please help out?

Hi Everyone,

I am using MySQL 3.51 for a online store.

There are many repeated customers in the site.

So, I want to maintain a database of the repeated customers.

How can I implement a Trigger for those customer account for two fields?

Hello,

I would like to transfer some of my files of * .mdb and* .Accdb format (Microsoft Office Access 2010) and also files of.XLs, .Xlsx and.Xlsb format (Microsoft Office Excel)  to another data source, i.e. Microsoft SQL Server.

In doing the above task I need to connect to MS Access by selecting a Microsoft Access database. Whenever I try to do that an error message pops out.

Does someone know how to fix this up?

No appropriate Access provider was found.

Hi,

When I am trying to connect my system through a MS Access tool to a Virtual Machine, which has SQL server installed. The error says the connection failed and it cannot generate SSPI context. How do I login in Server now? Please help me to establish a connection. Hunting for solution, please help me. Your help is great. Thanks.

Microsoft SQL Server Login

Connection failed:

SQL State: ‘S1000”

SQL Server Error:0

[Microsoft][ODBC SQL Server Driver] Cannot generate SSPL context.

Hello there,

I am new to Microsoft Access I got this error message and I am stuck here. I download and installation was good without any issues. When I start to work, I am getting lot of errors. Please help. I have attached the error message please do check the attachment. Your help is great.

Microsoft Office Access

Invalid bracketing of name ‘SELECT [900-01_NUMERO’.

Hello,

While working with DTS Import/Export to copy data from one the data source I ended up with an error message. When I select the Microsoft OLE DB Provider for SQL server, I got this error message pop up. I stuck here not able to move forward from this step. Please guide me. Thanks a lot.

DTS Import/Export Wizard Error

Error Source: Microsoft OLE DB Provider for SQL Server.

Error Description: [DBNETLTB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Hello DBA’s,

When I try to establish the connection Microsoft SQL, I ended up with an error message. It says the server does not exist or access denied. However, to my knowledge server exist and I have an authority to access the server. How do I establish the connection now? Do I need to check the settings? How do I check where I went wrong? Please help. Thanks. 

Microsoft SQL Server Login

Connection failed:

SQL State: ‘01000’

SQL Server Error: 5

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen

(Connect()).

Hi,

While working in project in Microsoft Access I got this weird error message. I have been doing action for quite long and never experienced this before. I do not understand what to do now to solve this error. The error says it ‘could not find the specified .mdb’. When I try to initiate the procedure, I got this error message pop up in Microsoft Access. Please help. Thanks.

Microsoft Access

Could not find file C:UsersAlicia.Alicia-PCDesktopClientFiletbITechnicians.mdb. 

Hello,

I am getting this error message in Microsoft SQL server Management Studio while working with the Interface type. The error says that the operation failed because the Query Interface call on the COM component for the interface. Please explain me to solve this problem. Is the problem with the interface type or with the component? Help please.

Microsoft SQL Server Management Studio

Unable to cast COM object of type ‘System_ComObject’ to interface type

‘Microsoft.VisualStudio.OLE.Interop.IServiceProvider’. This operation failed because the QueryInterface

Hi Expert DBA’s,

When I try to connect to a Microsoft SQL server, I ended up with an error message. In addition, I got this error pop up when I try to connect to SSIS service on machine. The error says the error loading type library dll. I have attached the error image please do check the attachment and explain me to fix the problem. Thanks a lot.

Connect to Server

Cannot connect to

Additional information:

      Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)