ASP upload image file

Im writing an asp page which allows users to upload files which are then
saved in a database table as an image. The problem is that the webpage is on
one server and the data is stored on another server, I can save the image to
the server the webpages are on but not the other, just get the error:
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.
Is it possible to do this?
Chris,
is the db on the same internal network as the webserver?
if it is i dont think thats your problem, post some code.
Mike
www.michaelevanchik.com
"chris2583" wrote:

> Im writing an asp page which allows users to upload files which are then
> saved in a database table as an image. The problem is that the webpage is on
> one server and the data is stored on another server, I can save the image to
> the server the webpages are on but not the other, just get the error:
> ADODB.Recordset error '800a0cb3'
> Current Recordset does not support updating. This may be a limitation of the
> provider, or of the selected locktype.
> Is it possible to do this?
|||For Each File In Uploader.Files.Items
' Open the table you are saving the file to
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "select * from test",conn,2,2
RS.AddNew ' create a new record
RS("filename") = File.FileName
RS("filesize") = File.FileSize
RS("contenttype") = File.ContentType
' Save the file to the database
File.SaveToDatabase RS("filedata")
' Commit the changes and close
RS.Update
RS.Close
Next
All the servers are on the same internal network. I have an included asp
page which has the FileUploader class. This is the code that works, when I
change source parameter in the RS.Open line to the table on the other server
it fails on the RS.AddNew line.
"Michael Evanchik" wrote:

> Chris,
> is the db on the same internal network as the webserver?
> if it is i dont think thats your problem, post some code.
> Mike
> www.michaelevanchik.com
>
sql

ASP upload image file

Im writing an asp page which allows users to upload files which are then
saved in a database table as an image. The problem is that the webpage is on
one server and the data is stored on another server, I can save the image to
the server the webpages are on but not the other, just get the error:
ADODB.Recordset error '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the
provider, or of the selected locktype.
Is it possible to do this?Chris,
is the db on the same internal network as the webserver?
if it is i dont think thats your problem, post some code.
Mike
www.michaelevanchik.com
"chris2583" wrote:

> Im writing an asp page which allows users to upload files which are then
> saved in a database table as an image. The problem is that the webpage is
on
> one server and the data is stored on another server, I can save the image
to
> the server the webpages are on but not the other, just get the error:
> ADODB.Recordset error '800a0cb3'
> Current Recordset does not support updating. This may be a limitation of t
he
> provider, or of the selected locktype.
> Is it possible to do this?|||For Each File In Uploader.Files.Items
' Open the table you are saving the file to
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "select * from test",conn,2,2
RS.AddNew ' create a new record
RS("filename") = File.FileName
RS("filesize") = File.FileSize
RS("contenttype") = File.ContentType
' Save the file to the database
File.SaveToDatabase RS("filedata")
' Commit the changes and close
RS.Update
RS.Close
Next
All the servers are on the same internal network. I have an included asp
page which has the FileUploader class. This is the code that works, when I
change source parameter in the RS.Open line to the table on the other server
it fails on the RS.AddNew line.
"Michael Evanchik" wrote:

> Chris,
> is the db on the same internal network as the webserver?
> if it is i dont think thats your problem, post some code.
> Mike
> www.michaelevanchik.com
>

ArgumentException: Font ? cannot be found.] (Asp.net Reports)

Hi guys, i have a scary problem, i have used the rdl files of an already existing reports (sql reporting services)

and succesfully converted them (to rdlc files) to asp.net local report (using reportviewer). and it works very good

on the development server,...However, it does not work completely on test(cert) server:

i actually can load the reports, except one which has graphics in it, on the other hand i can not export any of them

(even those reports that can be loaded to a page), so please help me, the point is that i have to have a pretty much of a good idea

before i go to those test server guys, i dont have access to test server myself. i get 4 exception at once, and i get them when i want to export to pdf, not just the graphic one but also all other reports. Interesting point is that the same reports (i mean the original rdl reports on sql reportingservices)

works wel on the same server (test server), that causes me to question whether it is about lack of some font on the server

i appreciate any help or idea's, and thanks:

[ArgumentException: Font '?' cannot be found.]
System.Drawing.FontFamily.GetGdipGenericSansSerif() +207809
System.Drawing.FontFamily.CreateFontFamily(String name, FontCollection fontCollection) +116
System.Drawing.FontFamily..ctor(String name, Boolean createDefaultOnFail) +13
System.Drawing.Font..ctor(String familyName, Single emSize, FontStyle style) +77
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.CreateFont(String family, Single size, FontStyle style) +54
Microsoft.ReportingServices.Rendering.ImageRenderer.CompositionBase.CreateDefaultFontPens() +33
Microsoft.ReportingServices.Rendering.ImageRenderer.CompositionPDF..ctor(CreateAndRegisterStream createAndRegisterStreamCallback, Report report) +428
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber) +32
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) +29

[ReportRenderingException: An error occurred during rendering of the report.]
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) +70
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) +1124

[WrapperReportRenderingException: An error occurred during rendering of the report.]
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) +1681
Microsoft.Reporting.LocalService.RenderWithDataCache(PreviewItemContext itemContext, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, IRenderingExtension renderer, ReportProcessing repProc, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup) +1693
Microsoft.Reporting.LocalService.Render(PreviewItemContext itemContext, Boolean allowInternalRenderers, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup, ProcessingMessageList& warnings) +227
Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +235

[LocalProcessingException: An error occurred during local report processing.]
Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +276
Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +189
Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +28
Microsoft.Reporting.WebForms.LocalReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileNameExtension) +52
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +202
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Hi guys,

thanks to all poeple who took some time and read my post, i like to say that for a great

part i found the solution, the problem was that the application didnt have reading right to

the font folder of windows. we gave that right to it and it worked, at least the graphic and export to pdf works now very good, however, very strangely export to excel does not work,

when i find a solution for that too, i will sure let you guys know.

thanks,

ceti

|||

Hi guys again,

today when i started to work, for a reason that i dont know yet, the export to excel was working too..!!!

so i guess i dont know why i didnt work yesterday and why it works today..

thanks

ceti

Are these DBs required?

Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

- Master
- Model
- MSDB

Cheers, @.shOn 06.09.2006 16:05, @.sh wrote:

Quote:

Originally Posted by

Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

Wait, did you just complain because of 35MB? You must be joking - or
using an ancient piece of hardware...

Quote:

Originally Posted by

- Master
- Model
- MSDB

You have two options:

- try it out
- read about them in the manuals

I'd go with option 2...

Regards

robert|||NO!

The master database is the cornerstone of your SQL Server
installation. Having good backups is vital.

I believe SQL Server will not start if there is no model database. A
fresh install will create one, but there are times that you want to
make changes to model, and you woiuld want to back them up. Besides,
model is TINY.

MSDB includes, among other things, all the details of your backups.
MSDB is growing because there is a record of every backup ever run.
You probably don't need this going back to day 1, and there is a
standard tool for deleting entries before a specified date:
sp_delete_backuphistory. See the docs for details.

Roy Harvey
Beacon Falls, CT

On Wed, 6 Sep 2006 15:05:58 +0100, "@.sh" <spam@.spam.comwrote:

Quote:

Originally Posted by

>Always wondered, now I have the time to ask - we currently backup ALL
>databases and these seem to all grow in size, the MSDB BAK files are now
>35mb each and growing!!! Can we remove these from our Enterprise Manager?
>
>- Master
>- Model
>- MSDB
>
>Cheers, @.sh
>

|||That "NO!" was in response to the question that ended the original
post, "Can we remove these from our Enterprise Manager?".

The question in the Subject, "Are these DB's required??", is YES!

Roy

On Wed, 06 Sep 2006 14:54:46 GMT, Roy Harvey <roy_harvey@.snet.net>
wrote:

Quote:

Originally Posted by

>NO!
>
>The master database is the cornerstone of your SQL Server
>installation. Having good backups is vital.
>
>I believe SQL Server will not start if there is no model database. A
>fresh install will create one, but there are times that you want to
>make changes to model, and you woiuld want to back them up. Besides,
>model is TINY.
>
>MSDB includes, among other things, all the details of your backups.
>MSDB is growing because there is a record of every backup ever run.
>You probably don't need this going back to day 1, and there is a
>standard tool for deleting entries before a specified date:
>sp_delete_backuphistory. See the docs for details.
>
>Roy Harvey
>Beacon Falls, CT
>
>On Wed, 6 Sep 2006 15:05:58 +0100, "@.sh" <spam@.spam.comwrote:
>

Quote:

Originally Posted by

>>Always wondered, now I have the time to ask - we currently backup ALL
>>databases and these seem to all grow in size, the MSDB BAK files are now
>>35mb each and growing!!! Can we remove these from our Enterprise Manager?
>>
>>- Master
>>- Model
>>- MSDB
>>
>>Cheers, @.sh
>>

|||Instead of being so f*cking anal you could actually advise me, if I had
manuals I would have read them, else I wouldn't be posting here...we have a
dedicated server, with no manuals, hence my newsgroup post.

Could anyone else be so kind as to help?

Cheers, @.sh

"Robert Klemme" <shortcutter@.googlemail.comwrote in message
news:4m844fF4umvpU1@.individual.net...

Quote:

Originally Posted by

On 06.09.2006 16:05, @.sh wrote:

Quote:

Originally Posted by

>Always wondered, now I have the time to ask - we currently backup ALL
>databases and these seem to all grow in size, the MSDB BAK files are now
>35mb each and growing!!! Can we remove these from our Enterprise Manager?

>
Wait, did you just complain because of 35MB? You must be joking - or
using an ancient piece of hardware...
>

Quote:

Originally Posted by

>- Master
>- Model
>- MSDB

>
You have two options:
>
- try it out
- read about them in the manuals
>
I'd go with option 2...
>
Regards
>
robert

|||Many thanks Roy, greatly appreciate your help! Guess I'll be leaving them in
place, we simply out of policy backup everything and question what we've got
later, its only now that we've had time for a cleanup, hence my questions.

Thanks again.

Cheers, @.sh

"Roy Harvey" <roy_harvey@.snet.netwrote in message
news:iaotf21jtp08f743267b5pppdlg8a6io4g@.4ax.com...

Quote:

Originally Posted by

That "NO!" was in response to the question that ended the original
post, "Can we remove these from our Enterprise Manager?".
>
The question in the Subject, "Are these DB's required??", is YES!
>
Roy
>
>
On Wed, 06 Sep 2006 14:54:46 GMT, Roy Harvey <roy_harvey@.snet.net>
wrote:
>

Quote:

Originally Posted by

>>NO!
>>
>>The master database is the cornerstone of your SQL Server
>>installation. Having good backups is vital.
>>
>>I believe SQL Server will not start if there is no model database. A
>>fresh install will create one, but there are times that you want to
>>make changes to model, and you woiuld want to back them up. Besides,
>>model is TINY.
>>
>>MSDB includes, among other things, all the details of your backups.
>>MSDB is growing because there is a record of every backup ever run.
>>You probably don't need this going back to day 1, and there is a
>>standard tool for deleting entries before a specified date:
>>sp_delete_backuphistory. See the docs for details.
>>
>>Roy Harvey
>>Beacon Falls, CT
>>
>>On Wed, 6 Sep 2006 15:05:58 +0100, "@.sh" <spam@.spam.comwrote:
>>

Quote:

Originally Posted by

>>>Always wondered, now I have the time to ask - we currently backup ALL
>>>databases and these seem to all grow in size, the MSDB BAK files are now
>>>35mb each and growing!!! Can we remove these from our Enterprise Manager?
>>>
>>>- Master
>>>- Model
>>>- MSDB
>>>
>>>Cheers, @.sh
>>>

|||In enterprise manager, the 10th icon from the left (looks like a yellow
question mark over a book). If you click on this it will open BOL
(books On Line) That is the manual that comes with SQL server

Denis the SQL Menace
http://sqlservercode.blogspot.com/
@.sh wrote:

Quote:

Originally Posted by

Instead of being so f*cking anal you could actually advise me, if I had
manuals I would have read them, else I wouldn't be posting here...we have a
dedicated server, with no manuals, hence my newsgroup post.
>
Could anyone else be so kind as to help?
>
Cheers, @.sh
>
>
"Robert Klemme" <shortcutter@.googlemail.comwrote in message
news:4m844fF4umvpU1@.individual.net...

Quote:

Originally Posted by

On 06.09.2006 16:05, @.sh wrote:

Quote:

Originally Posted by

Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?

Wait, did you just complain because of 35MB? You must be joking - or
using an ancient piece of hardware...

Quote:

Originally Posted by

- Master
- Model
- MSDB

You have two options:

- try it out
- read about them in the manuals

I'd go with option 2...

Regards

robert

|||On Wed, 6 Sep 2006 16:02:44 +0100, "@.sh" <spam@.spam.comwrote:

Quote:

Originally Posted by

>if I had
>manuals I would have read them

The "manuals" are Books on Line, not printed. It should have been
installed with the SQL Server tools. In any case they can be
downloaded (for 2000 and 2005 at least) from the Microsoft web site.

You can NOT operate without consulting Books on Line. Constantly.

Roy Harvey
Beacon Falls, CT|||Thanks guys, will have a read this weekend - what an exciting few days I
have in store ;o)

Cheers, @.sh

"Roy Harvey" <roy_harvey@.snet.netwrote in message
news:7tuuf2hat5dgjkakh3nsagbsd0fjcn7tp8@.4ax.com...

Quote:

Originally Posted by

On Wed, 6 Sep 2006 16:02:44 +0100, "@.sh" <spam@.spam.comwrote:
>

Quote:

Originally Posted by

>>if I had
>>manuals I would have read them

>
The "manuals" are Books on Line, not printed. It should have been
installed with the SQL Server tools. In any case they can be
downloaded (for 2000 and 2005 at least) from the Microsoft web site.
>
You can NOT operate without consulting Books on Line. Constantly.
>
Roy Harvey
Beacon Falls, CT

|||@.sh wrote:

Quote:

Originally Posted by

Always wondered, now I have the time to ask - we currently backup ALL
databases and these seem to all grow in size, the MSDB BAK files are now
35mb each and growing!!! Can we remove these from our Enterprise Manager?
>
- Master
- Model
- MSDB
>
Cheers, @.sh

1. Do NOT delete them.
2. Keep backing them up.
3. Go to books online and read about what these databases are for and
why you should keep them and back them up.|||Many thanks, had a brief read about their purposes last night via the Books
Online that I've now discovered thanks to the responses here.

Cheers, @.sh

<cphite@.gmail.comwrote in message
news:1157656930.798184.59480@.b28g2000cwb.googlegro ups.com...

Quote:

Originally Posted by

>
@.sh wrote:

Quote:

Originally Posted by

>Always wondered, now I have the time to ask - we currently backup ALL
>databases and these seem to all grow in size, the MSDB BAK files are now
>35mb each and growing!!! Can we remove these from our Enterprise Manager?
>>
>- Master
>- Model
>- MSDB
>>
>Cheers, @.sh

>
1. Do NOT delete them.
2. Keep backing them up.
3. Go to books online and read about what these databases are for and
why you should keep them and back them up.
>