embedded secure sqlite database system for embedded os(TS-linux)


any idea this is my final year project,may i have guide from u ........................
Posted On: Monday 31st of December 2012 01:09:31 AM Total Views:  227
View Complete with Replies

RELATED TOPICS OF Microsoft SQL Server PROGRAMMING LANGUAGE




max function

Does anyone know what would cause max(column_name) to not work I tried using max(hudamount) in a small join statement and got the deed results but then when I needed to add additional columns and tables, the max function does not work any longer. Anyone has any idea
VIEWS ON THIS POST

110

Posted on:

Thursday 15th November 2012
View Replies!

sql query string help?

Dear friends... I need a sql query string,.... I have database with names as follows.. ABC ABC DEF FRG FRG FRG FRG DEF ABC Now i need a sql query string to show the data by following way. FRG 4 ABC 3 DEF 2 please help regards Ananda
VIEWS ON THIS POST

173

Posted on:

Thursday 15th November 2012
View Replies!

My question is how to prevent to copy tables and store procedure of sql server 2000

My question is how to prevent to copy tables and store procedure of sql server 2000 from client/friend's system to another system. Dear Viewers' I developed small web application in .net 2.0 and backend is slq server 2000. I configured web application to my client/friend's systems, just i want to restirct them to copy my sql server 2000 database with password. If it's possible, please help me out in this secanrio. regards mdateeq2003
VIEWS ON THIS POST

200

Posted on:

Tuesday 20th November 2012
View Replies!

Searching records through mulitple tables having same column

i am having multiple tables such a,b,c,d,e,f,g,h,i ...etc now each of table having same data types , that means the column is same. now users would be entering the table name like in first text box b and another text box in a form g , now i want to search and display records from table b to g for specic records like where name ="tom tom" in all the tables of database how i can do that , kindly guide.
VIEWS ON THIS POST

140

Posted on:

Tuesday 20th November 2012
View Replies!

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

I keep getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired /admin/functions_web.asp, line 277 This application has been up for 5 years and we never had any problems and all of a sudden we have started getting this error. We have the latest MDAC version. I have increased the scripting and connection time and we still get this error. Please help!
VIEWS ON THIS POST

159

Posted on:

Tuesday 20th November 2012
View Replies!

Looking for Guru opinions

I have a script which dishes out XML based on a SQL recordset. Code: Joins = " INNER JOIN CIL_Addresses on CIL_Addresses.id = addressID FULL OUTER JOIN CIL_Zips as Z1 on CIL_Addresses.zip = Z1.zip " region3 = " AND ( Z1.county ='x' or Z1.county = 'y' or Z1.county = 'z') " Select Case Request.QueryString("module") Case "federalClosures" sql = "SELECT status, count(status) as count FROM Consumer_Inv " & Joins & " where " & fed & region3 & " AND closureDate IS NOT NULL GROUP BY status" Case "federalILP" sql = "SELECT count(*) as count FROM Consumer_Inv " & Joins & "WHERE createILP='False' and " & fed & region3 & " GROUP BY createILP" Case "federalFemmes" sql = "SELECT count(*) as count FROM Consumer_Inv " & Joins & "WHERE gender='F' and " & fed & region3 & " GROUP BY gender" Case "federalEth" sql = "SELECT count(*) as count FROM Consumer_Inv " & Joins & "WHERE ethnicity='HISP' and " & fed & region3 & " GROUP BY ethnicity" Case "federalRace" sql = "SELECT race,count(race) as count FROM Consumer_Inv " & Joins & "WHERE race='" & Request.QueryString("race") & "' AND " & fed & region3 & " GROUP BY race" Case "federalDisabPrime" sql = "SELECT disabPrimary, count(disabPrimary) as count from Consumer_Inv " & Joins & "WHERE " & fed & region3 & " GROUP BY disabPrimary" Case "federalDisabSec" sql = "SELECT disabSecondary as disabPriamry, count(disabPrimary) as count from Consumer_Inv " & Joins & "WHERE " & fed & region3 & " GROUP BY disabSecondary" Case "1A" sql = "SELECT Consumer_Services.service, COUNT(*) AS count, SUM(hours) AS hours FROM Consumer_Contacts INNER JOIN Consumer_Services on Consumer_Services.id = Consumer_Contacts.service WHERE contactDate " & range & " GROUP BY Consumer_Services.service order by Consumer_Services.service" Case "1B" As an external report loads, it calls upon this script multiple times, getting the data it needs. Am I being stupid
VIEWS ON THIS POST

92

Posted on:

Tuesday 20th November 2012
View Replies!

Backup database question

all. Is there a way of backing up all of the databases on the server (including data) I am using SQL Server 2000 on a Windows Server 2003 platform.
VIEWS ON THIS POST

128

Posted on:

Tuesday 20th November 2012
View Replies!

Stored Proc select query problem?

I am trying to fire a stored proc from my asp.net page. If Request.QueryString("ID") = '123' then the stored proc works fine. But if Request.QueryString("ID") = '123,456' then it doesn't work. Is my stored proc the culprit PLEASE HELP!!! Code: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim strPNum As String = Request.QueryString("ID") Dim strDateFrom As String = Request.QueryString("DateFrom") Dim strDateTo As String = Request.QueryString("DateTo") If ViewState("CmdTextStoredProc") = "GetDATA" Then strSQLCommand.CommandText = "GetDATA" strSQLCommand.Connection = Me.SqlConnection1 strSQLCommand.CommandType = CommandType.StoredProcedure strSQLCommand.CommandTimeout = 180 strSQLCommand.Parameters.Add("@PNum", strPNum) strSQLCommand.Parameters.Add("@DateFrom", strDateFrom) strSQLCommand.Parameters.Add("@DateTo", strDateTo) End If End Sub Code: CREATE PROCEDURE GetData ( @PNum as Varchar( 255 ), @DateFrom as Varchar( 8 ), @DateTo as Varchar( 8 ) ) As SELECT * FROM data WHERE [P_Number] IN (@PNum) AND ([DATE] BETWEEN @DateFrom AND @DateTo) ORDER BY [DATE] GO
VIEWS ON THIS POST

195

Posted on:

Tuesday 20th November 2012
View Replies!

Check if table exists

Is it possible to have an SQL syntax that returns TRUE if a table exists and FALSE if not I'm working in VB.NET and would like to have a check before I'm trying to write to the table. The check should be totally separate from the write function; since I want to give a message to the user if the table doesn't exist with a button where he can click to create the table. Thus queries like "IF EXISTS (SELECT * FROM [MyTable]) SELECT * FROM [MyTable]" are not really a solution
VIEWS ON THIS POST

91

Posted on:

Tuesday 20th November 2012
View Replies!

Inserting problem with primary key

I'm trying to insert a row in a table and I received this error: Cannot insert duplicate key in object Any ideas on how I can get around viloating the primary key INSERT INTO loan_channelcontacts select 0, 32, 1, 65, 8991, 1, 1, 21, 16023, 1, 1, lc1.loanrecordid, 0 FROM loan_channelcontacts lc1 inner join loan_channelcontacts lc2 on lc1.loanrecordid = lc2.loanrecordid inner join loan_postclosing on lc1.loanrecordid = loan_postclosing.loanrecordid WHERE (lc1.entityid 16023 and poolnumber = 'HQ0505') The above values do not exist in the table already so I am trying to insert an additional row for a loanrecordid. I wrote a similar code a while back and it worked but I can't seem to figure out what I am overlooking.
VIEWS ON THIS POST

289

Posted on:

Tuesday 20th November 2012
View Replies!

Extract text from a field

Hi in my tags field I have tagged dates between ^ eg: ^2007/04/16^ how in sql do I extract that text between the ^^ bear in mind i'm using that date in the same query to pull records.
VIEWS ON THIS POST

98

Posted on:

Tuesday 20th November 2012
View Replies!

Regex in mssql ?

hello people, I have a table with some field named 'f1', the filed contains string like this: 1:3-12/23.2:3-23/12.87:4-12/11 and so on with the same format... I need to write some sql query that extracts all the first one or two numbers that appears before the ':' (all the red numbers in the example above). I don't mind if I get the result as a set of rows or a string that contains all the (red) numbers. is it possible with mssql
VIEWS ON THIS POST

125

Posted on:

Tuesday 20th November 2012
View Replies!

Indexing on Encrypted Columns

1) We have SQL Server 2005 database on Windows 2003 Server. 2) Some columns data of some tables are encrypted while inserting itself with help of encryption views (datatype - varbinary). 3) We select data from tables using decryption views. 4) We use symmetric key & certificate for encryption and decryption respectively. 5) For normal columns we can index on tables but for encryption/decryption data columns, will indexes on tables on raw data columns of tables work or on views on their columns which represent normal data. 6) Our stored procedures have select queries only on decryption views but index tuning advisor is throwing indexes & statistics on tables even for encrypted columns.
VIEWS ON THIS POST

38

Posted on:

Tuesday 20th November 2012
View Replies!

please help with asp database connection 'login fails'

I've been trying to suss this for hours now with no luck at all. I'm trying to connect to a sql server database on a win2003 webserver running IIS6 (both IIS and sql server on same machine). I have set up the database and added a user 'CLUSR' with a password, I can log into query analyzer and return the info I want using this username and password. I am consistantly getting the following error trying to connect with asp: - Microsoft OLE DB Provider for SQL Server error '80004005' Cannot open database requested in login 'my_database'. Login fails. /test.asp, line 7 test is a simple asp file I created to try and get this to work and contains the following code: - I've been going around in circles with sql server users, permissions, etc as well as getting completely lost in IIS security settings. If anyone can shed any light on this at all you will gain instant promotion to the top of my christmas card list and save me from near imminent frustration overload! Cheers
VIEWS ON THIS POST

212

Posted on:

Tuesday 20th November 2012
View Replies!

Insert Auto Seq# in a Table

I am a SQL programming learner and trying to accomplish one thing. I have following table and want to insert auto record_id increment. record_id name 1 A1 2 A2 3 A3 4 A4 5 A5 . . 10 A10 Please advice how to use insert statement to insert the record_id. Please note :- record_id is not a identity field but part of unique key.
VIEWS ON THIS POST

43

Posted on:

Tuesday 20th November 2012
View Replies!

Recordset loops and javascript......

Im trying to perform a Javascript function for each iteration of a retrieved recordset. However as expected, I found the two don't always like working in tandom together. Basically my function needs data from the record set, does some calculations and then the recordset needs to be updated. I am finding that only the last record in the RS is being processed and would be very grateful if anyone could provide some suggestions as to how I may get around this
VIEWS ON THIS POST

110

Posted on:

Tuesday 20th November 2012
View Replies!

Update Records

My SQL database table holds two records for each applicant ID with an AcademicTerm (Spring Semester, Fall Semester) I want to update the applicant to update their CrHrs (credit hours) for each semester via an online form. SQL Table Columns = ApplicantID, AcademicTerm, CrHrs Value = 1, Spring, "" Value = 1, Fall, "" Form displays each AcademicTerm for the applicant with a text box for them to enter the CrHrs; however, I can't get the information to update with the submit button. Please help.
VIEWS ON THIS POST

113

Posted on:

Tuesday 20th November 2012
View Replies!

Conflicting Foreign Key fields

I am building a content management system for our intranet site. Users can create "pages" and "categories" if they have the proper permission. I'll include a few of the fields necessary to describe the problem below: tblContentIndex ContentID - Primary Key tblPages PageID - Primary Key ContentFK - FK to tblContentIndex Category - FK to tblCategories field tblCategories CategoryID - PrimaryKey ContentFK - FK to tblContentIndex tblUsers UserID Username I've created the following table to manage permissions tblContentAccess UserFK - FKfrom tblUsers ContentFK - FK from tblContentIndex I really do not want to use unique identifiers, so the only way I can think of to get around the hurdle ofhaving conflicting FK's between tblPages and tblCategories is to create the third table (tblContent) and assign permissions from that.... It just seems kind of clunky to have to create another table to ensure the FK fields don't cross. Any ideas how this could be better accomplished (or affirmation that I'm doing it in an acceptable manner) are greatly appreciated!
VIEWS ON THIS POST

93

Posted on:

Tuesday 20th November 2012
View Replies!

Copy SQL from server to local?

OK, I'm very new to SQL but I need to obtain a copy of the live database so I can setup a local test site. I don't intend to modify the SQL database AT ALL. I can see the database via Enterprise Manager but I'm not game to try anything in case I stuff up the live website - I would lose my job! Can someone tell me the best method of copying the database from the live server to my local machine and how to setup so I can run a local website connected to the test SQL database. I gather I must have appropriate server permissions to backup/copy Please help!
VIEWS ON THIS POST

246

Posted on:

Tuesday 20th November 2012
View Replies!

Parameter in select statement

I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND CityId IN (23,45,85,86)' SELECT @strQuery= 'SELECT VendorId From Vendors WHERE CountryId = '+@CountryId+' '+@CityId+' ORDERBY CreatedDate' EXEC(@strQuery) END I need to execute above in an open select statement instead of executing @strQuery. Getting error as When trying through following script as "Conversion failed when converting the varchar value ' AND CityId (23,45,85,86)' to data type int" SELECT VendorId From Vendors WHERE CountryId = @CountryId + ' ' +@CityId ORDERBY CreatedDate Please help me to get it working through above select statement.
VIEWS ON THIS POST

121

Posted on:

Tuesday 20th November 2012
View Replies!

SP to insert IF new UPDATE IF existing

I have a SP that inserts a record: Code: IF @action = 'add' BEGIN INSERT INTO OrderDetail (orderid, itemid, iquantity) VALUES (@orderid, @itemid, @itemQ) END I want to add a nested IF statement to check to see if a record exist WHERE orderid AND itemid = @orderid AND @itemid. I am thinking I should use something like: Code: SET @orderlineid int = SELECT orderlineid FROM OrderDetail WHERE orderid = @orderid AND itemid = @itemid IF (@orderlineid NOT NULL) BEGIN UPDATE OrderDetail SET iquantity = @itemQ WHERE orderlineid = @orderlineid ELSE INSERT INTO OrderDetail (orderid, itemid, iquantity) VALUES (@orderid, @itemid, @itemQ) END Is there a better way
VIEWS ON THIS POST

192

Posted on:

Tuesday 20th November 2012
View Replies!

help with variable problem in IF statement?

hi, i'm completely stumped with this one. It is a simple test (via IF) for booking where it decides which path to follow. Or not so simple, even.. It keeps taking me to same bit. Have tried putting form value into variable. Tried rearranging various ways. The available is definatley being calculated properly and have it displayed. What can be going wrong with form (just added 'id' there too) Is there something missing or do i have to convert to integer format or something The two "booked" and "places" fields are long integers, no indexing, not autoincrements or anything. Have tried for ages with this and is holding me back from the rest of code and final few pages of my site...which is VERY frustrating.
VIEWS ON THIS POST

159

Posted on:

Tuesday 20th November 2012
View Replies!

SQL Statement

May i know can i do this Dim strSQL as String = "select count(*) as 'count' from Login where UserName = '" & txtLogin.text & "' and Password = '" & txtPassword.text & "' and '" & txtType.text & "' = Type;"
VIEWS ON THIS POST

30

Posted on:

Tuesday 20th November 2012
View Replies!

ms sql newbie... need some understanding!

hi , i have just started using mysql, as the host we were using conveniently dumped the OLEDB method of interaction, and therefore i had to change from a .mdb and using asp.net. i need to be able to query the database from entering a number into a box, which then looks at the database, and finds the record and puts it back into a datagrid. number e.g. 11879965, entered via a box on a form. On clicking the search button, it looks at the database, searching through it all, and returns the record that matches the unique number (10 fields altogether) and puts them in a datagrid. questions: 1) can i use a asp datagrid, or will i need to use another method 2) how should i start my code (separate files like php or incorporate it into the html like asp / vb.net) 3) are there any sites where i can learn more about mssql.
VIEWS ON THIS POST

180

Posted on:

Tuesday 20th November 2012
View Replies!

So what do you do if you have NO IDEA

I created our website but now I need to setup a service for our customers to submit data into our website to create an educational resorce.I can use any method available.They would need to register and this would need to have numerous customized feilds. feildsThey would then submit info via a customized form . It would have multiple sub groups and need to be searched.I want the simplest method to get me there. We have a host that includes an acess DB and is ASP supported. A BD is good as we may publish the info in the future.Off the shelf solutions may work....ANY SUGESTIONS WOULD BE GREAT
VIEWS ON THIS POST

151

Posted on:

Tuesday 20th November 2012
View Replies!

Insert into multiple tables

hi i am using dreamweaver to create a insert record in to a table. but i need to insert the data into two tables. i am a newbie so is there a way to acheive this
VIEWS ON THIS POST

381

Posted on:

Tuesday 20th November 2012
View Replies!

link two tables in two different mdf files

i have two tables in two different mdf files each (under one MSDE instance). I would like to make a rational link between these two tables in VB6. Any suggestion
VIEWS ON THIS POST

190

Posted on:

Tuesday 20th November 2012
View Replies!

Import Data From Excel, DTSSource() data type conversion problem

I have been beating my head against the wall with this for quite a while, but I am trying to get a DTS package to import data from an excel spreadsheet into a SQL Table. Here's the code: Function Main() DTSDestination("name") = DTSSource("Name") + DTSSource("City") DTSDestination("modified_by") = DTSSource("Modified By") DTSDestination("created_by") = DTSSource("Created By") DTSDestination("delete_ind") = DTSSource("delete_ind") DTSDestination("dial_area_code_ind") = DTSSource("dial_area_code_ind") DTSDestination("chief_pharm_name") = DTSSource("Chief Pharm Name") DTSDestination("fax") = DTSSource("fax") DTSDestination("phone") = DTSSource("Telephone") DTSDestination("county_id") = DTSSource("County ID") DTSDestination("country_id") = DTSSource("Country ID") DTSDestination("zip") = DTSSource("ZIP") DTSDestination("state") = DTSSource("State") DTSDestination("city") = DTSSource("City") Main = DTSTransformStat_OK End Function When I run it on its own in the ActiveX Script Properties interface in SQL Server DTS Designer, it runs cleanly (because it dumps to a temp .txt file rather than the actual table). When I run the whole package, though, I get the following errors: Insert error, column 24 ('modified_by', DBTYPE_I4), status 10: Integrity violation; attempt to insert NULL data or data which violates constraints. (edited by poster: I get the same error for 'created_by' DBTYPE_I4, 'delete_ind' DBTYPE_STR, 'dial_area_code_ind' DBTYPE_STR). The constraints on these do not allow NULL values, and the table datatypes are as follows: created_by int(4) modified_by int(4) delete_ind char(1) dial_area_code_ind char(1) I've tried using CStr(), CInt(), CShort(), on the DTSSource columns, but I'm obviously doing something wrong... Please help.
VIEWS ON THIS POST

200

Posted on:

Tuesday 20th November 2012
View Replies!

Text data type in sql server

hi , can any one tell me how "text" data type is used in sql server especially in writing stored procedures.
VIEWS ON THIS POST

185

Posted on:

Tuesday 20th November 2012
View Replies!

Need Help

HELLO, i have a database under HP 3000 TURBO IMAGE in arabic character for the text files , i have a problem to migrate this database to MICROSOFT SQL SERVER 2000 in arabic caracter, becaut when i make an export for the database to a text filds with the ASMO 449 page code, the new database in SQL SERVER don't show the text in arabic, i think it's a problem of the asmo 449, can you help me it's urgent please.
VIEWS ON THIS POST

42

Posted on:

Tuesday 20th November 2012
View Replies!

Link request

, Does anyone have any website links related to SQL Server 2000 table relationships I can't get my 1-n relationship to work properly plz help,
VIEWS ON THIS POST

81

Posted on:

Tuesday 20th November 2012
View Replies!

SQL Mail

The SQL Mail can only work with Ms Exchange Server Can it just work with Ms Outlook alone And how the configuration and setting like
VIEWS ON THIS POST

52

Posted on:

Wednesday 21st November 2012
View Replies!

relocating datafile in sql server

hi could any one please tell me how to relocate datafile in sql server TIA Anand
VIEWS ON THIS POST

249

Posted on:

Wednesday 21st November 2012
View Replies!

DTS Import File Advice Needed

Basically I just need some advice. I am using DTS to import a CSV file into my database. This import will take place each day, as a scheduled task. This import will need to totally replace what was in the table before (delete data in the table and then import the csv). The bit I need advice on though is, I want to run some checks on the data that is being imported before it is commited. If there are any errors or probs then i want to just keep the data as it was the day before (ie. don't commit the new data). What is the best way to do this I was thinking along the lines of creating a 2nd table, which i first import the data to, run the checks on it (like row count etc) and then if all OK, copy this table into the final table. If there are any errors or the checks highlight a prob then this final copy will not take place, therefore leaving the data as it was the day before. Or is there a better (simpler / more efficient) way to do it Cheers.
VIEWS ON THIS POST

50

Posted on:

Monday 26th November 2012
View Replies!

stored procedure and join

, I am taking a class on sql. We are using sql server 2008 r2. We have a project to create a database and create 3 stored procedures. I have created the database as well as the entries for it. The stored procedures are giving me a little trouble though. I'd love if you could offer some help on how to fix these.
VIEWS ON THIS POST

272

Posted on:

Sunday 30th December 2012
View Replies!