mysql reference with asp.net

Question

0.00/5 (No votes)

See more:

HI
i m making website in asp.net and want to pass mysql.data.dll with my project..
i copied it in bin folder..and i dont have any entry in web.config..

i uploaded site in a server

and when i use

C#

using MySql.Data.MySqlClient;  in my default.aspx

i get error as

C#

Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. 

Compiler Error Message: CS0246: The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?)

Source Error:


Line 1:  using System;
Line 2:  
Line 3:  using MySql.Data.MySqlClient;
Line 4:  
Line 5:

pls can u help me out

I also added as reference and then what to do before putting it to server

also to upload solution to server

should i publish website or build website or what ??

My question is : i make a asp.net website and want to upload on windows server

Posted 26-Sep-13 20:44pm

maulikshah1990

Updated 26-Sep-13 21:15pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

Comments

walterhevedeich 27-Sep-13 2:48am

You did not mention anything about adding it as a reference on your web application project. Copying on the folder is not enough. You need to add it as reference as well.

Thomas ktg 27-Sep-13 3:15am

Yes i agree with Walterhevedeich.

maulikshah1990 27-Sep-13 3:17am

I also added as reference and then what to do before putting it to server

also to upload solution to server

should i publish website or build website or what ??

My question is : i make a asp.net website and want to upload on windows server

Harshil_Raval 27-Sep-13 3:19am

Hi, how you get this mysql.data.dll? I think you have followed this steps.
http://dev.mysql.com/doc/refman/5.6/en/connector-net-installation-windows.html
If yes, then check on your server.. have these steps followed or not?

maulikshah1990 27-Sep-13 3:22am

hii dont have access to server ..only details as

MySQL 5.1.68
MySQL Connector/NET 3.51.25

which version from above should be mysql.data.dll version to download

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Sep-13 3:26am

Then how did you deploy your app?

maulikshah1990 27-Sep-13 3:28am

I want to know how to deploy the website application made in asp.net

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Sep-13 3:35am

Please follow some Links/Articles on Google[^].

Harshil_Raval 27-Sep-13 3:30am

Hi, My first question is, have you install mysql connector in your pc(system). And it is working fine in your system. If it's working fine, then contact your server administrator for this problem. Whether, they provide access to mysql or not. You should ask them before publishing your app. First contact them and ask about this.

maulikshah1990 27-Sep-13 4:10am

I asked the server admin and they said that mysql is working properly

pls explain steps to make a simple asp.net website with mysql connection and upload to server after build

Harshil_Raval 27-Sep-13 4:48am

Hi, First download and install mysql connector from http://dev.mysql.com/downloads/connector/net/1.0.html. If you don't know how to do it. then follow this http://dev.mysql.com/doc/refman/5.6/en/connector-net-installation-windows.html. Then Get mysql.data.dll from application installed path/bin. In bin folder you will find this dll. Then search on google for demo app. one link from that is http://www.codeproject.com/Articles/43438/Connect-C-to-MySQL. After creating your app. Just clean,build and publish it. Make sure in bin folder you have your mysql.data.dll. It should work for you. Best of luck.

maulikshah1990 27-Sep-13 5:31am

hi
i tried to connect mysql from php code and it was successfull
but when i try to connect mysql .net connector ,, i get error as

Compiler Error Message: CS0246: The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?)

Harshil_Raval 28-Sep-13 0:28am

So, your php app works fine on server right. But it's not working in asp.net. As per my knowledge to use mysql you have to install mysql connector, whether it is your local system or server!!! I am not sure how to handle it on server, as we don't have rights to do so. Just contact to admin again, and ask for the same.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Singh Gyan · Answer 1 · 2013-09-30T01:54:00

Solution 1

you need to go to

project- add refrences
than you need to select System.Data.SQLClient

Hope this will resolve your problem.

Posted 30-Sep-13 1:54am

Singh Gyan