How to access a MySQL database with .NET

This is a comment thread discussing How to access a MySQL database with .NET
  • 14 years ago
    Very goog article!

    Now... I am trying to use the MaxDB version of that database, since it supports stored procedures.

    I have been able to connect and to execute SQL command, but when trying to use a SP it happens an error.

    Example:

    ...
    odbcComm.CommandText = "call playercount";
    ...

    ERROR [42000] [MySQL MaxDB][SQLOD32 DLL][MaxDB] Syntax error or access violation;-3005 POS(1) Invalid SQL statement ERROR [42000] [MySQL MaxDB][SQLOD32 DLL][MaxDB] Syntax error or access violation;-3005 POS(1) Invalid SQL statement

    Have you some experience with this version?

    Best Regards!

    Sergio Cossa
    Argentina
  • 14 years ago
    Dear SergioCossa

    I am new to the MaxDB database and trying to connect from my asp.Net application and Don't have any Idea for the same....Can you just guide me to get a start. And I searched complete web for a solution but could not get a solution - I would like to know whether u r using provider or DSN for establishing connection...If so how and just show by code to have the same...


    thanks

    Santhosh
    India
  • 14 years ago

    Could you please just guide me to write the connection string for asp.net and MaxDB. I have installed MaxDb 7.5 and its ODBC 7.5 and SQL Studio.. But Have no Idea of how to connect to the database from asp.net...


    School Administration at your Finger Tips.

  • 14 years ago

    Can u just tell how do u connect to MaxDB using the languages that u r using...Moreover if you come accross, give some links that highlight on the connectivity of asp.net and MaxDB.


    Intranet Application-E Commerce-web Solutions


    Smart way to be on NET

  • 11 years ago

    maybe this is the wrong place for this specific question, but how do you walk through the data? In Visual Basic 6, using databases was easy. Create a record set, then;   recordsetName!FieldName

    I can't find any easy way to do this in C#. Any ideas?

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” - Antoine de Saint Exupéry