I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardMS SQL Topic   Print This     

SQL and blob and long binary data

SQL and blob and long binary data in MS SQL topic (part of our DBA, Databases, & Data group).

Quick Search: SQL blob   SQL blob long   binary data  
KCRABBE
OTTAWA, ON, CANADA
We run a client database using MS SQL.

We can get access to some of the data via ACCESS but there are fields that are "blob" and "long binary data" that we cannot get direct access to via ACCESS.

The vendors will not help us claiming proprietary software issues.

Is there any "simple" way or any third-party products that will give us access to the contents of the blob and logn binary data files?

We are not extremely MS SQL literate but we'd be willing to try any suggestions.

Thanks, KC
 Posted 17 years ago (Thread Starter)
Comment Quote
About KCRABBE -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #10785, 1 replies
Thread Started 10/20/2004 8:56:00 AM
View Counter=3229
Last Reply Posted 10/21/2004 11:04:00 AM)
Location=OTTAWA, ON, CANADA  
Joined=21 years ago   MB Posts=32  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA
Hi Kathy,

I think you might be out of luck. If the vendor has put proprietary data in a binary field, then you'll have to rely on them to help you get the data out. By all means, you can use Access, or Paradox, or Delphi (for example) to read the data into a binary variable and then write it to disk and look at it to see if you can make sense of it.

Mike

--
Mike Prestwood
Prestwood IT Solutions

 Posted 17 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #10790 (Level 1.1)  Reply to 10785
Thread Started 10/21/2004 11:04:00 AM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=21 years ago   MB Posts=1410   KB Posts=1805   KB Comments=68   BLOG, Topics=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1111A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #10785 Counter
3229
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech