Connect to MySQL with MySQLDirect.NET and Visual Web Developer Express 2005

Rabzy · Post by **Rabzy** » Tue 15 Aug 2006 20:34

Hi,

I have problem to connect my DB in Visual web developer express 2005 :

I install the CoreLab.MySql.

I see in the component list : MySqlCommand, MySqlCommandBuilder, MySqlConnexion, MySqlDataAdapter, MySqlDataTable, MySqlDump, MySqlLoader, MySqlMonitor, MySqlScript

But i dont have the MySQL object in the toolbox.

My project start with master page and child page "connexion.aspx".

I put in master page.cs and connexion.cs : using CoreLab.MySql;

My web.config :

My Connexion.aspx have a asp:login object (with Username and Password name field). After this i have a asp:SqlDataSource :

"
SelectCommand="SELECT PKID FROM users WHERE Username = ? AND Password] = ?">

------------------------

When i enter a login pass and press the LoginButton this error append :

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Thanks for your help !

Alexey · Post by **Alexey** » Wed 16 Aug 2006 08:56

Microsoft Web Developer 2005 Express edition does not allow to work with toolbox.

Rabz · Post by **Rabz** » Wed 16 Aug 2006 13:29

Ok for the version of the software !

And for the code use with CoreLab connector and the error :

When i enter a login pass and press the LoginButton this error append :

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Do you know waths the problem.

Thanks for the support !

Alexey · Post by **Alexey** » Thu 17 Aug 2006 06:37

Please send us (address provided in the Readme file) small test project if possible to reproduce the problem; include definition of your own database objects. Do not use third party components.