mEnable Library

[elriba]

I've been using the mEnable library to access desktop databases (Sybase, SQL Server) from a device (I've been using a nsbasic for development).

I was wondering if this library could be used also with Basic4PPC?

Best regards,
Edgard

 

[Erel]

They seem to support .Net applications so you might be able to wrap their library.

 

[agraham]

I don't know if it will work for you but several people have successfully used my MSSQL library to access SQL Server from devices.

 

[elriba]

Thanks, you are right. This is a possibility.

 

[elriba]

Hi,
Thanks. This is really interesting. I'm guessing that you were able to write this library because the Compact Framework has "System.Data.SqlClient".

To access another database I would have to have the actual library to communicate with that database (e.g. System.Data.SqlAnywhere, etc...)....

Best regards
Edgard

 

[agraham]

To give credit where it is due I didn't actually write the library but polished a rough framework written by user citywest into a properly usable library.

The .NET Compact Framework, unlike .NET on the desktop, supports only connections to SQl Server by the classes included in the System.Data.SqlClient namespace. As you may well already know the desktop .NET natively supports OLE DB connections as well SQL Server and I believe the Microsoft also had an ODBC add-on for the full .NET Framework but I'm not sure if it is currently available.

I'm not really a database person but my guess would be that if nsbasic could use mEnable then Basic4ppc could but it would need a wrapper library written to expose it to Basic4ppc code. It would seem from the following quote that I found at SYWARE.com that a client side .NET library is available that could probably be wrapped.

The kit includes header and library files that developers can incorporate in their own Visual Basic, C/C++, or .NET applications to enable wireless access to server data via the mEnable Server and Client software.

EDIT :- I'm rusty on this but it looks like ODBC got included in the full framework in the System.Data.Odbc namespace.