asp.net - AccessDataSource control reports unrecognizable database -
i running visual studio 2012 express web , on page added asp dropdown box. tried load source access 2007 database using asp:accessdatasource object. wizzard completed fine. when ran page in web, got error message telling me database in unrecognisable format. googled problem , found out visual studio not know use provider microsoft.ace.oledb.12.0 , need modify connection string.
since i'm not writing code page, , relying on vs's visual interface generate code, how find code modify it? or write own code , not rely on vs me?
you can use sample code on page here display connection string accessdatasource using. verify connection string includes
provider=microsoft.ace.oledb.12.0;
and path data source
valid.
fwiw, tried recreate issue under visual web developer 2010 express access 2010 database , worked fine me. couldn't find evidence connection string accessdatasource "written down" anywhere, in web.config
or elsewhere.
Comments
Post a Comment