asp.net - Excel is not able to access from C# -

-

this regarding excel issue facing in production. have asp.net application reading excel shared drive. having issues dcom configuration , security settings on our server preventing complete process.

we running process service account defined in dcom identity tab.

we have full permission shared drive service account application reading file. still getting error below. (error message : microsoft cannot access file: there several possible reasons: file name or path not exist, file being used program, workbook trying save has same name open workbook )

we have full permission service account on excel location . application run different users cannot change dcom setting ‘interactive user’. business wants application run using on service account. if change ‘interactive user’ working expected , excel opening without issue.

service account added com property settings.

i created desktop folder under windows\system32\config\systemprofile\desktop , windows\syswow64\config\systemprofile\desktop , gave full permissions service account, issue did not resolve issue.

could please us. 

string con =   @"provider=microsoft.jet.oledb.4.0;data source=d:\temp\test.xls;" +    @"extended properties='excel 8.0;hdr=yes;'";     using(oledbconnection connection = new oledbconnection(con)) {     connection.open();     oledbcommand command = new oledbcommand("select * [sheet1$]", connection);      using(oledbdatareader dr = command.executereader())     {          while(dr.read())          {              var row1col0 = dr[0];              console.writeline(row1col0);          }     } }

try . guess work fine


Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more