Starting dbiproxy as a Win32 Service

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

I have an Access database on an XP machine and I use DBI proxying to access it over the network. I run dbiproxy on the XP machine manually. This works fine except that someone has to run the dbiproxy script everytime the machine is rebooted or the DOS window is closed accidently.

I tried to run the dbiproxy script as a Service using the Win32::Daemon module from roth.net. The Service setup seems to work and the DBI::ProxyServer seems to be running on the specified localport, but I got the following errors:

failed: Cannot log in to DBI::ProxyServer: Refused by server: User  is
+ not permitted to connect. at /xxx/perl-5.8.4/lib/site_perl/5.8.4/RPC
+/PlClient.pm line 82.
 at ./testdb.pl line 7
[download]

Cannot log in to DBI::ProxyServer: Refused by server: User  is not per
+mitted to connect. at /xxx/perl-5.8.4/lib/site_perl/5.8.4/RPC/PlClien
+t.pm line 82.
[download]

Any help? Thanks.

2005-04-06 Janitored by Arunbear - added code tags, as per Monastery guidelines

Comment on Starting dbiproxy as a Win32 Service Select or Download Code

Replies are listed 'Best First'.
Re: Starting dbiproxy as a Win32 Service by Anonymous Monk on Apr 06, 2005 at 23:36 UTC
I would investigate the reason User is not permitted to connect.	[reply]
Re: Starting dbiproxy as a Win32 Service by Anonymous Monk on Apr 07, 2005 at 16:52 UTC
I tried without a success to figure out what was causing the error. Is there any other way that I can start dbiproxy as Service so that I don't have manually run it in DOS? Thanks.	[reply]