Store DWG file in SQL server?

[shaif]

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]

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

-- CK

[shaif]

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]

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

please check this thread for reference.

[shaif]

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]

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

[shaif]

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?

[shaif]

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.AppendC hunk Chunk() ----------

If you have any sugession please?