Thanks for your response. Actually, we know that it is somehow SQL Server
related and not MDAC because once we uninstalled Server Manager and MSDE, the
connection worked fine again. As an aside, if they needed MDAC, we installed
2.6, but as I said, I don't believe this was the issue. Any other thoughts?
Thanks
[quoted text, click to view] "Jim Young" wrote:
> My guess is that the MSDE 7 installation is installing an older version of
> MDAC which is not ADO.Net compatible. It could also be an issue with named
> instances as earlier version of MDAC (pre 2.5 I think) did not support named
> instances.
>
> Jim
>
> "LisaConsult" <lisaconsult@online.nospam> wrote in message
> news:81EA76DC-A07B-4982-B9F2-CD31ACE1F0B0@microsoft.com...
> > We have a system which uses an ODBC connection to connect to SQL Server
> > 2000
> > for Ceridian Prism--an application for HR departments. Now we are
> > installing
> > a VB.Net application which uses MSDE (SQL 7). The problem is that for
> > some
> > reason we are losing the original ODBC connection to 2000 when we install
> > MSDE. Now I realize that installing MSDE 2000 may help this issue,
> > however
> > we really need to use SQL 7 for now. Does anyone have any ideas of what
> > might be causing the loss in the connection? Is the SQL 7 install
> > overwriting something that the ODBC needs for the 2000 connection? Is it
> > something with named instances? We are using the standard MSDE
> > installation
> > from Microsoft.
> > Thanks.
>
>
Oops, my mistake, this app is actually still a VB6 app.
[quoted text, click to view] "LisaConsult" wrote:
> We have a system which uses an ODBC connection to connect to SQL Server 2000
> for Ceridian Prism--an application for HR departments. Now we are installing
> a VB.Net application which uses MSDE (SQL 7). The problem is that for some
> reason we are losing the original ODBC connection to 2000 when we install
> MSDE. Now I realize that installing MSDE 2000 may help this issue, however
> we really need to use SQL 7 for now. Does anyone have any ideas of what
> might be causing the loss in the connection? Is the SQL 7 install
> overwriting something that the ODBC needs for the 2000 connection? Is it
> something with named instances? We are using the standard MSDE installation
> from Microsoft.
I still think that it is a problem with the data connection layer and not
SQL Server. Have you tried installing MDAC 2.8 after MSDE 7 is installed.
Jim
[quoted text, click to view] "LisaConsult" <lisaconsult@online.nospam> wrote in message
news:2271E92F-AFE5-4C14-A8FA-2A05326227B6@microsoft.com...
> Thanks for your response. Actually, we know that it is somehow SQL Server
> related and not MDAC because once we uninstalled Server Manager and MSDE,
> the
> connection worked fine again. As an aside, if they needed MDAC, we
> installed
> 2.6, but as I said, I don't believe this was the issue. Any other
> thoughts?
>
> Thanks
>
> "Jim Young" wrote:
>
>> My guess is that the MSDE 7 installation is installing an older version
>> of
>> MDAC which is not ADO.Net compatible. It could also be an issue with
>> named
>> instances as earlier version of MDAC (pre 2.5 I think) did not support
>> named
>> instances.
>>
>> Jim
>>
>> "LisaConsult" <lisaconsult@online.nospam> wrote in message
>> news:81EA76DC-A07B-4982-B9F2-CD31ACE1F0B0@microsoft.com...
>> > We have a system which uses an ODBC connection to connect to SQL Server
>> > 2000
>> > for Ceridian Prism--an application for HR departments. Now we are
>> > installing
>> > a VB.Net application which uses MSDE (SQL 7). The problem is that for
>> > some
>> > reason we are losing the original ODBC connection to 2000 when we
>> > install
>> > MSDE. Now I realize that installing MSDE 2000 may help this issue,
>> > however
>> > we really need to use SQL 7 for now. Does anyone have any ideas of
>> > what
>> > might be causing the loss in the connection? Is the SQL 7 install
>> > overwriting something that the ODBC needs for the 2000 connection? Is
>> > it
>> > something with named instances? We are using the standard MSDE
>> > installation
>> > from Microsoft.
>> > Thanks.
>>
>>
>>
Don't see what you're looking for? Try a search.
