|
LOL Colin that's one funny pointer.
I managed to work out my problem, it was do with timing issue. By the time MethodA finishes executing, I believe access has not had time to update Table A, then MethodB starts executing and Table A is missing the relavant data and MethodB fails to insert a row in Table B.
Why does it work in debug mode well when debugging there is ample time for Access to actually commit the data into the table.
Solution was to a a Thread.Sleep() to cause pause and it all works.
Yes you are right about placing tracing code.
<br />
public void AddStuffToDB()<br />
{<br />
MethodA(string x,string y);<br />
<br />
MethodB(string x);<br />
}<br />
|
|
|
|
|
Hello,
i have a ms access database, there is information written in cyrillic encoding. When i read the text from c++ using Ado, it cannt read proper text, it reads only "???????????????", what should i do to read correct text in c++?
here is the code
<br />
CString strItem;<br />
strItem = (char *) (_bstr_t) pRecordPtr->Fields->GetItem("name")->Value;<br />
strItem is "?????" if when encoding is cyrillic.
OR
Is there sql command like "SET CHARACTER SET utf8" in Jet Sql, Mysql has the command, but wondering that Microsoft Jet sql has it?
if Microsoft Jet Sql has it, it would be better to change encoding
thanks
|
|
|
|
|
Hello everyone.
I h've been trying for the last week to access a variable in my SSIS package and foward it down to a Data Conversion Item. I've read that I could use a Derived Column or a Script Component Item but I have not had any luck. When I use the Script Componet I am able to test the variable value by adding the code Msgbox(Me.Variables.WMWeekNbr) in the method CreateNewOutputRows in the ScriptMain class. I see the message box with value but it doesn't foward to the data conversion item. I did add the variable to ReadOnlyVariables property. I also created a output columns on the script object.
Im basically trying to create a C# application that will take a value and pass it to the SQL SSIS package which will delete values from the database.
Thanks 
|
|
|
|
|
I am using SSRS 2005 for the remote access of the reports. I will put url on browser, this will show the result. I am using ListChildren method.
catalogItems = rService.ListChildren(Global.ReportPath,true);
But the code is not working. This will make the tree. This should retrieve no. of reports from report server remotely and put in array, catalogItems. Based on the number of reports the another loop will retrieve names of the reports and will populate the tree vi ew.
Help me please.
|
|
|
|
|
Why is it not working? Do you get an exception? If so, what is the message?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Now I am able to populate the reports remotely.
I have used following lines :
rService.Url = "http://10.10.40.2/ReportServer/ReportService2005.asmx";
before,
catalogItems = rService.ListChildren(Global.ReportPath, true);
and added web references.
But I do'nt know how to do role based forms authentication. I need help.
|
|
|
|
|
This is a different question to the one you began the thread with. You should really start a new thread for it.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
