Re: MySql ado.net connector problem

"Steve" <sss@xxxxxxx> wrote in message
news:OOfOcB7lFHA.3380@xxxxxxxxxxxxxxxxxxxxxxx

> 1) mysql4.brinkster.com

OK.

> 2) I am trying to connect with asp.net web app. I can connect with the
> "MySql Administrator" application

OK - so we know that mySQL is actually running on that box...

> 3) Yes, I downloaded the ado.net provider from the mysql.com site

And installed it? And added it as a Reference into your ASP.NET project?

> 4) server=mysql4.brinkster.com;user id=xxxxxx; password=xxxxxx;
> database=xxxxxx; pooling=false

Hmm - that doesn't look quite right... Is that similar to the examples for
the .NET provider you got from the web?

I've only ever used the CoreLabs native .NET data provider, in which case
the string would look something like:

"User ID=root; Password=xxxxxx; Host=mysql4.brinkster.com; Port=3306;
Database=xxxxxx;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min
Pool Size=0;Max Pool Size=100; Connection Lifetime=0"


.

Relevant Pages

  • Re: Using Generics with System.DirectoryServices
    ... | I'm in the process of updating an ASP.NET v1.1 web app to v2. ... | WinNT provider - I'm in the process of fixing that too, ... can't use the following sample to query group membership in a NT4 domain. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Website Administration Tool not working from published applica
    ... provider, whom most of them can't afford the fancy of dedicated servers - ... SQL Server 2000 instead of SQL Express ... The first mistake was using ... that the Web App Admin Tool shows when it cannot connect to the database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MySql ado.net connector problem
    ... >> 2) I am trying to connect with asp.net web app. ... > the .NET provider you got from the web? ... That is the connection string that I was given from my host. ... a MySqlCommand object like this MySqlCommand command = new MySqlCommandI ...
    (microsoft.public.dotnet.framework.adonet)
  • Oracle Provider Comparison
    ... I'm creating a web app that needs to provide some simple, ... access to an Oracle database using SELECT statements. ... curious about is which provider ... able to get a paramaterized SqlDataSource to work with the ODP.NET ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Multiple Membership providers and AddUserToRole
    ... I have a question on the same subject if you dont mind? ... The way we have written this web app is ... provider with multiple membership user providers will not work here, ... it always use the fixed applicationName ...
    (microsoft.public.dotnet.framework.aspnet.security)
Loading