Re: MySql ado.net connector problem


"Mark Rae" <mark@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%234hNCN$lFHA.3312@xxxxxxxxxxxxxxxxxxxxxxx
> "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?
Yes, I installed it and from what I can tell, it simply copied the dll to
the C:\Program Files\MySql\etc, etc, etc...

>
> > 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?
That is the connection string that I was given from my host. It's not the
connection string that is the problem(yet) because if I even try to allocate
a MySqlCommand object like this MySqlCommand command = new MySqlCommand() I
will get the exception.

>
> 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"
>
>

I'm wondering if there are libraries in the MySql Server app that I need to
have?


.

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: VS 2003 + opening a connection to SQL SERVER 2000 database
    ... > on the old development machine to be able to connect to SQL Server. ... What does your connection string look like? ... >>> Is this a web app? ... >>> use your local ASPNET account? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: error running off IIS
    ... I've a simple web app that pulls data from an excel sheet into a small ... When I copy the project to IIS wwwroot folder I get a ... Below is my connection string stored in web.config ...
    (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)