Hi. I'm a bit confused and wonder whether someone of you can give me some
more information on this.
The EULA for MSDE 2000A states that you cannot use MSDE for hosting
services. Does anyone know what this mean?
I'm running an ASP.Net application and would like to use MSDE as the backend
database. Does this fall into this category?
Or does it mean that if I'm an ISP, I'm not allowed to offer MSDE as a
feature on my hosting packages?
Also, it says that you're not allowed to install any applications on SBS
2003 Web Edition. Does MSDE fall into this category?
Thanks very much for your help!
Martin
Hi Martin,
If you plan on using Webserver I think you need the full version of SQL. As
for SBS webserver 2003 I think you mean Windows Webserver 2003, which is a
lower priced version of windows server with a limited feature set optimized
for webhosting and reducing the cost of server to make it more competitive
in that market place. If you are a programmer look into either the ISV
program or the Action pack program which will help you out with the software
required to setup the development environment.
Regards,
Jeff Loucks
Available Technology
Solutions For Professionals
www.availabletechnology.com
"Martin Feuersteiner" <theintrepidfox@.hotmail.com> wrote in message
news:u$$6SFOcEHA.212@.TK2MSFTNGP12.phx.gbl...
> Hi. I'm a bit confused and wonder whether someone of you can give me some
> more information on this.
> The EULA for MSDE 2000A states that you cannot use MSDE for hosting
> services. Does anyone know what this mean?
> I'm running an ASP.Net application and would like to use MSDE as the
backend
> database. Does this fall into this category?
> Or does it mean that if I'm an ISP, I'm not allowed to offer MSDE as a
> feature on my hosting packages?
> Also, it says that you're not allowed to install any applications on SBS
> 2003 Web Edition. Does MSDE fall into this category?
> Thanks very much for your help!
> Martin
>
>
>
Showing posts with label bit. Show all posts
Showing posts with label bit. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
MSDE 2000 and x64 (WinXP 64 Bit)
Hi,
I do have MSDE 2000 (sr 3a) installed on a 64bit version of WinXP (x64).
Installation worked ok. Selfwritten client-code works ok with a 32bit
application in WOW. So far so good.
Then I ported my client code to native 64bit...compiled ok...but the
64bit-client can not connect to local MSDE desktop engine...connection to a
remote server works ok.
The OLEDB provider for SQLServer is 64bit...I've checked that. Error code
that I get is:
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."
Authentification is "integrated" and works in a 32bit-client. So should work
in a 64bit-client, too. Right? What am I doing wrong?
Thanks
Frank
hi Frank,
Frank wrote:
> "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied."
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks! That did the trick. There were no activated server-protocols
(TCP/IP, Named Pipes, etc.). So I assume the 64bit-client tried to connect
through "shared memory"-access which obviously won't work with a 64bit-client.
Now the 64bit-client connects to the server through loopback interface which
I originally don't wanted but it works for now.
By the way: I am using your DbaMgr tool...it's great!
|||hi Frank,
Frank wrote:
> Thanks! That did the trick. There were no activated server-protocols
> (TCP/IP, Named Pipes, etc.). So I assume the 64bit-client tried to
> connect through "shared memory"-access which obviously won't work
> with a 64bit-client.
> Now the 64bit-client connects to the server through loopback
> interface which I originally don't wanted but it works for now.
> By the way: I am using your DbaMgr tool...it's great!
thank you... please feel free to (privately) contact me for any question or
concern about DbaMgr prj..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I do have MSDE 2000 (sr 3a) installed on a 64bit version of WinXP (x64).
Installation worked ok. Selfwritten client-code works ok with a 32bit
application in WOW. So far so good.
Then I ported my client code to native 64bit...compiled ok...but the
64bit-client can not connect to local MSDE desktop engine...connection to a
remote server works ok.
The OLEDB provider for SQLServer is 64bit...I've checked that. Error code
that I get is:
"[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."
Authentification is "integrated" and works in a 32bit-client. So should work
in a 64bit-client, too. Right? What am I doing wrong?
Thanks
Frank
hi Frank,
Frank wrote:
> "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied."
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks! That did the trick. There were no activated server-protocols
(TCP/IP, Named Pipes, etc.). So I assume the 64bit-client tried to connect
through "shared memory"-access which obviously won't work with a 64bit-client.
Now the 64bit-client connects to the server through loopback interface which
I originally don't wanted but it works for now.
By the way: I am using your DbaMgr tool...it's great!
|||hi Frank,
Frank wrote:
> Thanks! That did the trick. There were no activated server-protocols
> (TCP/IP, Named Pipes, etc.). So I assume the 64bit-client tried to
> connect through "shared memory"-access which obviously won't work
> with a 64bit-client.
> Now the 64bit-client connects to the server through loopback
> interface which I originally don't wanted but it works for now.
> By the way: I am using your DbaMgr tool...it's great!
thank you... please feel free to (privately) contact me for any question or
concern about DbaMgr prj..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Wednesday, March 21, 2012
MSDE 2000 an 64 Bit CPU?
Does it make sense to use a 64 bit CPU with MSDE 2000? Or better: does MSDE
user it? I can′t find any hints.
hi,
Sven Behrend wrote:
> Does it make sense to use a 64 bit CPU with MSDE 2000? Or better:
> does MSDE user it? I cant find any hints.
actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
a database size limit of 2GB (per database data file)... so having a 64bit
CPU in order to address more memory is non sense..
anyway, I never tried, but it should run in WOW on 64bit OS...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ok, i′m talking about 100 Notebooks running MSDE as a SQL-platform for a CRM
system, so i would check it out befor changing, but the question is:
is MSDE using 64 bit or not?
"Andrea Montanari" wrote:
> hi,
> Sven Behrend wrote:
> actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
> a database size limit of 2GB (per database data file)... so having a 64bit
> CPU in order to address more memory is non sense..
> anyway, I never tried, but it should run in WOW on 64bit OS...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
Sven Behrend wrote:
> Ok, im talking about 100 Notebooks running MSDE as a SQL-platform
> for a CRM system, so i would check it out befor changing, but the
> question is:
> is MSDE using 64 bit or not?
if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
Window...
if, on the contrary, the question is "using" it, MSDE is a 32 bit
application..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, that′s it.
I have to make it faster, and that was an idea.
Sven Behrend
"Andrea Montanari" wrote:
> hi,
> Sven Behrend wrote:
> if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
> Window...
> if, on the contrary, the question is "using" it, MSDE is a 32 bit
> application..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
user it? I can′t find any hints.
hi,
Sven Behrend wrote:
> Does it make sense to use a 64 bit CPU with MSDE 2000? Or better:
> does MSDE user it? I cant find any hints.
actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
a database size limit of 2GB (per database data file)... so having a 64bit
CPU in order to address more memory is non sense..
anyway, I never tried, but it should run in WOW on 64bit OS...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ok, i′m talking about 100 Notebooks running MSDE as a SQL-platform for a CRM
system, so i would check it out befor changing, but the question is:
is MSDE using 64 bit or not?
"Andrea Montanari" wrote:
> hi,
> Sven Behrend wrote:
> actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
> a database size limit of 2GB (per database data file)... so having a 64bit
> CPU in order to address more memory is non sense..
> anyway, I never tried, but it should run in WOW on 64bit OS...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
Sven Behrend wrote:
> Ok, im talking about 100 Notebooks running MSDE as a SQL-platform
> for a CRM system, so i would check it out befor changing, but the
> question is:
> is MSDE using 64 bit or not?
if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
Window...
if, on the contrary, the question is "using" it, MSDE is a 32 bit
application..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, that′s it.
I have to make it faster, and that was an idea.
Sven Behrend
"Andrea Montanari" wrote:
> hi,
> Sven Behrend wrote:
> if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
> Window...
> if, on the contrary, the question is "using" it, MSDE is a 32 bit
> application..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
MSDE 1 or MSDE 2K ?
I want to experiment a little bit with the MSDE. I'll be working with
it strictly from Visual Basic 6.
I have both versions of MSDE available for installation (on
Windows2K). Which one should I use?
hi Martin,
"Martin" <martinvalley@.comcast.net> ha scritto nel messaggio
news:ku03605ao6d7v7o4vt9op58f1ob6f88m52@.4ax.com...
> I want to experiment a little bit with the MSDE. I'll be working with
> it strictly from Visual Basic 6.
> I have both versions of MSDE available for installation (on
> Windows2K). Which one should I use?
as MSDE 1.0 is base on SQL Server 2000 and is currently only in maintenance,
I'd stick with the live one, MSDE 2000, which is full supported and is
plenty of new features with regards to the SQL Server 7.0 code base...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||are things mixed up?
|||minor correction in <>
as MSDE 1.0 is base on SQL <Server 7.0> and is currently only in
maintenance,
I'd stick with the live one, MSDE 2000 (<based on SQL Server 2000>), which
is full supported and is
plenty of new features with regards to the SQL Server 7.0 code base...
MSDE 2000 (latest release) is available from
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Dave.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marc" <anonymous@.discussions.microsoft.com> wrote in message
news:84CAA9BC-DE4F-4779-BE75-B6B715F4A6B4@.microsoft.com...
> are things mixed up?
it strictly from Visual Basic 6.
I have both versions of MSDE available for installation (on
Windows2K). Which one should I use?
hi Martin,
"Martin" <martinvalley@.comcast.net> ha scritto nel messaggio
news:ku03605ao6d7v7o4vt9op58f1ob6f88m52@.4ax.com...
> I want to experiment a little bit with the MSDE. I'll be working with
> it strictly from Visual Basic 6.
> I have both versions of MSDE available for installation (on
> Windows2K). Which one should I use?
as MSDE 1.0 is base on SQL Server 2000 and is currently only in maintenance,
I'd stick with the live one, MSDE 2000, which is full supported and is
plenty of new features with regards to the SQL Server 7.0 code base...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||are things mixed up?
|||minor correction in <>
as MSDE 1.0 is base on SQL <Server 7.0> and is currently only in
maintenance,
I'd stick with the live one, MSDE 2000 (<based on SQL Server 2000>), which
is full supported and is
plenty of new features with regards to the SQL Server 7.0 code base...
MSDE 2000 (latest release) is available from
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Dave.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marc" <anonymous@.discussions.microsoft.com> wrote in message
news:84CAA9BC-DE4F-4779-BE75-B6B715F4A6B4@.microsoft.com...
> are things mixed up?
Subscribe to:
Posts (Atom)