db

Question

i want to connect to ms access databse when i run odbcad32.exe in the userdsn tab i get list 3 drivers but when i click on system dsn there is no list of drivers(empty) is it becuse there is no driver installed if so plz provide me the link where i can find it.

Answer 1

Hi  goofy nemo,

What is your operating system version and the access version? If you are using Office 2010 or later, which version is installed (32/64b bit)? Which version do you want to use 32/64bit?

Moderators, please move the thread to a more appropiate forum.

thanks,

Janos

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog

Answer 2

Hello Janos ,

What forum are you suggesting? Access for Developers  or another one ?  

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 3

Hi goofy nemo,

Could you please elaboreate  a bit? Which version of Windows are you using?

For “no driver installed”, do you mean the System Data Sources list is empty? If there is no system DSN created on your machine, the list is empty and you need to click the Add button to create one.

Which driver are you trying to use? There is no a x64 version of Jet ODBC driver/OLE DB Provider. If you are using a 64-bit version of Windows, please download and install Microsoft Access Database Engine 2010 Redistributable from: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255

For more information, please see: http://blogs.msdn.com/psssql/archive/2010/01/21/how-to-get-a-x64-version-of-jet.aspx

This forum is for posting questions about data access to SQL Server, if your problem is not related to SQL Server, I would suggest you start a thread in an Office forum for more help. 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Get or Request Code Sample from Microsoft
If you have any feedback, please tell us.