|
I normally use Oracle and I haven't been able to figure out the appropriate escape characters to allow the SELECT option to work properly for a given situation.
Given the following:
string newValue = "Joe's Place";<br />
string searchValue = newValue.Replace("'",@"\'");<br />
DataRow[] dr = dataTable.Select(displayMember+"='"+searchValue+"'");
newValue is actually a parameter into the method but when it's contents include an apostrophe, I get the error such as Missing operand after 's' operator. The code worked for all situations until I hit an apostrophe so I added the conversion of the apostrophe to what I thought was the appropriate escape sequence {newValue.Replace()}. But it doesn't seem to matter what value is searched, I still get the error.
What should I have done? Are there any other characters I need to be aware of other than the apostrophe?
Thanks
|
|
|
|
|
Have you tried:
string searchValue = newValue.Replace("'","''");
|
|
|
|
|
Yes, this gave a result of Joe''s Place but I still get the same error back from the database. That's why I thought I must need an escape character rather than doubling the apostrophe.
|
|
|
|
|
I have just installed VC ++ .Net and as part of this installation I was told to download a standalone SQL engine as I am sure you all know! but I then installed this and it jumped through all the hoops and completed successfully it said! but I get nothing, no icons, no sys tray icon nothing and IIS keeps telling me its not loaded when I try demo's out? any ideas would be appreciated, thank you for tolerating such a simple question but I am stumped!
Thanks for your time!
Many thanks for your time and may the force be with you! (you'll need it!) 
|
|
|
|
|
MSDE does not come with a user interface to manage the program (thats part of the reason it's free) Although SQL Server 2005 Express (same as MSDE) will apparently include one.
As for the problem:
MSDE is not installed out of the box when you check it in VS. It loads the MSDE setup file into a VS sub directory and that is all. You probably still need to run the setup explicitly for MSDE. I would NOT recommend running the MSDE from Visual Studio as it is probably out of date and you will need to patch to fix the SASSER vulnerability (updating is a pain with MSDE). I would download the current version from Microsoft Downloads and install that version. Now be very careful on reading the instructions for setup. Very specifically the choosing of the Instance name. Most Visual Studio samples tend to look for the instance $NETSDK (I think, cant remember) so you will have trouble connecting out of the box if the instance name does not match.
Having said that I prefer to actually change the instance name but that means changing all the code samples that point to the NETSDK instance. Your call. I would also recommend that you carefully read the security.
I would encourage installation in THIS order:
1. Check your services to see if you may have MSDE already installed (many software packages do install it without telling you)
2. Unpack MSDE
3. Creating the INI file described in the readme with both the Instance name and SQL server administrator password (the SA password)
4. then run the setup
5. Open your Services under the Administrative Tools menu and locate the MSSQL${InstanceName} entry in the list of services and change the properties to load on System Startup (If not already setup that way).
6. Download TeraTrax's MSDE manager (www.teratrax.com) - no affiliation - They have a free trial and if you intend to use MSDE a lot I would just buy it (I did). You can also use Access XP or later (I use Access 2003) as the client for data viewing, table creation, and other miscellaneous stuff but I would not use it to initially setup the database nor for backup or restore (I use TeraTrax for that) - personal preference.
I use MSDE ++ALOT++ and it is great for small to medium projects and clients. No problems from my end.
|
|
|
|
|
Oh yes.. I forgot.
7. Delete the INI file after installation is complete (it has your SA password afterall!)
|
|
|
|
|
Hi Orcrist,
Thanks for the help I have now installed SQL MSDE and its working great (thanks) I have also downloaded TeraTrax frontend and thats great. But I am really in a mess, I cannot make sense of the passwording and username.
Everytime I attempt to access the owner is ODB and I donot know the password for this user. Also when I attempt to create a user I cannot seem to set a password I think I am totally lost with the SQL security system.
Any chance of a quick run through with respect to setting passwords and users in TeraTrax and the interfacing it to the SqlConnect command? The TeraTrax manual is poor for evaluation do you get a better one when you buy it?
Thanks for all your help!
Many thanks for your time and may the force be with you! (you'll need it!)
|
|
|
|
|
If I had to guess (and I am), I would hedge a bet that the ODB user is a login created by another application for MSDE and that this login is for some other instance of SQL Server (MSDE). You should be able to just ignore it.
He are some steps to try. Hopefully it will get you rolling:
1. In bottom left taskbar tray for Windows 2000/XP double click the SQL service Manager Icon. In the server name field enter {MACHINE NAME}\{MSDE Instance Name}. So for example if your machine name is "CLOUD" and you MSDE instance was named "MSDEDB" you would enter:
CLOUD\MSDEDB
I am not sure on the following steps since it has been months since I last had to setup Teratrax for the database.
2. Start Teratrax
3. Under File select Add server
4. In the server name enter: {MACHINE NAME}\{MSDE Instance Name}
for example CLOUD\MSDEDB
If everything is setup okay then you should be able to connect to the database instance, add logins and perform other activities. If you are particularly weak with SQL server then I would suggest that you download SQL Server Books Online from Microsoft downloads.
As for you connection strings to the database you could use something like the following for a OLEDB connection:
"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ConsignIT;Data Source=CLOUD\MSDEDB"
That should do it. If you are still having trouble then perhaps reinstall MSDE again. The ini file should be something like the following:
[Options]
INSTANCENAME=MSDEDB
SAPWD=mypassword
Other than that I can imagigine what other problem you might be running into.
good luck and let me know how it went.
David
|
|
|
|
|
Thanks David!!!
I have now got MSDE working and am currently battling with the SqlDataReader component and the security systems with SQL!!
Thanks for the info David!!!!!!!! very much appreciated!!!!!!
Many thanks for your time and may the force be with you! (you'll need it!)
|
|
|
|
|
Hi all
I have a datagrid tied up to sql server. Also I have a very large record
need to page during runtime. I have looked up solutions to find out how to
increase the performance of my application when paging. However I'm not
satisfied with those solutions.
I would like to ask if there is an optimmize solution out there so that I can
do the following: paging, sorting, update, insert and delete.
Thanks for any instructions
|
|
|
|
|
Hey,
i know this havent anything to do with sql queries.
But I've heard there should be a plugin of some sort to Enterprise Manager, that lets you dbl click on a table and you will instantly get shown all rows, instead of the properties of the table which nobody actually cares about.
anybody know where to get this plugin or how to make it?
|
|
|
|
|
hi, im doing a add function. it allows user to enter numeric value into
Ms access database. I have 24 text boxes for the user to enter their data. however, if the user do not complete entering all the data into this 24 textbox, how do i insert a blank value into the database.
|
|
|
|
|
You need to check the each text box before it add the record to the database. If your text is null then don't add to your text box. Here is an example:
if isnull(text1.value) = false then rst.field(0).value = text1.value
if isnull(text2.value) = false then rst.field(1).value = text2.value
if isnull(text3.value) = false then rst.field(2).value = text3.value
...
if isnull(text24.value) = false then rst.field(23).value = text24.value
Try to do it and let me know if you have more problem.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
THanks. But how do i convert those statement into c#?
Chris
|
|
|
|
|
I'm sorry nuttynibbles1984, I never learn about C# programming language  I prefer in VB6 and VB.NET. May be you need to post this question in VB/VB.Net or C# forum. 
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Hi All,
I have .net webservice [with sybase backend], which Adds/Updates/Deletes the customer details. Considering the services is deployed on server where database also resides, if more than two clients requests[a multi-user environment] the same Update service, problems regarding the database locking arises.
I think record-level locking would be the better solution for handling datase locking issues related to Updates. for Inserts and Deletes actions using page loaking would be better.
Transaction obejct in .net have Isolation enums which can simulate these , odes anyone incrporated these.
Can Somebody help me out to solve these situation or any related links is appreciated.
Regards,
Vinay
|
|
|
|
|
In what way is this the last record in the table? It has to be last based upon some criteria (lname perhaps?). You can't guarantee that the last entry put into the database will be stored at the end of the table which is why you have to do a search on some criteria.
What database are you using?
store your internet favourites online - www.my-faves.co.uk
|
|
|
|
|
It is very difficult to search for the last record without any notification for each specific record. In my opinion, you should create one more fied that store a uniqe ID of the record. The structure as follow.
ID fname lname age
1 abc1 bbb 22
2 xyz2 bbb 32
3 klm css 23
So everytime when you insert new record it will generate the new unique ID. So when you want to call the last record use the following method (suppose that you use Ms access database and DAO.
dim dbs as DAO.Database
dim rst as DAO.Recordset
' Use this code in any procedure where you want to
' call the database.
set dbs = CurrentDb
' Suppose that tblData is the table that store your data.
set rst = dbs.OpenRecordset("SELECT * FROM tblData ORDER BY tblData.ID")
with rst
if .Recordcount > 0 then
.MoveFirst
.MoveLast ' Populate the recordset.
end if
' Post the record on the form.
txtId.value = .Field(0).value
txtfname.value = .Field(1).value
txtlname.value = .Field(2).value
txtage.value = .Field(3).value
end with
Try to do it and hope it is working 
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
How to get two or more params in the Extend Procedure DLL ?
In DLL the method is :
SRVRETCODE func( SRV_PROC* pSrvProc )
{
...
}
the pSrvProc might transmit two or more params. But i dont know How to get
their values?
for example, i SQL procedure, i will use this code:
Exec func @param1,@param2,@param3
How to get the three params' value in the DLL ?
|
|
|
|
|
|
I try to find the auto-increament for the Number - field, but can't.
In Ms SQL database, it supports this value.
Can anyone please advice me?
Thank you very much.
|
|
|
|
|
Yes access does support this. Its called an AutoNumber or Counter.
store your internet favourites online - www.my-faves.co.uk
|
|
|
|
|
Dear All,
I need the help for implementing the row level locking in my transaction-based form.
Following is the details of the working logic and the problem faced by me : -
Front End: MS Visual Basic 6.0
Back End: MS SQL Server 2000.
In one of my form first the user makes the document and saves it. While saving the document numbers is generated and then the details are saved in the detail table and one entry will be passed in the header table. After which the user needs to do the authorization of the same.
In the authorization form when the user selects the particular document for authorization then in the lost focus of the document number text box I want to lock the record for that document in the header table. The table contains precisely one record for each document.
I first BEGIN the transaction for the connection object I’m using and then I set the LOCK_TIMEOUT property to 0, by executing the statement 'SET LOCK_TIMEOUT 0' through the connection object. Then I execute the following statement: -
SELECT * from HEADERTBL WITH (UPDLOCK) where GRNNO='001'
But when I go back to SQL Server and execute the SP_LOCK procedure that gives me the status of locks hold by SQL Server. It shows that the record that I want is locked by Update lock but the other records are also locked by SHARED Lock, which I don’t want. After going through the number of records locks it was found that it locks the whole page by default with SHARED Lock and the record matching the where condition with the lock specified.
The problem is that if some other user when tries to lock some other document for UPDATE Lock then SQL Server refuses that until the rows locked previously are released.
Is anybody can help to set some property through ADO or directly so the records matching the where condition are only locked and other users are also allowed to lock other records then the one already locked. Also the locked records need to be allowed to read by all the users as they take the help for document number and due to which I was unable to use EXCLUSIVE Locks.
Revert back in case of any further details are required.
Chintan
|
|
|
|
|
You are attempting to use database level concurrency for an application concurrency problem, and it is a poor fit.
Rather create your own "locking" table, and use that to mark documents as locked.
my blog
|
|
|
|
|
hi chintan,
I a'm facing the similar proble, can u share how do u sort out the probelm
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
