Showing posts with label code. Show all posts
Showing posts with label code. Show all posts

Friday, March 30, 2012

MSDE stopps with code 1603

Hi!
When I tried to install MDSE on W2003 Server it stopped with error code
1603. I want to Install NAI ProtectionPilot 1.1 an Veritas Backup Exec 9.1
whic use that as well.
KB article dont match to my problem...
Thanks for helping
Marcel
hi Marcel,
Marcel Ksling wrote:
> Hi!
> When I tried to install MDSE on W2003 Server it stopped with error
> code 1603. I want to Install NAI ProtectionPilot 1.1 an Veritas
> Backup Exec 9.1 whic use that as well.
> KB article dont match to my problem...
> Thanks for helping
> Marcel
please have a look at http://tinyurl.com/apb8e to see 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
|||Hello,
I have seen the exact same problem on both Windows XP PRO and a Windows 2003
Server.
MSDE2000 Release A will not always install again after it has been
un-installed. I have never seen this problem on my own development machine,
only on customers machines installing our product!
So my guess is that on my machine where ex. Visual Studio .NET is installed
something is eliminating the problem... but NOT on a standard Windows XP PRO
or Windoes 2003 Server!
My question: Is there a solution to the problem or not ?
I can see a lot of people have had the same problem...
Best regards
Per Clausen
"Andrea Montanari" wrote:

> hi Marcel,
> Marcel K?sling wrote:
> please have a look at http://tinyurl.com/apb8e to see 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
>
>
|||hi,
Per Clausen wrote:
> Hello,
> I have seen the exact same problem on both Windows XP PRO and a
> Windows 2003 Server.
which both now have MDAC 2.8 sp 2 ...

> MSDE2000 Release A will not always install again after it has been
> un-installed. I have never seen this problem on my own development
> machine, only on customers machines installing our product!
uninstalling MSDE (often) does non properly clear MSDE related file system
and registry entries, and this often confuses users... a proper (and manual)
clean up is required, as indicated in
http://support.microsoft.com/default...b;en-us;320873
http://support.microsoft.com/default...;EN-US;Q290991

> So my guess is that on my machine where ex. Visual Studio .NET is
> installed something is eliminating the problem... but NOT on a
> standard Windows XP PRO or Windoes 2003 Server!
> My question: Is there a solution to the problem or not ?
> I can see a lot of people have had the same problem...
none that I'm aware of... but, for what is worth, I never had this kind of
problems on Win2k, XP (rtm/sp1/sp2) and Win2003 (rtm/sp1)

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
|||Hi Andrea,
Thank you for your reply. I guess we have to make a custom application to
fix the problem. It's just not easy when I can't reproduce the problem on my
own machine.
Best regards
Per Clausen
"Andrea Montanari" wrote:

> hi,
> Per Clausen wrote:
> which both now have MDAC 2.8 sp 2 ...
>
> uninstalling MSDE (often) does non properly clear MSDE related file system
> and registry entries, and this often confuses users... a proper (and manual)
> clean up is required, as indicated in
> http://support.microsoft.com/default...b;en-us;320873
> http://support.microsoft.com/default...;EN-US;Q290991
>
> none that I'm aware of... but, for what is worth, I never had this kind of
> problems on Win2k, XP (rtm/sp1/sp2) and Win2003 (rtm/sp1)
>
> --
> 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
>
>
|||Hi,
For your information:
I have found a way to reproduce the MSDE re-installation problem.
If the value InstanceComponentSet.1 exist in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set MSDE
will NOT install.
To make the MSDE install simply delete InstanceComponentSet.1 and everything
seems to work fine again.
Best regards
Per Clausen
CIM Electronics A/S
"Andrea Montanari" wrote:

> hi,
> Per Clausen wrote:
> which both now have MDAC 2.8 sp 2 ...
>
> uninstalling MSDE (often) does non properly clear MSDE related file system
> and registry entries, and this often confuses users... a proper (and manual)
> clean up is required, as indicated in
> http://support.microsoft.com/default...b;en-us;320873
> http://support.microsoft.com/default...;EN-US;Q290991
>
> none that I'm aware of... but, for what is worth, I never had this kind of
> problems on Win2k, XP (rtm/sp1/sp2) and Win2003 (rtm/sp1)
>
> --
> 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
>
>
|||hi,
Per Clausen wrote:
> Hi,
> For your information:
> I have found a way to reproduce the MSDE re-installation problem.
> If the value InstanceComponentSet.1 exist in
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component
> Set MSDE will NOT install.
> To make the MSDE install simply delete InstanceComponentSet.1 and
> everything seems to work fine again.
>
it's documented...
http://support.microsoft.com/default...b;en-us;320873
point 3..
3. If the following registry key points to the MSDE 2000 instance
ProductCode, remove the value InstanceComponentSet.x. For example,
InstanceComponentSet.1 has a value that matches the ProductCode of
Sqlrun01.msi:
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
sql

Wednesday, March 28, 2012

MSDE Sort Page

How can I change the Sort Code Page under MSDE? And also
where can i find the rebuild option under MSDE?
Any help would be highly appreciated
Thanks
hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:20a001c47d51$d5771270$a301280a@.phx.gbl...
> How can I change the Sort Code Page under MSDE? And also
> where can i find the rebuild option under MSDE?
you can create databases with different collations, and you can define
different collation at column level too...
as regard the defaul collation, I think MSDE does not provide the rubuild
utility, so you probably have to uninstall MSDE and reinstall it
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
|||HI Andrea,
Thanks for your quick response. As I am new to this, can
you please guide me how to determine the collation for the
database in msde.
Thanks once again
Asim
>--Original Message--
>hi Asim,
>"Asim" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio
>news:20a001c47d51$d5771270$a301280a@.phx.gbl...
>you can create databases with different collations, and
you can define
>different collation at column level too...
>as regard the defaul collation, I think MSDE does not
provide the rubuild
>utility, so you probably have to uninstall MSDE and
reinstall it
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||hi Asim,
"Asim" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:247501c47d58$fc457160$a601280a@.phx.gbl...
> HI Andrea,
> Thanks for your quick response. As I am new to this, can
> you please guide me how to determine the collation for the
> database in msde.
you can investigate the collation settings like
SET NOCOUNT ON
SELECT SERVERPROPERTY ( 'Collation' ) AS [Server wide Collation] ,
DATABASEPROPERTYEX ( 'master' , 'Collation' ) AS [Specific Database
Collation] ;
as for the specifi instance and for each database...
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
sql

MSDE Setup -- Wheres the Server?

I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE...or so I thought.

I have the server Icon in the bottom systray and it's green and seems to be running.

I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.

An in VB.net I see a master.dbo connection in Server Explorer.

But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer...the Create a New SQL database menu item is greyed out.

My concern is that my installation is not complete and/or I don't know how to locate and verify the server.

Any help would be appreciated. ThanksMSDN link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msderoadmap.asp to run thru the details.

Monday, March 12, 2012

msde login problem

I installed MSDE in my computer. When I try to connect to a database from a
program I get an error message:
Code = 80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = Login failed for user 'sa'. Reason: Not associated with
a trusted SQL Server connection.
Please help.
AntoninThis is a multi-part message in MIME format.
--010506050301020900000107
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
By default, MSDE is installed with Windows Authentication only. So
unless you've changed it to mixed mode you'll only be able to login with
trusted logins (not 'sa'). To change to mixed mode you have to change a
reg value, viz.
"HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode" or
"HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022). The
values for the reg key are:
1 - Windows only mode
2 - Mixed mode (Windows & SQL authentication)
Cheers,
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Antonin Koudelka wrote:
>I installed MSDE in my computer. When I try to connect to a database from a
>program I get an error message:
> Code = 80004005
> Code meaning = Unspecified error
> Source = Microsoft OLE DB Provider for SQL Server
> Description = Login failed for user 'sa'. Reason: Not associated with
>a trusted SQL Server connection.
>Please help.
>Antonin
>
>
--010506050301020900000107
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>By default, MSDE is installed with Windows Authentication only. So
unless you've changed it to mixed mode you'll only be able to login
with trusted logins (not 'sa'). To change to mixed mode you have to
change a reg value, viz.
"HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode" or
"HKLM\Software\Microsoft\Microsoft SQL Server\<Instance
Name>\MSSQLServer\LoginMode" for a named instance (detailed in
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022</a>). ">http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022">http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022</a>). The
values for the reg key are:<br>
1 - Windows only mode<br>
2 - Mixed mode (Windows & SQL authentication)<br>
<br>
Cheers,<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Antonin Koudelka wrote:
<blockquote cite="mid%23uTSP87FFHA.3888@.TK2MSFTNGP12.phx.gbl"
type="cite">
<pre wrap="">I installed MSDE in my computer. When I try to connect to a database from a
program I get an error message:
Code = 80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = Login failed for user 'sa'. Reason: Not associated with
a trusted SQL Server connection.
Please help.
Antonin
</pre>
</blockquote>
</body>
</html>
--010506050301020900000107--|||This is a multi-part message in MIME format.
--=_NextPart_000_0009_01C5182A.2893B8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks Mike,
It works now.
Antonin
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:eThC6n8FFHA.2156@.TK2MSFTNGP09.phx.gbl...
By default, MSDE is installed with Windows Authentication only. So =unless you've changed it to mixed mode you'll only be able to login with =trusted logins (not 'sa'). To change to mixed mode you have to change a =reg value, viz. ="HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode" or ="HKLM\Software\Microsoft\Microsoft SQL Server\<Instance =Name>\MSSQLServer\LoginMode" for a named instance (detailed in =http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;Q325022). The =values for the reg key are:
1 - Windows only mode
2 - Mixed mode (Windows & SQL authentication)
Cheers,
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
Antonin Koudelka wrote: I installed MSDE in my computer. When I try to connect to a database =from a
program I get an error message:
Code =3D 80004005
Code meaning =3D Unspecified error
Source =3D Microsoft OLE DB Provider for SQL Server
Description =3D Login failed for user 'sa'. Reason: Not associated =with
a trusted SQL Server connection.
Please help.
Antonin
--=_NextPart_000_0009_01C5182A.2893B8F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Thanks Mike,
It works now.
Antonin
"Mike Hodgson" wrote in message news:eThC6n8FFHA.2156=@.TK2MSFTNGP09.phx.gbl...By default, MSDE is installed with Windows Authentication only. So =unless you've changed it to mixed mode you'll only be able to login with =trusted logins (not 'sa'). To change to mixed mode you have to change a =reg value, viz. ="HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode" or "HKLM\Software\Microsoft\Microsoft SQL Server\\MSSQLServer\LoginMode" for a named instance (detailed in http://support.microsoft.com/default.aspx?scid=3Dkb;EN-US;Q325022).= The values for the reg key are: 1 - Windows only = mode 2 - Mixed mode (Windows & SQL authentication)Cheers,
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com Antonin Koudelka wrote: I installed MSDE in my computer. When I try =to connect to a database from a
program I get an error message:
Code =3D 80004005
Code meaning =3D Unspecified error
Source =3D Microsoft OLE DB Provider for SQL Server
Description =3D Login failed for user 'sa'. Reason: Not associated =with
a trusted SQL Server connection.
Please help.
Antonin


--=_NextPart_000_0009_01C5182A.2893B8F0--

Friday, March 9, 2012

MSDE installer problem

Hi
I'm working in visual C++ and through it I start MSDE setup.exe. I have to
wait in my VC++ code before the MSDE installer is finished totally. The
problem i'm having is that as soon as I initiate the process of MSDE
setup.exe, i get its finished status in my VC waiting code, though the
installer is still running. I've tried running the MSDE setup.exe from the
command line and i see that the status also come back to prompt just a
second after the setup.exe is run. I was wondering how can i keep the
control from coming back to the setup.exe instantiating application unless
the whole setup.exe is complete. Hope i've made my point clear.
Regards
Usman Jamil
Hi Usman,
Try this code: here WaitForSingleObject( ) waits till your process gets completed. I used the same for installing MSDE through my setup launcher.
Cheers
Piyush
int ExecCmd(char * pszCmd )
{
BOOL bReturnVal = false ;
STARTUPINFO si ;
DWORD dwExitCode ;
SECURITY_ATTRIBUTES saProcess, saThread ;
PROCESS_INFORMATION process_info ;
ZeroMemory(&si, sizeof(si)) ;
si.cb = sizeof(si) ;
saProcess.nLength = sizeof(saProcess) ;
saProcess.lpSecurityDescriptor = NULL ;
saProcess.bInheritHandle = TRUE ;
saThread.nLength = sizeof(saThread) ;
saThread.lpSecurityDescriptor = NULL ;
saThread.bInheritHandle = FALSE ;
bReturnVal = CreateProcess(NULL, (LPTSTR)pszCmd, &saProcess, &saThread, FALSE,
DETACHED_PROCESS,
NULL,
NULL,
&si,
&process_info) ;
if (bReturnVal)
{
CloseHandle( process_info.hThread ) ;
WaitForSingleObject( process_info.hProcess, INFINITE ) ;
GetExitCodeProcess( process_info.hProcess, &dwExitCode ) ;
CloseHandle( process_info.hProcess ) ;
}
return dwExitCode;
}
"Usman Jamil" <usman@.advcomm.net> wrote in message news:O11ArM2WEHA.2716@.tk2msftngp13.phx.gbl...
> Hi
> I'm working in visual C++ and through it I start MSDE setup.exe. I have to
> wait in my VC++ code before the MSDE installer is finished totally. The
> problem i'm having is that as soon as I initiate the process of MSDE
> setup.exe, i get its finished status in my VC waiting code, though the
> installer is still running. I've tried running the MSDE setup.exe from the
> command line and i see that the status also come back to prompt just a
> second after the setup.exe is run. I was wondering how can i keep the
> control from coming back to the setup.exe instantiating application unless
> the whole setup.exe is complete. Hope i've made my point clear.
> Regards
> Usman Jamil
>
|||Hi viki
I dont know how it worked in your case but its not supposed to work and i've
checked it too. It wont work coz the Waitforsingleobject would also return
as soon as the process created is finished. and when we run the process
setup.exe, this setup.exe script asks the windows installer service to run
the actull installer and it exits itself thus breaking the
waitforsingleobject lock too. So it would not work for MSDE installer from
C++ code. Anyway thanx for your help.
Still waiting for a solution..
Regards
Usman Jamil
"viki" <piyush__jain@.hotmail.com> wrote in message
news:eZ5ZQ3MXEHA.1144@.TK2MSFTNGP10.phx.gbl...
Hi Usman,
Try this code: here WaitForSingleObject( ) waits till your process gets
completed. I used the same for installing MSDE through my setup launcher.
Cheers
Piyush
int ExecCmd(char * pszCmd )
{
BOOL bReturnVal = false ;
STARTUPINFO si ;
DWORD dwExitCode ;
SECURITY_ATTRIBUTES saProcess, saThread ;
PROCESS_INFORMATION process_info ;
ZeroMemory(&si, sizeof(si)) ;
si.cb = sizeof(si) ;
saProcess.nLength = sizeof(saProcess) ;
saProcess.lpSecurityDescriptor = NULL ;
saProcess.bInheritHandle = TRUE ;
saThread.nLength = sizeof(saThread) ;
saThread.lpSecurityDescriptor = NULL ;
saThread.bInheritHandle = FALSE ;
bReturnVal = CreateProcess(NULL, (LPTSTR)pszCmd, &saProcess, &saThread,
FALSE,
DETACHED_PROCESS,
NULL,
NULL,
&si,
&process_info) ;
if (bReturnVal)
{
CloseHandle( process_info.hThread ) ;
WaitForSingleObject( process_info.hProcess, INFINITE ) ;
GetExitCodeProcess( process_info.hProcess, &dwExitCode ) ;
CloseHandle( process_info.hProcess ) ;
}
return dwExitCode;
}
"Usman Jamil" <usman@.advcomm.net> wrote in message
news:O11ArM2WEHA.2716@.tk2msftngp13.phx.gbl...
> Hi
> I'm working in visual C++ and through it I start MSDE setup.exe. I have to
> wait in my VC++ code before the MSDE installer is finished totally. The
> problem i'm having is that as soon as I initiate the process of MSDE
> setup.exe, i get its finished status in my VC waiting code, though the
> installer is still running. I've tried running the MSDE setup.exe from the
> command line and i see that the status also come back to prompt just a
> second after the setup.exe is run. I was wondering how can i keep the
> control from coming back to the setup.exe instantiating application unless
> the whole setup.exe is complete. Hope i've made my point clear.
> Regards
> Usman Jamil
>
|||Hi viki
I dont know how it worked in your case but its not supposed to work and i've
checked it too. It wont work coz the Waitforsingleobject would also return
as soon as the process created is finished. and when we run the process
setup.exe, this setup.exe script asks the windows installer service to run
the actull installer and it exits itself thus breaking the
waitforsingleobject lock too. So it would not work for MSDE installer from
C++ code. Anyway thanx for your help.
Still waiting for a solution..
Regards
Usman Jamil
"viki" <piyush__jain@.hotmail.com> wrote in message
news:eZ5ZQ3MXEHA.1144@.TK2MSFTNGP10.phx.gbl...
Hi Usman,
Try this code: here WaitForSingleObject( ) waits till your process gets
completed. I used the same for installing MSDE through my setup launcher.
Cheers
Piyush
int ExecCmd(char * pszCmd )
{
BOOL bReturnVal = false ;
STARTUPINFO si ;
DWORD dwExitCode ;
SECURITY_ATTRIBUTES saProcess, saThread ;
PROCESS_INFORMATION process_info ;
ZeroMemory(&si, sizeof(si)) ;
si.cb = sizeof(si) ;
saProcess.nLength = sizeof(saProcess) ;
saProcess.lpSecurityDescriptor = NULL ;
saProcess.bInheritHandle = TRUE ;
saThread.nLength = sizeof(saThread) ;
saThread.lpSecurityDescriptor = NULL ;
saThread.bInheritHandle = FALSE ;
bReturnVal = CreateProcess(NULL, (LPTSTR)pszCmd, &saProcess, &saThread,
FALSE,
DETACHED_PROCESS,
NULL,
NULL,
&si,
&process_info) ;
if (bReturnVal)
{
CloseHandle( process_info.hThread ) ;
WaitForSingleObject( process_info.hProcess, INFINITE ) ;
GetExitCodeProcess( process_info.hProcess, &dwExitCode ) ;
CloseHandle( process_info.hProcess ) ;
}
return dwExitCode;
}
"Usman Jamil" <usman@.advcomm.net> wrote in message
news:O11ArM2WEHA.2716@.tk2msftngp13.phx.gbl...
> Hi
> I'm working in visual C++ and through it I start MSDE setup.exe. I have to
> wait in my VC++ code before the MSDE installer is finished totally. The
> problem i'm having is that as soon as I initiate the process of MSDE
> setup.exe, i get its finished status in my VC waiting code, though the
> installer is still running. I've tried running the MSDE setup.exe from the
> command line and i see that the status also come back to prompt just a
> second after the setup.exe is run. I was wondering how can i keep the
> control from coming back to the setup.exe instantiating application unless
> the whole setup.exe is complete. Hope i've made my point clear.
> Regards
> Usman Jamil
>

Saturday, February 25, 2012

MSDE Install Hangs During Install

Please help!
The istall hangs at:
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
The work-around code in the MS white papers is not an option,
What is up?
This effects us a great deal as well. I have to say the whole install
scenario for MSDE 2000 has been incredibly frustrating with many issues that
MS could fix, simply KB articled instead.
You can't depend on users not running applications that occasionally stop
pumping their message queue. This just stops the installer dead.
"A Met" wrote:

> Please help!
> The istall hangs at:
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
> /q:a"
> The work-around code in the MS white papers is not an option,
> What is up?
>
|||We are having and the install hang at the exact same point. Previously in
the thread there was a reference to a knowledge base article. If there is a
workaround could you post a link to that article or white paper please.
Also mentioned is the fact that the other applications can stop the intstall
by their affect on the message queue. Would having the user close all other
programs stop the install from failing in this case?
"jwf" wrote:
[vbcol=seagreen]
> This effects us a great deal as well. I have to say the whole install
> scenario for MSDE 2000 has been incredibly frustrating with many issues that
> MS could fix, simply KB articled instead.
> You can't depend on users not running applications that occasionally stop
> pumping their message queue. This just stops the installer dead.
>
> "A Met" wrote:

MSDE Install Failure - error code 6

During one of our client's install of MSDE 2000, they are getting this error message in thier install log:
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 12:07:55: InstallFinalize. Return value 3.

MSI (s) (10:FC): Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

Does anyone have any idea on how to fix it?

thanks,

DanielWas there ever a reply or fix for this?

Thanks,
BD

Originally posted by DanielP
During one of our client's install of MSDE 2000, they are getting this error message in thier install log:
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 12:07:55: InstallFinalize. Return value 3.

MSI (s) (10:FC): Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

Does anyone have any idea on how to fix it?

thanks,

Daniel

Monday, February 20, 2012

MSDE exchange

hi there,
How do i have a server side code/software that will connect all the field of
my exchange server to a MSDE database? i need custom fields and all address
fields? i need it to be a link if pos?
dorling
In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes
>hi there,
>How do i have a server side code/software that will connect all the field of
>my exchange server to a MSDE database? i need custom fields and all address
>fields? i need it to be a link if pos?
>dorling
One simple answer is to use Forms in the Public Folders. Using Outlook
you can design and Publish these forms using templates and adding your
own custom fields as you go. You don't need MSDE or any other database
for that matter.
If you really need to hook Exchange into a backend database like MSDE
then the next real step would be to right your own plugin / extension
for Outlook. This would enable you to tie the two together but requires
learning more than T-SQL.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
thanks for that, is there some code/software or a web site that i could use
to help me, hook Exchange into a backend database like MSDE? i want the data
to be live/link not copy if possible in to the Database?
Jonathan
"Andrew D. Newbould" wrote:

> In message <46D35AD2-0C3E-47E9-9755-443F87EA5BF2@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> One simple answer is to use Forms in the Public Folders. Using Outlook
> you can design and Publish these forms using templates and adding your
> own custom fields as you go. You don't need MSDE or any other database
> for that matter.
> If you really need to hook Exchange into a backend database like MSDE
> then the next real step would be to right your own plugin / extension
> for Outlook. This would enable you to tie the two together but requires
> learning more than T-SQL.
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||It depends on the programming language you want to use. However, try
these sites out for starters as they cover more than one programming
language:
Planet Source Code - http://www.pscode.com
Developers Dex - http://www.codecomments.com
Developer Fusion - http://www.developerfusion.com
The Code Project - http://www.codeproject.com
Source Forge - http://www.sourceforge.net
Kind Regards,
Andrew.
In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>thanks for that, is there some code/software or a web site that i could use
>to help me, hook Exchange into a backend database like MSDE? i want the data
>to be live/link not copy if possible in to the Database?
>Jonathan
>"Andrew D. Newbould" wrote:
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com
|||hi there,
I am going to be builting this apps in VB6!!
Jonathan
"Andrew D. Newbould" wrote:

> It depends on the programming language you want to use. However, try
> these sites out for starters as they cover more than one programming
> language:
> Planet Source Code - http://www.pscode.com
> Developers Dex - http://www.codecomments.com
> Developer Fusion - http://www.developerfusion.com
> The Code Project - http://www.codeproject.com
> Source Forge - http://www.sourceforge.net
> Kind Regards,
> Andrew.
>
> In message <65FEA908-558A-4B05-8ACF-93EA81C5D17D@.microsoft.com>, dorling
> <dorling@.discussions.microsoft.com> writes
> --
> Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
> ZAD Software Systems Web : www.zadsoft.com
>
|||Then also check out these other good sites:
VB Net - http://vbnet.mvps.org
VB City - http://www.vbcity.com
VB IP - http://www.vbip.com
Kind Regards,
Andrew
In message <D1A6DB20-A3B8-4A77-ADEA-3A423B54D664@.microsoft.com>, dorling
<dorling@.discussions.microsoft.com> writes[vbcol=seagreen]
>hi there,
>I am going to be builting this apps in VB6!!
>Jonathan
>"Andrew D. Newbould" wrote:
<Snip>
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com