MSAccess Problem solved (was Simultaneous access: Perl (DBD::ODBC) and C# (ODBC))

MSAccess Problem solved (was Simultaneous access: Perl (DBD::ODBC) and C# (ODBC))

Post by info » Mon, 31 Oct 2005 02:11:27

Thanks Timothy,
I tried subscribing but the list server does not appear to be working.
Hmmm.. well maybe I'm mistaken. I just tried again and it sent me a
confirmation this time.

I figured out my problem: Microsoft Access does not use the traditional
architecture where clients use pipes or sockets to connect to a process on a
(possibly) remote machine. Instead it creates a temporary file with the
extension of ldb.

If users from two different accounts have access to the database file
because the administrator granted them access, the second user will still
have a problem because he won't be able to access the temporary ldb file
created by the first user.

My solution is to have everyone use the same account. This works because in
my situation, one user is a web server and the other user is a batch job
that runs every couple of hours.


-----Original Message-----
From: Timothy Johnson [mailto: XXXX@XXXXX.COM ]
Sent: Thursday, October 20, 2005 3:54 PM
To: Siegfried Heintze; XXXX@XXXXX.COM
Subject: RE: Simultaneous access: Perl (DBD::ODBC) and C# (ODBC)

I have two suggestions:

One is to go to and sign up for the dbi-users
mailing list.

Two is just a thought, but have you tried using DBD::ADO instead of

-----Original Message-----
From: Siegfried Heintze [mailto: XXXX@XXXXX.COM ]
Sent: Thursday, October 20, 2005 2:15 PM
Subject: Simultaneous access: Perl (DBD::ODBC) and C# (ODBC)

<snip>DBD-ADO interaction issue</snip>

1. DBD::ODBC looks in /etc not /usr/local/etc for odbc files

2. Ingres and ODBC Date problems from W2K ODBC access.


We run an ingres 2.6 database on an AIX server.

The ingres database is accessed via ODBC calls from a W2K server

A problem we have just encountered is that the binary dll's return a
different date format

to the ASP script code.

binary dll date format DD/MM/YYYY hh:mm:ss
ASP script date format MM/DD/YYYY hh:mm:ss

I'm really stumped as to why the dates would be returned any
differently. If anyone has

any ideas or suggestions I would really appreciate the help, Im really
stuck on this one.

Thank you

3. [dbi] DBD::ODBC with Perl 5.8.8

4. perl DBI,DBD::ODBC installation help

5. DBD::ODBC works in perl 5.8.7 but fails in 5.8.8 and above

6. newer version of perl dbd-odbc not working with dates

7. Perl DBI and DBD::ODBC for Oracle on Windows

8. [dbi] DBD::ODBC for Solaris 2.9 Perl 5.6.1 or 5.8.2

9. Perl crashes with DBD::ODBC to SQL server

10. SAS Access to PC File Formats, Access to Oracle (or ODBC) and SAS-ODBC

11. ODBC - Correct solution for passing a date field to Informix via ODBC and C#.NET

12. Unicode patch for DBD::ODBC (was: DBD.Ingres 0.51 unicode support)

13. DBD::Sybase / DBD::ODBC + FreeTDS woes - placeholders and implicit datatype conversions

14. DBD::ODBC vs. DBD::ADO

15. DBD::oracle DBD::ODBC DBI