Re: Problem while filling the dataset where the data source is a .CSV file

Thank you so much for your reply.
i went thru the link provided but couldnt find helpk relavant to my
issue.........

also i would like add some more information to the same........

hope i can find some more help........

i would also like to bring to your note dat i m using an impersonated
user (programatically)
there are two cases:

one:

if i include the <identity impersonate="true"> in web config

and use the following string

strConnA = "Provider=MS Remote;"+"Remote Server="+@"\\<comp name>
\<foleder name>;" + " Remote Provider=Microsoft.Jet.OLEDB.4.0;"+"Data
Source="+"try1.csv"+";"+"Extended
Properties='text;HDR=Yes;FMT=Delimited'";

i get the error "MS remote is not registered in the local machine"

and if i use the following string
strConnB ="Provider=Microsoft.Jet.Oledb.4.0;"+"Data Source="+"\\<comp
name>\<foleder name>;"+"Extended
Properties='text;HDR=Yes;FMT=Delimited'";

i get the error " Microsoft.Jet.Oledb.4.0 is not registered in the
local machine"
whereas Microsoft jet with the latesh version is available on my
machine (win XP)

and the second is

if i set <identity impersonate="false"> then with

the strConnA i get the error "specified cast is not valid"

and with strConnB i get "Unspecified error"

i m really not sure which is the right path dat i should go ahead with
there being so many option

it would be really helpful if you could tell me wut would ideally be
the right path(i mean whc string should i use and should i set the
idedntity to true o not)

i really need this.have been racking my head since quite some time now
on this
plz do help

thanx





Cor Ligthert [MVP] wrote:
Hi Simran,

Have a look what Paul has written about your question, this is a selection
on this topic he has in my idea at least given thousand answers.

http://groups.google.nl/group/microsoft.public.dotnet.framework.adonet/search?group=microsoft.public.dotnet.framework.adonet&q=Excel+Clement+hdr&qt_g=Zoeken+in+deze+groep



.

Relevant Pages

  • Re: Disk cleanup (Cleanmgr) freezes dead
    ... Kellys fix did WORK! ... > This string does not exist in Local Machine AFTER Microsoft?? ...
    (microsoft.public.windowsxp.general)
  • Listing, adding, and removing users to a local or domain group
    ... This code will list the users on the local machine using the ... Purpose: This will list the users in a domain. ... Dim domainDirectory As New DirectoryEntry ... directorySearcher.PropertiesToLoad.AddRange(New String() {"givenName", ...
    (microsoft.public.windows.server.active_directory)
  • Re: Simple HTML read/write question
    ... I would like to overwrite it on my local machine. ... > replace the encrypted data with unencrypted data. ... given directory on your machine, process it as a string, and then save ... on the Microsoft MSDN web site. ...
    (comp.lang.javascript)
  • i cant retrieve and/or write a binary or hex value from the regis
    ... I've successfully accessed the HKLM hive on a local machine. ... drilling down to where i need to be, i cannot read and display the correct ... extract the key as a binary value instead of a string, etc, etc. ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast