Ask Your Question
1

Can't Connect to Access Database

asked 2017-04-22 19:22:59 +0200

toml_12953 gravatar image

I'm using Windows 10 (64-bit) and when I try to connect to an Access database, I get

"The connection could not be created. May be the necessary data provider is not installed."

Windows 10 doesn't use ODBC so how can I connect to Access? I'm using LO 5.3.2.2 (x64)

edit retag flag offensive close merge delete

Comments

Suggest you get ODBC datasource (connectors) defined as @peterwt has pointed you to below. Then test using Access: create link, select type (at bottom of file window that opens) of ODBC (it's way at the bottom of the list, at the bottom of the screen), then select your newly created ODBC datasource and the table to link to and test it out. That will work you thru the ODBC maze so you can see how it works. Then once you have this working, try to use LO with an ODBC datasource.

EasyTrieve gravatar imageEasyTrieve ( 2017-05-26 14:56:45 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2017-05-24 06:06:23 +0200

EasyTrieve gravatar image

Hi,

Please search this forum for an answer, as this issue is not a new one. For example, here is one such finding that might answer your question that I noticed when I entered Access into the search box above.

Then if you get stuck again, feel free to come back here and ask about that specific issue.

edit flag offensive delete link more
0

answered 2017-05-24 13:53:55 +0200

peterwt gravatar image

updated 2017-05-25 17:24:38 +0200

ODBC is in Windows 10 - see here

edit flag offensive delete link more

Comments

@peterwt, Have you actually tried ODBC lately? I tried it some time ago from Linux and I ran into a bug that I reported and was confirmed and to my knowledge has never been fixed. I have been assuming it does not work. ??

EasyTrieve gravatar imageEasyTrieve ( 2017-05-25 12:55:08 +0200 )edit

@EasyTrieve I was pointing out that ODBC is in Windows 10 as the poster said "Windows 10 doesn't use ODBC".

peterwt gravatar imagepeterwt ( 2017-05-25 13:19:40 +0200 )edit

@peterwt, ok. I see. Also your link above doesn't work for me (is broken).

EasyTrieve gravatar imageEasyTrieve ( 2017-05-25 13:35:50 +0200 )edit

@EasyTrieve Updated link.

peterwt gravatar imagepeterwt ( 2017-05-25 17:26:02 +0200 )edit

@peterwt I got 'The specified DSN contains an architecture mismatch between the driver and application'. LO is 64-bit whereas the driver is 32-bit (no 64-bit ODBC driver - by default). For this you need this package.

grahamh gravatar imagegrahamh ( 2017-06-29 12:54:20 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-22 19:22:59 +0200

Seen: 1,804 times

Last updated: May 25 '17