[Mono-list] ODBC.NET Provider on Windows

Brian Ritchie brianlritchie@hotmail.com
Sat, 12 Oct 2002 01:57:49 -0400 

Great news!!

I'm "power-leveling" the odbc code...
- I've jacked in the transaction objects
- I'm straightening out all of the SQL data type mappings.
- DBNull works
- I've implemented the Cancel method

Do we have a #define to force conditional compilation on Linux/Windows?  I'd 
like to setup the libodbc to point at odbc32 on windows.  Or is there a 
better way?

I'll be checking this stuff in this weekend.

Brian


>From: "Daniel Morgan" <danmorg@sc.rr.com>
>To: "Brian Ritchie" <brianlritchie@hotmail.com>,   "Mono-List" 
><mono-list@ximian.com>
>Subject: RE: [Mono-list] ODBC.NET Provider on Windows
>Date: Fri, 11 Oct 2002 22:53:16 -0400
>
>Brian,
>
>It works on Windows too!!!!
>
>I compiled and ran the OdbcTest on .NET 1.1 beta on Windows and on Mono on
>Windows.  It works on both.  I had to use a DSN and change something in my
>DSN in ODBC Sources in the Control Panel.
>However, I made the authentication set to SQL Server (not NT) and set my
>default database to pubs.
>
>			dbcon.ConnectionString =
>				"DSN=LocalServer;UID=sa;PWD=";
>
>DanielMorgan@DANPC ~/mono/mcs/class/System.Data/Test
>$ mcs OdbcTest.cs -r System.Data.dll
>Compilation succeeded
>
>DanielMorgan@DANPC ~/mono/mcs/class/System.Data/Test
>$ mono OdbcTest.exe
>ODBCInit Complete.
>WARNING: Unknown type 0
>Last Name: Cruz
>
>
>
>Last Name: Roulet
>
>
>
>Last Name: Devon
>
>
>
>Last Name: Domingues
>
>
>
>Last Name: Hernadez
>
>
>
>Last Name: Schmitt
>
>
>
>Last Name: Tonini
>
>
>
>Last Name: Roel
>
>
>
>Last Name: Lincoln
>
>
>
>Last Name: Chang
>
>
>
>Last Name: Thomas
>
>
>
>Last Name: Bennett
>
>
>
>Last Name: Nagy
>
>
>
>Last Name: Snyder
>
>
>
>Last Name: Labrune
>
>
>
>Last Name: Josephs
>
>
>
>Last Name: Jablonski
>
>
>
>Last Name: Brown
>
>
>
>Last Name: Lebihan
>
>
>
>Last Name: Larsson
>
>
>
>Last Name: Pereira
>
>
>
>Last Name: Rance
>
>
>
>Last Name: Paolino
>
>
>
>Last Name: Smith
>
>
>
>Last Name: Sommer
>
>
>
>Last Name: Karttunen
>
>
>
>Last Name: Pontes
>
>
>
>Last Name: Saveley
>
>
>
>Last Name: McKenna
>
>
>
>Last Name: Ibsen
>
>
>
>Last Name: Franken
>
>
>
>Last Name: Accorti
>
>
>
>Last Name: Koskitalo
>
>
>
>Last Name: Afonso
>
>
>
>Last Name: Parente
>
>
>
>Last Name: Cramer
>
>
>
>Last Name: Henriot
>
>
>
>Last Name: Mendel
>
>
>
>Last Name: Muller
>
>
>
>Last Name: Ottlieb
>
>
>
>Last Name: O'Rourke
>
>
>
>Last Name: Ashworth
>
>
>
>Last Name: Latimer
>
>
>
>
>Unhandled Exception: System.NotImplementedException: The requested feature
>is no
>t yet implemented
>in <0x0002b> 00 System.Data.Odbc.OdbcCommand:Dispose (bool)
>in <0x00015> 00 System.ComponentModel.Component:Dispose ()
>in <0x00174> 00 Test.OdbcTest.OdbcTest:Main (string[])
>
>
>-----Original Message-----
>From: mono-list-admin@ximian.com [mailto:mono-list-admin@ximian.com]On
>Behalf Of Daniel Morgan
>Sent: Friday, October 11, 2002 11:18 AM
>To: Brian Ritchie; Mono-List
>Subject: RE: [Mono-list] ODBC.NET Provider on Windows
>
>
>Yes, it got me further, I still have a problem.  However, I think you said
>System.Data.Odbc does not have support for DSN-less connections yet.
>
>This is what I get now:
>
>DanielMorgan@DANPC ~/mono/mcs/class/System.Data/Test
>$ mono OdbcTest.exe
>ODBCInit Complete.
>ERROR: SQLConnect: <Error>
>ERROR: SQLAlloc(Prepare): <Error>
>ERROR: SQLPrepare: <InvalidHandle>
>ERROR: SQLExecute: <InvalidHandle>
>ERROR: SQLCancel: <InvalidHandle>
>
>Unhandled Exception: System.NotImplementedException: The requested feature
>is no
>t yet implemented
>in <0x0002b> 00 System.Data.Odbc.OdbcCommand:Dispose (bool)
>in <0x00015> 00 System.ComponentModel.Component:Dispose ()
>in <0x00174> 00 Test.OdbcTest.OdbcTest:Main (string[])
>
>
>-----Original Message-----
>From: Brian Ritchie [mailto:brianlritchie@hotmail.com]
>Sent: Friday, October 11, 2002 10:28 AM
>To: Daniel Morgan; Mono-List
>Subject: Re: [Mono-list] ODBC.NET Provider on Windows
>
>
>Here's the fix...
>
>In libodbc.cs, the OdbcReturn enum needs to be a short.
>
>internal enum OdbcReturn : short {
>Error = -1,
>
>InvalidHandle = -2,
>
>StillExecuting = 2,
>
>NeedData = 99,
>
>Success = 0,
>
>SuccessWithInfo = 1
>
>}
>
>Let me know if this works for you,
>
>Brian
>
>----- Original Message -----
>From: "Brian Ritchie" <brianlritchie@hotmail.com>
>To: "Daniel Morgan" <danmorg@sc.rr.com>; "Mono-List" <mono-list@ximian.com>
>Sent: Friday, October 11, 2002 9:17 AM
>Subject: Re: [Mono-list] ODBC.NET Provider on Windows
>
>
> > Guys,
> >
> > I'm able to duplicate the problem.  The very first call into odbc32 is
> > failing.  It is a pretty basic call...it only allocates the first 
>handle.
> > So, it appears to be some sort of interop problem with the dll.  I'm 
>still
> > checking into it.  Let me know if you have any thoughts.
> >
> > Brian
> >
> > ----- Original Message -----
> > From: "Daniel Morgan" <danmorg@sc.rr.com>
> > To: "Mono-List" <mono-list@ximian.com>
> > Sent: Friday, October 11, 2002 3:49 AM
> > Subject: [Mono-list] ODBC.NET Provider on Windows
> >
> >
> > > Rodrigo and Brian
> > >
> > > I have tried to get the Odbc.net provider to use Microsoft Window's
>native
> > > ODBC library which is odbc32.dll by changing the DllImport from
>"libodbc"
> > to
> > > "odbc32".  The library apparently loads,
> > > but I don't know what the errors are for.
> > >
> > > Any ideas?
> > >
> > > This is the results I got:
> > >
> > > DanielMorgan@DANPC ~/mono/mcs/class/System.Data/Test
> > > $ mono OdbcTest.exe
> > > ERROR: SQLAllocHandle: <528285696>
> > > ERROR: SQLSetEnvAttr: <528285696>
> > > ODBCInit Complete.
> > > ERROR: SQLAllocHandle(hdbc): <528285696>
> > > ERROR: SQLConnect: <65535>
> > > ERROR: SQLAlloc(Prepare): <528351231>
> > > ERROR: SQLPrepare: <528351230>
> > > ERROR: SQLExecute: <528351230>
> > > ERROR: SQLCancel: <528351230>
> > >
> > > Unhandled Exception: System.NotImplementedException: The requested
>feature
> > > is no
> > > t yet implemented
> > > in <0x0002b> 00 System.Data.Odbc.OdbcCommand:Dispose (bool)
> > > in <0x00015> 00 System.ComponentModel.Component:Dispose ()
> > > in <0x00174> 00 Test.OdbcTest.OdbcTest:Main (string[])
> > >
> > > I have a ODBC.net test named OdbcTest.cs that works on Windows XP
> > > using .NET 1.1 Beta, but not Mono:
> > >
> > > using System;
> > > using System.Data;
> > > using System.Data.Odbc;
> > >
> > > namespace Test.OdbcTest
> > > {
> > > class OdbcTest
> > > {
> > > [STAThread]
> > > static void Main(string[] args)
> > > {
> > > OdbcConnection dbcon = new OdbcConnection();
> > > // connection string to a Microsoft SQL Server 2000 database
> > > dbcon.ConnectionString =
> > > "DRIVER={SQL Server};" +
> > > "SERVER=(local);" +
> > > "Trusted_connection=true;" +
> > > "DATABASE=pubs;";
> > >
> > > dbcon.Open();
> > >
> > > OdbcCommand dbcmd = new OdbcCommand();
> > > dbcmd.Connection = dbcon;
> > > dbcmd.CommandType = CommandType.Text;
> > > dbcmd.CommandText = "SELECT lname FROM employee";
> > >
> > > OdbcDataReader reader;
> > > reader = (OdbcDataReader) dbcmd.ExecuteReader();
> > >
> > > while(reader.Read()) {
> > > Console.WriteLine("Last Name: " + reader[0].ToString());
> > > }
> > > reader.Close();
> > > dbcmd.Dispose();
> > > dbcon.Close();
> > > }
> > > }
> > > }
> > >
> > >
> > >
> > > _______________________________________________
> > > Mono-list maillist  -  Mono-list@ximian.com
> > > http://lists.ximian.com/mailman/listinfo/mono-list
> > >
> >
> > _______________________________________________
> > Mono-list maillist  -  Mono-list@ximian.com
> > http://lists.ximian.com/mailman/listinfo/mono-list
> >
>
>
>_______________________________________________
>Mono-list maillist  -  Mono-list@ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-list
>
>
>_______________________________________________
>Mono-list maillist  -  Mono-list@ximian.com
>http://lists.ximian.com/mailman/listinfo/mono-list




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com