By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,841 Members | 1,115 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,841 IT Pros & Developers. It's quick & easy.

Complicated web-Access question

P: n/a
I have several Access databases that I want to publish (or make
available) through our web-pages. The problem...our web server is on
a Linux-Apache machine while our Access db is obviously on a Windows
(2000) machine...all on the same network.

Short of rebuilding my databse on MySQL/etc is there any way to
"point" a PHP web application through the Linux webserver to the
Access db on the Windows box?
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the SAMBA networking s/w to cross the Linux/MS barrier.

I know you can make client/server programs using Perl sockets & you
can open an Access db using the Perl DBI (see the O'Reilly book
_Programming the Perl DBI_ for info).

MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP8I8KIechKqOuFEgEQIdiACg3l/r69QwQ++Zqacppvirrb27JXMAn3+r
sce+uwPZhM5D41jR+8EM9wqw
=CS3x
-----END PGP SIGNATURE-----

SJ Mo2 wrote:
I have several Access databases that I want to publish (or make
available) through our web-pages. The problem...our web server is on
a Linux-Apache machine while our Access db is obviously on a Windows
(2000) machine...all on the same network.

Short of rebuilding my databse on MySQL/etc is there any way to
"point" a PHP web application through the Linux webserver to the
Access db on the Windows box?


Nov 12 '05 #2

P: n/a
DFS
I think you can use the Java JDBC-ODBC bridge driver to read/edit an Access
db from Java code
"SJ Mo2" <sj***@hotmail.com> wrote in message
news:ed**************************@posting.google.c om...
I have several Access databases that I want to publish (or make
available) through our web-pages. The problem...our web server is on
a Linux-Apache machine while our Access db is obviously on a Windows
(2000) machine...all on the same network.

Short of rebuilding my databse on MySQL/etc is there any way to
"point" a PHP web application through the Linux webserver to the
Access db on the Windows box?

Nov 12 '05 #3

P: n/a
Hi,

merging your DB to MySQL on linux would definitely be the easiest way.
However,
you can interface your linux box quite easily with the serverside .mdb
datasets. There is the possibility to setup an odbc/odbc bridge. You
can interface an odbc with a native MS Access DSN on the serverside,
then talking to the very same bridge with a clientside odbc from
linux. You can find the
required components at http://www.openlinksw.com (Mulit-Tier Driver
Suite).

Feel free to post any further questions you might have.

Kind Regards,
Jan
"DFS" <no******@nospam.com> wrote in message news:<vs************@corp.supernews.com>...
I think you can use the Java JDBC-ODBC bridge driver to read/edit an Access
db from Java code
"SJ Mo2" <sj***@hotmail.com> wrote in message
news:ed**************************@posting.google.c om...
I have several Access databases that I want to publish (or make
available) through our web-pages. The problem...our web server is on
a Linux-Apache machine while our Access db is obviously on a Windows
(2000) machine...all on the same network.

Short of rebuilding my databse on MySQL/etc is there any way to
"point" a PHP web application through the Linux webserver to the
Access db on the Windows box?

Nov 12 '05 #4

P: n/a
Interestingly, Java interfaces just fine with Access. Here is a sample
JSP which calls a Java Bean that uses Access:

<html>
<head>
<title>Insert Records</title>
</head>
<%@ page import="java.sql.*" %>
<body>
<h2>asdkjasdflkj</h2>
<jsp:setProperty name="updateUser" property="dsn" value="<%=
application.getRealPath("/mydb.mdb") %>" />
<br>
</body>
</html>

package project2; //java bean

import java.util.*;
import java.net.*;
import java.io.*;
import java.sql.*;

public class SqlBean2 implements Serializable
{
private String dsn = "jdbc:odbc:;DRIVER=Microsoft Access Driver
(*.mdb);DBQ=";
private String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

public void setDsn(String dsn){this.dsn = this.dsn + dsn;}

public String AddRec()
{
try
{
Class.forName(this.driver);
Connection con;
con = DriverManager.getConnection(this.dsn);
Statement Stmt = con.createStatement();
Stmt.executeUpdate("Insert Into tblmydb(Name) Values('Bill')");
con.close();
}
catch(Exception e){return "ERROR: " + e;}
return "";
}
}

I could get into this more, but hey, it's an Access NG :). Just giving
you an idea how you could use Access with Apache Tomcat or Resin. Note:
this sample doesn't display anything on the webpage, just adds a record
to an Access mdb from a jsp webpage. But you get the idea.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.