hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>