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...
>> 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,

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?

>> As to ODBC Data Sources, well since ODBC is nearing end of life ...