Hi All,
Thanks for all your responses.
It was found that the installation was a Standard Edition. I found from the
Microsoft web that there is limitation on concurrent access for development
license. However, the problem here is getting mysterious then.
Does anyone has similar experiences? The error message complaints about
ODBC. Does the error came from my the ODBC driver on my local workstation
instead of the SQL server? Would you please kindly advise? Thank you very
much.
Regards,
Devin
-----Original Message-----
From: John Thomas [mailto:[Email Address Removed] Friday, December 19, 2003 3:40 AM
To: LazyDBA.com Discussion
Subject: RE: Is MSDN installation any different from purchased CD?
Pmfji, SQL Server Developer Edition is not restricted to 5 connections.
It is a full feature version with licensing restrictions.
HTH,
John
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed]
Sent: Thursday, December 18, 2003 6:05 AM
To: LazyDBA.com Discussion
Subject: RE: Is MSDN installation any different from purchased CD?
Only the SQL Server Developer Edition is limited to 5 connections. MSDN
Universal also has the Standard and Enterprise Editions, which are not
limited to 5 connections (even if installed from MSDN media).
Check the @@VERSION for the server and see what edition it is -- it
sounds like the developer edition to me.
-----Original Message-----
From: Lepingwell, Christopher [mailto:Christopher.[Email Address Removed]
Sent: Thursday, December 18, 2003 5:03 AM
To: LazyDBA.com Discussion
Subject: RE: Is MSDN installation any different from purchased CD?
MSDN installs of servers are all development versions, and limited to (I
think) five concurrent connections.
-----Original Message-----
From: Devin Wong [mailto:devin.[Email Address Removed]
Sent: Thursday, December 18, 2003 11:00 AM
To: LazyDBA.com Discussion
Subject: Is MSDN installation any different from purchased CD?
Dear all,
I have a silly question. I was trying to run scripts with several
concurrent sessions. When I ran the scripts with more than 4 concurrent
users that access the same tables, I started to get error like the
following
SQL Error State 23000, Native Error Code: A29, ODBC Error .....
I was using WinSQL to run the scripts. Would tool be the reason of the
error? My server was installed from MSDN CD. Would it be the problem?
Would you please kindly advise? Thank you very much.
Regards,
Devin
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's
cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page