Ms Access JDBC Driver?
in [General]
|
From: metaltecks on 3 Jul 2008 17:00 I have a Java product; Lawson, that is trying to connect to MS Access database on a network share. It is asking for the JDBC driver for it and i thought it was jdbc:odbc:JdbcOdbcDriver, but it keeps on telling me that the connection is failing. Can someone help me. Thank you
From: Arvin Meyer [MVP] on 3 Jul 2008 17:35 There is no JDBC driver that comes with Access (at least that I'm aware of) You'd have to get the driver from your language supplier. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "metaltecks" <metaltecks(a)discussions.microsoft.com> wrote in message news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57(a)microsoft.com... >I have a Java product; Lawson, that is trying to connect to MS Access > database on a network share. > It is asking for the JDBC driver for it and i thought it was > jdbc:odbc:JdbcOdbcDriver, but it keeps on telling me that the connection > is > failing. > > Can someone help me. > > Thank you
From: david on 4 Jul 2008 10:27 It could be that the connection is failing... Access/Jet/MDB is very sensitive to network connections. Any network problem is likely to cause an Access/Jet/MDB problem. Also, what kind of system is hosting the network share? Do you have full c/r/u/d permissions? Also, can you test the ODBC connection outside of the JDBC connection? Using something like Excel? (david) "metaltecks" <metaltecks(a)discussions.microsoft.com> wrote in message news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57(a)microsoft.com... > I have a Java product; Lawson, that is trying to connect to MS Access > database on a network share. > It is asking for the JDBC driver for it and i thought it was > jdbc:odbc:JdbcOdbcDriver, but it keeps on telling me that the connection is > failing. > > Can someone help me. > > Thank you
From: metaltecks on 7 Jul 2008 10:49 I have tested it out on the odbc administrator and do have full permissions to the share. The share is on a windows 2003 server. "david(a)epsomdotcomdotau" wrote: > It could be that the connection is failing... Access/Jet/MDB > is very sensitive to network connections. Any network > problem is likely to cause an Access/Jet/MDB problem. > > Also, what kind of system is hosting the network share? > Do you have full c/r/u/d permissions? > > Also, can you test the ODBC connection outside of > the JDBC connection? Using something like Excel? > > (david) > > "metaltecks" <metaltecks(a)discussions.microsoft.com> wrote in message > news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57(a)microsoft.com... > > I have a Java product; Lawson, that is trying to connect to MS Access > > database on a network share. > > It is asking for the JDBC driver for it and i thought it was > > jdbc:odbc:JdbcOdbcDriver, but it keeps on telling me that the connection > is > > failing. > > > > Can someone help me. > > > > Thank you > > >
From: david on 7 Jul 2008 19:06 If you've got any other kind of ODBC source, have you tried connecting to that, to see if you have a JDBC installation or configuration problem? Apart from that I'm out. Every ODBC connection problem I've ever seen with Access could be diagnosed and fixed from the ODBC administrator on the machine where the client is installed. If the Access connection connects there, anything can connect to it. The actual connection API is simple and standard, and nobody ever gets it wrong, so the chance that there is some internal bug with jdbc:odbc:JdbcOdbcDriver and the Access driver is zero. (david) "metaltecks" <metaltecks(a)discussions.microsoft.com> wrote in message news:77B07547-90BD-46E6-A508-0244E64CB8A9(a)microsoft.com... > I have tested it out on the odbc administrator and do have full permissions > to the share. The share is on a windows 2003 server. > > "david(a)epsomdotcomdotau" wrote: > > > It could be that the connection is failing... Access/Jet/MDB > > is very sensitive to network connections. Any network > > problem is likely to cause an Access/Jet/MDB problem. > > > > Also, what kind of system is hosting the network share? > > Do you have full c/r/u/d permissions? > > > > Also, can you test the ODBC connection outside of > > the JDBC connection? Using something like Excel? > > > > (david) > > > > "metaltecks" <metaltecks(a)discussions.microsoft.com> wrote in message > > news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57(a)microsoft.com... > > > I have a Java product; Lawson, that is trying to connect to MS Access > > > database on a network share. > > > It is asking for the JDBC driver for it and i thought it was > > > jdbc:odbc:JdbcOdbcDriver, but it keeps on telling me that the connection > > is > > > failing. > > > > > > Can someone help me. > > > > > > Thank you > > > > > >
|
Pages: 1 Prev: Grouping by common fields Next: Adding monthly records to quarterly |