Hi,

I'm trying to connect to Ms Access database throug webfocus using the ODBC/Ms Access adapter connection. But since the MS access file is in a ".accdb" file format when testing the adapter conneciton I'm getting the following message.

FOC1394) CONNECT FAILURE
(FOC1400) SQLCODE IS -1028 (HEX: FFFFFBFC)
: [S1000] [Microsoft][ODBC Microsoft Access Driver] Cannot open database '
: (unknown)'. It may not be a database that your application recognizes,
: or the file may be corrupt. [IM006] [Microsoft][ODBC Driver Manager] Dri
: ver's SQLSetConnectAttr failed
(FOC1405) SQL PREPARE ERROR.

Any one have idea abot this or any alternative exist ? if I select the ".mdb" format which is MS Access 2003/2007 format I'm able to connect acess the data.

Thanks!

I created an ODBC 'System DSN' named AccessTest to Sturgeon.accdb in Windows. I then used the SQL:MS Access adapter to create the connection AccessConnect to the DSN AccessTest. I tested and configured the connection and assigned it to an application - AccessApp. In AccessApp I was able to create and test metadata using the tables in Sturgeon.accdb.

Hi Meagher,

I tried the same thing created the ODBC system DSN and used the MS Access datadapter to create the connection but it was failed.

Is it because of the Version of the Web FOCUS
like I'm using 7.6.10 ?

Thanks!