MSSQL SQL Server library

[georgea]

If you have the time to do it, there is no need from me to edit your source file. I am sure you are going to make it better.

I just asked for that because i don't want to bother you every single time i want an additional option to a library

Thank you,

George.

[agraham]

Version 2.0 now posted has a new ConnectionState property.

[georgea]

Works fine. Thank you Andrew.

George

[Tex8503]

Hey guys,
I trying to use this library - but for some reason when working with MS SQL 2008 I can read and write - and with MS SQL 2005 - I can read, but I can't run INSERT statements to MS SQL 2005 - does this make any sense?

How would I go about finding why this is happening?

[citywest]

Thank you Andrew and others I'm glad this went somewhere, although I'm sorry that I didn't fully test the transactional stuff before posting.

I ended up using something different than Basic4ppc for the project that utilized this library (because of a silly client requirement that I had no control over) so it's been sitting on the shelf ever since, but I'm back as I need to do a lot of Android work for a current project which will ongoing for a long time.

After wasting a lot of time with phonegap and a few others it looks like Basic4android will "fit the bill". So Erel you will receive an order from me shortly

To the gentleman whom can't do insert queries it will be the permissions on the database. The user that you are using will have Update queries un-ticked in SQL Management Studio, check both the DB and overall security settings.

Cheers,

Mark S.

[Tex8503]

Hey Citywest,
I actually resolved this issue. The problem was the DBA gave me the incorrect table names. So not your fault after all - their development didn't mirror their production accurately.

Sorry about that!

[citywest]

That's great you resolved the problem. You've got to love sys and db admins, it's a bit like extracting teeth or banging 4 inch nails into your forehead at times.

Perhaps if there is enough interest we could take this to another level with SSPI integration and a few other things which will fix a number of difficulties that a few people have had.

Cheers,

Mark S.