Recent content by nickspace

thanks for your help, jbenson. i finally got it to work. I was a permissions issue on the server.

Sorry, I should have added that to the post. I did download and install CRRedist2005_x86.msi because that's what I read somewhere. But that did not help either.

I've written an ASP.net 2.0 app that allows users to run crystal reports. The site works flawlessly on my dev server but when I publish it on the prod server, the crystal report viewer bar does not load. Instead I get "Submit query" label for all the crystal buttons (print, export, last page...

I get an error when I attempt to connect to SQL Express using VB.net. I am attempting to use a System DSN previously created using the ODBC Data Source Administrator. The DSN was tested using MS Access by linking the tables. (Inserts... Updates and etc. all working) The code that fails is when I...

i feel it is more a security issue than an incorrect source issue. i think the ASP.NET account doesn't have the correct NTFS permissions. But i have no clue how to go about switching this.

i am allowing users to build a document with images in it. it is built using an html editor. the users can upload images and input text. the local image is viewable here: http://www.flickr.com/photos/31690563@N08/2961798103/ the server image can be viewed here...

yes, the images are uploading correctly. they are supposed to be displayed after they get uploaded as the users are creating documents that can have images ebedded within text. The code is too long for me to post here. Also, the code for uploading is not available as I just have a dll for this...

I am using Winthusiasm HTML Editor. The images get stored under "~/ImageBrowser/Images" folder. This is a setting available on the control itself. However, when uploaded, images appear with a red x as if there is not read permission. btw, under this Images folder, there is one folder each for...

I have a small .Net 2.0 app. that allows users to upload images and input text to an HTML editor. This site works perfectly when I run it from VS.Net. However when I publish it to IIS, the images appear as white boxes with a red square. I have tried messing with the security settings of the...

thanks, mrdenny. will do.

Hi everyone, I'm new to DTS. I've gone through a lot of posts in this forum but so far I have not found any post that informs about importing any excel file (any random name) to a SQL table. In my case, the column names in the excel file are consistent, but the actual file name could be...

My apologies.... linked table manager does not have a save password option. Here's what you'll need to do: 1) Delete all linked tables 2) Right-click on tables and select link tables 3) Find the correct DSN 4) Input the username and password 5) While selecting the tables from the available...

When you link tables using linked table manager, check the box that reads "Save Password". Nick

Here's the output: DBCC SHOWCONTIG scanning 'PAGE HISTORY' table... Table: 'PAGE HISTORY' (330484256); index ID: 0, database ID: 33 TABLE level scan performed. - Pages Scanned................................: 3011 - Extents Scanned..............................: 382 - Extent...

Hi SQLSis, There are no triggers on this table. Here is the syntax of the proc, if that helps: DELETE FROM dbo.[PAGE HISTORY] WHERE ([Page History ID] = @PHToDelete) Thanks, Nick