Download the free trial version
Basic4android Video
Features
Tutorials and manuals
Showcase
Screenshots

Go Back   Android Development Forum - Basic4android > Basic4ppc (Windows Mobile) > Code Samples & Tips > Additional Libraries
Documentation Wiki Register Members List B4P Search Today's Posts Mark Forums Read

Additional Libraries Users contributed libraries.
This sub-forum is only available to licensed users.

MS SQL Library

Reply
 
LinkBack Thread Tools Display Modes
  #41 (permalink)  
Old 07-22-2010, 11:27 AM
agraham's Avatar
Basic4ppc Expert
 
Join Date: Jul 2007
Location: Cheshire, UK
Posts: 6,072
Awards Showcase
Innovator medal Beta Tester Forum Contributer 
Total Awards: 3
Default

I intended in the next version to dispose the transaction in Commit and Rollback and remove TransactionDispose which I think would then be unnecessary. Is there a reason to not do this?
__________________
Sorry, but I don't answer questions by PM or email.
Please post your queries in the forum.
Reply With Quote
  #42 (permalink)  
Old 07-22-2010, 11:36 AM
Junior Member
 
Join Date: Jul 2010
Posts: 39
Default

I think it would be ok but maybe a commit or a rollback would be better to start a new transaction automatically after ending it. Furthermore, the beggining of any executable SQL statement would be nice to start automatically a new transaction.
Reply With Quote
  #43 (permalink)  
Old 07-22-2010, 11:51 AM
agraham's Avatar
Basic4ppc Expert
 
Join Date: Jul 2007
Location: Cheshire, UK
Posts: 6,072
Awards Showcase
Innovator medal Beta Tester Forum Contributer 
Total Awards: 3
Default

Commit and Rollback now end a transaction so I have removed TransactionDispose. I decided not to try any automatic starts to a transaction to leave the programmer more control and make what is happening more obvious.
Attached Files
File Type: zip MSSQL1.5.zip (3.0 KB, 12 views)
__________________
Sorry, but I don't answer questions by PM or email.
Please post your queries in the forum.
Reply With Quote
  #44 (permalink)  
Old 07-22-2010, 12:00 PM
Junior Member
 
Join Date: Jul 2010
Posts: 39
Default

TransactionDispose removed from my code and works perfect!
Reply With Quote
  #45 (permalink)  
Old 07-22-2010, 01:33 PM
agraham's Avatar
Basic4ppc Expert
 
Join Date: Jul 2007
Location: Cheshire, UK
Posts: 6,072
Awards Showcase
Innovator medal Beta Tester Forum Contributer 
Total Awards: 3
Default

Version 1.6 now posted in a new thread here http://www.basic4ppc.com/forum/addit...html#post36303

Some names have been changed to better reflect what they do. Data renamed to Advance, Read renamed to ReadField, Field to FieldCount
__________________
Sorry, but I don't answer questions by PM or email.
Please post your queries in the forum.

Last edited by agraham : 07-22-2010 at 01:37 PM.
Reply With Quote
  #46 (permalink)  
Old 09-30-2010, 01:02 PM
Newbie
 
Join Date: Aug 2010
Posts: 4
Default

On my PDA can not run the program with the library.
Error: Can not find filename or assembly "System.Data.SqlClient, versioned = 3.0.3600.0, Culture = neutral, PublicKeyToken =" or one of its dependencies.
Tell me what to do.
Reply With Quote
  #47 (permalink)  
Old 09-30-2010, 01:21 PM
agraham's Avatar
Basic4ppc Expert
 
Join Date: Jul 2007
Location: Cheshire, UK
Posts: 6,072
Awards Showcase
Innovator medal Beta Tester Forum Contributer 
Total Awards: 3
Default

You should be using the version reached by the link in my post above your post. In the first post of that thread there is a link to download the client dll.
__________________
Sorry, but I don't answer questions by PM or email.
Please post your queries in the forum.
Reply With Quote
  #48 (permalink)  
Old 10-28-2010, 12:57 PM
Newbie
 
Join Date: Oct 2010
Posts: 3
Default install sql server ce on win ce 6.0

hi, I'm using MSSQL and it work correctly with my psion pocket pc with wince4.2. Now I would like to use it in a panel pc with ce6.0 Intel i486 with NET CF 2 installed.
my software doesn't work because I need sql cab installation for wince...

somebody can help me?? where can I find it??

thank you!
Reply With Quote
  #49 (permalink)  
Old 10-28-2010, 01:52 PM
Newbie
 
Join Date: Oct 2010
Posts: 3
Default

Quote:
Originally Posted by mariocast View Post
hi, I'm using MSSQL and it work correctly with my psion pocket pc with wince4.2. Now I would like to use it in a panel pc with ce6.0 Intel i486 with NET CF 2 installed.
my software doesn't work because I need sql cab installation for wince...

somebody can help me?? where can I find it??

thank you!


I FOUND IT, in

C:\Program Files (x86)\Microsoft Visual Studio 9.0\SmartDevices\SDK\SQL Server\Client\v2.0\wce500\x86

...

thank you.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Door library (Beta) - Special library Erel Official Updates 60 01-13-2011 11:23 AM
Merging Outlook library and Phone library Erel Official Updates 11 09-15-2010 09:22 AM
PhoneticAlgorithms Library (ex-StringComparison Library) moster67 Additional Libraries 10 11-11-2008 07:46 PM


All times are GMT. The time now is 06:26 AM.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0