Re: [OT] Connect to local linux ms access jet database via odbc from php or java
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 04/21/07 14:45, Mirko Scurk wrote:
> Ron Johnson wrote:
>>
>> On 04/20/07 16:05, Mirko Scurk wrote:
[snip]
>>>
>>> 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.
>>
>
> How come isql then works without daemon?
Because isql directly attaches to the mdb file, but odbc needs a
daemon listening on a port.
>> 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.
>>
>
> I had to write "extension" to application already running on jet database.
> Another words, I just need read-only access to mdb to get some data
> necessary to new application.
> Old application is windows-only application accessing to mdb file stored
> on linux samba server. I don't see any way to replicate mdb data
> constantly to postgres.
That's what I suspected...
> Searching Internet there are some (not to many) working examples of such
> setup but I can't get to those people. On unixodbc and sqlrelay sites
> there are explanations of working setups so I figure it's not impossible.
Looks like you might need to write your own. Or bite the bullet and
accept the pain that is Vendor Lock-in.
- --
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)
iD8DBQFGKoT5S9HxQb37XmcRAprDAJ4zKvU1MFVkUlKax3YMbpMbUIQwJQCgz2I3
43FbHXmy0/p0G4Ns+uFq/8Q=
=mWgd
-----END PGP SIGNATURE-----
Reply to: