How about not using access and converting your DB to SQL Express then your troubles dissapear :-)

Kind Regards, Gary

My Website || My Blog || My Articles

Hi guys I got a bit of a problem that has taken me days to try and sort out and I'm getting nowhere. basically I have to servers that are setup in a DMZ, as a workgroup, one server is a Application Server and the other is a Database and File Server. I need to be able to be able to upload files from the application server the file server via a UNC path. but everything I have tried seems to fail. I recieve errors along the lines of "can't find part of path", "incorrect user/password", etc. I have tried a Myriad of approaches including creating a user account on both machines, and impersonating that account, to write, Created a Virtual Directory and used : string SaveLocation =System.Web.Hosting.HostingEnvironment.MapPath ("~/webmedia/article/" + fn ) To get the UNC path, Stored the UNC path in the Web.config file, but nothing seems to work. I haved scoured the net for any information, but seem to have got nowhere, I have found one or two articles but they basically tell me what I have tried. I was wondering if anybody knows of any other Tut's/atricles I could read. I have included some of my code in the help somebody could spot an error HttpPostedFile selectedPDF = ImageUploadFile.PostedFile; if ((selectedPDF != null) && (selectedPDF.ContentLength > 0) && selectedPDF.ContentType == "application/pdf") { try { string fn = System.IO.Path.GetFileName(selectedPDF.FileName); string dir = ConfigurationManager.AppSettings["docpath"].ToString(); // string SaveLocation =System.Web.Hosting.HostingEnvironment.MapPath ("~/webmedia/article/" + fn ); string SaveLocation = ConfigurationManager.AppSettings["devdocpath"].ToString() + fn; selectedPDF.SaveAs(SaveLocation); ..... -- modified at 8:47 Wednesday 7th November, 2007 I have tried doing a simple app here locally on my own network and haven't even tried using impersonation, but it just works here is the sample code. I am completely baffled try { HttpPostedFile theFile = FileUpload1.PostedFile; //System.IO.Path.GetFileName(selectedPDF.FileName) FileUpload1.SaveAs(@"\\Cyko\d\" + System.IO.Path.GetFileName(theFile.FileName).ToString()); }

Kind Regards, Gary

My Website ||

Malta, Ukraine, Serbia, China, Hungary are the new India's

Kind Regards, Gary

My Website || My Blog || My Articles

Work in CZ for UK company :-)

Kind Regards, Gary

My Website || My Blog || My Articles

Any Czech .Net developers on here looking for work?

Kind Regards, Gary

My Website || My Blog || My Articles

If I wanted to work on the command prompt I would've stuck to Unix :-) This is what gets me about GUI operating system. Sometimes it is so pointless, when you have to resort to using the command line to do the simple things!! I already use the command line FTP because the GUI keeps on falling over. Why did MS bother with the GUI?

Kind Regards, Gary

My Website || My Blog || My Articles

does anybody else here think that some developer on the Vista team got a bit stoked about the message box functionality and decided to put it everywhere? I want to change attributes on a folder from read only to normal and i will get 3 message boxes telling whats happening, I wouldn't mind but when I right click on the folder and check the attributes they are still read only!! I get all the message boxes but no action!!

Kind Regards, Gary

My Website || My Blog || My Articles

Ever since the Macintosh was a raincoat.

Kind Regards, Gary

My Website || My Blog || My Articles

YEah I've used VS2005 to debug Javascript, it's kinda cool. There is an article somewhere on MSDN explaining how to set it up

Kind Regards, Gary

My Website || My Blog || My Articles

Ok I took the plnuge today and bought a new laptop with Vista Ultimate installed. After talking to ex-colleagues and respected peers, all say this is not really a good decision, as most claim it is the worst operating systems since WIn98/Millenium Edition. I know this question has been asked a thousand times on here, but just thought I would check with you guys. Should I wipe the hard drive and install XP and wait another year before trying Vista again, or should I persevere. Bearing in mind I spend most of time going from Client site to client site, connecting up and coding. Have a let myself in for a life of misery? With an operating system that just isn't worth it?

Kind Regards, Gary

My Website || My Blog || My Articles

I did have an email this week saying that there will be planned maintenance happening this weekend on my servers. Maybe your servers were scheduled for earlier.

Kind Regards, Gary

My Website || My Blog || My Articles

Hi Guys, I have a stored proc that is returning XML to the client, as listed below. The question I have is that the description field can contain some HTMLa and possibly some illegal XML characters i.e &,<,>, ' etc. I would like to wrap these sections in a CDATA field but am a little unsure how to do it. Oh yeah the XML is going to be transformed by XSLT on the client. Any tips would be greatly appreciated. Ideally what I would like to achieve is to get rid of calling my DBO.HTMLENcode function I have written to encode the illegal characters. Select @Brief as briefdescription, Cast('' + replace(cast(DBO.HTMLENcode(@Desc) as varchar(max)) , char(13),'' ) + '' as xml) as descriptions , cast('' + replace(cast(DBO.HTMLENcode(Features) as varchar(max)), char(13)+char(10), '') + '' as xml) AS Features, cast(price as money) as price, bedrooms as bedroom, status_id, cast(replace(('' + replace(cast(DBO.HTMLENcode(rooms) as varchar(max)), char(13), '')+ ''),'','') as xml) as rooms, Size_metre_sq as sqm, COALESCE (ADDRESS1 + ', ', '') + COALESCE (ADDRESS2 + ', ', '') + COALESCE (ADDRESS3 + ', ', '') + COALESCE (ADDRESS4, '') AS Address ,directions , Saleterms.SALETERMS as saleterm ,Saleterms.price_label as PriceLabel, leaseterms, rating, Convert(varchar(11) ,Availability, 113) as availability from dbo.PROPERTY as Property inner join Saleterms on Property.Saleterms_ID = Saleterms.ID where Property.id = @id FOR XML PATH('Property'), ROOT('Detail')

Kind Regards, Gary

My Website || My Blog || My Articles

Don't be so Naive. Things don't work like that in the real world

Kind Regards, Gary

My Website || My Blog || My Articles

Tell them to FO. And go get a sub par software built for next to nothing at some hack code workshop in bangladesh or Kiev. These request are generally these same Hack Code workshops, trying to figure out a price to charge one of there clients. -- modified at 9:58 Tuesday 15th May, 2007

Kind Regards, Gary

My Website || My Blog || My Articles

Give me a clue who is SQL Stan??

Kind Regards, Gary

My Website || My Blog || My Articles

Obviously "undocumented security features"

Kind Regards, Gary

My Website || My Blog || My Articles

But thought I'd say it again. I'm not liking the mucking about with the menu thing that's happened!! I've logged in after a couple of weeks of being away, and it appears some things have changed!! I'm being a typical user here, and putting up a resistance to change!!

Kind Regards, Gary

My Website || My Blog || My Articles

Thanks Jim. I will be downloading the product and have a real good play with it over the next couple of days

Kind Regards, Gary

My Website || My Blog || My Articles

Thanks guys on your feedback, We are looking at the product, to generate all the crud code to quickly deliver an estate agency management application. In trials so far I have been quite impressed, we can create the bones of the application in a matter of seconds, as we have the Database design done. However we have one concern obviously being the price adn licence. Thanks code-frog for your offer, we'll be looking into the product a bit more over the next couple of days, so we may get in touch with you.

Kind Regards, Gary

My Website || My Blog || My Articles

Has anybody here used Ironspeed, the code generating tool? If so what are your views?

Kind Regards, Gary

My Website || My Blog || My Articles