Hi there,
How can I monitor the MSDE performance. I read about it
on the MSDN site but was not clear what tool to use.
Can u help?
Thanks,
FP
hi FP,
FP wrote:
> Hi there,
> How can I monitor the MSDE performance. I read about it
> on the MSDN site but was not clear what tool to use.
> Can u help?
depending on what you want to monitor, you can even use the System Monitor,
adding your preferred counters, like
http://www.windowsitpro.com/Articles...layTab=Article
http://www.windowsitpro.com/Articles...layTab=Article
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
How do I know if it is working?
Hi
I think I have installed MSDE sucessfully. The new servie is running, but how can I test ifit is working? Can I place my files anywhere on the system?
All help appreciatedAs the service is running try to access it using "osql" utility.
I think I have installed MSDE sucessfully. The new servie is running, but how can I test ifit is working? Can I place my files anywhere on the system?
All help appreciatedAs the service is running try to access it using "osql" utility.
If you are talking about data files, yes you can declare the path while creating your database...
check create database syntax for thissql
Friday, March 23, 2012
How do I install MSDE after SQLServer 2000?
Hello,
I have SQLServer 2000 installed on a PC and I want to install
MSDE as well.
The attempted MSDE installation immediately fails with the
message:
"The instance name specified is invalid"
I looked at the autorun.inf file and I see that there is no name
specified for the new MSDE installation. Presumably it takes the
default machine name? The default machine name is already taken
by the existing SQL Server installation.
What are the correct lines to add to the MSDE autorun.inf file
for the default MSDE server name and sa account password?
After I have MSDE working is it possible to connect to it? I
would like to develop an ASP.NET web application that uses MSDE.
Ideally I would like to use something like Enterprise Manager
but to manage MSDE, at the very least I need something like
Query Analyser to work.
I note that there are some ASP.NET web apps in development that
emulate both Enterprise Manager and Query Analyser for MSDE. Has
anyone used these tools?
If necessary I can install MSDE on an other machine as I have a
LAN running here. I would prefer not to do that.
Hi,
Try executing the setup with Instance name:-
Setup.exe INSTANCENAME=<name> SAPWD=<sapassword >
Thanks
Hari
MCDBA
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||On Wed, 23 Jun 2004 08:50:23 +0100, Zenobia
<6.20.zenobia@.spamgourmet.com> wrote:
>Hello,
>I have SQLServer 2000 installed on a PC and I want to install
>MSDE as well.
>The attempted MSDE installation immediately fails with the
>message:
>"The instance name specified is invalid"
>I looked at the autorun.inf file and I see that there is no name
>specified for the new MSDE installation. Presumably it takes the
>default machine name? The default machine name is already taken
>by the existing SQL Server installation.
>What are the correct lines to add to the MSDE autorun.inf file
>for the default MSDE server name and sa account password?
>After I have MSDE working is it possible to connect to it? I
>would like to develop an ASP.NET web application that uses MSDE.
>Ideally I would like to use something like Enterprise Manager
>but to manage MSDE, at the very least I need something like
>Query Analyser to work.
>I note that there are some ASP.NET web apps in development that
>emulate both Enterprise Manager and Query Analyser for MSDE. Has
>anyone used these tools?
>If necessary I can install MSDE on an other machine as I have a
>LAN running here. I would prefer not to do that.
Apologies for wasting your time. I needed to add some lines to
the setup.ini file:
++++++++++++++++++++++++++++++++++++++++
[Options]
InstanceName="instance_name"
SAPWD="sa_password"
SecurityMode=SQL
++++++++++++++++++++++++++++++++++++++++
See:
http://msdn.microsoft.com/library/de...stsql_84xl.asp
http://support.microsoft.com/default...99&Product=sql
++++++++++++++++++++++++++++++++++++++++
But if anyone's reading. I'd appreciate help on utilities for
editing and creating MSDE databases and...
Now that MSDE is running I can't even see it on my machine. I
now have 2 Sqlservr.exe processes running, which have 2
different memory usages (16M and 8M). But why can't I see the
new database instance in my Tray. Is that normal. Surely, if I
have a process running, I should have an icon in my tray
allowing me to stop and start it?
I running XP pro SP1.
|||Zenobia,
--For the MSDE install issue
Try to run the setup in command line specifying a instance name, as
mentioned in the below syntax:
<path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
c:\<path>\msdeInstallation.log
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||>>>> > After I have MSDE working is it possible to connect to it?
Ofcourse.It will be just like a SQLServer instance.
[vbcol=seagreen]
MSDE is devoid of any GUI but you can always use EM/QA from other editions
to manage.
[vbcol=seagreen]
Aaron has a collection.Please search www.aspfaq.com
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#zwrcyPWEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Zenobia,
> --For the MSDE install issue
> Try to run the setup in command line specifying a instance name, as
> mentioned in the below syntax:
> <path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
> c:\<path>\msdeInstallation.log
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
> news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
>
|||On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
<tkdinesh@.nospam.mail.tkdinesh.com> wrote:
>Ofcourse.It will be just like a SQLServer instance.
>MSDE is devoid of any GUI but you can always use EM/QA from other editions
>to manage.
>
>Aaron has a collection.Please search www.aspfaq.com
Thanks.
After running server network utility I installed:
Named Pipes
TCP/IP
for my new MSDE installation aka machine_name\instance_name
After re booting it now shows to be 'running' in my system tray
as an option of my SQL Server and I have connected to it using
Enterprise Manager and QA.
Are these the 2 protocols I should install or will only one do?
|||Zenobia,
[vbcol=seagreen]
Its fine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:7vlid016ddkp0mdfpkvstd9kdgkoroe6ls@.4ax.com... [vbcol=seagreen]
> On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
> <tkdinesh@.nospam.mail.tkdinesh.com> wrote:
editions
> Thanks.
> After running server network utility I installed:
> Named Pipes
> TCP/IP
> for my new MSDE installation aka machine_name\instance_name
> After re booting it now shows to be 'running' in my system tray
> as an option of my SQL Server and I have connected to it using
> Enterprise Manager and QA.
> Are these the 2 protocols I should install or will only one do?
>
sql
I have SQLServer 2000 installed on a PC and I want to install
MSDE as well.
The attempted MSDE installation immediately fails with the
message:
"The instance name specified is invalid"
I looked at the autorun.inf file and I see that there is no name
specified for the new MSDE installation. Presumably it takes the
default machine name? The default machine name is already taken
by the existing SQL Server installation.
What are the correct lines to add to the MSDE autorun.inf file
for the default MSDE server name and sa account password?
After I have MSDE working is it possible to connect to it? I
would like to develop an ASP.NET web application that uses MSDE.
Ideally I would like to use something like Enterprise Manager
but to manage MSDE, at the very least I need something like
Query Analyser to work.
I note that there are some ASP.NET web apps in development that
emulate both Enterprise Manager and Query Analyser for MSDE. Has
anyone used these tools?
If necessary I can install MSDE on an other machine as I have a
LAN running here. I would prefer not to do that.
Hi,
Try executing the setup with Instance name:-
Setup.exe INSTANCENAME=<name> SAPWD=<sapassword >
Thanks
Hari
MCDBA
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||On Wed, 23 Jun 2004 08:50:23 +0100, Zenobia
<6.20.zenobia@.spamgourmet.com> wrote:
>Hello,
>I have SQLServer 2000 installed on a PC and I want to install
>MSDE as well.
>The attempted MSDE installation immediately fails with the
>message:
>"The instance name specified is invalid"
>I looked at the autorun.inf file and I see that there is no name
>specified for the new MSDE installation. Presumably it takes the
>default machine name? The default machine name is already taken
>by the existing SQL Server installation.
>What are the correct lines to add to the MSDE autorun.inf file
>for the default MSDE server name and sa account password?
>After I have MSDE working is it possible to connect to it? I
>would like to develop an ASP.NET web application that uses MSDE.
>Ideally I would like to use something like Enterprise Manager
>but to manage MSDE, at the very least I need something like
>Query Analyser to work.
>I note that there are some ASP.NET web apps in development that
>emulate both Enterprise Manager and Query Analyser for MSDE. Has
>anyone used these tools?
>If necessary I can install MSDE on an other machine as I have a
>LAN running here. I would prefer not to do that.
Apologies for wasting your time. I needed to add some lines to
the setup.ini file:
++++++++++++++++++++++++++++++++++++++++
[Options]
InstanceName="instance_name"
SAPWD="sa_password"
SecurityMode=SQL
++++++++++++++++++++++++++++++++++++++++
See:
http://msdn.microsoft.com/library/de...stsql_84xl.asp
http://support.microsoft.com/default...99&Product=sql
++++++++++++++++++++++++++++++++++++++++
But if anyone's reading. I'd appreciate help on utilities for
editing and creating MSDE databases and...
Now that MSDE is running I can't even see it on my machine. I
now have 2 Sqlservr.exe processes running, which have 2
different memory usages (16M and 8M). But why can't I see the
new database instance in my Tray. Is that normal. Surely, if I
have a process running, I should have an icon in my tray
allowing me to stop and start it?
I running XP pro SP1.
|||Zenobia,
--For the MSDE install issue
Try to run the setup in command line specifying a instance name, as
mentioned in the below syntax:
<path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
c:\<path>\msdeInstallation.log
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||>>>> > After I have MSDE working is it possible to connect to it?
Ofcourse.It will be just like a SQLServer instance.
[vbcol=seagreen]
MSDE is devoid of any GUI but you can always use EM/QA from other editions
to manage.
[vbcol=seagreen]
Aaron has a collection.Please search www.aspfaq.com
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#zwrcyPWEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Zenobia,
> --For the MSDE install issue
> Try to run the setup in command line specifying a instance name, as
> mentioned in the below syntax:
> <path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
> c:\<path>\msdeInstallation.log
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
> news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
>
|||On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
<tkdinesh@.nospam.mail.tkdinesh.com> wrote:
>Ofcourse.It will be just like a SQLServer instance.
>MSDE is devoid of any GUI but you can always use EM/QA from other editions
>to manage.
>
>Aaron has a collection.Please search www.aspfaq.com
Thanks.
After running server network utility I installed:
Named Pipes
TCP/IP
for my new MSDE installation aka machine_name\instance_name
After re booting it now shows to be 'running' in my system tray
as an option of my SQL Server and I have connected to it using
Enterprise Manager and QA.
Are these the 2 protocols I should install or will only one do?
|||Zenobia,
[vbcol=seagreen]
Its fine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:7vlid016ddkp0mdfpkvstd9kdgkoroe6ls@.4ax.com... [vbcol=seagreen]
> On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
> <tkdinesh@.nospam.mail.tkdinesh.com> wrote:
editions
> Thanks.
> After running server network utility I installed:
> Named Pipes
> TCP/IP
> for my new MSDE installation aka machine_name\instance_name
> After re booting it now shows to be 'running' in my system tray
> as an option of my SQL Server and I have connected to it using
> Enterprise Manager and QA.
> Are these the 2 protocols I should install or will only one do?
>
sql
Monday, March 19, 2012
how do i get started
I hope some one can help with this most basic of
questions. I am working on a project that requires a
mediium size data base and so MSDE look like a good fit.
Problem is that in all my VB 6.0 work i never did any data
base work and i cant find any good way to get started. I
am lookign for samples and things to help me conect, read
write and update tables. All the MSDN resources talk about
what you can do but none tell me how.
Thanks to any one who can help
"steven davis" <stevend@.parabit.com> wrote in message
news:24ed601c45fdb$8cabc380$a401280a@.phx.gbl...
> I hope some one can help with this most basic of
> questions. I am working on a project that requires a
> mediium size data base and so MSDE look like a good fit.
> Problem is that in all my VB 6.0 work i never did any data
> base work and i cant find any good way to get started. I
> am lookign for samples and things to help me conect, read
> write and update tables. All the MSDN resources talk about
> what you can do but none tell me how.
> Thanks to any one who can help
While this book is geared for MS Access/SQL Server developers, most, if not
all of the concepts (and code) will translate to what you need to do. I
highly recommend it.
Microsoft Access Developer's Guide to SQL Server
by Mary Chipman, Andy Baron
ISBN: 0672319446
Steve
|||Also another starter's book which uses MSDE is 'Beginning Visual Basic .Net databases' by Wrox
But what programming language are you using..
dev
"Steve Thompson" wrote:
> "steven davis" <stevend@.parabit.com> wrote in message
> news:24ed601c45fdb$8cabc380$a401280a@.phx.gbl...
> While this book is geared for MS Access/SQL Server developers, most, if not
> all of the concepts (and code) will translate to what you need to do. I
> highly recommend it.
> Microsoft Access Developer's Guide to SQL Server
> by Mary Chipman, Andy Baron
> ISBN: 0672319446
> Steve
>
>
|||"dev_kh" <devkh@.discussions.microsoft.com> wrote in message
news:11AF35E9-E1EA-45FE-A72A-E95F1AA734B3@.microsoft.com...
> Also another starter's book which uses MSDE is 'Beginning Visual Basic
..Net databases' by Wrox
> But what programming language are you using..
It sounded like VB 6 from his original post...
Steve
|||Hello.
Yes i am using vb 6.0. It looks to me like MSDE is simply
SQL 2000 with out the manager graphical interface. If that
is so then maybe i can just read an SQL & VB book. Am i
correct?
thanks.
>--Original Message--
>"dev_kh" <devkh@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:11AF35E9-E1EA-45FE-A72A-E95F1AA734B3@.microsoft.com...
is 'Beginning Visual Basic
>..Net databases' by Wrox
>It sounded like VB 6 from his original post...
>Steve
>
>.
>
|||hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:2564501c46169$ef458eb0$a601280a@.phx.gbl...
> Hello.
> Yes i am using vb 6.0. It looks to me like MSDE is simply
> SQL 2000 with out the manager graphical interface. If that
> is so then maybe i can just read an SQL & VB book. Am i
> correct?
you are correct...
I've found
http://www.amazon.com/exec/obidos/AS...948653-0983837
quite intuitive for beginners... it's a little bit dated and offer no cover
about .Net.. but addresses quite all typical scenarios for MSDE solutions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||My book "Hitchhiker's Guide to Visual Basic and SQL Server (6th Edition)"
should help quite a bit. Yes, it's a bit dated but focuses solely on SQL
Server (and MSDE).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
<anonymous@.discussions.microsoft.com> wrote in message
news:2564501c46169$ef458eb0$a601280a@.phx.gbl...[vbcol=seagreen]
> Hello.
> Yes i am using vb 6.0. It looks to me like MSDE is simply
> SQL 2000 with out the manager graphical interface. If that
> is so then maybe i can just read an SQL & VB book. Am i
> correct?
> thanks.
>
> message
> is 'Beginning Visual Basic
questions. I am working on a project that requires a
mediium size data base and so MSDE look like a good fit.
Problem is that in all my VB 6.0 work i never did any data
base work and i cant find any good way to get started. I
am lookign for samples and things to help me conect, read
write and update tables. All the MSDN resources talk about
what you can do but none tell me how.
Thanks to any one who can help
"steven davis" <stevend@.parabit.com> wrote in message
news:24ed601c45fdb$8cabc380$a401280a@.phx.gbl...
> I hope some one can help with this most basic of
> questions. I am working on a project that requires a
> mediium size data base and so MSDE look like a good fit.
> Problem is that in all my VB 6.0 work i never did any data
> base work and i cant find any good way to get started. I
> am lookign for samples and things to help me conect, read
> write and update tables. All the MSDN resources talk about
> what you can do but none tell me how.
> Thanks to any one who can help
While this book is geared for MS Access/SQL Server developers, most, if not
all of the concepts (and code) will translate to what you need to do. I
highly recommend it.
Microsoft Access Developer's Guide to SQL Server
by Mary Chipman, Andy Baron
ISBN: 0672319446
Steve
|||Also another starter's book which uses MSDE is 'Beginning Visual Basic .Net databases' by Wrox
But what programming language are you using..
dev
"Steve Thompson" wrote:
> "steven davis" <stevend@.parabit.com> wrote in message
> news:24ed601c45fdb$8cabc380$a401280a@.phx.gbl...
> While this book is geared for MS Access/SQL Server developers, most, if not
> all of the concepts (and code) will translate to what you need to do. I
> highly recommend it.
> Microsoft Access Developer's Guide to SQL Server
> by Mary Chipman, Andy Baron
> ISBN: 0672319446
> Steve
>
>
|||"dev_kh" <devkh@.discussions.microsoft.com> wrote in message
news:11AF35E9-E1EA-45FE-A72A-E95F1AA734B3@.microsoft.com...
> Also another starter's book which uses MSDE is 'Beginning Visual Basic
..Net databases' by Wrox
> But what programming language are you using..
It sounded like VB 6 from his original post...
Steve
|||Hello.
Yes i am using vb 6.0. It looks to me like MSDE is simply
SQL 2000 with out the manager graphical interface. If that
is so then maybe i can just read an SQL & VB book. Am i
correct?
thanks.
>--Original Message--
>"dev_kh" <devkh@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:11AF35E9-E1EA-45FE-A72A-E95F1AA734B3@.microsoft.com...
is 'Beginning Visual Basic
>..Net databases' by Wrox
>It sounded like VB 6 from his original post...
>Steve
>
>.
>
|||hi,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:2564501c46169$ef458eb0$a601280a@.phx.gbl...
> Hello.
> Yes i am using vb 6.0. It looks to me like MSDE is simply
> SQL 2000 with out the manager graphical interface. If that
> is so then maybe i can just read an SQL & VB book. Am i
> correct?
you are correct...
I've found
http://www.amazon.com/exec/obidos/AS...948653-0983837
quite intuitive for beginners... it's a little bit dated and offer no cover
about .Net.. but addresses quite all typical scenarios for MSDE solutions..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||My book "Hitchhiker's Guide to Visual Basic and SQL Server (6th Edition)"
should help quite a bit. Yes, it's a bit dated but focuses solely on SQL
Server (and MSDE).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
<anonymous@.discussions.microsoft.com> wrote in message
news:2564501c46169$ef458eb0$a601280a@.phx.gbl...[vbcol=seagreen]
> Hello.
> Yes i am using vb 6.0. It looks to me like MSDE is simply
> SQL 2000 with out the manager graphical interface. If that
> is so then maybe i can just read an SQL & VB book. Am i
> correct?
> thanks.
>
> message
> is 'Beginning Visual Basic
Friday, February 24, 2012
How do I do an Unattended install of "MSDE 1.0 sp4"?
I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch
but I need to do either a Silent or Unattended install.
Does anyone know how to do this? Does anyone know the
command-line command to do this?
I tried using...
sql70sp4.exe -a -f1 "unattend.iss"
....but that didn't work. It popped up a window asking where I
should extract the contents of the .exe (that shouldn't be appearing
either) and then after it extracted it didn't do anything else.
Any help is greatly appreciated.
see if this helps
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q233312
Subscribe to:
Posts (Atom)