MySql connection error while using asp.net with mysql connector 6.6.4, .Net ver 2.0

A strange error is shown while trying to connect:

"Arithmetic operation resulted in an overflow".

After some searching, I found that this is a bug in MySql connector. It occurs when you use select old authentication (hash) method while creating the database user in MySql.

Command to set password using old method is:
set password for 'oldpassuser'@'localhost' = old_password( '123' )

To solve it, just change the method through admin and use new method (4.1+) while setting the password.


Command to set password using new method is:
set password for 'oldpassuser'@'localhost' = password( '123' )

Problem: Error "Port 80 in use by System" while starting Apache through XAMPP.
Platform: Windows 7, IIS not installed.

After some searching, I found following service was using port 80: Web Deployment Agent Service. I stopped it and the problem was solved.

Error running MySQL (XAMPP) on Windows 7

XAMPP Ver: 1.7.7 (win32)

I was getting error: #2002 Cannot log in to the server.

I first uncommented my.ini - bind-address="127.0.0.1". Then the error changed to "Invalid settings"

Then I changed passwords from Apache Admin page - Security - Link for updating security settings.

I changed "config.inc.php" under \xampp\phpmyadmin folder - $cfg['Servers'][$i]['password'] = 'root'.

Finally I checked my firewall - it was "Rule Based" for the process "mysqld". I changed it to "Allow All Activity"

Restarted Mysql from XAMPP control panel.

It worked! Will find the exact reason later!

Fixing MySQL error - "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)"

On one of our websites, the above error started showing suddenly after an upgrade. There seemed to be no reason for this error as there were no updates on the database or any related component.

After quick googling, there were no. of solutions proposed. Basically, all solutions mentioned that code & MySQL should handle strings using same char set & collation.

I tried changing collation of tables using phpMyAdmin's "Operations" tab. It changed charset & collation for the table, but did not affect individual columns of the table.

I then tried executing this query:

ALTER TABLE `dataexchange`.`crnotes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

But, it failed showing me "Error copying file ???? to table-name, errno 150". Error No. 150 is foreign key constraint error.

I created this a SQL file containing following commands and tried from phpMyAdmin's "Import" tab, And it worked:


/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

ALTER TABLE `dataexchange`.`crnotes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;


One more point, I had tried same set of commands from "SQL" tab of phpMyAdmin, which did not work.

Creating PDF files

There are many options available for converting existing documents to PDF format. Many free tools are available which do it through a print driver.

Most of them create PDF output comprising of a single image for the entire page. This hampers the quality of the output in PDF due to scaling. Ideally, each object (text, image, etc) should be written to PDF using the same object type within the PDF.

After much trial, I found that Corel does what is exactly needed. So, if you want to create good quality, scalable, without distorting text within the PDF, use CorelDraw's "Save As" feature. It creates excellent quality PDF using the same object types as used in the original CorelDraw document.


http://www.alliedsoftech.com
Medical, Retail, Shop, Software, Drug, Store, Management, System, Pharmacy, Pharmaceutical, Distributor, Wholesaler, Billing, Stockist, Hospital, OPD, IPD, Healthcare, Laboratory, Hotel, Restaurant, Bar, Lodge, Garment, POS

Accessing HTTPS web page through ports other than 443 through SSL under ISA Server

Hi.

Many hosting control panel provide their interface through HTTPS website with port other than 443. e.g. Contro Panel link for a host might look like https://www.cpanel.com:8440. ISA server does not allow requests through ports other than 443.

While scratching my head, trying to figure out a solution, searching on the net, I found that there is a utility called ISAtrpe which creates a "tunnel" under ISA to allow such requests.

Click Here for more detailed explanation.

Download ISAtrpe from here.

ASP.NET error - BC30456: 'Title' is not a member of ...

The error message shown is misleading. This error is caused by using same code behind class in two .aspx pages in Inherits='xxx' clause. Remove the duplication and deploy again.