Category Archives: Technology – Tips

Foreign key in phpmyadmin

Foreign key in phpmyadmin Setting Foreign key in phpmyadmin is very easy. We just have to follow few simple steps and we are done. Here we are creating three tables(Product_master, Category_master and Order_master). He have to setup Foreign key in Order_master table i.e. refers to product_master and category_master table. Below i am showing you tables structure’s. After

Could not load file or assembly ‘System.EnterpriseServices’ or one of its dependencies. An attempt was made to load a program with an incorrect format

Could not load file or assembly ‘System.EnterpriseServices’ or one of its dependencies. An attempt was made to load a program with an incorrect format In this post we will discuss how to solve this error: Could not load file or assembly ‘System.EnterpriseServices’ or one of its dependencies. An attempt was made to load a program with

#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

#1045 – Access denied for user ‘root’@’localhost’ (using password: NO) Hi friends, recently i have installed MySQL on my laptop and all my website hosted on wamp are not working with error: Error establishing a database connection. I tried to connect phpmyadmin but result with another error: #1045 – Access denied for user ‘root’@’localhost’ (using password: NO) or

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Hi Friends, recently i am working with MySQL, i have to set up DSN(data source name) to  access MySQL from Microsoft SQL Server.But ended up with following error: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture

Create Database, Table in MySQL

Create Database, Table in MySQL In this tutorial we will learn Create Database, Table in MySQL, also we will learn how to insert, Update, Delete data into MySQL table. MySQL has almost same syntax as SQL Server. In earlier post we had learnt How to Install MySQL in Windows 7. Script: Create schema dummy; use dummy; CREATE

How to Install MySQL in Windows 7

How to Install MySQL in Windows 7 In this tutorial we will explain How to Install MySQL in Windows 7. You can download MYSQL installer from here. MySQL: MySQL is the world’s second most widely used open source relational database management system. It is named after co-founder Michael Widenius’s daughter, My.The SQL phrase stands for Structured Query