I have an asp.net website that needs to connect to a dBase file on a remote server. The remote server has a ODBC System DSN connection configured but I have no idea how to connect to it.
View 1 RepliesI have a project that must illustrate that connection to the database is not locally, so I have install VirtualBox and I intend to install SQL Server on it. So any one have the idea of how can I connect from the Host Machine to the SQL Server located on the Virtual Machine
View 3 RepliesI have a SQL server in my office. I can connect from my home development workstation website to the remote SQL server with no problems but when I upload the site to the web host and try and use the same SQL server it fails with 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible'
View 4 RepliesHow do I connect to a remote site in IIS 7.5 using vwd 2010? vwd 2010 appears to be looking for deprecated software instead of the IIS 7.5 supported protocol using webdav. My application uses a cookie authentication from a central corporate authority and nothing but a legitimate URL is going to work during debugging. There is almost no information in a google search and the only forums.asp.net post from last year says it isn't possible. If MS is no longer supporting FPSE in the new versions of IIS, then what is vwd 2010 doing looking for it--is there a patch or module of some kind that is available to enable webdav access?
View 4 Replies[Code]....
and i found it, here http://forums.asp.net/p/1480079/3451771.aspxi can fairly easily code for a general dbase (name, address, etc..)my question here with this code is...where does my dbase info go?
my dbase info
dbase name = files
tablename = fileTable
column names = fileOne, fileTwo, fileThree
the file upload object is called "fileupload1" and this all goes with a "submit" button
also, that is pretty much for one file, what if the user is uploading more than one file? do i just add more if/then statements, one for each fileupload object?
I am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
I have asp.net2005 on my system with sql server.
In my windows application, i am listing the System DSN's configured on the remote machine in a combobox. Once i select the DSN and click on Connect button, i should be able to connect to the remote database. I am trying to open the connection to the database using ODBC but am getting the below error.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Below is the code sample
string conn = "Provider=MSDASQL;Remote Server=http://BLR1WKD010; Remote Provider=MSDASQL;DSN=" + clsODBC.pDBName + ";UID=" + txtUsername.Text + ";PWD=" + txtPassword.Text;
OdbcConnection odbcConn = new OdbcConnection(conn);
odbcConn.Open();
I am trying to conect to my SQL Server 2008 instance from application in Visual studio unsuccessfully.
This how my Instance appears in SSMS
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Below is an example of a connection string from the book I am following which works if you have SQLExpress on your localhost domain.
I am using SQL Server Enterprise My Server name is DETERMIN (computer) . When I am in SSMS this is how my instance node appears
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Determin is the name of my computer I think its the name of my instance as well not sure, balloonshop is my login. How can I substitute the names properly for the connection string below in order to connect to my instance
[Code]....
[Code]....
I'm trying to force a large (200+ MB) file to download that's on a remote server. The problem is that I can't use the "WriteFile()" function, since I'm not using a virtual path. Then, when I try:
Response.AppendHeader("content-disposition",
I tried this code by inputting the ftp address as ftp//: and the correct username and password and I get the following error
"Unable to connect to the remote server" on line :
FtpWebResponse Response = (FtpWebResponse)Request.GetResponse();I tired this on my ftp server provided by a hosting service and an anonymous ftp located at 193.166.120.5 ?
Note: I was able to connect to both of these ftp through filezilla, via a webbrowser, and through windows command line.
I have deployed my site in Win 2003 server. In this, it copies file from Another server and copies it in local. It is working with my local computer, but not in the server i have deployed. I hope access credentials may be the first reason. But are there any other reasons for this.
After upload a pdf file (order.pdf) to remote server in UNC format, I used code below to open order.pdf file.Code is working in IE9 but not Chrome.Is there another way to open pdf file in remote server?
Dim fullpath As String = [String].Format("file:///{0}", "webserverorderorder.pdf")
Response.Redirect(fullpath)
The below code works fine for downloading a file from a current pc.plz suggest me how to download it from remote server using ip address or any method
protected void Button1_Click(object sender, EventArgs e)
{
const string fName = @"C:ITFSPDFbillsFebruaryAA.pdf";
FileInfo fi = new FileInfo(fName);
long sz = fi.Length;
Response.ClearContent();
Response.ContentType = MimeType(Path.GetExtension(fName));
Response.AddHeader("Content-Disposition", string.Format("attachment; filename = {0}", System.IO.Path.GetFileName(fName)));
Response.AddHeader("Content-Length", sz.ToString("F0"));
Response.TransmitFile(fName);
Response.End();
}
public static string MimeType(string Extension)
{
string mime = "application/octetstream";
if (string.IsNullOrEmpty(Extension))
return mime;
string ext = Extension.ToLower();
Microsoft.Win32.RegistryKey rk = Microsoft.Win32.Registry.ClassesRoot.OpenSubKey(ext);
if (rk != null && rk.GetValue("Content Type") != null)
mime = rk.GetValue("Content Type").ToString();
return mime;
}
I need to open and read a Dbase file in my ASP.NET application. When I try to open the connection, I am getting the exception "Could not find installable ISAM." I have tried the solutions in the top answer in this question, but they did not work for me.The filepath of the data file is C:devDATA.DBF. Here is the code I am using to try to open the connection:
Dim connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:devDATA.DBF;Extended Properties=dBASE IV;"
Dim connection As OleDbConnection = New OleDbConnection(connectionString)
connection.Open()
I get the exception "Could not find installable ISAM." Do you have any ideas what I can try to get this to work? Note that I am able to import this file into an Access database as a dBASE IV file.
filetoread = Server.MapPath("\servernamesharefile.csv")
filestream = File.OpenText(filetoread)
readcontents = filestream.ReadToEnd()
It works fine if I put the file in the local directory and use "filetoread = Server.MapPath("file.csv")", but won't do it over the UNC path.I'm guessing the problem is security related but can't find any info related to it, do I need to somehow specify a username/password somewhere ?
I have many images on remote server say [URL] & i want to access file names of all files that resides in the folder 222 on [URL]
i have tried following code but getting error "virtual path is not valid" :
imageserver = http://images.foo.com/222;
DirectoryInfo di = new DirectoryInfo(imageserver); // line giving exception
FileInfo[] rgFiles = di.GetFiles();
string simagename = "";
if (rgFiles.Count() > 0)
{
foreach (FileInfo fi in rgFiles)
{
//collect each filename from here
}
}
I am trying to access a remote network share from a C# program in asp.net. What I need is something like
function download(dirname)
{
file = (This is the part I don't know how to do)
for file in directory:
copyfile(file);
}
On remote server i have shared folder. If there any way to download file from this shared folder on local machine? Without using ftp. Server dont have iis or something like this,just have shared folder.
View 1 RepliesWhat I am doing seems to be saving the Excel file in a text format. All I am trying to do is save the Excel file (xls) on my web server. Below is the code that "fetches" it now but doesn't save it in the proper format.
[Code]....
This is what I have right now for a file residing on the same server and it works.
Dim FILENAME as String = Server.MapPath("Output.txt")
Dim objStreamWriter as StreamWriter
objStreamWriter = File.CreateText(FILENAME)
dr = myCommand.ExecuteReader()
While dr.Read()
objStreamWriter.WriteLine("{0}|{1}|{2:yyyy-MM-dd}|{3:yyyy-MM-dd}", dr(0), dr(1), dr(2), dr(3))
End While
objStreamWriter.Close()
I was planning on FTPing the file to another server once done but is there a way to do it on a remote server? i.e create a text file on a remote server and write to it? Did not find any instances of that usage. How to use ServerXMLHTTP to replace Server.MapPath in this instance?
I have previleges to create folder and create files in the remote windows 2003 server. But I am not able to create im ny Website.
View 2 RepliesI have a simple Upload method that send the file to the FTP server, if the file name is already exist, i will overwrite the existing file in the server. This method is working fine.
[Code]....
I'm just wondering how would i be able to change the filename ( originalFileName+timeStamp) during the process of uploading to avoid overwriting of files? I did try changing the method property of WebRequestMethod to
[Code]....
But I'm getting an error
The remote server returned an error: (550) File unavailable (e.g., file not found, no access)
How to read/open a pdf file from web site existing on remote file share?
View 7 RepliesI have an interesting challenge. My application uses a third party's services and one of the functions is to upload video files to Amazon S3. The current solution I've implemented uses a simple form with a POST action set to a URL on Amazon's system. The
issue I have is that because the form posts to Amazon, I have no way of doing any type validations before the user clicks to upload the file i.e. checking file type, file size, etc.
However, I really do NOT want to set up my logic so that the file is first uploaded to my server then to Amazon because these are huge files and we'll end up using costly bandwidth on both ends -- our server and Amazon S3.
P.S. To be perfectly honest, I'm not that pleased with the current solution where it's a simple HTML form with a simple post to Amazon. However, because Amazon is so picky about all the hidden fields in my asp.net page, I had to strip everything off the
page -- including form runat"server" because the minute I have this, I end up with a hidden field for ViewState -- even if I completely turn off ViewState. There's always something left as a hidden field and Amazon was generating an error because of this.
Ideally, I'd love to be able to do an HttpWebRequest in code behind so that I can have the functions of a web form back and do some pre-upload work but I'm not sure how to upload the file to a remote destination without putting the file on my server first.
I'm using an .ashx handler to retrieve an image file... It queries a local database, which retrieves the URL of an image which is hosted on Amazon S3.
But I can't use context.response.write(AmazonS3URL) because it returns the error '...is not a virtual path'.
Can context.response.write only return files that are on the local machine? Or is there another function to call remote files?