Hi,

> when I use the wizard to configure the data source in .NET, it throws an
error, unable to
> use this connection or something.

What is this **configure the data source in .NET** ? Can you please elaborate
?

FYI : I used the following compilation options:

csc /t:exe /out:mycon.exe mycon.cs
           /r:System.dll
           /r:System.Data.dll
           /r:"C:\WINNT\Microsoft.NET\Framework\v1.0.2914\System.Data.Odbc.dll

And here is the simple C# sample using ODBC.NET (though its not perfect
sample)
to makeuse of BIGINTs fetch with MyODBC 3.51 driver.

/**
* @sample    : mycon.cs
* @purpose   : Demo sample for ODBC.NET using MyODBC or MyODBC 3.51
* @author    : Venu, [EMAIL PROTECTED]
*
* (C) Copyright MySQL AB, 1995-2002
*
**/

using Console = System.Console;
using System.Data.Odbc;

namespace myodbc3
{
  class mycon
  {
    static void Main(string[] args)
    {
      try
      {
        //Connection string for MyODBC
        /*string MyConString = "DRIVER={MySQL};" +
                             "SERVER=localhost;" +
                             "DATABASE=test;" +
                             "UID=venu;" +
                             "PASSWORD=venu;" +
                             "OPTION=3";
        */
        //Connection string for MyODBC 3.51
        string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
                             "SERVER=localhost;" +
                             "DATABASE=test;" +
                             "UID=venu;" +
                             "PASSWORD=venu;" +
                             "OPTION=35"; // Dynamic cursor support

        OdbcConnection MyConnection = new OdbcConnection(MyConString);

        MyConnection.Open();

        Console.WriteLine("\n !!! success, connected successfully !!!\n");

        //Connection
        Console.WriteLine("Connection Information:");
        Console.WriteLine("\tConnection String:" +
MyConnection.ConnectionString);
        Console.WriteLine("\tConnection Timeout:" +
MyConnection.ConnectionTimeout);
        Console.WriteLine("\tDatabase:" + MyConnection.Database);
        Console.WriteLine("\tDataSource:" + MyConnection.DataSource);
        Console.WriteLine("\tDriver:" + MyConnection.Driver);
        Console.WriteLine("\tServerVersion:" + MyConnection.ServerVersion);

        //Create a sample table
        OdbcCommand MyCommand = new OdbcCommand("DROP TABLE IF EXISTS
my_odbc_net",MyConnection);
        MyCommand.ExecuteNonQuery();
        MyCommand.CommandText = "CREATE TABLE my_odbc_net(id int, name
varchar(20), idb bigint)";
        MyCommand.ExecuteNonQuery();

        //Insert
        MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(10,'venu',
300)";
        Console.WriteLine("INSERT, Total rows affected:" +
MyCommand.ExecuteNonQuery());;

        //Insert
        MyCommand.CommandText = "INSERT INTO my_odbc_net
VALUES(20,'mysql',400)";
        Console.WriteLine("INSERT, Total rows affected:" +
MyCommand.ExecuteNonQuery());

        //Insert
        MyCommand.CommandText = "INSERT INTO my_odbc_net
VALUES(20,'mysql',500)";
        Console.WriteLine("INSERT, Total rows affected:" +
MyCommand.ExecuteNonQuery());

        //Update
        MyCommand.CommandText = "UPDATE my_odbc_net SET id=999 WHERE id=20";
        Console.WriteLine("Update, Total rows affected:" +
MyCommand.ExecuteNonQuery());

        //COUNT(*)
        MyCommand.CommandText = "SELECT COUNT(*) as TRows FROM my_odbc_net";
        Console.WriteLine("Total Rows:" + MyCommand.ExecuteScalar());

        //Fetch
        MyCommand.CommandText = "SELECT * FROM my_odbc_net";
        OdbcDataReader MyDataReader;
        MyDataReader =  MyCommand.ExecuteReader();
        while (MyDataReader.Read())
        {
         if(string.Compare(MyConnection.Driver,"myodbc3.dll") == 0) {
           Console.WriteLine("Data:" + MyDataReader.GetInt32(0) + " " +
                                       MyDataReader.GetString(1) + " " +
                                       MyDataReader.GetInt64(2)); //Supported
only by MyODBC 3.51
         }
         else {
           Console.WriteLine("Data:" + MyDataReader.GetInt32(0) + " " +
                                       MyDataReader.GetString(1) + " " +
                                       MyDataReader.GetInt32(2)); //BIGINTs
not supported by MyODBC
         }
        }

        //Close all resources
        MyDataReader.Close();
        MyConnection.Close();
      }
      catch (OdbcException MyOdbcException)
      {
         Console.WriteLine("Error" + "\n" +
          "NATIVE: " + MyOdbcException.Errors[0].NativeError.ToString() + "\n"
+
          "SQLSTATE: " + MyOdbcException.Errors[0].SQLState + "\n" +
          "MESSAGE: " + MyOdbcException.Errors[0].Message );
      }
    }
  }
}
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
       <___/  www.mysql.com





---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to