Re: Read-only Access DB Problem - Database Discussion Boards

Re: What's wrong with Query String;

Alexander Kojevnikov28-Jul-03 23:20

Alexander Kojevnikov

28-Jul-03 23:20

AND operator has a higher priority than OR. You might want to use parentheses:

SELECT [ID], Title, NodeType, ParentID, [Language], Description 
FROM SourceCode 
WHERE (Title LIKE '%Title%' OR Code LIKE '%Title%') 
AND (Language = 1 OR Language = 2 OR Language = 3 OR Language = 4 OR Language = 5)
AND (NodeType = 1 OR NodeType = 2 OR NodeType = 3 OR NodeType = 4 
OR NodeType = 5 OR NodeType = 6)
AND (ParentID = 4 OR ParentID = 6)

HTH,

Alexandre Kojevnikov
MCAD charter member
Leuven, Belgium

Re: What's wrong with Query String;

Jon Hulatt29-Jul-03 1:43

Jon Hulatt

29-Jul-03 1:43

Furthermore, you really ought to use "IN":-

SELECT [ID], Title, NodeType, ParentID, [Language], Description 
FROM SourceCode (nolock)
WHERE (Title LIKE '%Title%' OR Code LIKE '%Title%') 
AND Language IN (1,2,3,4,5)
AND NodeType IN (1,2,3,4,5,6)
AND ParentID IN (4,6)

#include <beer.h>

Re: What's wrong with Query String;

Bo Hunter29-Jul-03 10:21

Bo Hunter

29-Jul-03 10:21

Will the IN operator work in Access?
I forgot to mention that.
And also some of the idetifiers like Language
has to be exscaped. Does that also have to be
exscaped in OleDbParameter like so,
OleDbParameter param = new OleDbParameter( "[Language]", bla bla );
Is this correct?

Thank You
Bo Hunter

Re: What's wrong with Query String;

Alexander Kojevnikov29-Jul-03 22:07

Alexander Kojevnikov

29-Jul-03 22:07

Bo Hunter wrote:
Will the IN operator work in Access?

Yep, it will.

Bo Hunter wrote:
Does that also have to be
exscaped in OleDbParameter

Probably it has to be escaped. This won't hurt anyway Wink | ;)

Alexandre Kojevnikov
MCAD charter member
Leuven, Belgium

Read-only Access DB Problem

-- NA --28-Jul-03 2:41

-- NA --

28-Jul-03 2:41

Hi all,

I'm having the following problem: my site can access the database perfectly, using an ODBC-less connection, but when I try and insert or edit records I get the error "Cannot update. Database or object is read-only." I have changed all permissions in IIS, and in Windows Explorer but I can't seem to get it working. Suggestions please? Big Grin | :-D

The connection string I'm using:

(driver: Microsoft.Jet.OLEDB.4.0)

var sConnectionString = "Provider=" + sDBDriver + "; ";<br />
sConnectionString += "Data Source=" + Server.MapPath("../../bin/db/db.mdb");

Paul

Tiny problem with said member has been corrected.
Chris Maunder

modified 18-Jul-18 11:59am.

Re: Read-only Access DB Problem

-- NA --28-Jul-03 5:56

-- NA --

28-Jul-03 5:56

Fixed

Paul Wink | ;)

Tiny problem with said member has been corrected.
Chris Maunder

modified 18-Jul-18 11:59am.

Re: Read-only Access DB Problem

Roger Wright28-Jul-03 7:26

Roger Wright

28-Jul-03 7:26

How?

"Welcome to Arizona!
Drive Nice - We're Armed..."
- Proposed Sign at CA/AZ Border

Re: Read-only Access DB Problem

-- NA --28-Jul-03 7:27

-- NA --

28-Jul-03 7:27

I had to give IUSR_<computername> read and write access to the directory containing the Access DB.

HTH Big Grin | :-D

Paul

Tiny problem with said member has been corrected.
Chris Maunder

modified 18-Jul-18 11:59am.

Re: Read-only Access DB Problem

Roger Wright28-Jul-03 7:48

Roger Wright

28-Jul-03 7:48

Ah, of course... I've run into similar fun and games simply hosting files on IIS for public access. I assumed that the Everyone group included IUSR_... but never bothered to look. I still haven't, in fact, but found empirically that adding IUSR access to hosted files suddenly made them accessible from the outside world.

"Welcome to Arizona!
Drive Nice - We're Armed..."
- Proposed Sign at CA/AZ Border

Re: Read-only Access DB Problem

-- NA --28-Jul-03 7:51

-- NA --

28-Jul-03 7:51

Yeah, It's really irritating. Took me a long time, and lots of troubleshooting before I fixed it. I repeated the "Oh, that's it!! Jig | [Dance]

" process about 3 times before actually getting it to work Mad | :mad:

Oh well, at least it's working now. I should write on my forehead, "check IUSR_ permissions!" because it's caused me so much grief Poke tongue | ;-P

Paul

Tiny problem with said member has been corrected.
Chris Maunder

modified 18-Jul-18 11:59am.

Firehose

THEMYTH27-Jul-03 22:19

THEMYTH

27-Jul-03 22:19

Hello

I have a problem while trying to edit a record on SQL Server 2000 (Sp 3).

The problem occures, w hen I click to "Return all rows" in the context menu of the table, and I tried to uptade a record .
It occures an error. The error message says : "Transaction cannot start while in firehose mode"

I have researched a little about firehorse, but could not find any useful information.

I look forward to hearing from you

thanks

Best Regards
Emre YAZICI

Re: Firehose

Arjan Einbu27-Jul-03 22:50

Arjan Einbu

27-Jul-03 22:50

Firehose mode or firehose cursor is a forward only readonly way of going throug data.

Is this in Enterprise Manager? Is this problem consistent, or only on a certain table?

Re: Firehose

THEMYTH27-Jul-03 22:57

THEMYTH

27-Jul-03 22:57

thanks for your help

There are lots of tables, It occures just for ONE table.

We are using a client of a network

The database is on the SERVER of the network

There is a strange thing that I do not understand
I am able to update the record , when I add a new record.

e.g.

There are 10 records
I have added a new one, after I updated the 8th one .
After this there are 11 records, and the 8th record has been updated successfully.

please contact for further information if necessary

Best Regards
Emre YAZICI

Problems with LIKE in MFC(vs6)

jag_typ27-Jul-03 22:00

jag_typ

27-Jul-03 22:00

Hi..

When I try to run the following SQL against my SQL server in MFC i only get "No records" in return
(complete CDaoRecordset opening string)
rs.Open(AFX_DAO_USE_DEFAULT_TYPE, _T("SELECT * FROM scala_A_SL010100 WHERE FNCustomerName LIKE '%AB%'"), 0);

(sql query)
SELECT * FROM scala_A_SL010100 WHERE FNCustomerName LIKE '%AB%'

But if i run the exact same sql query in the SQL Query Analyzer it returns 167 posts..

Any one who has any idéas??

Re: Problems with LIKE in MFC(vs6)

Mike Dimmick29-Jul-03 2:44

Mike Dimmick

29-Jul-03 2:44

Perhaps DAO isn't passing the query into SQL Server as-is?

I suggest using ODBC to connect to the database, i.e. use the CRecordset and CDatabase classes rather than CDaoRecordset.

Re: Problems with LIKE in MFC(vs6)

jag_typ2-Aug-03 0:18

jag_typ

2-Aug-03 0:18

I think it's much easier working with CDao classes...

And the way the program is ment to be used, i can't create System-DSN's on all computers (to be able to use ODBC) I would like to connect directly to the SQL server...

One strange thing I've noticed is that if I use very simple SQL queries such as SELECT * FROM scala_A_SL010100 or SELECT * FROM scala_A_SL010100 WHERE FNCustomerName LIKE 'Besam AB'.. Or something else without the % it works fine..

Iv'e also noticed that it doesn't work then i use joins.. but as I

SELECT DISTINCT scala_A_OR200100.FNSalesmanNo AS 'Salesman', scala_A_SYCD0100.FNCurrencyShortName AS 'Currency', scala_A_OR120100.FNOrderNumber AS 'Ordernumber', scala_A_OR120100.FNLineNumber AS 'LineNumber', scala_A_OR120100.FNStockCode AS 'StockCode', scala_A_OR120100.FNDescripLine1 AS 'DescLine1', scala_A_OR120100.FNDescripLine2 AS 'DescLine2', scala_A_OR120100.FNUnitPrice AS 'UnitPrice', scala_A_OR120100.FNQty AS 'Qty', scala_A_OR120100.FNDelDate AS 'DelDate', scala_A_OR120100.FNOrderDate AS 'OrderDate' <br />
FROM scala_A_OR200100 right outer join scala_A_OR120100 <br />
ON scala_A_OR120100.FNOrderNumber = scala_A_OR200100.FNOrderNo <br />
right outer join scala_A_SYCD0100 <br />
ON scala_A_OR120100.FNUnitCode = scala_A_SYCD0100.FNCurrencyCode <br />
WHERE scala_A_OR120100.FNCustCodeDel = '400002' <br />
ORDER BY scala_A_OR120100.FNOrderNumber Desc, <br />
scala_A_OR120100.FNLineNumber asc"

But it works perfectley in the Query Analyser...

If I take away the last join it seems to work without any errors, but I naturally don't recieve all data I need..

I wonder if he DaoClass can't cope with a little more advanced SQL queries.. Or if it may be something i've done wrong.. And if there may be some way to fix my problem??

(ps. been on a vaccation a few days, therefore I havn't replied until now ds.)

Getting Child Items;

Bo Hunter27-Jul-03 20:32

Bo Hunter

27-Jul-03 20:32

Well I have come to a stop on this one;
I have a Nodes table with 4 columns ( ID, ParentID, Name, IsRoot )
I have sample data entered in
ID=====ParentID=====Name=======IsRoot
1 =====0 ==========Title1======True
2 =====0 ==========Title2======True
3 =====0 ==========Title3======True
4 =====1 ==========Child1======False
5 =====2 ==========Child2======False
6 =====5 ==========Child3======False

Now when I do a search and include sub categories
I need all the sub categories IDs. Now if I pass
ID 2 for a search then I need to get 5 and 6; I have 2 already
as it was passed in to the function; So it will look
something like Select Whatever From Nodes Where
( ParentID = 2 OR ParentID = 5 OR ParentID = 6 ).
The reason this is so hard for me is I am not filling
a dataset with all the data because it will get rather large
and take a long time to load all the data. So I am
populating the nodes as the user selects them. This
is the only method I like.

Thank You
Bo Hunter

Re: Getting Child Items;

Not Active28-Jul-03 2:34

Not Active

28-Jul-03 2:34

Personally I would use two tables

Parent Table (id, name)
Children Table( id, parent_id, name)

Re: Getting Child Items;

ZoogieZork28-Jul-03 8:33

ZoogieZork

28-Jul-03 8:33

I'm not sure I understand your question...

Are you trying to build a query in which given a node ID, you get the node's children, the children's children, etc.?

- Mike

Re: Getting Child Items;

Bo Hunter28-Jul-03 10:35

Bo Hunter

28-Jul-03 10:35

I am not tring to build the query but the methods to do what you
are saying. So if I pass 2 to the function then I need to be able
to get the children of that node and then get the children for these
nodes and keep doing it until there is no more results. I had this
done using a recursive function on the TreeNodes in the treeview.
I added these ID and ParentID properties to the treenode derived class
but forgot that if the node has not been loaded then it does not return
all the chilren. Calling a function recursively using a DataReader does
not work to well Smile | :)

Thank You
Bo Hunter

Re: Getting Child Items;

Alexander Kojevnikov28-Jul-03 23:37

Alexander Kojevnikov

28-Jul-03 23:37

I would maintain another table with all sub-children for each node. This table could be updated automatically in your primary table triggers. If you have many requests for all sub-children, and not so many updates, this technique makes sense.

You can also have a look at this[^] article and its comments.

Alexandre Kojevnikov
MCAD charter member
Leuven, Belgium

ADO.NET connection problem

sacoskun27-Jul-03 1:11

sacoskun

27-Jul-03 1:11

Hi all,
I tried to connect a database(SQL) by both VS 2003 interface tools and normal typing.

When I make the connection in local Web project it doesn't work and gives an error like this;

Server Error in '/Logon' Application.
----------------------------------------------------
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Nevertheless, when I use the same .aspx page in normal web site (not default site) it works without any error.

I have been using Windows 2000 and it was both working but when I installed Windows 2003 Enterprise Edition, it started to give that error(below). So, most probably this error acquires because of Windows 2003 settings is there anyone who knows how to solve this problem?

Kind Regards,
Arda Coskun

-
When in doubt, push a pawn!
-

Re: ADO.NET connection problem

Mike Dimmick29-Jul-03 2:54

Mike Dimmick

29-Jul-03 2:54

Under Windows 2000, your ASP.NET worker process runs as the ASPNET user. You probably added the ASPNET user to your database to make this work.

On Windows Server 2003, ASP.NET applications now use the standard worker process w3wp.exe, which runs using the NETWORK SERVICE credentials.

You need to change your worker process credentials for this application in IIS configuration so that it uses a local or domain account as appropriate. Ensure that this account can log in to SQL Server (use the Logins feature under Security in Enterprise Manager).

Alternatively, you could use SQL Server Mixed Mode and not use a trusted connection, but I wouldn't advise this.

Re: ADO.NET connection problem

sacoskun29-Jul-03 5:23

sacoskun

29-Jul-03 5:23

Thank you Mike.

-
When in doubt, push a pawn!
-

Bulk Insert - DataTable to DataTable

sburton@amersham25-Jul-03 12:41

sburton@amersham

25-Jul-03 12:41

I am currently researching an approach to bulk copy datarows from one datatable to another without iterating through each row adding them one at a time such as:

// The _dtGrid1.Rows is very large ( 20,000 rows per TIFF image loaded ).

foreach( DataRow row in _dtGrid1.Rows ) {

GenDataSet.grid2Row newRow = _dtGrid2.Newgrid2Row();

newRow.DISPENSE_FILE_ID = row[_dtGrid1.DISPENSE_FILE_IDColumn];
newRow.CUSTOMER_PROBE_NAME = row[_dtGrid1.CUSTOMER_PROBE_NAMEColumn]

_dtGrid2.Addgrid2Row( newRow );

}

This copy need to be able to execute extremely fast. I am going to look into creating my own provider but... Maybe memories move of some sort... Can somebody point me in the right direction or shed a little light on the subject.

Thanks

Stephen Burton

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.