Hi all, Is there any way by which we can find pro grammatically whether SQL Compact is installed or not... Actually I need to know whether the compact edition is installed or not in PC and so that I can include or exclude the SQL Compact dll... Because in my application there are different process that access the same .sdf file which will cause Access Violation error if those dll are included and compact is installed...
Any idea!!...
jankhana
Last Activity: Dec 26 '09, 07:18 AM
Joined: May 2 '09
Location:
-
Sql Compact Installation
-
what about students and all?????
can u give some demo of ur records so that its clear... Only name of the NGO will be repeated again and again total boys or girls and all those stuff will be different than right???????? -
No I mean you just include one more column called year which will have the year value i.e 2004-2005 or 2008-2009 etc so.
Table design will be like this:
Name of NGOs
totalBoys
totalGirls
total No. of Students
total Passed
total Failed
Employment Status
Grant Released
Year
So table is well maintained and has no problem in which year or which NGO and you can query...Leave a comment:
-
You mean that Grant Released is common for all students in NGO and same is the case for the Employment status?????????
If that is so than u can directly go for one table and include one more col as financial yr which will store for which financial yr the data is!!!!!!!!!!
I hope I understood right!!!!!Leave a comment:
-
You can have SNO , Name of NGO, Boys, Girls and NoofStudents in one table say
NGO_DET
and in another table you can have SNO(Ref parent NGO_DET), Student Name , Employment Status, Grant Released.
I don't know what is passed and failed I thing you can add that with the second table and instead of having No of students as a columns you can calculate it every time by using sum(Boys,Girls) .Leave a comment:
-
sqlce in Xenocode
Hi all,
I'm using Xenocode in my application so that it works without a .NET framework. I'm using Xenocode Virtual Application Studio(version 6.1). Everything works fine except the .sdf file which I have embedded inside the application directory. actually in the application the instead of SQL server i have used SQL Compact edition(3.5) and i have included the reqired dll . All the files are working except the ".sdf"... -
Hi,
Thanks for the reply...
I don't need those records again to be used and hence i'm deleting it. Ya table is big. It may contain hundred records or one lakh records depending on user's choice. Mostly ten thousand records will be there and once i get the record i don't want to use them again and hence i need to delete them!!!!!!!!
hmmm........ So update will not work in my scenario......Leave a comment:
-
sql compact lock problem
Hi,
Thanks for the reply.
Ya i use those values in my application for further processing. one command inserts the records in the table and so soon as the records are inserted it is used by the application. To make the process fast I've multiple threads that contact the table and uses the records. Each thread takes five-five records does the job. The records...Leave a comment:
-
SQL Server Compact timed out waiting for a lock
Hi all,
I'm having an application in that i use Sql Compact 3.5 with VS2008. I'm running multiple threads in my application which contacts the compact database and accesses the row. It selects and deletes those rows in a fashion i.e selecting and giving to the application 5 rows and deleting those rows from the table. It works great with a single thread but if i use multiple threads i.e if 3 or more threads are running I get very... -
Multiple Clients Accessing Server
Hi all,
I'm not used to web.config and ASP.NET. I want to know whether is this possible and if so how???
I have my client accessing my server for some work and the server in turn accesses other server which will do the work. Now if the client increases the server has to send all those request to the other server and that's slowing my work if I have more clients.
The client accesses main server only. The main... -
Microsoft.ReportViewer.Common
Hi all....
I'm using Microsoft ReportViewer(RD LC) for showing the reports.
There are nearly six reports that i'm trying to create. First two are working propely i.e the reports get displayed but the next four are showing errors as....
An error occurred during local report processing.
"The definition of the report 'Main Report' is invalid"
The table ‘table1’ is in the... -
Narrator
Hey it was a great information thank you....
This what i was searching for...
Thanks once again.......Leave a comment:
-
I have posted there also.... Anyways....
Any idead?????????? ?Leave a comment:
-
Microsoft Narrator Voice
I want to change the Narrator's Voice from Sam to any one....
Ihave installed Mar and Mike's voice but still in the narrator window I'm not able to see their name only Sam is Visible!!!!!!!! !!!!!
I have already changed in the Control Panel-> Speech-> Voice to Mike but still the Sam is on and in Narrator Window still Sam only i can find.
And one more thing I cannot open my ControlPanel->... -
Change Narrator from Sam to something else
I want to changet the Narrator's Voice from Sam to any one....
Ihave installed Mar and Mike's voice but still in the narrator window I'm not able to see their name only Sam is Visible!!!!!!!! !!!!!
I have already changed in the Control Panel-> Speech-> Voice to Mike but still the Sam is on and in Narrator Window still Sam only i can find.
And one more thing I cannot open my ControlPanel->... -
Sql Server in Installer Class
Did you get the answer for that??? Even i want to run SQL commands in set up...Leave a comment:
No activity results to display
Leave a comment: