(Msg. 1) Posted: Thu Jul 03, 2008 2:00 pm
Post subject: Ms Access JDBC Driver? Add to elertz Archived from groups: microsoft>public>access (more info?)
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.
(Msg. 2) Posted: Thu Jul 03, 2008 5:35 pm
Post subject: Re: Ms Access JDBC Driver? Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
"metaltecks" <metaltecks.RemoveThis@discussions.microsoft.com> wrote in message
news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57@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
(Msg. 3) Posted: Sat Jul 05, 2008 12:27 am
Post subject: Re: Ms Access JDBC Driver? Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@discussions.microsoft.com> wrote in message
news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57@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
(Msg. 4) Posted: Mon Jul 07, 2008 7:49 am
Post subject: Re: Ms Access JDBC Driver? Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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@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.RemoveThis@discussions.microsoft.com> wrote in message
> news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57@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
>
>
>
(Msg. 5) Posted: Tue Jul 08, 2008 3:00 am
Post subject: Re: Ms Access JDBC Driver? Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.TakeThisOut@discussions.microsoft.com> wrote in message
news:77B07547-90BD-46E6-A508-0244E64CB8A9@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@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.TakeThisOut@discussions.microsoft.com> wrote in message
> > news:DBFBD140-2C33-49DD-AB33-0F0A0764FE57@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
> >
> >
> >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other