VS 2008 Migrate BLOBs Out Of Database

Apr 27, 2009

I have a suite of programs that currently store PDF files as BLOBs in a SQL Server database table. The purpose of this design is to take advantage of Adobe's PDF iFilter and Microsoft's Full-Text Search functionality to allow other modules of my suite to run queries against the contents of a PDF file.This has been a huge headache, however, resulting in databases that are gigantic and unwieldy. We have also run into problems getting the Adobe PDF iFilter to play nice at times. Further, re-creating the entire full-text index on an 80 GB database can take a looooooong time (when it works at all!).So, the new idea is to use the open source XPdf library to extract a copy of the textual contents from each PDF file, and instead of storing the entire BLOB, merely store that textual data for the full-text functionality. Then, instead of storing the whole PDF file in the database, it will be stored somewhere on the server's file system.My issue relates to that last bit, storing the file on the server's file system, and the subsequent serving of that file out to remote users. Currently, with the entire BLOB residing inside of SQL, it has been very simple (though not easy) to manipulate the BLOB from the server to the client and vice versa. Sending the files across the network in chunks worked out well, too. I'm not sure how to do what I want to do now, though. I'm thinking that it's not a good solution to simply make a network share where all of the PDF files are stored and let the remote user view them by issuing a: Process.Start("{remote file share}filename.pdf")What I would LIKE to do is the following:

1. A Search is run, and the end user selects a file for viewing.
2. The SQL Server knows where the file resides on the local file system.
3. Something (on the server) issues a command to create a temp copy of the file at a safe location that is shared over the network.
4. The client's program then opens the file using a web browser.

Advantages:

1. The main body of the PDF files are protected and hidden from the prying eyes of those who shouldn't see them.
2. PDF files with Fast Web View enabled will load in a linear fashion, improving user experience.

Drawbacks:

1. I don't know what the "something" is in #3 above.
2. I don't know what happens when a file type other than ".pdf" is the target of the URL in a web browser. I know simple image formats will just open, but what if the file is ".doc/x". What about any other file type? Is it the same as issuing a "Process.Start("") to the UNC path?

View 5 Replies


ADVERTISEMENT

Asp.net - Store Blobs / Rich Text Memos As Rtf Programmatically On Server Hard Disc Instead Of The Database?

Jan 14, 2011

is there a way to store blobs / rich text memos as rtf programmatically on server hard disc instead of the database ?

Update (1)

i want to write in a memo field and store it using identifiers like sessions and time stamps for example writing a memo with the session "subject" and session "dateANDtime" to be stored as "mysubject-12/12/2010-11:56pm.rtf"

how to retrieve the file. can i build hyperlink programmatically?

View 3 Replies

Migrate From Access Database To SQL Server Database?

Nov 10, 2010

I am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?

I understand I need to change connection but what about code?

View 1 Replies

Migrate From Access Db To SQL 2005 Database

Jun 1, 2010

I have an Access data base back end that contains only the tables that was created in the year 2005 (by someone no longer here so cannot answer much about past and I am not very familiar with Access). When I use SSMA 2005 for Access v4.0 to migrate to SQL 2005 a table with images (defined as OLE Object) the ones that appear in the Access table as bitmap will work fine, there are ones that appear in the Access table as "Microsoft Photo Editor 3.0 Photo" or "Picture" that will not. I set up a data source and used tableadapters in a VB Windows Form and used data binding by dragging the column from the data table and dropping it on a predefined picture box on the form (this basic method works fine for all the other columns in the table). I am using Visual Studio 2008.

The Access database is over 130 megs and we are migrating it to make it available across a network to multiple and sometimes distant sites. [Code] I have used all the extensions defined in Photo Editor and this .obd is just another one I have tried to see if that makes any difference. I tried moving the array to a variable defined as an Image and then moving that to the picture box and that failed too. [Code]

View 4 Replies

VS 02/03 : Migrate A Sql Server Database To Mysql?

Apr 19, 2009

how i can migrate a sql server database to mysql? I have an app (developed with VB 2003) that it works with a big DB SQL server. But the user wants to migrate to MySQL.

View 11 Replies

VS 2008 Migrate To VS 2005

Jul 30, 2009

is there a quick way to migrate a .Net 3.5 App written with VS 2008 back to VS 2005?

I'm really fed up with VS 2008 freezing every time I resize a Table.

View 7 Replies

VS 2008 - How To Migrate Option Button

Dec 23, 2010

In VB6 I would say "optReason.Value = true"
In VS2008 would I say "rbReason.Focus()"
And accomplish the same thing?

View 2 Replies

Reading Blobs From Access Db?

Jun 14, 2009

i have to store and read pdf files in an access db. it seems not to work with larger files

the code for reding fom db:

[code]
Dim cn As New OleDbConnection(constr)
Dim cmd As New OleDbCommand("SELECT ....., cn)
cn.Open()

[Code]....

View 3 Replies

When Using MODI Printer / Sometimes It Prints 'blobs'

May 6, 2009

I have written a VB.NET program to open a word document and generate a .TIF file by printing it using the MODI printer. Usually the documents print fine. But, sometimes it appears as though all of the letters on each line are printed on top of each other which produces little square "blobs".[code]

View 1 Replies

.net - Insert Large Blobs Into Oracle 10G Using System.Data.OracleClient?

Mar 26, 2010

Trying to insert 315K Gif files into an Oracle 10g database. Everytime I get this error "ora-01460: unimplemented or unreasonable conversion requested" whe I run the stored procedure. It appears that there is a 32K limit if I use a stored procedure. I read online that this does not apply if you are doing a direct insert, but I do not know how to create the insert string for a Byte Array. This is a thick client running on the server so not worried about SQL Injection attacks.

View 1 Replies

Migrate From C# To VB?

Mar 7, 2009

I am going to be taking up a new job as a VB.net developer. I have worked with C# for about 3years. I did mention to the interviewer that I haven't worked with VB.net, but he seemed to think that its easy to migrate from C# to Vb.net.

how I can prepare myself for this job? Any good books or websites on this area? How different is vb.net from C#?

View 3 Replies

Migrate From VB 6.0?

Feb 2, 2010

I am thinking of migrating to VB 2008 from VB 6.0. What are the things to expect from VB 2008. Is still the same?

Im still Looking for a trial version of VB 2008.

View 13 Replies

Migrate VB 6.0 COM+ To .Net?

Aug 22, 2011

I have been using COM+ components(using VB 6.0) in my existing web application developed using Asp/sql. I'm basically using COM+ to get the benefit of it's inbuilt Transaction Management feature which is useful when you are performing some set of actions across different databases simultaneously.Now I want to migrate my existing site to the .Net Framework.

View 1 Replies

Migrate VB To Net?

Jun 14, 2010

I having the project in Vb i want to migrate that project in the vb.net.

View 4 Replies

Vb 6 Migrate To .Net?

Dec 29, 2006

I Have installed Visual Studio 2005 ( 90-days trail), I want to use Visual Basic Upgrade wizard an error will appear on step 5 the error is :

vbu.exe has encountered a problem and needs to close

more detialed info is :

AppName: vbu.exe AppVer: 8.0.50727.1 ModName: msvcr80.dll
ModVer: 8.0.50727.163 Offset: 0001c1cd

how i can migrate my vb6 to vb.net

View 2 Replies

Migrate Backwards From ASP 4.0 To 3.5

May 25, 2011

I have a simple application that I have to migrate backwards from ASP VB.NET 4.0 to 3.5 because of client limitations.

View 2 Replies

Migrate C++ To C# / Program?

Oct 11, 2010

How to do the following in either C# and VB.net.

In C++, in my header file I do the following[code]...

I tried the same thing in C# but it got error. How could I do the same thing in C# and VB.Net?

View 4 Replies

How To Migrate From XslTransform To XslCompiledTransform

Mar 14, 2010

I have the following code that I need to migrate from VS 2003 (.Net 1.1) to VS 2008 (.Net 2+)but I get compilation error System.Xml.Xsl.Xsl Transform' is obsolete: This class has been deprecated.I probably need to use System.Xml.Xsl.XslCompiledTransform instead.but I do not find the matching Load() and Transform() overload versions that I can use with all the parameters of my original code.in MSDN [How to: Migrate Your XslTransform Code] I only found some simpler cases.url...but in my code I see some remarks that hints that the added parameters were used to avoid exceptions, so I prefer to use these parameters.[code]

View 1 Replies

Migrate A VB6 ActiveX Control To .net?

Jul 9, 2009

I have a legacy VB6 ActiveX control used in IE to provide control of a parallel-port device from a browser application. I wrote this thing about five years ago; It's a pretty simple control, and it doesn't require a lot of maintenance. However, I've noticed that running the VB6 tools is becoming more and more painful over time, so I'm looking at the possibility of migrating this code to VB.net 2008.This thing is super-simple. It implements IObjectSafety and exposes a single public method, which we call using Javascript. The control has no UI other than a single box with a caption that displays its name and version number-- useful for troubleshooting deployment issues.

How would I create the equivalent in .net? Am I creating an applet? Or a .net Assembly? Any gotchas to look for as I try to make this transition?(I should make it clear here that I'm not either a VB6 programmer or a .net developer-- I've dabbled in this stuff but it isn't my area of expertise, so go easy on me).

View 1 Replies

Migrate ASP.Net Website To Azure

Apr 21, 2011

I have an ASP.NET in VB code base that if I open in Visual Studio as an existing website works and tests just fine. I have followed many tutorials for porting this over to Azure: -Tried create new Azure project add a webrole and drag and drop project files into the new webrole, but I get about 300 reference/missing stuff/etc errors -I have also tried creating an azure project under the website solution but the option to add the website to the webrole by clicking "web role project in solution" is disabled/grayed out I have been able to make the configuration files and compile through the command line but this does not work with visual studio so I am unable to test before deploying into staging

View 1 Replies

VS 2010 - Advantages Of Migrate From VB 6 To .NET

Jan 10, 2012

I have some questions: 1) What's the learning curve for someone with good background in VB6? 2) what are the main advantages of VB.Net compared to VB6 and what will I be missing from VB6? 3) With VB.NET 2010 "ultimate" edition is it possible to make stand alone apps or they will be depending on net anyway even for the EXEs?

View 12 Replies

Error When Migrate From Vista To Windows 7

Jun 8, 2011

I get the following error when I run my vb2010 progrm on windows 7 machine:Class not registered (Exception from HRESULT: 0x80040154. It ran fine on vista. there is no option on the compile to target x86. It is related to an active x flex grid

View 2 Replies

Migrate Delphi 2007 Component To .NET?

Jul 12, 2010

I have generated a component in Delphi 2007 Code Gear and I need to migrate it to .NET to be used by VB.NET platform.I generated an ActiveX dll but I have been told that only the declaration of the class is visible in .NET.Actually the component I have generated is inherited by another component of which I have only the .dcu files. My new component is exactly similar as the parent one except from that I have overridden the constructor create.I wonder why the .NET, although it accepted the component, it did not provide the inherited properties, methods etc.

View 1 Replies

C# - Migrate .RESX File When Changing .NET Framework?

Mar 12, 2012

How to migrate .RESX file when changing .NET Framework... I was changing the .NET framework from 4.0 to 3.5 (because of an incompatbility we discovered in a third party dll) and everything went fine except some .RESX file got messed up. I was starting to fix them manually but is there some tool I can use for this?

View 2 Replies

Migrate A Source Code From BASIC To .NET 2010?

Oct 3, 2011

I am trying to migrate a source code from BASIC to VB.NET 2010

Dim obj(4096)
Dim strng As String

obj$ = string$ + ".obj" -> Error: Value of type 'String' cannot be converted to '1-dimensional array of Object'I can get away with this in VB6 but i can't in VB.NET.I can't convert obj using CStr either. ToString won't work because it work on the left side of an assignment.

View 3 Replies

Migrate Projects That Were Made In Visual Studio 2003?

Jun 2, 2011

I need to migrate projects that was made in visual studio 2003 but this projects includes several applications that acts as the base for different clients and every client has its own personalization of the product.visual studio 2008 use an architecture in order to turn everything into a single system with differents configurations?

View 1 Replies

Migrate CanPropertyChange ("Text") From VB6 To .NET?

Aug 16, 2011

I want to upgrade an ActiveX control from VB6 to VB.NET. I'm having trouble upgrading this code:

If CanPropertyChange("Text") Then
Text1.Text = Value
RaiseEvent TextChange()
End If

I get the error: "Name 'CanPropertyChange' is not declared."

View 2 Replies

Migrate From .net Specific Language To .net Framework Language?

Mar 11, 2010

What reasons are there to migrate from vb.net specific language to .net framework language?
Examples:

VB.net
ubound
msgBox
.Net Framework
array.getUpperBound(0)
messageBox

View 4 Replies

Migrate VB6 Data Report To Crystal Report Within VS.NET?

Feb 19, 2009

I am trying to convert a VB6 Data Report (.dsr file) to a Crystal Report through the migration process within Visual Studio. I have read articles that reference adding a Data Report to a Project from Visual Studio 2005/2008 and that it will convert the Data Report to a Crystal Report, but I have not been successful in doing so. Does the VB6 Data Environment need to be converted too? Has anyone been able to do this successfully and if so, how?

View 1 Replies

Using SQL Server As May Database And Developing That Database In Visual Studio 2008?

Apr 22, 2009

I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.

[Code]...

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved