Microsoft SQL

[Nolan Bradshaw]

Has anyone successfully used Microsoft SQL with Haxe. I am attempting to make an application with haxeui for a small maintenance application that has an SQL Connection. Also, we are looking at possibly making this to talk to agilent and other devices however, I have yet to see anything regarding this as well. Any help with Microsoft SQL would be good. I'm not a new programmer, but their isint much information regarding this topic.

Thank you,

Nolan Bradshaw

[Nolan Bradshaw]

No one has done this yet? I would think I would have received some sort of instruction forward. I guess I will have to make a ndll or something for microsoft sql. :(

[Cauê Waneck]

Hi,

In a recent Haxe build, there's support for all ADO.NET compatible drivers if you're compiling to C#. It's still very experimental, but it passes the database tests in Haxe - which are still not many.

The class is called `cs.db.AdoNet`: https://github.com/HaxeFoundation/haxe/blob/development/std/cs/db/AdoNet.hx#L5
In order to use it, you'll need to reference the `System.Data` assembly using `-net-lib` like this: https://github.com/HaxeFoundation/haxe/blob/development/tests/unit/compile-cs-travis.hxml#L3

With this setup, you'll be able to connect to any MS SQL database.

Cheers
Cauê

2015-02-07 19:01 GMT-02:00 Nolan Bradshaw <nolanjb...@gmail.com>:

No one has done this yet? I would think I would have received some sort of instruction forward. I guess I will have to make a ndll or something for microsoft sql. :(

--
To post to this group haxe...@googlegroups.com
http://groups.google.com/group/haxelang?hl=en
---
You received this message because you are subscribed to the Google Groups "Haxe" group.
For more options, visit https://groups.google.com/d/optout.

[Nolan Bradshaw]

I'm getting a permission denied even though i've  added a directory cs_drivers and placed the dll in there I always changed permissions something is going on where it just wont install easily.I'll keep hacking at it

You received this message because you are subscribed to a topic in the Google Groups "Haxe" group.

[Cauê Waneck]

You're probably making the output directory to be in a place inside your haxe installation. It's best to copy the cs_drivers somewhere else, and use it from there.

[Cauê Waneck]

Also note that with -net-lib you can ditch the sys.db.* implementation completely and use the ado.net interface itself.

[Nolan Bradshaw]

Update: I'm not receieving this error:

File "ilMetaReader.ml", line 281, characters 36-42: Assertion failed

error 0x2

[Nolan Bradshaw]

Let me correct that I am now receiving that error

[Cauê Waneck]

Are you using only the -net-libs specified at cs_drivers? Are you using a recent haxe build? If possible, can you update to the very latest? You can download a build at builds.haxe.org

Also, can you share the code you're using?

[Nolan Bradshaw]

Yes, I got the latest build from the development branch

I grabbed a dll that I was using that was compiled in a previous .net application.

The only thing is that the haxelib i'm using shows version 3.1.0rc-4

haxe compiler version Haxe Compiler 3.2.0  (git build development @ 216083e)

I installed hxcs,..

The build.hxml I have is currently

--build.hxml--

-main Main

-cs Main.cs

#for ado.net

-net-lib "D:\Development\HaxeProjects\cs_drivers\System.Data.dll"

current error:

File "ilMetaReader.ml", line 281, characters 36-42: Assertion failed

error 0x2

I might be doing this incorrectly, as I'm only a week old in haxe. If I am  doing it wrong please let me know.

As of now I have an SQL class that basically has nothing

--SQL.hx--

package ;

import sys.db.Connection;

class SQL 

{

private static var connection:Connection;

}

[Cauê Waneck]

Hmm I don't see the problem on Linux:
$ haxe -cs cs -main Main -net-lib /usr/lib/haxe/tests/unit/cs_drivers/System.Data.dll                                                                                                                                                            
haxelib run hxcs hxcs_build.txt --haxe-version 3200 --feature-level 1

Can you try the very latest version? I've been working actively on -net-lib lately, and you might just have happened to grab an unstable version.

[Nolan Bradshaw]

I'm on windows

my current version i am using is 

2015-02-09 19:30         4044670        haxe_2015-02-09_development_a696542.tar.gz

[Cauê Waneck]

I've just realized that you're using another dll that was not the one used by the haxe tests. Can you upload this somewhere and open an issue so we can check this out without polluting the list?

Thanks!