-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
-
You are all welcome to join our new Facebook page: https://www.b4x.com/android/forum/threads/new-facebook-group.167607
MSSQL SQL Server library
- Thread starter agraham
- Start date
- Similar Threads Similar Threads
Yeah! Almost there. Seemed I had an older version of the DLL, had to play around a little to get it to load the new one and then edit my program (ReadField in stead of Read, Advance in stead of Data and so on).
Now I've lost the messages, program does run on the PDA only won't connect to the SQL server some how. Next challenge!
Now I've lost the messages, program does run on the PDA only won't connect to the SQL server some how. Next challenge!
Still not managing to have it access my SQL Database on the server, I verified that my WiFi connection is up and it connects to the server through the same connection on my laptop.
Does anybody have a working example of a program that connects to an SQL server through the MSSQL 1.9 driver from a Windows Mobile 6.5 Professional device? I would like to have a look...
Does anybody have a working example of a program that connects to an SQL server through the MSSQL 1.9 driver from a Windows Mobile 6.5 Professional device? I would like to have a look...
Have you seen this post http://www.b4x.com/forum/additional-libraries/3082-ms-sql-library-2.html#post26953 where he needed to use the IP address of the server and not it's name. This also happens to me making connections with the Network library on devices for reasons I don't understand.
Last edited:
Darn, I should have known! Have had some DNS problems before... working now, thanks a lot!
Hello Agraham,
After using your library for about 8 months, i get complaints from my customers that my application disconnects from sql server and needs restart.
As i realized it myself, when my application is in idle mode for some time, then the connection with server is lost and must call Mssql.Open method again.
I can't figure out why this happens but as i looked at the SqlConnection Members on MSDN and i saw that a property called State exists and there is also an event called StateChange that is fired when connection state goes from Open to Closed and vise versa.
If you don't have much time to mess with that you could post the source file to examine it myself.
Thank you in advance,
George.
After using your library for about 8 months, i get complaints from my customers that my application disconnects from sql server and needs restart.
As i realized it myself, when my application is in idle mode for some time, then the connection with server is lost and must call Mssql.Open method again.
I can't figure out why this happens but as i looked at the SqlConnection Members on MSDN and i saw that a property called State exists and there is also an event called StateChange that is fired when connection state goes from Open to Closed and vise versa.
If you don't have much time to mess with that you could post the source file to examine it myself.
Thank you in advance,
George.
I guess it only needs the State property, and not the event, exposed so that you can check it before each transaction. If you can't easily, say with a couple of hours work, add it yourself then post here and I will do it. It will only take me about 15 minutes to add it, update the help and repost the dll.
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?
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?
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.
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.
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.
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.
Basic4Android with MSSQL
Could You send to me a example how to use it MSSQL library for using query in Basic4Android
Could You send to me a example how to use it MSSQL library for using query in Basic4Android