.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Connecting to MySQL

Posted By:      Posted Date: October 17, 2010    Points: 0   Category :ASP.Net


im new to all this and i have just finishd uploading my latest project

im trying to connect it to a MySQL server but nothing i write in my connection string

works (http://www.connectionstrings.com/mysql) im using C#

is there something i need to do in order to link my 3.5 asp project with mysql? 

View Complete Post

More Related Resource Links

Connecting BCS to ODBC / MySQL sources in SharePoint Designer 2010


Internally we are trying to migrate our MOSS 2007 solution to SP2010 in readiness for RTM.  So far, minus a few tweaks everything has been successful.

However we have a requirement to connect to a MySQL database.  It would be great to do this within SPD 2010 rather than via Visual Studio (which I suspect is the only way).

Does any body have any ideas or suggestions regarding this?

problem connecting to mysql database



I'm new to ASP.net and I'm trying to connect to a mysql database but I'm getting this error when I'm running my application.  Access denied for user 'test_mysql'@'localhost' (using password: YES). I used this tutorial to get this far ( http://www.15seconds.com/issue/050210.htm ) but I don't know how to fix this.


connecting mysql to visual web developer


is there a way to connect mysql to visual web developer like it's connected to visual studio.

notes: i have mysql community server, i have the .net connector , visual web developer 2010 sp1.

thanks in advance

Connecting to MS SQL Server database using webmatrix.



I am novice  user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.

The connection string that i setup as follows.

<?xml version="1.0"?>


        <compilation debug="false" targetFramework="4.0" />
    <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />


And i am using websecurity helper as well and the setup is as follows.

WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);

When i am trying to insert the user details into database i am getting the below error.

Format of t

Individual field - MySQL



I was wondering how to recieve an individual field from my MySQL database.

I have been able to get a row, but what I am trying to do is get a name from my database and set it into the HeaderText in my DataGrid.

The way I am trying to do it at the moment is

using (OdbcCommand cmd = new OdbcCommand(formQuery, con))
                formDataGrid.Columns[0].HeaderText = cmd.ExecuteReader(
                    CommandBehavior.CloseConnection |

This doesn't seem to get a value from the GetValue, but if use

using (OdbcCommand cmd = new OdbcCommand(formQuery, con))
                formDataGrid.DataSource = cmd.ExecuteReader(
                    CommandBehavior.CloseConnection |

it will bind my data into the grid.

I just want to be able to change the HeaderText in the first coulmn of the DataGrid from one table and have the DataGrid be filled from another table.

I can fill the DataGrid its just changing the HeaderText that I am having trouble with.

Any help?

search in mysql database, mvc



I have set up a mysql connection in visual studio 2010 and now i have a connection and dont really know where to go next.

I want to be able to search the data and get the result in a view.

using asp.net mvc

Using LINQ and MySQL


Hi. I am wondering if its possible to use LINQ and MySQL?

I am build as .NET MVC, i have set up my MySQL connection and want to retrive the data and display it in a view, how is this done?

Can i use LINQ or something else or should dont use it at all.

// Thanks

Saving textbox data to MySql database in asp.net


Hi dear coders

though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.

i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net

i will be highly thankful for any kind help from you geniuses.



MySql.Data assembly problem



I added refernece MySql.Data to my project. My web.config looks like that:

<?xml version="1.0"?>
                <add assembly="MySql.Data, Version=, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>

But when in ServerExplorer I try "Add Connection..." I can't find "MySql Database" in the "Choose Data Source" dialog box?

What the problem can be?

get the last inserted row ( autoincrement id ) in mysql database back


In my mysql I have an autoincrement id , whenever I add a new row into database I need to store this id in other table, so how to get this autoincrement Id back?

Help with connecting to SqlExpress 2005 remotely


So I've intalled SQL 2005 Express and Sql Server Management Studio Express (SSMSE). I don't have any problems connecting to it using Windows authentication. But I would like to set it up so that I can log in using Sql Server Authentication with a username and password.

My Problem

But I'm getting an error message of "A connection was successfully established with the server, but then an error occured during the login process. (provider: Shared Memory Provider, error: 0- No process is on the other end of the pipe) (Microsoft SQL Server, Error: 233).

What I've done

I've created a new "Login" in the Security node. Provided all necessary role access level. Granted permission to connect to database and enabled login.

I've used the Sql Server Surface Area Configuration to set the Remote Connection type to "Using TCP/IP only" or "Using Both TCP/IP and named pipes" (tried both, but in either situation I get the same error message when attempting to login to SSMSE with the user name and password). I also made sure to restart the service.

What do I need to do to fix this problem? 

Problems connecting stored procedure to Crystal Reports


I am working on updating a reporting system that uses Crystal Reports.  All of the 250+ reports were created in CR 8 and I have been opening up the old files in Visual Studio 2005 and updating the database location.  All I have had to do with all connections to views and even a couple of stored procedures is create a new connection to the database and then update the old report's datasource location.  The reason I need to update the location is so that the .NET application will use the correct driver.  Everything has worked fine up until I got to one stored procedure.  The old version of the report works perfectly with the stored procedure, but when I try to run the report using VS 2005 I keep getting errors.

First I connected to the database using the Oracle OLE DB provider, then updated the location of the stored procedure in the report.  It then prompts me for the two parameter values for the stored procedure, both of which I keep as NULL so that the report parameters will be passed to the procedure.  Then I get the following error:

Query Engine Error: 'ADO Error Code: 0x
Source: OraOLEDB
Description: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STORED_PROCEDURE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored'

The proce

Checkout/Chevk in issue in MOSS 2007 while connecting through VPN(virtual private network)


HI, I am using VPN connection . When I try modify a file and try to checkin the file in sharepoint document library it does not gets checked in. I get a message saying

"Unable to checkin the file, since File is being edited in Local Draft, please close the application or discard the checkout ".

Please do the needful....



Having Trouble Connecting to BDC


Hello Share Point experts,

For the first time I'm trying to connect to BDC in SharePoint. I created the Application Definition File and successfully uploaded it to the page. Here is the Authentication part of my ADF:

    <AccessControlEntry Principal="domain\admin">
      <Right BdcRight="Execute"/>
      <Right BdcRight="Edit"/>
      <Right BdcRight="SetPermissions"/>
      <Right BdcRight="SelectableInClients"/>
    <AccessControlEntry Principal="domain\admin">
      <Right BdcRight="Execute"/>
      <Right BdcRight="SelectableInClients"/>
  <LobSystemInstance Name="CRMDB">
<Property Name="AuthenticationMode"

Connecting to Oracle on 64bit OS

We have a 64-bit implementation of MOSS 2007. I recently installed the SharePoint SDK to use the Application Definition Designer to connect to Oracle. I enter the connection string and then I get this:

Attempt to load Oracle client libraries threw BadImageFormatException. The problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

I have verified that the server contains the 64 bit version of the Oracle client installed both with the instantclient and with system.data.oracleclient.dll. The only thing I can think of is that the tool was compiled as a 32bit application.  Is there a 64bit version available? Is there something else that I'm missing?

Connecting to Sharepoint Using Windows XP Home




I'm new in using sharepoint and tried to use my windows xp home computer to connect on the company's network. However, when I am trying to join sharepoint as a client computer, I come up with the following message:

Run the wizard to complete networking setup

Problem however, is that the wizard doesn't run.

While I found info describing this issue for win 7 and vista, http://support.microsoft.com/kb/926505, I can't find any regarding XP home.

Can someone kindly assist?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend