[no subject]

--
Jonathan


On Fri, 25 Mar 2005 10:53:41 -0800 (PST), Kevin O'Neill Stoll
<kevinostoll at yahoo.com> wrote:
> Thinking out of the box here but ....
> 
> You could convert your Access Database to Mysql using this
&gt; tool: <a  rel="nofollow" href="http://www.convert-in.com/acc2sql.htm";>http://www.convert-in.com/acc2sql.htm</a>
&gt; 
&gt; I know you said you have to use Access but stay with me
&gt; here...
&gt; 
&gt; Write your app on linux, all reads, writes, deletes occur
&gt; on the linux/mysql master database. Then, using
&gt; <a  rel="nofollow" href="http://www.mysql.com/products/connector/odbc/";>http://www.mysql.com/products/connector/odbc/</a> MySQL's ODBC
&gt; connector, installed on the NT box - map all of your tables
&gt; in the Access database to this datasource.
&gt; 
&gt; This preserves all of your queries, reports, macros,
&gt; etc.... in access but allows you to write your app in
&gt; linux. If fact I use a versus of this for a person in my
&gt; office who does nothing but write reports from the master
&gt; data on a linux box, running mysql and a web based java
&gt; app. Works very well.
&gt; 
&gt; Also, if you are worried about the impact that the access
&gt; queries/actions will have on the live application you could
&gt; replicate the data to a local copy on the nt host and have
&gt; the access database point it's odbc to localhost:3306.
&gt; 
&gt; And, to address security ...
&gt; 
&gt; If you use the replication technique just replication over
&gt; built in ssl in mysql. Or in the 1st example just an ssh
&gt; tunnel to connect to the linux/mysql instance, the later
&gt; being how I do it.
&gt; 
&gt; Hope that helps.
&gt; 
&gt; 
&gt; --- gchendry at bellsouth.net wrote:
&gt; &gt; Need to connect to a MS Access database from Linux
&gt; &gt;
&gt; &gt; Specifics:
&gt; &gt; Yes, I have to use MS Access : (
&gt; &gt;
&gt; &gt; I have a Linux server that has a samba mounted directory
&gt; &gt; from a NT server containing the MS Access database. Thus
&gt; &gt; I have local access to the database file.
&gt; &gt; I want to write standalone Java and tomcat:JSP programs
&gt; &gt; on the Linux server to access this database.
&gt; &gt;
&gt; &gt; I have been reading a lot of forms on this issue, and
&gt; &gt; most if not all solutions contain middleware running on
&gt; &gt; the MS platform to listen for jdbc remote calls.
&gt; &gt; I would like to stay away from any and all MS dependant
&gt; &gt; components.
&gt; &gt; Warning, there are some java examples on the web on how
&gt; &gt; to do this but they are for a  MS platform, they don't
&gt; &gt; tell you that and lead you to think it is a solution.
&gt; &gt;
&gt; &gt; The best solution I see available right now is :RmiJdbc :
&gt; &gt; Client/Server JDBC Driver Based on Java RMI :
&gt; &gt; <a  rel="nofollow" href="http://rmijdbc.objectweb.org/";>http://rmijdbc.objectweb.org/</a>
&gt; &gt; It is free, but requires a middleware component running
&gt; &gt; on the MS server side.
&gt; &gt;
&gt; &gt; Need Ideas, anybody have any?
&gt; &gt;
&gt; &gt; If it comes down to buying an ODBC driver I'll do it. 've
&gt; &gt; tried to find one,  but reading through all the red tape
&gt; &gt; to find what I need is a time synch.  Recommendations?
&gt; &gt;
&gt; &gt;
&gt; &gt; _______________________________________________
&gt; &gt; Ale mailing list
&gt; &gt; Ale at ale.org
&gt; &gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt; &gt;
&gt; 
&gt; Kevin Stoll
&gt; <a  rel="nofollow" href="http://kevinstoll.com/";>http://kevinstoll.com/</a>
&gt; 
&gt; OpenSource Software...FREE!
&gt; Angering Bill Gates...priceless.
&gt; ============================================================
&gt; 
&gt; 
&gt; __________________________________
&gt; Do you Yahoo!?
&gt; Yahoo! Mail - Helps protect you from nasty viruses.
&gt; <a  rel="nofollow" href="http://promotions.yahoo.com/new_mail";>http://promotions.yahoo.com/new_mail</a>
&gt; _______________________________________________
&gt; Ale mailing list
&gt; Ale at ale.org
&gt; <a  rel="nofollow" href="http://www.ale.org/mailman/listinfo/ale";>http://www.ale.org/mailman/listinfo/ale</a>
&gt;


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00475" href="msg00475.html">[ale] Need to connect to a MS Access database from Linux</a></strong>
<ul><li><em>From:</em> kevinostoll at yahoo.com (Kevin O'Neill Stoll)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00480.html">[ale] Need to connect to a MS Access database from Linux</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00482.html">[ale] Any redistributable ISOs of current RedHat?</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00475.html">[ale] Need to connect to a MS Access database from Linux</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00476.html">[ale] PSC 1350 and ptal</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00481"><strong>Date</strong></a></li>
<li><a href="threads.html#00481"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>