Re: [OT] Connect to local linux ms access jet database via odbc from php or java
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 04/20/07 16:05, Mirko Scurk wrote:
> Hi!
>
> I originally sent this post to unixodbc support list but received no
> answer. Its crucial to me to solve this problem so any help will be
> apreciated.
>
> I spent some time googling and trying to establish connections from linux
> pc to local mdb file but had no luck. Here is my configuration:
>
> Ubuntu edgy 2.6.17-10-generic #2 SMP
Why aren't you asking the Ubuntu forums? We don't ask Debian
questions there.
Anyway, see below for my resonses.
> unixodbc 2.2.11-13
> unixodbc-bin 2.2.11-13
> libmdbodbc 0.5.99.0.6pre1.0.20051109-3
> libmdbtools 0.5.99.0.6pre1.0.20051109-3
> mdbtools 0.5.99.0.6pre1.0.20051109-3
> mdbtools-gmdb 0.5.99.0.6pre1.0.20051109-3
>
> # cat /etc/odbc.ini
[snip]
> +-----------+
> SQLRowCount returns 34
> 34 rows fetched
>
> What am I doing wrong?
> Is it even possible to connect from php to mdb?
> Do I have to buy some drivers?
> Is it possible to connect from netbeans to this odbc dns via jdbc-odbc
> without some special additional drivers?
Does mdbtools supply a daemon? If not, you might have to write your
own.
More fundamentally, though, is: why are you leaving this data in mdb
format? mdbtools is designed for extracting data so you can convert
it to robust RDBMSs like PostgreSQL or SQLite3.
- --
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGKTwLS9HxQb37XmcRAjF+AKDcYS3nCm5PzZDtpLb9jS1Fb+kZQACgvWiJ
5FybmPPf4C6+k1KNr1os8MU=
=tUDR
-----END PGP SIGNATURE-----
Reply to: