|
I have recently mnodified the security arrangements of my ASP.NET application and am now receiving the error
"The Microsoft Jet database engine cannot open the file '\\W91\AvolitesDownload\Databases\2008License.mdb'. It is already opened exclusively by another user, or you need permission to view its data"
I have got my self in a bit of a tangle over this and now can't work out how it used to work!
Application details:
ASP.NET pages(C#)
one SQL Server 2005 database which I can read/write to fully and correctly
one MS Access 2003 database for which I now receive the above error
connection strings for both are stored in the web.config, a sample of which is below:
<code>
<configuration>
<connectionStrings>
<add name="W123_LicensingSourceData" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source W123\Databases\Copy of 2008License.mdb;Persist Security Info=True;" providerName="System.Data.OleDb" />
<add name="LicensingConnectionString" connectionString="Data Source=s321;Initial Catalog=Licensing;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
<identity impersonate ="true"/>
</system.web>
<location path="Operator">
<system.web>
<authorization>
<allow users="DOMAIN\Reception"/>
<allow roles="SoftwareDeveloper"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="Admin">
<system.web>
<authorization>
<allow users="Reception"/>
<allow roles="SoftwareDeveloper"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="Production">
<system.web>
<authorization>
<allow users="DOMAIN\Production"/>
<allow roles="SoftwareDeveloper"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
</configuration>
</code>
The windows authentication seems to be the correct way forward, and "Everyone" is allowed full access to the MSAccess database. There is no user name or password needed to open the DB itself. The ASP.NET app discussed above is on a different server to the Access DB. A second ASP.NET which is hosted on the same server as the Access DB has no problem with connecting to it.
Any help for the above much appreciated
Thanks, Des
|
|
|
|
|
i am having one database and the data will be comming through a device and i need to copy the newly generated row to another database how is it possible
i need to insert new row into another database this to be done in sql express
can anybody give solution for this
padma
padma
|
|
|
|
|
Run an INSERT...VALUES query to insert a new row of data into a table in your second database.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
i need to write trigger for this
|
|
|
|
|
Good for you.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
You want to look at syntax like this:
create trigger dbo.MyTrigger
on dbo.MyTable
for insert
as
insert into database2.dbo.table2 (col1, col2)
select col1, col2 from inserted
end
|
|
|
|
|
i am having one database and the data will be comming through a device and i need to copy the newly generated row to another database how is it possible
i need to insert new row into another database this to be done in sql express
can anybody give solution for this
padma
padma
|
|
|
|
|
IS that Database on same server?
Hardik Panchal
|
|
|
|
|
in sql express How we know that user has inserted new row or update old row, is there any keyword to find out.
regards
padma
|
|
|
|
|
You can use Query Notifications[^] but I'm not sure whether it is included in express addition or not
|
|
|
|
|
hi friends...
is there any replacement for the following query
select 0/0 from dual;
if i execute the query i am getting error ORA-01476.
can any body helps me in
bye
mahen
|
|
|
|
|
hi
Its a mathematical error..in a division divisor cannnot be Zero.
Regards
Joe
|
|
|
|
|
thanks jo
instead of error if it gives some value.. i can assign that to variable and get the value..
i working with one programme..say variable a and b.
some time variable b might be zero..
when i run the query.. say select a/b then it gives the error if thats values become 0..
please help.. me
thanks
mahen
|
|
|
|
|
hi
you can use DECODE function with which you can replace 0 with some other value.
Regards
Joe
|
|
|
|
|
hi
i havae to insert data from one record to another for that i created a trigger
CREATE TRIGGER trigInsertion on master
AFTER insert as
INSERT into child
SELECT Convert(varchar(50),master_date,105) FROM inserted
in this i need to convert varchar to datetime and insert these values into child table but it is not working
padma
|
|
|
|
|
hi
for converting varchar to date use
convert(datetime,FIELD)
try to include the error message..so that we can identify the problem
Regards
Joe
|
|
|
|
|
in sql express How we know that user has inserted new row or update old row, is there any keyword to find out.
padma
|
|
|
|
|
In what format dates are stored in "master_date"
As you are using 105 (style) it should be in "dd-mm-yy" format
Regards
KP
|
|
|
|
|
I WILL TRY TO HELP YOU SOON
THANKS
MAHEN
|
|
|
|
|
Hi
can anybody give solution for my req
i had a mastertable and i need to copy generated recordsd to my child table my code follows in this way:
CREATE TRIGGER trigInsertion on GlobalScan
AFTER insert as
INSERT into GlobalScanNew
SELECT * FROM inserted
end
but here in my mastertable coloums data type is different from child table
now i need to convert this and place it in my new table
plz can anybody give solution for this
Regards
padma
padma
|
|
|
|
|
hi
you can use convert() function for converting data type and insert it in to the child Table.
eg: INSERT INTO CHILD
SELECT CONVERT(VARCHAR,FIELD1) FROM INSERTED
Regards
Joe
|
|
|
|
|
thanks for reply
but in my master table i had 10 coloums and in that i need to check three coloums so how can i do it
padma
padma
|
|
|
|
|
hi
if you needs only 3 columns specify that columns in your select qry
eg: INSERT INTO CHILDTABLE
SELECT CONVERT(FIELD1),CONVERT(FIELD2),FIELD3
FROM INSERTED
Regards
Joe
|
|
|
|
|
|
I can do a select within a dataset to search for a string. This works great.
When I try to do the select to search for a number I get a 'does not evaluate to a Boolean term'.
For example- matchingRows() = ds.Tables("Generations").Select("id = 3")
I get a simular error when I try to create a dataview that keys off of a number.
How do you search a dataset for a numeric value?
Thanks in advance!
kermit88
|
|
|
|