How To Insert 9 MB Audio File Into Blob Field

May 14, 2010

Trying to insert a large audio file into an Oracle 10g database and keep getting this error:
ORA-01460: unimplemented or unreasonable conversion requested
The byte array length of the audio file is 2702577. The procedure works with smaller array lengths, but not the larger ones.

Here is my code:
Dim oracleConnection As New OracleClient.OracleConnection
Dim Cmd As New OracleClient.OracleCommand
Dim oracleDataAdapter As New OracleDataAdapter
oracleConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings("MasterConnectionODT")
[Code] .....

View 1 Replies


ADVERTISEMENT

Zipping File Stored On SQL Server As Blob Image Field

Jul 14, 2010

I'm trying to zip a file that is stored on SQL Server as a blob image field and when downloading the zip file it says the file is corrupted.. or the file will open but contains some crazy characters. I've tried WinRAR and 7zip and no luck. I checked out [URL] and tried to kind of combine the browser attachment code and the memorystream/byte array code and no luck.

Here is my code snippet:
Try
BinData = DirectCast(dt.Rows(0)("ImageField"), Byte())
Catch ex As Exception
End Try
Dim blen As Integer = BinData.Length
[Code] .....

View 12 Replies

Odbc - Reading A Large File (>5MB) From A BLOB (container) Field From Filemaker?

May 4, 2011

I'm trying to read a binary file from a FileMaker 11 container field using Filemaker's own ODBC driver. I was able to write files to the database and this works fine. retrieving them manually works fine and the files look OK and are not corupted. However when retreiving them using VB.NET, and if the file size is approx > 5MB, I get the following "uncatchable" error (yes thats right, I cant "Try Catch End Try", it just crashes):

System.AccessViolationException was unhandled
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

[code].....

View 1 Replies

Can Itext Generate Pdf File And Insert Into Database As Blob

Jan 12, 2011

I just wondering can Itext done the following function before i dive into it.I want to develop a window application, and schedule this application in my server. This application should query the data from (oracle) and with itext help (i hope it help), generate pdf report. Then insert back to oracle as blob.

View 2 Replies

How To Declare A Blob Field

Sep 19, 2011

How can I declare a blob field in an access database with SQL?

View 1 Replies

Blob Field In Query String

Feb 25, 2010

I had been using this way for while, and it seems it work fine with char and numbers.
Dim MyVar1 as String = "Hello"
Dim MyVar2 as Integer = 1
Dim MySQL = "Select * from table where field1 = '<field1>' and Field2 = <field2>"
MySQL = MySQL.Replace("<field1>",MyVar1).Replace("<field2>",MyVar2)
msgbox(MySQL)

But, when I have to deal with blob field, where I store "wav file" for example, I had to read it as array of bytes, and the only way I find to insert the array of bytes in my query string is by using the command.AddParameter
Dim myfile As System.IO.FileStream = System.IO.File.OpenRead("full_wav_file_path")
Dim myArray(myfile.Length) As Byte
myfile.Read(myArray, 0, (myfile.Length))
[Code] .....
Is there another way to insert it without addParameter?

View 4 Replies

Get Value Of BLOB Field And Show / Hide A Label Based On It?

Nov 2, 2011

I'm calling some data from my Oracle table and I have a field which is called 'image1' which is a BLOB field.

Sometimes an image is input into the field and others it's not. I need a way to read the BLOB field to see if its a blank and then show/hide my label based on its contents.[code]...

View 1 Replies

VS2010-blob - Insert Several PDF Files Into Oracle

Nov 9, 2010

I would like to insert several PDF files into oracle. I have been looking for some examples but i didn't find it.

View 1 Replies

Audio Management System - Allow User To Add Audio Files Itself Into Database Together With Audio Information

Jan 28, 2010

I'm developing a standslone system for my school project. I'm developing an audio management system which allow user to add audio files itself into database together with the audio information such as artist name and album year. I just started it few days ago and face some problems.. my song in the playlist wont continue to play after 1 finished and i need some idea on how to store the audio files into database ... in blob types may be?

Heres the screenshot and codes

Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_add.Click

[CODE]............................

View 2 Replies

Insert DataBase Audio Into Sound?

Apr 20, 2010

This is a short program that I am trying to make work. I have a database that has 2 fields

1) Text

2) OLE Object - Audio.wav

I know that the My.Computer.Audio.Play Uses a Filepath, but I want to use the Audio.wav OLE Object inside my DataBase to make the sound. When I compile the program I get that Conversion from type 'Byte()' to type 'String' is not valid.

[Code]...

View 2 Replies

Does DB2 OS / 390 BLOB Support .docx File

May 13, 2010

ASP.net app inserts Microsoft Windows 2007 .docx file into a row on DB2 OS/390 Blob table. A different VB.net app gets the DB2 OS/390 Blob data. VB.net app kicks off Microsoft Word to open the .docx file but then Microsoft Word pops up a message that the data is corrupted. Word will allow you to fix the data so the file can be viewed but it is extra steps and users complain.I've seen some examples where .docx can be converted to .doc but they only talk about stripping out the text. Some of our .docx have pictures in them.

View 1 Replies

Write A Blob File To MySQL?

Mar 17, 2009

I am recieving an error when I am trying to write a blob file to MySQL. figure out what I am doing wrong. Here is my code:

[Code]...

View 14 Replies

InvalidCastException When Reading A BLOB Object (PDF File) From An SQL Database?

Nov 3, 2011

I'm having problems with an Invalid Cast Exception when I try and read a PDF from a database as a BLOB. I am able to write the files into the database no problems at all,however, when I try to retrieve them I just get InvalidCastException.Here is the code I'm using:

Protected Sub btnPDF_Click(sender As Object, e As EventArgs) Handles btnPDF.Click
' Request.QueryString["docid"].ToString();
Dim docuid As String = "b39a443d-ccfd-47f4-b333-f12cd94683d6"

[code].....

View 1 Replies

Retrieve MySQL Blob - Save The File To Disk

Aug 29, 2010

I have a mySQL table(IMP_SCANS) holding the file, it's name and size for every document:

scan_1 blob
description varchar
filesize int
doc_no varchar
doc_date date

I managed to insert a file to the table. Now I need to save the file to disk.

So I have the code:

Dim conn As New MySqlConnection
Dim cmd As New MySqlCommand
Dim myData As MySqlDataReader
Dim SQL As String
Dim FileSize As UInt32
Dim fs As FileStream

[CODE]............

I all works fine up to the line: myData.GetBytes(myData.GetOrdinal("scan_1"), 0, rawData, 0, filesize) Where it says "Object reference not set to an instance of an object". I cannot figure out why I receive this error.

View 5 Replies

Insert One Field From A Table Into Another?

Mar 17, 2012

Is it possible that i would only want to insert one field from a table into another table?

View 6 Replies

Any Way To Replace DetailView Field Before Insert?

Nov 15, 2011

Is there a way to edit an hidden field value of detailsview before inserting? I want to replace it with another value. Which event can I use?

View 2 Replies

IDE :: The INSERT INTO Statement Contains The Following Unknown Field Name?

Mar 30, 2009

Using MS Access 2007 GUI, I created an append Query, as I always have since version 2003, where I am trying to append records froma a temporary to a master table, all fields match, and keep getting the message:The INSERT INTO statement contains the following unknown field name: <field name>. Make sure you have typed the name correctly, and try the operation again.(Error 3127)

View 2 Replies

Insert Command For A Checkbox Field

Jul 22, 2009

Here is hte code I'm using to insert into my database:[code]I believe it is Cell 4 that is causing the exception, because it is a checkbox column and i'm not sure what syntax to use to store the "CheckedState" of it.Yes, I know I should be using parameters, but I don't know how yet, and I would like to make the INSERT statement work before implementing the paramater approach with it.

View 5 Replies

Insert Command With A Boolean Field?

Jul 21, 2009

If I need to set the value of a checkbox (threestate) inside of an INSERT command, what would the syntax be? I've tried 'True' but that fails and I can't think of another way to do it.

View 3 Replies

INSERT INTO Statement Contains Unknow Field Name

May 18, 2010

I am getting an error when trying to access an access database through oledb. The problem is it is saying "The INSERT INTO statement encountered an unknow field name Node Name". I though it might be because the column names contain spaces so I put brackets around them but same issue. I know I am typing it right.[code]

View 6 Replies

Insert Null Value In Date Field?

Nov 22, 2010

i have a maskedtextbox which will accept only date in the format of "DD-MM-yyyy" no i want to insert this date in my db. i have done this successfully.

Now i want to insert null value in through that maskedtextbox .

View 6 Replies

Insert Value In NChar Type Field In Sql Using?

Jan 13, 2011

I am inserting the nChar type value into sql db using the vb.net. Its simple insert query but i dont know why not inserting into db.

[Code]...

View 2 Replies

Audio Converter And Compressor - Audio & Video - Dream.In.Code

Mar 13, 2009

I just want to ask or I need some idea on how to convert wav files to mp3 and compressed the file to make the size smaller. I've search on the internet and find vorbis.dll as a reference object and lame.exe for converter. With regards to the audio compression, i downloaded monkey's audio software but doesnt have an idea on how to incorporate it.

View 2 Replies

VS 2008 Recording Audio - Capture The Audio Played On My Laptop

Jun 11, 2009

Im trying to capture the audio played on my laptop. so i have searched the internet and found a source code for doing exactly that. the problem i have is that my audio device is not listed in the dropdown box (see picture) but it does when its run on windows xp (im running windows 7 x64) the goal of this application would be to capture my friends radio stream and save the individual played mp3's to a loction on my hard drive.(yes i have permission) i have included the source code so perhaps some 1 could have a look at it. (source code)[URL]

View 2 Replies

Error INSERT INTO Statement Contain Unknown Field Name?

Apr 10, 2011

I keep getting the following error when I try to add new record into database (Access 2007)"The INSERT INTO statement contain unknown field name:'login'."I dont know whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the solution,

[Code]...

View 4 Replies

Insert A Datetime Field Into The SQL Server Database?

Aug 12, 2011

I am not sure if this should be in the SQL or vb.net section.But, Basically I have a vb.net application from where I insert a datetime field into the SQL Server Database. Now for some reason the SQL server field(which is datetime) will not display AM/PM, I have referred this link where my code looks like this:

Dim dateToDisplay As DateTime = DateTime.Now dsNewRow.Item("date_created") = dateToDisplay.ToString("MM.dd.yyyy hh:mm:ss tt")

I tried stepping into the code by debugging and it seems to be inserting the PM but is not displayed in the table QuotedateToDisplay#8/12/2011 6:01:06 PM#Date

View 4 Replies

Insert Attachment Field Of MS Access DB By ADO.Net Using Code?

Dec 3, 2010

i use Ms Access 2010 DB as Backend and Programing using VB.NET COdeNarmada

View 1 Replies

INSERT INTO Query Cannot Contain A Multi-valued Field

Mar 1, 2009

[code]"An INSERT INTO query cannot contain a multi-valued field." i got this exception while trying to save record in access file.

View 4 Replies

Insert Null Value From A Textbox At Numeric Field?

May 17, 2012

Why when I try to save a null value from textbox at sql server 0 is saved?

View 2 Replies

Pull A Field From A SQL Datatbase And Insert It Into A Textbox

Feb 26, 2012

How can I pull a field from a SQL datatbase and insert it into a texbox?
[Code]

View 2 Replies







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