in reply to Re: How can I connect/access an MS access database from solaris?
in thread How can I connect/access an MS access database from solaris?

In talking with a DBA friend of mine, we've both confirmed that I won't be able to connect to the DSN/ODBC for the MS Access database file.

While your suggestion of a proxy is a good one, I don't have control over the server that file will be on - in the manner of installing a proxy.

I may need to consider the option of using a SQL Server, or having some ASP code that I POST my record info, and the ASP page inserts it to the local Access database file.

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

Replies are listed 'Best First'.
Re: Re: Re: How can I connect/access an MS access database from solaris?
by hiseldl (Priest) on Sep 10, 2002 at 19:18 UTC
    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

      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?

          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)) _ ) %>
        Where your module would take your data and put it into Access.

        --
        hiseldl
        "Act better than you feel"

Re: Re: Re: How can I connect/access an MS access database from solaris?
by richardX (Pilgrim) on Sep 11, 2002 at 00:15 UTC
    FYI

    MSDE 2000 is a free Microsoft baby brother to SQL 2000. It runs on the desktop but it limits the number of connections. I don’t know if it will run on as a server for Internet connections. But for local database applications under Windows, it can be valuable since it is royalty free and you can include it with your application.

    Richard

    There are three types of people in this world, those that can count and those that cannot. Anon