Solved

Modify DSN to Conect Acess

  • 20 January 2021
  • 6 replies
  • 105 views
S

Good morning.

I am converting our proyects in AIMMS from version 3 to version 4 and the DSN that already was used to connect to Access has failed.

 

I used the extension (*.mdb), also tried with  (*.accdb) but doesn´t work.

 

Could you help?

Thanks a lot

icon

Best answer by deannezhang 20 January 2021, 16:27

View original

6 replies

deannezhang
Rank
Userlevel 4
Badge +3

Could it be something related to what is mentioned in this article https://how-to.aimms.com/Articles/129/129-MSACCESS-32bit-64bit.html ? 

S

Thanks a lot, we are using Office 365 32 bits. And AIMMS 4 64 bits. I believe

that might be the problem.

 

 

S

It seems impossible to connect AIMMS 64 bits to Access data (32 bits) through the DSN conector.

 

How should I modify the DSN?

 

Thanks a lot

J
Badge

Dear Sonia,

 

After .mdb on the last line of the dsn file I added an X, so:

.mdbX

 

In my case it works.

Good luck!

Joost

S

Dear Sonia,

 

After .mdb on the last line of the dsn file I added an X, so:

.mdbX

 

In my case it works.

Good luck!

Joost


Thanks a lot but it doesn´t work yet ;(

Are you using Office 2010 ? In my case is Office 365 (32 bits)

 

J
Badge

I'm using Office 365 but 64 bits. When I used 32 bits before I used a 32 bits version of AIMMS and a 64 bits version. I read in the database using 32 bit, stored the data in a case, closed AIMMS 32 bits, opened AIMMS 64 bit and read in the case. This is of course quite cumbersome.

Reply


Terms & Conditions

Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator