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.
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.
|||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...
>
>
|||Oops, my mistake, this app is actually still a VB6 app.
"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.
> Thanks.
|||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
"LisaConsult" <lisaconsult@.online.nospam> wrote in message
news:2271E92F-AFE5-4C14-A8FA-2A05326227B6@.microsoft.com...[vbcol=seagreen]
> 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:
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Friday, March 30, 2012
Friday, March 23, 2012
Loopback adapter
I am running Windows XP and have SQL Server 2005 Enterprise Edition that I use for testing on my notebook. I want to install Oralce 11g on it as well and use VS 2005 as a front end programming. For me to install Oracle I need to install a loopback adapter. If I do this will it mess up SQL Server 2005 or will it not affect SQL Server 2005? Please advise
Hi,
Do you mean you want to install Microsoft Loopback Adapter on your Windows XP machine?
The Microsoft Loopback adapter is a testing tool for a virtual network environment where network access is not available. It will not affect the Microsoft SQLServer2005.
For more information on installation, see:
http://support.microsoft.com/kb/839013/en-us
Thanks.
Wednesday, March 7, 2012
Looking for step by step guide/white paper to install MS SQL Clust
Hello,
I need to install a MS SQL 2000 Cluster server which will include 2 nodes
(setup as standard).
Where can I find a step by step documentation about that and
hardware/software requirements?
Thanks,
Don DiegoHi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
John
"dondiego" wrote:
> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don Diego|||Thanks John - I'll have a look at the links.
"John Bell" wrote:
> Hi
> There is quite alot of information in books online:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> Not a step by step guide but check out the following and links in Appendix B
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
> John
> "dondiego" wrote:
> > Hello,
> >
> > I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> > (setup as standard).
> > Where can I find a step by step documentation about that and
> > hardware/software requirements?
> > Thanks,
> > Don Diego|||Hi
You may also want to look at
http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp
John
"dondiego" wrote:
> Thanks John - I'll have a look at the links.
> "John Bell" wrote:
> > Hi
> >
> > There is quite alot of information in books online:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> >
> > Not a step by step guide but check out the following and links in Appendix B
> > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
> >
> > John
> >
> > "dondiego" wrote:
> >
> > > Hello,
> > >
> > > I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> > > (setup as standard).
> > > Where can I find a step by step documentation about that and
> > > hardware/software requirements?
> > > Thanks,
> > > Don Diego|||Hi
Other things to look at!
http://support.microsoft.com/default.aspx?scid=kb;en-us;259267&sd=tech
John
"John Bell" wrote:
> Hi
> You may also want to look at
> http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp
> John
> "dondiego" wrote:
> > Thanks John - I'll have a look at the links.
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > There is quite alot of information in books online:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> > >
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> > >
> > > Not a step by step guide but check out the following and links in Appendix B
> > > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
> > >
> > > John
> > >
> > > "dondiego" wrote:
> > >
> > > > Hello,
> > > >
> > > > I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> > > > (setup as standard).
> > > > Where can I find a step by step documentation about that and
> > > > hardware/software requirements?
> > > > Thanks,
> > > > Don Diego
I need to install a MS SQL 2000 Cluster server which will include 2 nodes
(setup as standard).
Where can I find a step by step documentation about that and
hardware/software requirements?
Thanks,
Don DiegoHi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
John
"dondiego" wrote:
> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don Diego|||Thanks John - I'll have a look at the links.
"John Bell" wrote:
> Hi
> There is quite alot of information in books online:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> Not a step by step guide but check out the following and links in Appendix B
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
> John
> "dondiego" wrote:
> > Hello,
> >
> > I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> > (setup as standard).
> > Where can I find a step by step documentation about that and
> > hardware/software requirements?
> > Thanks,
> > Don Diego|||Hi
You may also want to look at
http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp
John
"dondiego" wrote:
> Thanks John - I'll have a look at the links.
> "John Bell" wrote:
> > Hi
> >
> > There is quite alot of information in books online:
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> >
> > Not a step by step guide but check out the following and links in Appendix B
> > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
> >
> > John
> >
> > "dondiego" wrote:
> >
> > > Hello,
> > >
> > > I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> > > (setup as standard).
> > > Where can I find a step by step documentation about that and
> > > hardware/software requirements?
> > > Thanks,
> > > Don Diego|||Hi
Other things to look at!
http://support.microsoft.com/default.aspx?scid=kb;en-us;259267&sd=tech
John
"John Bell" wrote:
> Hi
> You may also want to look at
> http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp
> John
> "dondiego" wrote:
> > Thanks John - I'll have a look at the links.
> >
> > "John Bell" wrote:
> >
> > > Hi
> > >
> > > There is quite alot of information in books online:
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> > >
> > > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
> > >
> > > Not a step by step guide but check out the following and links in Appendix B
> > > http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/32bitconsolidation.mspx
> > >
> > > John
> > >
> > > "dondiego" wrote:
> > >
> > > > Hello,
> > > >
> > > > I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> > > > (setup as standard).
> > > > Where can I find a step by step documentation about that and
> > > > hardware/software requirements?
> > > > Thanks,
> > > > Don Diego
Looking for step by step guide/white paper to install MS SQL Clust
Hi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/d...
ering_2icn.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/pr...on.ms
px
John
"dondiego" wrote:
> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don DiegoHello,
I need to install a MS SQL 2000 Cluster server which will include 2 nodes
(setup as standard).
Where can I find a step by step documentation about that and
hardware/software requirements?
Thanks,
Don Diego|||Hi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/d...
ering_2icn.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/pr...on.ms
px
John
"dondiego" wrote:
> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don Diego
There is quite alot of information in books online:
http://msdn.microsoft.com/library/d...
ering_2icn.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/pr...on.ms
px
John
"dondiego" wrote:
> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don DiegoHello,
I need to install a MS SQL 2000 Cluster server which will include 2 nodes
(setup as standard).
Where can I find a step by step documentation about that and
hardware/software requirements?
Thanks,
Don Diego|||Hi
There is quite alot of information in books online:
http://msdn.microsoft.com/library/d...
ering_2icn.asp
http://msdn.microsoft.com/library/d...
ering_2icn.asp
Not a step by step guide but check out the following and links in Appendix B
http://www.microsoft.com/technet/pr...on.ms
px
John
"dondiego" wrote:
> Hello,
> I need to install a MS SQL 2000 Cluster server which will include 2 nodes
> (setup as standard).
> Where can I find a step by step documentation about that and
> hardware/software requirements?
> Thanks,
> Don Diego
Subscribe to:
Comments (Atom)