[Mono-list] ODBC.NET Provider on Windows
Brian Ritchie
brianlritchie@hotmail.com
Sat, 12 Oct 2002 03:07:24 -0400
Thanks for the info...I should have known you guys would already have this
figured out :-)
>From: "Daniel Morgan" <danmorg@sc.rr.com>
>To: "Brian Ritchie" <brianlritchie@hotmail.com>, <mono-list@ximian.com>
>Subject: RE: [Mono-list] ODBC.NET Provider on Windows
>Date: Sat, 12 Oct 2002 02:19:17 -0400
>
>The mono module in cvs in directory data, there is a file config.in, you
>will see something like:
>
><configuration>
> <dllmap dll="cygwin1.dll" target="@LIBC@" />
> <dllmap dll="libc" target="@LIBC@" />
> <dllmap dll="libxslt.dll" target="libxslt.so" />
> <dllmap dll="libmySQL.dll" target="libmysqlclient.so" />
></configuration>
>
>Add the following line:
> <dllmap dll="odbc32.dll" target="libodbc.so" />
>
>In you DllImport where you have "libodbc", use "odbc32.dll" instead.
>
>On Windows, the mono runtime will use "odbc32.dll" while on on Linux the
>mono runtime will use "libodbc.so" based on the config file and what you
>use
>in your DllImport.
>
>-----Original Message-----
>From: Brian Ritchie [mailto:brianlritchie@hotmail.com]
>Sent: Saturday, October 12, 2002 1:58 AM
>To: danmorg@sc.rr.com; mono-list@ximian.com
>Subject: RE: [Mono-list] ODBC.NET Provider on Windows
>
>
>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
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx