Error in asp.net application after converting mssql to mysql

Hi All,

Hw r u ???? Hope u all r doing gr8...

Actually i have designed a website on jobportal in asp.net using sqlserver 2005 as a backend... and now m trying to convert its database to mysql....

I have installed and configured mysql correctly and all the libraries and namespaces working fine for mysql in my existing application... and also using the quick replace facility i have changed the namespaces i.e from System.data.sqlclient to Mysql.Data.Sqlclient and all the dataadapters and everything in MySql... but now when i m running this website m getting these two types of errors :-

1. Login failed for user ''. The user is not associated with a trusted SQL Server connection. Why is it showing for SQL as m using MYSQL as my database and replaced everything of SQL into MYSQL, even from the Web.Config file.


2. A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

------- Sometimes it shows this error...

Plz help to solve these problem ASAP...

Thanx in Advance ...

Rajan Arora.

re: Error in asp.net application after converting mssql to mysql

Please type full words like great instead of gr8.
You didn't change everything. SQL server is using Windows Authentication Mode and so is rejecting sql user accounts.
Also (for later), did you migrate the database data itself and are you making sure MySQL is started before you make the connection all the time?