Configuration :: Reading Problem In XLS File In 64 Bit Server?
Sep 9, 2010Reading XLS file in 64 bit server , following errror "microsoft.jet.oledb.4.0 not registered on local Is any solution for this problem?
View 1 Replies
Similar Messages:
SQL Server :: Reading Text File Using Sql Server 2000 - 2008
Sep 22, 2010how to read the data's in the text file using sql server 2000 and 2008. i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.
View 2 RepliesSQL Server :: Reading And Checking .CSV File And Inserting Data To SQL Server
Sep 30, 2010I have got a page in which there is a file upload option where I have to upload/import the csv file. What I want to do is to check if the correct format of file is uploaded for instance if any other than csv file is uploaded, the system should give an error message. Also what I need to do is to check certain fields of the csv file for instance there are some mandatory fields in the csv file which should be there like name , postcode, How can I check that these fields are not empty . After performing these task, the system should automatically upload the csv file onto the sql sever 2008.
View 3 RepliesVS 2010 - Reading A File From Server
Nov 22, 2013I am trying to read a text file from the root of the server. This is what I tried
Code:
Dim sr As StreamReader
Try
sr = File.OpenText("~ est.txt")
Label1.Text = sr.ReadToEnd
Catch ex As Exception
Label1.Text = ex.Message
End Try
If I test this locally, I get the error: "Could not find a part of the path 'C:Program Files (x86)Common FilesMicrosoft SharedDevServer10.est.txt'."If I upload it and run the code on the server, nothing happens (Lable1.text does not change).
SQL Server :: Reading Data From .CSV File Into Sql Database
Jul 15, 2010I urgently need to find a way of reading data from a .CSV or .xls(Excel) file into an sql database so that I can use it in my asp.net 2.0 application.
View 4 RepliesReading A File Into Memory And Then Reading It One Line At A Time?
Mar 7, 2011I know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
View 8 RepliesDataSource Controls :: Reading From SQL Server And Saving As Physical File
Mar 26, 2010I have to create PDF Files reading data from SQL Server where the data is in Binary format as Image data type.
View 2 RepliesSQL Server :: Reading File Csv And Inserting Into SqlCE Performance Improvement?
Dec 15, 2010NOTE: Code and names simplified for post. Elimination of try catch and other best practices also limited for post.
I have a simple SqlCE database one table consisting of 4 columns (specialvalue, name, state)
I am using a streamreader from a file.txt that contains 3000 lines of csv data, looping the below.
s[] = {id,name,specialvalue,state) //(SAMPLE DATA-displaying names)
while(!sr.EndOfStream)
{
[Code]....
This code works as expected but I would like to increase the performance since it takes over 30 sec to complete. I will be moving to a stored procedure later but would like to find out how to optimize the current code. This is more for experience than anything. It is a project that I am working on for codeplex.
Reading An Embedded File From A Custom Server Control An Rendering It?
Mar 31, 2010I currently have a file "abc.htm" in my Custom Server Control Project and it's Build Action is set to Embedded Resource.Now in the RenderContents(HtmlTextWriter output) method, I need to read that file and render it on the website.I am trying the following but it's to no avail:
protected override void RenderContents(HtmlTextWriter output)
{
var providersURL = Page.ClientScript.GetWebResourceUrl(typeof (OpenIDSel), "OpenIDSelector.Providers.htm");
var fi = new FileInfo(providersURL); // <- exception here
//the remaining code is to possibly render the file
}
This is an example of how the providersURL is:
/WebResource.axd?d=kyU2OiYu6lwshLH4pRUCUmG-pzI4xDC1ii9u032IPWwUzMsFzFHzL3veInwslz8Y0&t=634056587753507131
FileInfo is throwing System.ArgumentException: Illegal characters in path.
SQL Server :: Reading Xml File And Inserting Data Into A Tsql Table (no Duplicates)?
Feb 25, 2011I am writing code to insert values from an xml file. I check for a duplicate before inserting and delete if there is a match. Is there a more effecient way to prevent duplicates before insert a record? my code: private void LoadFData() { SqlConnection oConn = new SqlConnection(ConnectionString); SqlCommand oCommand = new SqlCommand(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.Text; oConn.Open(); // Load committee master files string[] strFiles = System.IO.Directory.GetFiles("fff", "ffff.dta", System.IO.SearchOption.AllDirectories); for (int i=0; i
View 2 RepliesWeb Forms :: Reading Data From Excel File And Inserting Into Sql Server - Initialize HasFile?
May 24, 2010I am using reading data from excel file and inserting into sql server using following article, it seems to be working correctly except when I do page refresh normally, it again execute the the btnUpload_click. I want that once the record imported and if user refresh the page again it should ask for enter file name again. let me know how do I resolve this? [URL]
View 8 RepliesWeb Forms :: Automatic File Reading / Check For New File Everyday And If The New File Is In The Folder Read It
Sep 20, 2010I would like ask you for some ideas how can I write mechanism that will be automatically read files from folder. I don't know how to schedule the write task. I want to check for new file everyday and if the new file is in the folder read it.
View 2 RepliesSQL Server :: Escape A Comma "," When Reading From A .csv File
Jul 30, 2010I have data that I am trying to read in from a .csv file. Some of my fields however have their own commas. For instance my file may look like:
Name, City, Country
And my data may have:
Walmart, New York, USA
"My store, and more", New York, USA
If you look at the second row of my data you will notice the first field has a comma in it: "My Store, and more".
It is surrounded by double quotes to distinguish that the field includes the comma, but when I read it into a table in MSSQL it splits that field into two. How do I tell MSSQL to leave everything in the double quotes as one field?
WCF / ASMX :: Add Service Reference Reading Svc File But Not Reading Service?
Mar 10, 2011I was trying to go through this tutorial:
[URL]
but when I tried to add the service reference to the silverlight app, the Add Service Reference window would show me that there was a service file, but the node wouldn't expand to show the rest of the files that contain the services and what not. I got this error instead:
"An error occurred during the processing of a configuration file required to service this request. review the specific error details below and modify your configuration file appropriately."
"Parser Error Message:There is no service behavior named 'AdventureWorks_WebServer.Service1Behavior'."
"Metadata contains a reference that cannot be resolved: 'http://localhost:55579/Service1.svc'.
The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.
If the service is defined in the current solution, try building the solution and adding the service reference again."
here's my web.config file:
[Code]....
Databases :: Upload Ms Word File And Store It Into Database Then Reading The File?
Jan 12, 2011i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 RepliesWCF / ASMX :: Web Service Reading *.txt File .this File Contains Some Special Characters Like "?
Jan 21, 2011In web service reading *.txt file .this file contains some special characters like "" .so its shows error while reading .
string fullPath = Server.MapPath("sample.txt");
string reconciliationData = string.Empty;
StreamReader ObjReconciliationDataStream = new StreamReader(fullPath, Encoding.UTF8);
string strReconData = ObjReconciliationDataStream.ReadToEnd();
ObjReconciliationDataStream.Close();
ObjReconciliationDataStream = null;
return strReconData;
above code i am using .
Configuration :: Reading Data From Another Web / Folder?
Jul 12, 2010From some reasons I added virtual directory to my site- e.g. the entire site running under one domain and one part from another and different folder. I need to read some data that's stored in the main root of the site in text file... but the .NET frame work (and I think iis itself) doesn't give simple access to another folder that declared as different site.
Are there is a way to read the text file? Let's say my main site is-www.domain.com and the virtual directory is-www.domain.com/newsite, (the folders are different, off course, even in different disks) can I get text data from the main root?
Reading Txt File And Modify Content To A Output File?
Jan 5, 2011I would like to find a way to read a txt file (in my case delimited by €). I need to change the order of the columns and also add and remove some columns. My output file should be a txt file delmited by ;.
I tried Jet.OLEDB to read the file and put it into a datatable and then used a stringBuilder and streamwriter to get an output file in .txt format. However. This does not me since IŽ, reading the txt file from start to end and my output will be the same. It does not seem like I can have a custom sql statement when reading the file. The only query that works is
Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from 1.txt", TextConn)
How can I possible modify a txt file?
This is my code for now:
[Code]....
C# - Application Only Partially Reading External Configuration
May 27, 2010I have an ASP.NET web app and am attempting to reference an external config (using enterprise application blocks configuration) for some of the configuration but it is not entirely working. I previously had all of the configuration info in the web.config (and it was working), but we are wanting to share some of this configuration information between multiple apps. When I put configurationSource tag in the web.config, and read the configuration through the WebConfigurationManager object, it loads some of the external config info (Logging) but not the connectionStrings and not the custom section I created. So it's reading it (logging is working), but some dots aren't being connected and my connection strings aren't coming through.
Again, it worked when it was all in the web.config. I am running .NET 3.5. Any idea what needs to change to be able to reference an external configuration source and have it all come through?
[Code that accesses web.config]
Configuration webConfig =
System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
ConnectionStringSettingsCollection connectionStrings =
System.Web.Configuration.WebConfigurationManager.ConnectionStrings;
[web.config]
<configuration>
<configSections>
<section name="enterpriseLibrary.ConfigurationSource" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.ConfigurationSourceSection, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.1.0.0, Culture=neutral, PublicKeyToken=74025d8738dfe4ce" />
<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" />
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
</sectionGroup>
</sectionGroup>
</sectionGroup>
</configSections>
<enterpriseLibrary.ConfigurationSource selectedSource="File Configuration Source">
<sources>
<add name="File Configuration Source" type="Microsoft.Practices.EnterpriseLibrary.Common.Configuration.FileConfigurationSource, Microsoft.Practices.EnterpriseLibrary.Common, Version=4.1.0.0, Culture=neutral, PublicKeyToken=74025d8738dfe4ce"
filePath="C:MSEABMSEAB.config" />
</sources>
</enterpriseLibrary.ConfigurationSource>
...
...
</configuration>
[external MSEAB.config]
<configuration>
<configSections>
<section name="loggingConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.LoggingSettings, Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.1.0.0, Culture=neutral, PublicKeyToken=74025d8738dfe4ce" />
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=4.1.0.0, Culture=neutral, PublicKeyToken=74025d8738dfe4ce" />
<sectionGroup name="customSectionGroup">
<section name="customSection" type="app.CustomSection" allowLocation="true" allowDefinition="Everywhere" />
</sectionGroup>
</configSections>
<loggingConfiguration name="Logging Application Block" tracingEnabled="true"
defaultCategory="General" logWarningsWhenNoCategoriesMatch="true">
...
</loggingConfiguration>
<connectionStrings>
<clear />
<add name="DB.DEV" connectionString="User ID=user;Password=pwd;Data Source=DV1;" providerName="Oracle.DataAccess.Client"/>
<add name="DB.TEST" connectionString="User ID=user;Password=pwd;Data Source=TS1;" providerName="Oracle.DataAccess.Client"/>
...
</connectionStrings>
<customSectionGroup>
<customSection notificationemail="email@mail.com" dirPath="C:Dir" initialrowlimit="500" maxrowlimit="1500" adminadgroup="_admins">
</customSection>
</customSectionGroup>
</configuration>
Impersonation + Error Reading Configuration Information From The Registry?
Jul 6, 2010have registered keys in the registry for impersonation for my application (asp.net 2.0 running in IIS 7.0)
<identity impersonate="true" userName="registry:HKLMSOFTWAREMY_SECURE_APPAPPNAMEASPNET_SETREG,userName" password="registry:HKLMSOFTWAREMY_SECURE_APPAPPNAMEASPNET_SETREG,password" />
DataSource Controls :: SSIS Package Not Reading Configuration
Mar 2, 2010The short story is, I'm developing an SSIS package to select from a remote Oracle database (read: no Windows Authentication) and store into an SQL Server db. I can execute the package just fine in development and after importing, but when I run it as a scheduled job, I get an ora-01017 error (bad un/pw). The details are, I built this package and tested in in BIDS but came across the problem that BIDS really doesn't save the password I'd set for the Oracle connection. After poking around a bit, I found this
[URL] which showed how to create an XML configuration which the package could then read. Fiddled around with that, got it working in BIDS. Connected to Integration Services on the server on which I want to run the package, imported it, right-clicked and did the "Run Package" option as a test, it works great. However, when I connect to the same server's Database Engine to create and schedule a job, I cannot connect to Oracle. For some reason, it seems as if the package is not reading the configuration when run in schedule.
I've tried removing the job and re-working it, thinking maybe it didn't pick up the new version when I re-imported the package. A new job had the same problem. Next, I tried re-naming the .dtsConfig and doing the "Run Package" option as a test. Failed with the same error. A bit surprised, I thought I'd get some kind of file error and we wouldn't get as far as trying to talk to Oracle. Anyway, thinking maybe it's permissions on the configuration, fixed the .dtsConfig name and gave full access to Everyone. That ought to let the Agent see it. Scheduled up the job, still can't talk to Oracle. So it seems as if the scheduled version is ignoring the configuration. Anyone have any idea what I'm missing, that scheduling an SSIS package makes it act differently than running it manually? BTW, the instance under which we're running the package is VS 2005. BIDS 2005 to build the package.
Configuration :: Cannot Save XML File On Server
Feb 18, 2010I have an XML file that generated by a Codebehind (.cs) of an .aspx page. And everytime it must be generated automatically and must be saved on Server. It works on my local machine, but how can I do it on Server (host)?n local I managed it like:xmlDoc.Save(Server.MapPath("~")+filename);
View 2 RepliesConfiguration :: Uploading File Using Fileupload To Another Server?
Oct 12, 2010I am using the fileupload control to upload an excel file to a server, but I am getting a
"Access to the path '\<server>importResponses.xls' is denied" when I try to use fileUploader.SaveAs(filepath). The filepath I use is \<server>importResponses.xls, so I am actually saving it to a share on a different server.My environment consists of a web server and a database server. I am trying to upload the excel file to a share on the database server. A stored procedure then takes that excel file and imports the data from it into a table. So the problem isn't with being unable to save a file to a share on the web server, but it's a problem with being unable to save a file to a share on the database server. It used to work, but now it doesn't and I have no idea why. What process(es) on the database server do I need grant write access for in order for the fileupload control to successfully save the excel file?Right now, I only have the Network Service account with read/write access to the share on the database server. I tried adding other accounts, such as the ASPNET and IUSR_<server name> accounts, but nothing seems to work.The web application that does the actual uploading is configured like this:
<authentication mode="Windows"/>
<identity impersonate="true"/>
Could that have anything to do with it?If you're asking why I'm trying to save an excel file on the database server instead of on the web server, this was the only way I got this to work. If anyone has a better suggestion on how to programatically import excel data into a SQL table, I am all ears.
Configuration :: Run An Exe File Located At Web Server Using Application
May 14, 2010I am running an exe file located at Server named Wget (Command line Web Crawler) using aps.net application.
When I run it from Visual Studio Development environment it run properly and gives required results.
But when I run it from the IIS Server its process run properly but terminated immediately and doesn't give required results and there is no any kind of exception.
Configuration :: File Upload In A Different Server In Application?
Mar 30, 2010My application in published in web server A. From my application I am uploading file to a folder that is in server B. I have windows authentication in web.config file and all the servers are in same network.
I am getting Access Denied error message when I try to upload a file from my application.