How to set a photo path when creating table

Hi all,
I am doing a project which need to use Microsoft SQL Server 2000 as my
database. Now, I am creating a table, that I need to put in a photo.
So, I am facing a problem of setting the photo path. Can u all give me
some help on it. Thks.
Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
Interface. So, I need to do the database linking between my database in
SQL Server to VB. Can I have the sample code which can do the linking
part. Thks.Whats photo path?
If you are trying to save an image, use image datatype. or keep it in a
particular folder in server and update the location in database.
Use connection string,
"Driver={SQL Server};Server=ServerName;Database=pubs;Uid=sa;Pwd=asdasd;"
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"jyetying" wrote:
> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>|||Have a look at this.
http://support.microsoft.com/kb/194975/en-us
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jyetying" <yam_jyet_ying@.hotmail.com> wrote in message
news:1158310229.209741.157910@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am doing a project which need to use Microsoft SQL Server 2000 as my
> database. Now, I am creating a table, that I need to put in a photo.
> So, I am facing a problem of setting the photo path. Can u all give me
> some help on it. Thks.
> Besides that, I am using Visual Basic 6.0 to do my GUI, Graphic User
> Interface. So, I need to do the database linking between my database in
> SQL Server to VB. Can I have the sample code which can do the linking
> part. Thks.
>