mdac and odbc

Hi,
I have installed a mdac 2.6 on my client's Windows XP PC, but the ODBC seems
to be the same.
What do I need to do so the ODBC will be changed to the ODBC comes up with
the MDAC?
Thanks for help.
Jason
Yes...MDAC 2.6 wouldn't have done anything if you are on XP
SP2.
I'm not real clear on what you are trying to accomplish or
what in particular you want changed. If you need to verify
the installation of MDAC and what versions of what pieces
are on there, you can use the component checker. I'm
guessing that's probably what you need to do first anyway.
You can download the component checker from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Thu, 12 Oct 2006 15:05:15 +0800, "Jason Huang"
<JasonHuang8888@.hotmail.com> wrote:

>Hi,
>I have installed a mdac 2.6 on my client's Windows XP PC, but the ODBC seems
>to be the same.
>What do I need to do so the ODBC will be changed to the ODBC comes up with
>the MDAC?
>Thanks for help.
>
>Jason
>
sql

mdac and odbc

Hi,
I have installed a mdac 2.6 on my client's Windows XP PC, but the ODBC seems
to be the same.
What do I need to do so the ODBC will be changed to the ODBC comes up with
the MDAC?
Thanks for help.
JasonYes...MDAC 2.6 wouldn't have done anything if you are on XP
SP2.
I'm not real clear on what you are trying to accomplish or
what in particular you want changed. If you need to verify
the installation of MDAC and what versions of what pieces
are on there, you can use the component checker. I'm
guessing that's probably what you need to do first anyway.
You can download the component checker from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Thu, 12 Oct 2006 15:05:15 +0800, "Jason Huang"
<JasonHuang8888@.hotmail.com> wrote:

>Hi,
>I have installed a mdac 2.6 on my client's Windows XP PC, but the ODBC seem
s
>to be the same.
>What do I need to do so the ODBC will be changed to the ODBC comes up with
>the MDAC?
>Thanks for help.
>
>Jason
>

Maximum Databases in ODBC

What is the maximum number of Databases you can have connections to using
ODBC connection to SQL? I am talking hear about the entries in ODBC Data
Sources as System DSN's.
Anyone got any ideas? Assume Windows XP SP2 workstation and Windows 20003
server with MS SQL 2000 SP4.
In fact is there any limit to the number of MSSQL databases you can have on
one server. I know its a bit like how longs a piece of string, but lets
assume as an average that each database is about 20Mb in size and has about
100 tables.
Hi
Maximum number of databases per SQL Server instance: 32'767.
As to ODBC Data Sources, well since ODBC is nearing end of life I don't
think anyone is interested anymore. I could imagine that one of the 16 bit
number limits could be hit (256, 1024 or 32'737).
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rowland Costin" <technical@.selven.co.uk> wrote in message
news:%23TMk65EwFHA.1148@.TK2MSFTNGP11.phx.gbl...
> What is the maximum number of Databases you can have connections to using
> ODBC connection to SQL? I am talking hear about the entries in ODBC Data
> Sources as System DSN's.
> Anyone got any ideas? Assume Windows XP SP2 workstation and Windows 20003
> server with MS SQL 2000 SP4.
> In fact is there any limit to the number of MSSQL databases you can have
> on one server. I know its a bit like how longs a piece of string, but lets
> assume as an average that each database is about 20Mb in size and has
> about 100 tables.
>
|||What is replacing ODBC?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OSaSXGIwFHA.3548@.tk2msftngp13.phx.gbl...
> Hi
> Maximum number of databases per SQL Server instance: 32'767.
> As to ODBC Data Sources, well since ODBC is nearing end of life I don't
> think anyone is interested anymore. I could imagine that one of the 16 bit
> number limits could be hit (256, 1024 or 32'737).
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rowland Costin" <technical@.selven.co.uk> wrote in message
> news:%23TMk65EwFHA.1148@.TK2MSFTNGP11.phx.gbl...
>
|||Hi,
OLE DB. It's not really a "replacement" for ODBC but a newer technology.
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:OebocSIwFHA.3720@.TK2MSFTNGP14.phx.gbl...
> What is replacing ODBC?
[vbcol=seagreen]

Maximum Databases in ODBC

What is the maximum number of Databases you can have connections to using
ODBC connection to SQL? I am talking hear about the entries in ODBC Data
Sources as System DSN's.
Anyone got any ideas? Assume Windows XP SP2 workstation and Windows 20003
server with MS SQL 2000 SP4.
In fact is there any limit to the number of MSSQL databases you can have on
one server. I know its a bit like how longs a piece of string, but lets
assume as an average that each database is about 20Mb in size and has about
100 tables.Hi
Maximum number of databases per SQL Server instance: 32'767.
As to ODBC Data Sources, well since ODBC is nearing end of life I don't
think anyone is interested anymore. I could imagine that one of the 16 bit
number limits could be hit (256, 1024 or 32'737).
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rowland Costin" <technical@.selven.co.uk> wrote in message
news:%23TMk65EwFHA.1148@.TK2MSFTNGP11.phx.gbl...
> What is the maximum number of Databases you can have connections to using
> ODBC connection to SQL? I am talking hear about the entries in ODBC Data
> Sources as System DSN's.
> Anyone got any ideas? Assume Windows XP SP2 workstation and Windows 20003
> server with MS SQL 2000 SP4.
> In fact is there any limit to the number of MSSQL databases you can have
> on one server. I know its a bit like how longs a piece of string, but lets
> assume as an average that each database is about 20Mb in size and has
> about 100 tables.
>|||What is replacing ODBC?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OSaSXGIwFHA.3548@.tk2msftngp13.phx.gbl...
> Hi
> Maximum number of databases per SQL Server instance: 32'767.
> As to ODBC Data Sources, well since ODBC is nearing end of life I don't
> think anyone is interested anymore. I could imagine that one of the 16 bit
> number limits could be hit (256, 1024 or 32'737).
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rowland Costin" <technical@.selven.co.uk> wrote in message
> news:%23TMk65EwFHA.1148@.TK2MSFTNGP11.phx.gbl...
>|||Hi,
OLE DB. It's not really a "replacement" for ODBC but a newer technology.
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:OebocSIwFHA.3720@.TK2MSFTNGP14.phx.gbl...
> What is replacing ODBC?
[vbcol=seagreen]