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

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

problem to connect mysql remote db

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

hi friends,

i am getting problem to connect to my remote sqlserver database..

i have connection string as follows


add name="ConnStr" connectionString="DRIVER={MySQL ODBC 3.51 Driver};SERVER=;PORT=3306;DATABASE=mydb name;UID=username;PASSWORD=mypasswd;OPTION=3;" />


i am giving all information correctly..

View Complete Post

More Related Resource Links

MySQL: can't connect from remote client code


I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts

In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.

private void button8_Click(object sender, EventArgs e)
string MyConString = "server=db.MYSITE.dk;user;" +
"pwd=PASSWORD;database=DATABASE" ;

label1.Text = label1.Text + MyConString;

MySqlConnection connection = new MySqlConnection();
connection.ConnectionString = MyConString;

catch (MySqlException ex)
label7.Text = ex.Message;


I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.

Any help that will allow me to connect to the database from my client application I much appreciated. I use connector 6.2.4



how to connect to Remote mySql Server?


Hi there,

i have installed mysql server on linux on remote server.

now i want to connect it from my local mysql server which is on windows.

whenever i connect to mysql server i get the error 

Error No: 1130

Host '' is not allowed to connect to this mysql server.

this= my remote server which is on linux...

please help how to connect it?

Error No. 1130
Host '' is not allowed to connect to this MySQL server

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?

need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

Connection Problem with mysql and asp.net

i'm using this string to connect with mysql and asp.net but still agot the connection problem. the connection is not going to open............. i got the following error....... ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified please help me come from this problem "DRIVER={MySQL ODBC 3.51 Driver};DSN=sql4;SERVER=;DATABASE=myppw; UID=kraft; PASSWORD=myka; OPTION=3"

WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7

Hi, WCF Client (netTcpBinding) does not connect to remote DNS on Vista and Windows 7. With other OS like XP and Windows 2003, client connects to remote DNS properly. I got the following exception. Same client works in Vista and Windows 7 if service is available in local network. Following are the exceptions: <Exception> <ExceptionType>System.ServiceModel.EndpointNotFoundException, System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> <Message>No DNS entries exist for host icelive.theice.com.</Message> <StackTrace> at System.ServiceModel.Channels.DnsCache.Resolve(String hostName) at System.ServiceModel.Channels.SocketConnectionInitiator.GetIPAddresses(Uri uri) at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.TracingConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout) at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.Comm

Problem with MOM using DMO to connect to SQL 2000 instance

Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

Problem Linking SQL 2008 with MySQL

Hi, Iam trying to add a Linked Server in sql2008 with a MySQL database. My OS is Windows SERVER 2008 64bit. My Odbc connection works just fine using mysql odbc connector 5.1 The Problem is that i cannot  establish the new linked server connection . I receive the following message : Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "B2B1". (.Net SqlClient Data Provider) Any Ideas? Thanks in advance  

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Problem with users needing sysadmin server role to connect to db

When we create a new user in SQL Management Studio 2005 and give it just the public server role, it does not allow us to connect to the db. We found that we had to give it the sysadmin server role in order to allow it to connect to the db. We are using a UDL file in order to test connect. It seems that this is true for all users we create in SQL Management Studio 2005. Is there a way where we can change it so that users are not required to have the sysadmin server role in order to connect to a db? We would like it so that if they have at least the public server role, they should be able to connect to the db.

problem in Transferring a large dataset to remote machine by using the NetTcpBinding

i am developing an WCF application, in which i have to transfer a large dataset to the remote machine!! for that im using nettcpbinding in WCF but i got this exception ' The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '10:29:59.4140000'. at my sender side.   Sender/Client side code   // Object for sending to remote client using (_dpParameters = new DPParameters()) { _dpParameters.SequenceFieldName = "Sequence"; _dpParameters.Size = 10; _dpParameters.SubjectsForFiles = "S,Y,T"; _dpParameters.SubjectNames.Equals(SubjectNames); _dpParameters.FilePath = " E:\\Source\\Phospho.xml"; // this dataset can be in GBs but for testing me using jst 6.78mb DataSet ds = new DataSet(); ds.ReadXml(_dpParameters.FilePath); _dpParameters.Usd = ds.Tables[0]; } /// This is the binding settings NetTcpBinding tcpBinding = new NetTcpBinding(); tcpBinding.ReceiveTimeout = new TimeSpan(10, 30, 00); tcpBinding.SendTimeout = new TimeSpan(10, 30, 00); tcpBinding.MaxBufferSize.Equals(67108864); tcpBinding.MaxBufferPoolSize.Equals(67108864); tcpBinding.MaxReceivedMessageSize.E

BIDS Connection Manager Cannot Connect to Remote Oracle Db

Hi All,
I'm not having much luck getting an 'Oracle Provider for OLE DB' remote connection in connection manager to work when creating an SSIS package in BIDS.

I've covered off all the steps in the following link

The local machine is running SQL 2005 Sp2 Enterprise Edition on W2003 Sp2 Standard Edition X64

Using the Oracle 'Net Configuration Assistant' I can connect successfully to the remote service

I'm using ODAC 10g Release 2.

The steps to reproduce the error are as follows

1. in BIDS after creating an SSIS Solution
2. Right click in the  Connection Manager and select new OLE DB Connection
3. Click 'New'
4. Select 'Oracle provider for OLE DB'
5. Under server I enter the service name that I created in the Oracle 'Net Configuration Assistant'
6. Enter the user name and password as I entered in the Oracle 'Net Configuration Assistant'
7. When I click 'Test Connection' I get the following error

Test connection failed because of an error in initializing provider. ORA-12154: TNS could not resolve the connect identifier specified

I've spent a lot of time trying to get this to work and tried othe

Connect vwd 2010 to remote iis 7.5


How do I connect to a remote site in IIS 7.5 using vwd 2010?  vwd 2010 appears to be looking for deprecated software instead of the IIS 7.5 supported protocol using webdav.  My application uses a cookie authentication from a central corporate authority and nothing but a legitimate URL is going to work during debugging.  There is almost no information in a google search and the only forums.asp.net post from last year says it isn't possible.  If MS is no longer supporting FPSE in the new versions of IIS, then what is vwd 2010 doing looking for it--is there a patch or module of some kind that is available to enable webdav access?

Problem with remote connection using NetTcpBinding in WCF...



I try to implement a file storage and recovery system using WCF and NetTcpBinding, when I test the system locally (in the same sub-red) all work fine, but I can't communicate with my server application from another domain (not in the same sub-red). I was verify all the configuration for my machine firewall, router and application, but I not see the problem. My question is: Is possible that WCF or more precisely NetTcpBinding require extra configuration for remote access? It is my app.config file...

<?xml version="1.0"?>
    <compilation debug="true"/>
      <service behaviorConfiguration="BackUpBehavior"
        <endpoint address=""

Cannot Connect to Remote MS SQL Express (error: 26)

Hey guys,
I have tried 
but non of them are working.

I have tried all the settings, without any success.

I am using 
windows 7 ultimate, 
 Visual Studio 2008, 
 linksys wireless router.

I currently disabled my firewall, and have enable traffic on 1037,1434,1433,52369 ports for my router.

So, does anyone have any solution(s) for me to connect to my database remotely?

My codes is as follow:

// attempt 1 : using external IP
String databaseName = "testDB";

string dataSource = @"xx.xx.xx.34\SQLEXPRESS";

MySql connector/net problem


I have a asp.net 4.0 site that can't connect to my hosting company's Mysql server

im using Mysql connector/net 6.3.4 also installed on host server.
i can run the site from my dev server or from my web Hosts server. as long as the connection string host name points to my dev mysql server ....all is good work great.
i have also tried using another company's hosted mysql server... everything works good.

all three databases were created from same dump file...

all three Mysql servers are v5

It would seem to me that my web site code is good.

whenever i change the server host name in the web.config file back to my hosting company's mqsql server i get this error.

This is the error:
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unable to initialize provider.  Missing or incorrect schema.

Source Error:

Line 50:         <add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />
Line 51:      &nbs

connect the shapes with the Data from the SQL Server Problem



I would like to connect the shapes with the Data from the SQL Server. If I do it in the MS Visio I have got the connection and I can update the Data. If I publish it to the Sharepoint as an Web-Drawing (.vdw) I have got an error by updating although it is working in the MS Visio Software.

Thanks in advance

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