application failure due to sql upgrade

Hi, could someone give me some general pointers on why an application would
fail after an sql upgrade from 6.5 -> 7 or 7 -> 2000.
What are some of the reasons/causes an application would not become
compatible with an upgrade of sql. Are there any references/resources on
this?
Thanks!
PeterPeter,
There is a large Backward Compatability section in the BOL. Online it can
be found at:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp
Also there is a section on New and Enhanced Features in Transact-SQL.
Online this is at:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp
Hope that these help.
Russell Fields
"Hz" <Hz@.nospam.com> wrote in message
news:flmAb.4463$xm.141272@.nasal.pacific.net.au...
> Hi, could someone give me some general pointers on why an application
would
> fail after an sql upgrade from 6.5 -> 7 or 7 -> 2000.
> What are some of the reasons/causes an application would not become
> compatible with an upgrade of sql. Are there any references/resources on
> this?
> Thanks!
> Peter
>|||Russell gave some good links, but in the end,
functionality, code calls, and syntax can change.
Plus, DB-Lib, which was (pre-7.0) the preferred method of
connecting to SQL Server, is no longer that way from 7.0
on, and newer features cannot be used with DB-Lib.
The application must be tested PRIOR to upgrading to fix
any problems in a test environment.
>--Original Message--
>Hi, could someone give me some general pointers on why an
application would
>fail after an sql upgrade from 6.5 -> 7 or 7 -> 2000.
>What are some of the reasons/causes an application would
not become
>compatible with an upgrade of sql. Are there any
references/resources on
>this?
>Thanks!
>Peter
>
>.
>|||Thanks for the pointers, they are much appreciated!
Peter
"Allan Hirt" <allanh@.NOSPAMavanade.com> wrote in message
news:e49301c3bc25$181fb990$a601280a@.phx.gbl...
> Russell gave some good links, but in the end,
> functionality, code calls, and syntax can change.
> Plus, DB-Lib, which was (pre-7.0) the preferred method of
> connecting to SQL Server, is no longer that way from 7.0
> on, and newer features cannot be used with DB-Lib.
> The application must be tested PRIOR to upgrading to fix
> any problems in a test environment.
> >--Original Message--
> >Hi, could someone give me some general pointers on why an
> application would
> >fail after an sql upgrade from 6.5 -> 7 or 7 -> 2000.
> >
> >What are some of the reasons/causes an application would
> not become
> >compatible with an upgrade of sql. Are there any
> references/resources on
> >this?
> >
> >Thanks!
> >Peter
> >
> >
> >.
> >