MS Access 2010 as a frontend to Oracle Database format error

[alcalina]

acess.png

Good morning

I create a table using an oracle database
And I am using MS Access 2010 as a fronten.

The information is correct in oracle but when I see in the access I get this error.

As you can see in the image, the black part is the oracle and the white one is on acess.

I do not know how to fix or how to look.

Is it possible to be some kind of problem to convert beteween 0,1 and 0.1?
.
If it is this, I do not know how to configure the ms access.


I am still reading
http://www.linkedin.com/groups/Probl...37.S.202234741

I am trying to replicate the solution, but so far nothing.

[ranman256]

It could be your ODBC version connection.

[alcalina]

Solved:
I changed the tnsnames.ora

aliastoconnect =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = blabla)
)
)

I changed to service_name instead sid
And I use the microsoft obdc driver instead using the oracle driver to connect to access.

in the access just put the name, username and server. It needs to put in the server the aliastoconnect