rdsimg.png

<div>
Hi,<br />
<br />
String parameters were all right, it was to do with the rds vpc security group as you said.<br />
<br />
Thanks,<br />
Stuart
</div>


Hi,

String parameters were all right, it was to do with the rds vpc security group as you said.

Thanks,
Stuart

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have installed MySQL for Visual Studio and the .net connector and I have tried this connection string in my app.config:<br />
<br />
&lt;add name=&quot;mysqlGrowercon&quot; connectionString=&quot;Server=*<wbr />****;Port=<wbr />3306;Datab<wbr />ase=Grower<wbr />Reports;Ui<wbr />d=Develope<wbr />r;Pwd=****<wbr />*&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; providerName=&quot;MySQL.Data.M<wbr />ySQLClient<wbr />&quot; /&gt;<br />
<br />
And I've tried adding the connection through the Data Source Configuration Wizard but either way I get:<br />
<br />
There has been an error, The handshake failed due to an unexpected packet format.<br />
<br />
I can connect okay to a SQL Server Amazon RDS just not this MySQL Amazon RDS.<br />
Anyone know what I'm doing wrong?<br />
<br />
Thanks,<br />
Stuart
</div>
</div>


Hi,

I have installed MySQL for Visual Studio and the .net connector and I have tried this connection string in my app.config:

<add name="mysqlGrowercon" connectionString="Server=*****;Port=3306;Database=GrowerReports;Uid=Developer;Pwd=*****"
            providerName="MySQL.Data.MySQLClient" />

And I've tried adding the connection through the Data Source Configuration Wizard but either way I get:

There has been an error, The handshake failed due to an unexpected packet format.

I can connect okay to a SQL Server Amazon RDS just not this MySQL Amazon RDS.
Anyone know what I'm doing wrong?

Thanks,
Stuart

Connecting to MySQL Amazon RDS from VB.NET Visual Studio 2013

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Amazon Web Services (AWS), is a collection of remote computing services, also called web services, that make up a cloud-computing platform  operated from 11 geographical regions across the world. The most central and well-known of these services include Amazon Elastic Compute Cloud, also known as "EC2", and Amazon Simple Storage Service, also known as "S3". Other services include Elastic MapReduce (EMR), Route 53 (a DNS web service),  provides a highly available and scalable Domain Name System (DNS) web service, Virtual Private Cloud (VPC), storage, database, deployment and application services.