[egenix-users] mx.ODBCConnect vs mx.ODBC, why am I seeing
tentin.quarantino at gmail.com
Mon Mar 23 14:39:17 CET 2009
>> Could the null UID cause a problem for mx.ODBCConnect?
> It is possible that the Access driver defaults to the login name
> of the user accessing the database on the server. Since the mxODBC
> Connect Server runs as service, the user account name is different
> than the one you use to log in to the machine.
> To prevent such problems, always provide a full UID in the connection
As I am accessing the database of a 3rd party,
then I would need to persuade the 3rd party to
use a username. Thanks for the advice.
It was not until I tried using a different Windows
box, that I was able to get things to work.
It would appear your speculation regarding the cause
is likely correct.
More information about the egenix-users