Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > sql server > answers

Store DWG file in SQL server?

Newbie
  
Join Date: Mar 2008
Location: Australia
Posts: 23
#1: Aug 6 '08
Hi All, I would like to insert a CAD file in SQL server database. I am using VB with SQL server. If some one can help me out with the idea please , Many thx in advance.
ck9663's Avatar
Expert
  
Join Date: Jun 2007
Posts: 1,925
#2: Aug 6 '08

re: Store DWG file in SQL server?

Or you can just store the path of the file and access it

-- CK
Newbie
  
Join Date: Mar 2008
Location: Australia
Posts: 23
#3: Aug 6 '08

re: Store DWG file in SQL server?

Quote:

Originally Posted by ck9663

Or you can just store the path of the file and access it

-- CK


Ya it is possible , But requirement is to put CAD file in DB .......
debasisdas's Avatar
Moderator
  
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,508
#4: Aug 6 '08

re: Store DWG file in SQL server?

you need to convert the file to binary format and save in database .

please check this thread for reference.
Newbie
  
Join Date: Mar 2008
Location: Australia
Posts: 23
#5: Aug 7 '08

re: Store DWG file in SQL server?

Quote:

Originally Posted by debasisdas

you need to convert the file to binary format and save in database .

please check this thread for reference.

Hi Deb,

I checked this example but bit unclear, where i can get the image file? I mean location of file? which avriable contain image? Thx
ck9663's Avatar
Expert
  
Join Date: Jun 2007
Posts: 1,925
#6: Aug 7 '08

re: Store DWG file in SQL server?

It's not an actual image file. SQL Server will convert your file into a binary file and will store it. It will convert it back when you need it. Just follow the script that was posted on the thread.

-- CK
Newbie
  
Join Date: Mar 2008
Location: Australia
Posts: 23
#7: Aug 7 '08

re: Store DWG file in SQL server?

Quote:

Originally Posted by ck9663

It's not an actual image file. SQL Server will convert your file into a binary file and will store it. It will convert it back when you need it. Just follow the script that was posted on the thread.

-- CK


Yes thats right, CK. My question is the source file of image where I can define in this example?
Newbie
  
Join Date: Mar 2008
Location: Australia
Posts: 23
#8: Aug 8 '08

re: Store DWG file in SQL server?

Quote:

Originally Posted by debasisdas

you need to convert the file to binary format and save in database .

please check this thread for reference.


Hi Deb, I used the thread that you given for that probelm. The Error shows---- Run-time error '91' Object variable or With block variable not set , in SavePicture() line : Rs!logo.AppendChunk Chunk() ----------

If you have any sugession please?
Reply

« previous question | next question »

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,392 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved