Microsoft access error

[danbou]

I get this error trying to map a microsoft access database with cold fusion 18 dev. edition on windows 10,64 bits....

Connection verification failed for data source: Labarque

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.

The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.

[BKBK]

Please show us a printscreen of the datasource settings for Labarque.

[danbou]

is this what you mean ?

thanks

[BKBK]

Thanks for that. However, I meant the settings for Labarque in the ColdFusion Administrator.

[danbou]

oh sorry...do you mean this:

thanks

[danbou]

and more settings...

[BKBK]

Yes, those are the settings I meant. Before we go any further, is there any particular reason you're sticking with MS Access? if your provider offers MySQL, say, you should go with that.

[danbou]

Yeah...i guess i will have to...

Now, got to do some research about conversion... 

[Charlie Arehart]

Folks, I would point out that cf2018 doesn't list ms access as a supported db any longer:

https://helpx.adobe.com/pdf/coldfusion2018-support-matrix.pdf

So I don't know if you're going to get this working. Even in 2016 and 11 it took extra steps. Danbou,  what were you using before 2018?

[danbou]

I got it to work with 11...with some tweakings that don't work anymore...i thought there would be a way...

[danbou]

also, hostek who is hosting my application runs with CF16 and it works with my access database...

I guess i could install cf16 dev. edition on my computer if I knew I could get it to work with my access databases...

thanks for your replies...