Hi Guru's I have a Linked Server in SQL 2005 to an Access 2003 database. I have written a stored procedure to insert a record into the Access DB. When I run the Proc on it's own, it perfoms the task, but the moment I call it from a Insert Trigger, do I get an Error Message Saying that the Linked Server does not support the required interface. Could someone please help me with a solution as to how I am going to insert / update the table in Access from SQL? Your help will be greatly appreciated. Kind Regards, Elizma

Thanx for your help! I tried searching for it before I asked the question, but I guess my search criteria was wrong since the I put in "Convert String To Expression". I found something that works. E.g. string x = "(2+3)+((7*2)-5)"; DataTable dt = new DataTable(); object sumObject; sumObject = dt.Compute(x, ""); Elizma

Hi Guys and Gals. I have a simple question, but for the life of me cant find an answer out there. I have a string that will contain an Expression: string x = "(2+3)+((7*2)-5)"; I need x to execute now as an expression in order to get the result of the expression. Eg. decimal y = (2+3)+((7*2)-5); [This is the value from the text string x] Result in y = 14 Your help will be greatly appreciated or your guidance to a possible workable solution. Kind Regards, Elizma

Hi Thank you soooo much for your solution. It works, but only partialy. It does not run when I call it from an aspx page, but if I create an html page it runs, but only if I run it directly from the saved location. When I deploy it into IIS and browse to the file, nothing happens. It's almost as if IIS is blocking this. This will also explain why nothing is happening in the aspx page. Am I missing something? Kind Regards, Elizma

Hi Guys and Gals I've tried almost everything, so this is the last resort. I really do hope someone might be able to help me. I have a web page (ASP.NET). In here I have a button. When the user clicks the button a bat file needs to execute on the client machine. The bat file will contain a link to a .aut file. I've tried the System.Diagnostics.Process, but this executes the file on the server and also under the NETWORK SERVICE account. Thus the user never see what's happening because it's not happening on his/her machine. Can anybody please either give me advice on how to accomplish this or direct me to a article that can explain this. I've been searching for 8 hours now and just cant find anything workable. Thank you so much. I will be forever greatful. Elizma

Hi We actually gone through quite a few problems with this. I will try to help you. I know one thing we had to do is to give write access to everyone to the C:\Temp folder. If you need more assistance, you can mail me at elizma_smith@hotmail.com I know how I struggled with this and was very gratefull for Sylvester to assist me. Kind Regards, Elizma

Hi Thanx for your suggestion. It might have been able to work, but I forgot to say that this is on a SQL 2000 Server and unfortunately does not support XML!

Hi Also not quite what I needed. If I use your example: stockcode item qty 1 101 10 1 102 20 1 103 20 2 104 25 2 105 20 2 106 25 2 107 26 The result I require is the following. (Say I want the Top 2 PER StockCode) Result: StockCode Item Qty 1 101 10 1 102 20 2 104 25 2 105 20 Thanx for trying to help. I really do appreciate it. Elizma

Hi Thanx for your willingness to help, but I dont think there is an easy way to do what I was looking for and it is quite difficult to explain, so I decided to not waste too much time on a easy way out and to rather go for the cursor option to solve my problem. I dont think your solution would have worked either since my problem was that I have 20+ Rows Reletad to 1 StockCode. I have 1000 StockCodes. So EACH StockCode Have 20 Related Rows. Giving the Total Number of Details to 20000. So my question was. I only want to select the top 5 rows PER StockCode. I.O.W. I would now have 5000 Records returned to me. 5 Per StockCode. Hope this makes more sense. Kind Regards, Elizma

Hi Sorry. Thanx for your supply, maybe I didn't ask the question properly. I now the plain top 5 query. My problem is: I have a master StockCode table that will contain unique StockCodes and their information. I also have a Details Table that is linked to the Master StockCode Table. Each Stock Code in the Master might have 20+ rows in the Detail table. I want to specify the Top N PER StockCode. E.g. If we use only TOP 2 StockCode1 - DetailDataRow1 DetailDataRow2 StockCode2 - DetailDataRow1 DetailDataRow2 Not maybe in this format, but I still need to get the TOP 2 rows per StockCode and not the First Top 2 Rows like what the normal solution that you suggested would do. Hope this is a bit more clear. Thanx for trying to help. Elizma

Hi Clever People. I have a scenario and no matter what I try (other than cursors) I cant seem to get this working on an easy way. I have StockCodes Say 10 Detail Rows per StockCode, but I want to see say the top 5 rows per StockCode. Can anyone give me advice please on a quick and painless way or should I just go with the cursor? Kind Regards Elizma

Hi Here is my code. CREATE Trigger [trg_MovementsLog] ON [dbo].[GtrDetail] FOR INSERT AS INSERT INTO tblMovementsLog(GtrReference,Line,StockCode, QtyMoved, MovedBy,TransactionDate) SELECT inserted.GtrReference,inserted.Line, inserted.StockCode, inserted.GtrQuantity AS QtyMoved, SUBSTRING(LotTransactions.Narration,9,Len(LotTransactions.Narration)-8) AS MovedBy, inserted.TransactionDate FROM inserted INNER JOIN GtrLot ON inserted.GtrReference = GtrLot.GtrReference AND inserted.Line = GtrLot.Line INNER JOIN LotTransactions ON GtrLot.Lot = LotTransactions.LotJob AND inserted.GtrReference = LotTransactions.Reference AND inserted.StockCode = LotTransactions.StockCode WHERE (inserted.TargetWarehouse = 'HS') AND (NOT (inserted.TransferComplete = 'Y')) AND (LotTransactions.Narration LIKE 'JOB_TRF_%') I know however that my code does work. The trigger use to work fine until they re-installed the server. Also it runs if I manually insert a record into the GtrDetail table. It just does not run when it's basically inserted via a script (Well, so it seems). Thanx for your assistance. Elizma

modified on Thursday, July 2, 2009 2:55 AM

Hi I am using SQL 2005. I have a trigger for insert on a table. In the script I read everything from the inserted table and write it into a User Log table. It seems as if the trigger is not fireing when the insert happens, but if I copy the records, delete it from the table and paste them back in, it fires the trigger. Have anyone experience this problem before, and if you have, what can I do to fix this? Your help on this will be greatly appreciated. Kind Regards, Elizma

Hi Clever people I have a simple question and for the life of me, just cant seem to track down the problem. When I am running my web application from the desktop in VS 2008, it reads the png image and displays it for me. The moment I copy and configure the web application in IIS still running it from VS, then the image does not pull through at all. Can anyone please tell me what I am doing wrong. BTW, it is not the image path since both starts with ../Images/test.png The only difference in the URL is that from IIS it's http://localhost/ while from the desktop it is http://localhost:1234/ Sorry if I am being an Idiot! Elizma

Hi Guys I hope someone will be able to give me advice on this. Our client have a service that trancates a particular table every 30 minutes. Then it re-inserts information into this table, run update statements to update certain fields with values from formulas. The problem is that now there is quite a number of unnecessary transactions in the transaction log. This results into the backup (with the trancate option) file to be about almost 20GB (I know!!!!) per day. So, my question: Is there any way possible that I can exclude this particular table's transactions from being logged? Could someone maybe give me advice on how I can get this transaction log file size smaller. Your help will be greatly appreciated. Elizma

Hi Guys, Sorry if I am posting this in the wrong Forum. I have an web app that makes use of the ReportViewer control. In this control I am calling a Remote SQL 2005 Report. This app works fine if I run in from IIS. I can export without any issues. We added this app into a Portal which is a Windows App and uses the Web Browser Control to display aspx pages. The page and the report displays just fine, but when I try to export the report using the Export link on the ReportViewer toolbar I get the following Error Message: ASP.NET session has expired. Can anyone please give me guidance as to what I must do to be able to get this report exportable. Your help is greatly appreciated. Elizma

Hi Guys, Sorry if I am posting this in the wrong Forum. I have an web app that makes use of the ReportViewer control. In this control I am calling a Remote SQL 2005 Report. This app works fine if I run in from IIS. I can export without any issues. We added this app into a Portal which is a Windows App and uses the Web Browser Control to display aspx pages. The page and the report displays just fine, but when I try to export the report using the Export link on the ReportViewer toolbar I get the following Error Message: ASP.NET session has expired. Can anyone please give me guidance as to what I must do to be able to get this report exportable. Your help is greatly appreciated. Elizma

Hi, Thanks for the willingness to help. I dont know what the problem was, but I deleted the report table, recreated it and then it worked fine. Elizma

Hi Guys I have a query that I am using to build a report in SRS 2005. The query sorts records by Customer ASC. When I view the query in SRS 2005 it is still sorted correctly. I have a group by Customer in the report. If I view the Report, my records comes back totally out of order. I also tried to force a sort by using the group properties and setting the sorting to customer, but still no luck. Can someone please tell me how I will be able to get this records sorted properly? I will really be greatfull for your help. Kind Regards, Elizma

Thank you so much. You are a life saver!!!! Kind Regards, Elizma