Showing posts with label books. Show all posts
Showing posts with label books. Show all posts

Wednesday, March 28, 2012

Images in SQL

Look up the usage and example of statements UPDATETEXT and WRITETEXT in SQL
Server Books Online.
AnithI looked those up and they just give examples of writing text to the fields.
I would like to know how to add a picture to the field.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:OoEv9%23glGHA.4444@.TK2MSFTNGP02.phx.gbl...
> Look up the usage and example of statements UPDATETEXT and WRITETEXT in
> SQL Server Books Online.
> --
> Anith
>|||Image and nText fields are binary fields, like the old BLOB (binary large
object) fields.
To write an image into thsee fields you need to serialize the data into eith
er a
stream or use ADO or ADO.Net
A better question back to you is how and when do you want to get the picture
s
into the database?
Alternatively, you may wish to simply store the images somewhere and use a p
ath
to the raw image files, there are benefits and costs for both methods, in th
e
database or a pointer to a file.
HTH
JeffP...
<Preacher Man> wrote in message news:udRf$ChlGHA.4772@.TK2MSFTNGP04.phx.gbl...">
> I looked those up and they just give examples of writing text to the field
s.
> I would like to know how to add a picture to the field.
>
> "Anith Sen" <anith@.bizdatasolutions.com> wrote in message
> news:OoEv9%23glGHA.4444@.TK2MSFTNGP02.phx.gbl...
>|||I am trying to write a simple application for printing employee badges. I
have VFP 9.0 that I will be using as the application writer.
Any ideas on how I should enter these images into the database? I can use a
VFP table or SQL is doesn't really matter to me in this case.
A path to the filename would be fine for me to use also, but how would I
implement that into a form?
Thanks for any info.
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:%23cB$WUhlGHA.4792@.TK2MSFTNGP02.phx.gbl...
> Image and nText fields are binary fields, like the old BLOB (binary large
> object) fields.
> To write an image into thsee fields you need to serialize the data into
> either a
> stream or use ADO or ADO.Net
> A better question back to you is how and when do you want to get the
> pictures
> into the database?
> Alternatively, you may wish to simply store the images somewhere and use a
> path
> to the raw image files, there are benefits and costs for both methods, in
> the
> database or a pointer to a file.
> HTH
> JeffP...
>
> <Preacher Man> wrote in message
> news:udRf$ChlGHA.4772@.TK2MSFTNGP04.phx.gbl...
>|||Sorry, I'm out of the loop on VFP since 3.2... but google this...
image data into SQL
HTH
JeffP...
<Preacher Man> wrote in message news:%23pQTiXhlGHA.3740@.TK2MSFTNGP02.phx.gbl...en">
> I am trying to write a simple application for printing employee badges. I
> have VFP 9.0 that I will be using as the application writer.
> Any ideas on how I should enter these images into the database? I can use
a
> VFP table or SQL is doesn't really matter to me in this case.
> A path to the filename would be fine for me to use also, but how would I
> implement that into a form?
> Thanks for any info.
> "JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
> news:%23cB$WUhlGHA.4792@.TK2MSFTNGP02.phx.gbl...
>|||I notice that SQL 2000 has a datatype of image.
My question is after I setup the table and fields how do I populate the
table with image data?|||Look up the usage and example of statements UPDATETEXT and WRITETEXT in SQL
Server Books Online.
Anith|||I looked those up and they just give examples of writing text to the fields.
I would like to know how to add a picture to the field.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:OoEv9%23glGHA.4444@.TK2MSFTNGP02.phx.gbl...
> Look up the usage and example of statements UPDATETEXT and WRITETEXT in
> SQL Server Books Online.
> --
> Anith
>|||Image and nText fields are binary fields, like the old BLOB (binary large
object) fields.
To write an image into thsee fields you need to serialize the data into eith
er a
stream or use ADO or ADO.Net
A better question back to you is how and when do you want to get the picture
s
into the database?
Alternatively, you may wish to simply store the images somewhere and use a p
ath
to the raw image files, there are benefits and costs for both methods, in th
e
database or a pointer to a file.
HTH
JeffP...
<Preacher Man> wrote in message news:udRf$ChlGHA.4772@.TK2MSFTNGP04.phx.gbl...">
> I looked those up and they just give examples of writing text to the field
s.
> I would like to know how to add a picture to the field.
>
> "Anith Sen" <anith@.bizdatasolutions.com> wrote in message
> news:OoEv9%23glGHA.4444@.TK2MSFTNGP02.phx.gbl...
>|||I am trying to write a simple application for printing employee badges. I
have VFP 9.0 that I will be using as the application writer.
Any ideas on how I should enter these images into the database? I can use a
VFP table or SQL is doesn't really matter to me in this case.
A path to the filename would be fine for me to use also, but how would I
implement that into a form?
Thanks for any info.
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:%23cB$WUhlGHA.4792@.TK2MSFTNGP02.phx.gbl...
> Image and nText fields are binary fields, like the old BLOB (binary large
> object) fields.
> To write an image into thsee fields you need to serialize the data into
> either a
> stream or use ADO or ADO.Net
> A better question back to you is how and when do you want to get the
> pictures
> into the database?
> Alternatively, you may wish to simply store the images somewhere and use a
> path
> to the raw image files, there are benefits and costs for both methods, in
> the
> database or a pointer to a file.
> HTH
> JeffP...
>
> <Preacher Man> wrote in message
> news:udRf$ChlGHA.4772@.TK2MSFTNGP04.phx.gbl...
>

Friday, March 9, 2012

IIS for SQL Server - problem

I configured IIS Virtual Directory Management for SQL Server Utility as
is described in Books Online, but I receive 404 error.
I gave everywhere everyone full access where I can…. But I don’t know
where to look for an error…
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?
Hello,
Please let me know the SQL server version you use. For example, SQL server
2000 Standard Edition with SP3. I suggest that you perform the following
steps to narrow down the issue:
1. Make sure your IIS server works fine.
2. Create the virtual directory <nwind>. For more information about how to
configure a virtual directory by using the IIS Virtual Directory Management
SQL Server utility, visit the following MSDN Web site:
http://msdn.microsoft.com/library/en..._xml1_2xvd.asp
3. Open Microsoft Internet Explorer and locate:
http://IISServer/nwind?sql=SELECT+*+...TO&roo t=root
If you receive the error message "HTTP error 404 - File or directory not
found", please perform the steps in the following article 810784:
810784 Error message "HTTP error 404 - File or directory not found" occurs
when
http://support.microsoft.com/?id=810784
Check the issue again. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

IIS for SQL Server - problem

I configured IIS Virtual Directory Management for SQL Server Utility as
is described in Books Online, but I receive 404 error.
I gave everywhere everyone full access where I can…. But I don’t know
where to look for an error…
IIS seems to work properly because other WWW are working OK.
My SQL Server is from Small Business Server, maybe it shouldn’t work
under SBS?Hello,
Please let me know the SQL server version you use. For example, SQL server
2000 Standard Edition with SP3. I suggest that you perform the following
steps to narrow down the issue:
1. Make sure your IIS server works fine.
2. Create the virtual directory <nwind>. For more information about how to
configure a virtual directory by using the IIS Virtual Directory Management
SQL Server utility, visit the following MSDN Web site:
http://msdn.microsoft.com/library/e...c_xml1_2xvd.asp
3. Open Microsoft Internet Explorer and locate:
http://IISServer/nwind? sql=SELECT+...r />
&root=root
If you receive the error message "HTTP error 404 - File or directory not
found", please perform the steps in the following article 810784:
810784 Error message "HTTP error 404 - File or directory not found" occurs
when
http://support.microsoft.com/?id=810784
Check the issue again. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.