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

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

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