Sql server 2000 client libraries and SQL Server 2008

24 Jun 2009 7:53 AM

Russell

I am currently working on the upgrade of our Coda Financials system. the
current version is running on SQL Server 2000. However I am keen for the new
version to be on the latest version i.e. 2008.

However the vendor has said that as two of the modules require the Sql
Server 2000 client libraries we will have to use SQL 2005 rather than SQL
2008.

Is this correct?

Regards

Russell

24 Jun 2009 8:18 AM

Robert Lakinski

Hi Russell,

Can you be more specific ? What kind of data access provider is used by the
application ?
Maybe Sql Native Client is an option ?

Robert

Show quoteHide quote

"Russell" <Russ***@discussions.microsoft.com> wrote in message
news:7E612573-990A-4435-B769-2A0A21514057@microsoft.com...
>I am currently working on the upgrade of our Coda Financials system. the
> current version is running on SQL Server 2000. However I am keen for the
> new
> version to be on the latest version i.e. 2008.
>
> However the vendor has said that as two of the modules require the Sql
> Server 2000 client libraries we will have to use SQL 2005 rather than SQL
> 2008.
>
> Is this correct?
>
> Regards
>
> Russell

24 Jun 2009 8:37 AM

Russell

I am not sure on the actual type of connection the application makes it just
the vendor seems to think that sql 2000 librairies are not
supported/compatible with SQL 2008. If I look in the config app for the
application the two choices for the database driver are SQL Server 2000 or
ODBC. Looking at the current connections on the database server they are all
TCP/IP.

Show quoteHide quote

"Robert Lakinski" wrote:

> Hi Russell,
>
> Can you be more specific ? What kind of data access provider is used by the
> application ?
> Maybe Sql Native Client is an option ?
>
> Robert
>
>
>
> "Russell" <Russ***@discussions.microsoft.com> wrote in message
> news:7E612573-990A-4435-B769-2A0A21514057@microsoft.com...
> >I am currently working on the upgrade of our Coda Financials system. the
> > current version is running on SQL Server 2000. However I am keen for the
> > new
> > version to be on the latest version i.e. 2008.
> >
> > However the vendor has said that as two of the modules require the Sql
> > Server 2000 client libraries we will have to use SQL 2005 rather than SQL
> > 2008.
> >
> > Is this correct?
> >
> > Regards
> >
> > Russell
>
>

24 Jun 2009 9:08 AM

Robert Lakinski

Check this:

http://msdn.microsoft.com/en-us/library/ms131415.aspx

Robert

Show quoteHide quote

"Russell" <Russ***@discussions.microsoft.com> wrote in message
news:781760DB-3B21-4549-800B-BC9CE900E523@microsoft.com...
>I am not sure on the actual type of connection the application makes it
>just
> the vendor seems to think that sql 2000 librairies are not
> supported/compatible with SQL 2008. If I look in the config app for the
> application the two choices for the database driver are SQL Server 2000 or
> ODBC. Looking at the current connections on the database server they are
> all
> TCP/IP.
>
> "Robert Lakinski" wrote:
>
>> Hi Russell,
>>
>> Can you be more specific ? What kind of data access provider is used by
>> the
>> application ?
>> Maybe Sql Native Client is an option ?
>>
>> Robert
>>
>>
>>
>> "Russell" <Russ***@discussions.microsoft.com> wrote in message
>> news:7E612573-990A-4435-B769-2A0A21514057@microsoft.com...
>> >I am currently working on the upgrade of our Coda Financials system. the
>> > current version is running on SQL Server 2000. However I am keen for
>> > the
>> > new
>> > version to be on the latest version i.e. 2008.
>> >
>> > However the vendor has said that as two of the modules require the Sql
>> > Server 2000 client libraries we will have to use SQL 2005 rather than
>> > SQL
>> > 2008.
>> >
>> > Is this correct?
>> >
>> > Regards
>> >
>> > Russell
>>
>>

24 Jun 2009 9:54 AM

Russell

If this was an app that had been developed in house then we could probably
move over to this. Unfortunatly as far as Coda is concerned even the
configuration of the connections has its own control panel applet.

Has anyone actually seen any web pages or the like that actually mentions
that these libraries are not supported by 2008?

Show quoteHide quote

"Robert Lakinski" wrote:

>
> Check this:
>
> http://msdn.microsoft.com/en-us/library/ms131415.aspx
>
> Robert
>
> "Russell" <Russ***@discussions.microsoft.com> wrote in message
> news:781760DB-3B21-4549-800B-BC9CE900E523@microsoft.com...
> >I am not sure on the actual type of connection the application makes it
> >just
> > the vendor seems to think that sql 2000 librairies are not
> > supported/compatible with SQL 2008. If I look in the config app for the
> > application the two choices for the database driver are SQL Server 2000 or
> > ODBC. Looking at the current connections on the database server they are
> > all
> > TCP/IP.
> >
> > "Robert Lakinski" wrote:
> >
> >> Hi Russell,
> >>
> >> Can you be more specific ? What kind of data access provider is used by
> >> the
> >> application ?
> >> Maybe Sql Native Client is an option ?
> >>
> >> Robert
> >>
> >>
> >>
> >> "Russell" <Russ***@discussions.microsoft.com> wrote in message
> >> news:7E612573-990A-4435-B769-2A0A21514057@microsoft.com...
> >> >I am currently working on the upgrade of our Coda Financials system. the
> >> > current version is running on SQL Server 2000. However I am keen for
> >> > the
> >> > new
> >> > version to be on the latest version i.e. 2008.
> >> >
> >> > However the vendor has said that as two of the modules require the Sql
> >> > Server 2000 client libraries we will have to use SQL 2005 rather than
> >> > SQL
> >> > 2008.
> >> >
> >> > Is this correct?
> >> >
> >> > Regards
> >> >
> >> > Russell
> >>
> >>
>
>

24 Jun 2009 12:12 PM

Scott Morris

"Russell" <Russ***@discussions.microsoft.com> wrote in message
news:4933B050-6827-4E56-B6E2-F22DF03BD38F@microsoft.com...
> If this was an app that had been developed in house then we could probably
> move over to this. Unfortunatly as far as Coda is concerned even the
> configuration of the connections has its own control panel applet.
>
> Has anyone actually seen any web pages or the like that actually mentions
> that these libraries are not supported by 2008?
>

Unless you can be more specific about "libraries" I doubt anyone can offer
any definitive help. My guess is that this app still uses dblib - which is
still supported in 2008 but requires the use of the client libraries (i.e.,
dlls) from 2000 since MS has helpfully stopped shipping them (but not
supporting them). This interface is deprecated and has been deprecated
since 2000 - though MS appears not to be in any real hurry to remove support
(what's that all about?).

That said, it is your vendor that generally chooses which versions of
dependent software they support. Choosing to use their system in an
unsupported manner is a risk you should evaluate carefully.