Re: Re: Re: How can I connect/access an MS access database from solaris?

If you can connect to the access database using ASP, then you should be able to run a CGI script. And, if you can run a CGI script you may be able to run the CGI as a SOAP service.

Your service could take your data as parameter(s) and store them in Access on the remote box. Take a look at Soap::Lite for Perl, there are some ASP examples there too.

--
hiseldl
"Act better than you feel" --inner prophet

Comment on Re: Re: Re: How can I connect/access an MS access database from solaris?

Replies are listed 'Best First'.
Re: Re: Re: Re: How can I connect/access an MS access database from solaris? by Anonymous Monk on Sep 10, 2002 at 20:14 UTC
ASP would be on the WinNT/IIS box. Perl CGI is being used on the Solaris/Apache box. Perl is not on the WinNT box. I'll take a look at the SOAP stuff. Though, wouldn't I need a web-service running on the WinNT box, waiting to hear the remote SOAP call from the Solaris box?	[reply]
Re: How can I connect/access an MS access database from solaris? by hiseldl (Priest) on Sep 10, 2002 at 20:29 UTC
wouldn't I need a web-service running on the WinNT box, waiting to hear the remote SOAP call from the Solaris box? Yes, you will need an ASP/VB SOAP server, here is the example from the SoapLite website: `<% Response.ContentType = "text/xml" Response.Write(Server.CreateObject("SOAP.Lite") _ .server("SOAP::Server") _ .dispatch_to("/Your/Path/To/Deployed/Modules") _ .handle(Request.BinaryRead(Request.TotalBytes)) _ ) %>` [download] Where your module would take your data and put it into Access. -- hiseldl "Act better than you feel"	[reply] [d/l]