base64 decode then insert into SQL Server - ASP / Active Server Pages

robert.bull

Hello -
I am currently working on a project in classic ASP where I receive an
XML file that contains an encoded base64 string that I need to do the
following to:

1. Decode the base64 string for a binary write
2. Insert the decoded string into SQL Server for later binary writes

I have searched the web but I cannot find anything that works. There
are many decode functions available but I cannot insert the results
into SQL server.

Thanks in advance for any help.

-Rob

Mar 13 '06 #1

Subscribe Post Reply

8566

robert.bull

I forgot to mention that the encoded string is a GIF image

Mar 13 '06 #2

Egbert Nierop $MVP for IIS$

<ro*********@charter.net> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

I forgot to mention that the encoded string is a GIF image

there is no easy way to decode using script. If there is such code, it would
be -very- very slow.

If you want, I can compile a COM component for you, that can do it for you.
The input would be a base64 string, the output a byte array.

Mar 14 '06 #3

robert.bull

Egbert - That would be great...thanks for the help.

Mar 14 '06 #4

Egbert Nierop $MVP for IIS$

<ro*********@charter.net> wrote in message
news:11**********************@j52g2000cwj.googlegr oups.com...

Egbert - That would be great...thanks for the help.

here it is
http://www.nieropwebconsult.nl/download/setup1.msi

syntax

set obj = CreateObject("NWC.Decode")
obj.Read([base64stringhere]]

obj.WRite() ' returns byte array!

Mar 15 '06 #5

Egbert Nierop $MVP for IIS$

"Egbert Nierop (MVP for IIS)" <eg***********@nospam.invalid> wrote in
message news:Ob**************@TK2MSFTNGP10.phx.gbl...

<ro*********@charter.net> wrote in message
news:11**********************@j52g2000cwj.googlegr oups.com...
Egbert - That would be great...thanks for the help.

here it is
http://www.nieropwebconsult.nl/download/setup1.msi

syntax

set obj = CreateObject("NWC.Decode")
obj.Read([base64stringhere]]

obj.WRite() ' returns byte array!

ps: I found that this programmer has full tools...
http://www.motobit.com/help/asp-upload/cm435.htm

Mar 15 '06 #6

Similar topics

Base64-Encoded URL in ASP

by: Michael | last post by:

I am trying to integrate my ASP page with an external application that sends me a QueryString that is URLEncoded and each Name and Value in the QueryString is Base64 Encoded as well. ...

ASP / Active Server Pages

Decoding Base64 and Saving to a file - HELP!

by: plank | last post by:

Hey Peeps, Ok here is my situation.. I have a Java applet which allows the user to select files and upload them to the server. The applet converts the file to Base64 and then POSTS the data to an...

ASP / Active Server Pages

Decoding base64 data and extracting images

by: gRizwan | last post by:

Hello all, We have a problem on a webpage. That page is sent some email data in base64 format. what we need to do is, decode the base64 data back to original shape and extract attached image...

ASP / Active Server Pages

Base64

by: John | last post by:

Hi all, I've been going through google and yahoo looking for a certain base64 decoder in C without success. What I'm after is something that you can pass a base64 encoded string into and get back...

C / C++

decode base64 string

by: Guoqi Zheng | last post by:

Dear sir, I need to decode base64 encoded email. I used below function but it does not work correctly, especially when I need to decode some Characters like Chinese, Can some one point out...

Visual Basic .NET

base64

by: Jay | last post by:

I have bean trying to get my head around reading .GIF files from base64 strings, Basically I need to specify a filename and convert it to base64 then I can copy/past the string to wear I want it....

Python

Decoding Base64

by: BB | last post by:

Hello. i am trying to decode a block of (what i think is) base64 into text, and i have NO idea how to begin. I'm going to paste the whole string here, but i want to know the steps necessary to...

C / C++

BASE64 Encoding and don't want to use session variables

by: MrHelpMe | last post by:

Hello again all, I've finished my whole application and now I don't like the whole session variables that I am using. I have a form, user fills in info clicks submit and using CDOSYSMail an...

ASP / Active Server Pages

sample for base64 encoding in c language

by: aruna.eies.eng | last post by:

i am currently trying to convert data into binary data.for that i need to know how to achieve it in c language and what are the libraries that we can use. so if any one can send me a sample code or...

C / C++

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing