[erlang-questions] ODBC Connection Error to MS Access Database file (.mdb)

[Robert Raschke]

As far as I remember, there are four different places in MS land where DSNs
and drivers are defined: 32-bit system and user, 64-bit system and user.
And I think the Erlang odbc module needs the 32-bit system one.

This is from memory, so things could have moved on. But I would recommend
you try checking the drivers by explicitly running the 32-bit odbc driver
manager.

HTH,
Robby
 On May 24, 2014 11:18 AM, "austin aigbe" <eshikafe@REDACTED> wrote:

> I have the ODBC driver installed but I get the IM002 error. What could be
> wrong?
>
>
> 5> application:start(odbc).
> ok
> 6> odbc:connect("Driver={Microsoft Access Driver
> (*.mdb)};DBQ=mml_dump_20140523.mdb",[]).
> {error,"[Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified SQLSTATE IS: IM002 Connection to database failed."}
> 7>
>
>
>
>
> On Fri, May 23, 2014 at 5:44 PM, Sean Cribbs <sean@REDACTED> wrote:
>
>> It's saying you need to start the 'odbc' application:
>>
>> application:start(odbc).
>>
>>
>> On Fri, May 23, 2014 at 9:31 AM, austin aigbe <eshikafe@REDACTED> wrote:
>>
>>> Hi,
>>>
>>> How do I use the odbc module to connect to an access database file on my
>>> PC?
>>> The connect function gives me the following error:
>>>
>>> 4> odbc:connect("Driver={Microsoft Access Driver
>>> (*.mdb)};DBQ=mml_dump_20140523.mdb",[]).
>>> {error,odbc_not_started}
>>>
>>> Thanks.
>>>
>>> BR,
>>> Austin
>>>
>>>
>>> _______________________________________________
>>> erlang-questions mailing list
>>> erlang-questions@REDACTED
>>> http://erlang.org/mailman/listinfo/erlang-questions
>>>
>>>
>>
>>
>> --
>> Sean Cribbs <sean@REDACTED>
>> Software Engineer
>> Basho Technologies, Inc.
>> http://basho.com/
>>
>
>
> _______________________________________________
> erlang-questions mailing list
> erlang-questions@REDACTED
> http://erlang.org/mailman/listinfo/erlang-questions
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20140525/1e107aea/attachment.htm>