asp.net - Spreadsheet connection in vb web app -

-

my client wants price list on website. i'm trying use spreadsheet (.xlsx) data source limit processing of data before appears on website.

the site running on iis 7. server windows server 2008. i've updated .net framework on 4.0 well.

it doesn't have office packages installed on it, , have hunch thats problem lies, i'd sure.

heres error text i'm getting:

system.invalidoperationexception: 'microsoft.jet.oledb.4.0' provider not registered on local machine. @ system.data.oledb.oledbserviceswrapper.getdatasource(oledbconnectionstring constr, datasourcewrapper& datasrcwrapper) @ system.data.oledb.oledbconnectioninternal..ctor(oledbconnectionstring constr, oledbconnection connection) @ system.data.oledb.oledbconnectionfactory.createconnection(dbconnectionoptions options, object poolgroupproviderinfo, dbconnectionpool pool, dbconnection owningobject) @ system.data.providerbase.dbconnectionfactory.createnonpooledconnection(dbconnection owningconnection, dbconnectionpoolgroup poolgroup) @ system.data.providerbase.dbconnectionfactory.getconnection(dbconnection owningconnection) @ system.data.providerbase.dbconnectionclosed.openconnection(dbconnection outerconnection, dbconnectionfactory connectionfactory) @ system.data.oledb.oledbconnection.open() @ products.page_load(object sender, eventargs e) in c:\hostingspaces\webbuddies\waterinc.webbuddies.co.za\wwwroot\products.aspx.vb:line 14

heres code:

protected sub page_load(byval sender object, byval e system.eventargs) handles me.load ' here's connection string defined in web.config: ' <connectionstrings> '     <add name="xlsx" connectionstring="provider=microsoft.jet.oledb.4.0;data source=app_data/pricelist.xlsx;extended properties=excel 8.0;" /> ' </connectionstrings>     dim con new oledbconnection(configurationmanager.connectionstrings("xlsx").connectionstring)      ' spreadsheet has 4 sheets in it, 1 each category on client's pricelist.     try         con.open()          dim dswater dataset         dim dawater new oledbdataadapter         dawater.selectcommand = new oledbcommand("select * water", con)          dim dsjuice dataset         dim dajuice new oledbdataadapter         dajuice.selectcommand = new oledbcommand("select * fruitjiuce", con)          dim dsmix dataset         dim damix new oledbdataadapter         damix.selectcommand = new oledbcommand("select * muffinmix", con)          dim dsmisc dataset         dim damisc new oledbdataadapter         damisc.selectcommand = new oledbcommand("select * miscellaneous", con)          dawater.fill(dswater, "water")         dajuice.fill(dsjuice, "fruitjuice")         damix.fill(dsmix, "muffinmix")         damisc.fill(dsmisc, "miscellaneous")          rptwater.datasource = dswater : rptwater.databind()         rptjuices.datasource = dsjuice : rptjuices.databind()         rptmixes.datasource = dsmix : rptmixes.databind()         rptmisc.datasource = dsmisc : rptjuices.databind()          con.close()     catch ex exception         errormessage = ex.tostring         lblresponse.text = "could not connect 1 or more data sources required display " & _             "pricelist. please contact webmaster." & vbcrlf & errormessage         lblresponse.forecolor = drawing.color.red     end try end sub

edit 1
since posting have installed 2007 office driver on server link in 1st answer, , have modified connection string per 2nd answer:

<connectionstrings>     <add name="xlsx" connectionstring="provider=microsoft.ace.oledb.12.0; data source=app_data/pricelist.xlsx; extended properties=excel 12.0 xml; hdr=yes;"/> </connectionstrings>

you need have 2007 office driver installed work.

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more