MEGA Search
20.3 Million

Sign Up
From: Nick Soethof  
Subject: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 13-Sep-2006 at 7:51:43 PST 
I'm trying to make a product vista certified and our product uses interbase 7.1.0.189. 

The problem though is that, although the service is started autmatically, I need to start it manually via the console in order to work correctly.

The log file came up with just the usual:
  SERVER/set_process_affinity: setting ProcessAffinityMask to 1
  Guardian starting: C:\Program Files\Interbase corp\Interbase\Bin\ibserver.exe

Is there a way to fix this problem?
From: Nick Soethof  
Subject: Re: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 13-Sep-2006 at 9:23:3 PST 
"Craig Stuntz [TeamB]"  wrote:
>	Can you clarify what the problem is? I can't tell from your message.
>
>-- 
>Craig Stuntz [TeamB] ˇ Vertex Systems Corp. ˇ Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>Please read and follow Borland's rules for the user of their 
>  server: http://support.borland.com/entry.jspa?externalID=293

the service is set to autmatic and claims to be "started" (according to the services manager) although it does not run. When I start my application I get an error that I can't connect to the database (which seems logical because interbase isn't running).

When I connect to the database manually via IBcons.exe it notifies me the following: "The server has not been started. Would you like to start it now?". After starting it manually, my application works fine.


So the problem is that although the services manager is claiming it's running, it is not. Resulting in a problem opening the database in my application. I haven't had this problem in Windows XP sp2
From: Nick Soethof  
Subject: Re: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 13-Sep-2006 at 10:2:7 PST 
What do you see in interbase.log? Also, which edition of IB are you
>using?
>
>-- 
>Craig Stuntz [TeamB] ˇ Vertex Systems Corp. ˇ Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>How to ask questions the smart way:
>  http://www.catb.org/~esr/faqs/smart-questions.html


interbase 7.1.0.189. 
The log file:
  SERVER/set_process_affinity: setting ProcessAffinityMask to 1
  Guardian starting: C:\Program Files\Interbase corp\Interbase\Bin\ibserver.exe

Eventviewer came up with the following:

 InterBaseServer error: 1063 
   StartServiceCtrlDispatcher failed
From: Nick Soethof  
Subject: Re: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 14-Sep-2006 at 2:53:50 PST 
>	That can't be all of it.
>
>-- 
>Craig Stuntz [TeamB] ˇ Vertex Systems Corp. ˇ Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>Useful articles about InterBase development:
>  http://blogs.teamb.com/craigstuntz/category/21.aspx

Entire interbase.log

VISTA-PC (Server)	Fri Sep 08 15:53:19 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Fri Sep 08 15:53:19 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Fri Sep 08 15:53:20 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Client)	Fri Sep 08 16:06:52 2006
	C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe: normal shutdown


VISTA-PC (Server)	Fri Sep 08 16:06:53 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Fri Sep 08 16:06:53 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Fri Sep 08 16:13:48 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Mon Sep 11 11:38:44 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Mon Sep 11 11:38:44 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Mon Sep 11 11:38:44 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Mon Sep 11 14:07:48 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Mon Sep 11 14:07:48 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Mon Sep 11 14:07:49 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Mon Sep 11 14:23:06 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Mon Sep 11 14:23:06 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Mon Sep 11 14:23:06 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Mon Sep 11 14:31:38 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Mon Sep 11 14:31:38 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Mon Sep 11 14:31:39 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Mon Sep 11 14:59:30 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Mon Sep 11 14:59:30 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Mon Sep 11 14:59:31 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Mon Sep 11 15:25:53 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Mon Sep 11 15:25:53 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Mon Sep 11 15:25:54 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Tue Sep 12 15:56:18 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Tue Sep 12 15:56:18 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Tue Sep 12 15:56:20 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Tue Sep 12 16:07:49 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Tue Sep 12 16:07:49 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Tue Sep 12 16:07:50 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Wed Sep 13 08:23:30 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Wed Sep 13 08:23:30 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Wed Sep 13 08:23:30 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Client)	Wed Sep 13 14:31:24 2006
	C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe: normal shutdown


VISTA-PC (Server)	Wed Sep 13 14:31:25 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Wed Sep 13 14:31:25 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Server)	Wed Sep 13 15:33:51 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Wed Sep 13 15:33:51 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Wed Sep 13 15:33:52 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Client)	Wed Sep 13 16:32:12 2006
	C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe : The guardian was unable to launch the server thread. errno : 1053

VISTA-PC (Server)	Wed Sep 13 16:37:37 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Wed Sep 13 16:37:37 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Wed Sep 13 16:37:38 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe


VISTA-PC (Server)	Wed Sep 13 16:50:51 2006
	Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000, SWEEP_YIELD_TIME to 1 ms
                        and MAX_THREADS to 1


VISTA-PC (Server)	Wed Sep 13 16:50:51 2006
	SERVER/set_process_affinity: setting ProcessAffinityMask to 1

VISTA-PC (Client)	Wed Sep 13 16:50:52 2006
	Guardian starting: C:\Program Files\Interbase Corp\Interbase\Bin\ibserver.exe
From: Nick Soethof  
Subject: Re: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 14-Sep-2006 at 8:29:52 PST 

>	OK, I see this over and over again in your log: Setting the affinity
>mask, then the server apparently crashes and Guardian tries to restart
>it.
>
>	Now Vista isn't a supported OS, being pre-release and all, but I can't
>think of a reason why IB shouldn't work on it.
>
>	So some additional questions:
>
>o  Does IB work if you start the Guardian service manually via the
>service control manager (Control Panel->Administrative Tools->Services)
>instead of automatically at system startup?
>
>o  What is the contents of your IBConfig?
>
>	-Craig
>
>-- 
>Craig Stuntz [TeamB] ˇ Vertex Systems Corp. ˇ Columbus, OH
>  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
>Borland newsgroup denizen Sergio González has a new CD of 
>  Irish music out, and it's good: http://tinyurl.com/7hgfr


1) I've disabled automatic startup, restarted the computer, started the service (the guardian) manually but still no luck. 
Both processes (ibguard.exe & ibserver.exe) are running but I'm not logged in to the database


2) Followed my ibconfig. I've removed the comments from it.
#ADMIN_DB                  "admin.ib"

#ANY_EVENT_MEM_SIZE	   32768

#ANY_LOCK_MEM_SIZE	   98304

#ANY_LOCK_SEM_COUNT	   32

#ANY_LOCK_SIGNAL	   16

#CPU_AFFINITY			

#CONNECTION_TIMEOUT 	   180

#DATABASE_CACHE_PAGES 	   2048

#DEADLOCK_TIMEOUT	   10 

#DUMMY_PACKET_INTERVAL	0 

#ENABLE_HYPERTHREADING   	 1

#EXTERNAL_FILE_DIRECTORY

#EXTERNAL_FUNCTION_DIRECTORY

#LOCK_ACQUIRE_SPINS 	   0

#LOCK_HASH_SLOTS 	   101

#MAX_THREADS		   1000000

#SERVER_CLIENT_MAPPING 	   4096

#SERVER_PRIORITY_CLASS 	   1

#SERVER_WORKING_SIZE_MAX   0

#SERVER_WORKING_SIZE_MIN   0

#SORTMEM_BUFFER_SIZE	   1048500

#SWEEP_QUANTUM		   250

#SWEEP_YIELD_TIME	   1

#TCP_REMOTE_BUFFER         8192

#TMP_DIRECTORY 

#USER_QUANTUM		   1000

#V4_EVENT_MEMSIZE 	   32768

#V4_LOCK_GRANT_ORDER 	   1

#V4_LOCK_MEM_SIZE 	   98304

#V4_LOCK_SEM_COUNT	   32

#V4_LOCK_SIGNAL 	   16

#V4_SOLARIS_STALL_VALUE    60
From: Nick Soethof  
Subject: Re: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 14-Sep-2006 at 3:5:36 PST 
"Dan Palley"  wrote:
>Are you running in a Remote Desktop session?  Sounds like you cannot access 
>interbase locally.  Try connecting to it as a remote server using LOCALHOST: 
>as the server name.
>
>Dan

I'm running it locally. Remote would be the next step. In IBcons.exe there is a local server but it is not started. In windows XP, it was.
From: Nick Soethof  
Subject: Re: Interbase 7.1 won't start as a service in Windows Vista
NewsGroup: borland.public.interbase.general
Date Posted: 15-Sep-2006 at 7:53:9 PST 
>Ok, it looks like Fast User Switching is enabled in all versions of Vista 
>(unlike just home in XP) and cannot be disabled (as far as I can tell). 
>When Fast User Switching is enabled, you won't be able to connect to 
>Interbase via a local connection (fast user switching uses Remote Desktop).
>
>For now, you'll need to prefix your database alias with LOCALHOST: and 
>create a remote connection in IB Console to access Interbase.
>
>I created a QC entry to alleviate this problem 
>(http://qc.borland.com/wc/qcmain.aspx?d=11504), but it was marked as 'Won't 
>Do' saying Terminal Server is not supported.  I think Interbase folks need 
>to revisit this issue, as it's only going to get worse with Vista.
>
>Dan 

)If I see it correctly, I need to register a server and make it remote instead of local and set up my host name as LOCALHOST? 

)I've tried that and I still need to log in manually to be able to connect to the database. But I appriciate your effort :)

I, myself, don't have an account to access QC :(.