Database access samples on IBMi - ADO.Net

[richardschoen]

I downloaded and installed the binary today. Seems to work nicely with the simple hello.cs.

Do you have any database samples yet using ADO.Net ?

Not sure if there is any database drivers that will work on IBMi yet with this port ?

Please let me know.

Thanks
Richard

[NattyNarwhal]

Any ADO.NET provider and consuming code that doesn't call into native code unsupported on PASE should work. Note that if code depends on a native library that is supported, but doesn't load the library, then the DllMap may need to be adjusted. I think Mono comes with an MS SQL, Oracle, Unix DB2, and SQLite provider out of the box.

As mentioned in the README, the IBM-supplied DB2/400 provider won't work due to requiring an ODBC provider only available as a Win32 DLL. Working on cross-platform (including from i) ways to access DB2/400 in .NET is an eventual goal of the project, however.

[richardschoen]

Got it. I'll do a little test to see if I can get SQL Server driver to work.

[richardschoen]

What level of .Net is supported ? I might be able to tweak my XMLSERVICE wrapper code to work since that uses HTTP.

[NattyNarwhal]

The MS SQL driver changed quite a bit in newer Mono; if authentication doesn't work, let us know, as we may have to integrate Kerberos stuff inside. (I'll ask upstream to clarify the situation further, if needed.)

The latest .NET Framework should be supported; there's no need to use Core binaries.

[richardschoen]

Tried to use the System.Data namespace.

Should that be part of the base Mono build or is there something I need to include on the mcs command line ?
I simply added the following line to the hello.cs program:
System.Data.Datatable dt = new SYstem.Data.DataTable();

Got following compile error: CS0234: The type or namespace Data does not exist in the namespace System. Are you missing 'System.Data' namespace reference ?

My first time using command line compile with Mono :-)

[NattyNarwhal]

-r:System.Data should do it. Alternatively, you can compile software from another system (including compiled with Visual Studio) and it should work.

[richardschoen]

Yep. If I get SQL Server connection working I'll do a little speed test.

[richardschoen]

ConsoleApp2SqlClient.cs.txt

Very simple DB console app attached.

Throw following error when called from PASE on IBMi:

Error:Snix_Connect (provider: SNI_PN7, error: 25 - SNI_ERROR_25)
Snix_Connect (provider: SNI_PN7, error: 25 - SNI_ERROR_25)

Used old style SQL Server connection string syntax.

I'll play some more, but it appears that something with DB access isn't quite right yet.

[NattyNarwhal]

We'll try to get a test environment set up; I myself am not familar with MS SQL, so it might take some poking once it happens. Some quick ideas:

• The server looks like SQL Server Express based on the name - is this licensed or configured to listen on the network?

• The connection string looks right to us. Might be worth reviewing anyways.

• You're using the "sa" user, which may be treated special.

• Could be a bug in Mono?

[richardschoen]

Yep the sql server is fine and talking to the network.

I'm betting on a bug in mono.

Stack trace in .net gave no detail.

Let me know if there's a secret to tracing these comms in Mono.