I have a UDL file with a connection string in the web.config that my DBML file connects to with no problems. However, I now need to connect to the same file in ADO.NET, and it does not connect.
Here is my code :
[Code]....
We have an MVC application where we have put an excell loader. It works fine in the VS studio environment but on the IIS (64 bit) we get an error message .->
Microsoft.ACE.OLEDB.12.0 provider is not registrated on the local machine.The excell (2010) is 32 bit, but the IIS is 64 bit. Here the code
[Code]....
I am playing around with WebMatrix ans SQL CE 4.0. I wanted to load up a SQL CE V4.0 db from an Access db.
Tried to connect SSMS Exp to SQL 4.0 sdf file (created in WebMatrix starter site template) and was rejected with the following error that SSMS Express is not yet "aware" of SQL CE V4.0):
Cannot connect to C:Users....App_DataStarterSite.sdf.
This is not a valid SQL Server Compact Database file or this file version is not supported by current SQL Server Compact Engine. (SQL Server Compact ADO.NET Data Provider)
[code]...
The sdf file is "a valid SQL Server Compact Database file" - it works fine in WebMatrix.
What do I need to do to make SQL CE 4.0 files kosher for SSMS Express? The error messages suggest that I need to update the SQL Server Compact ADO.NET Data Provider, however I might do that.
I don't know how to connect datbase.mdf file with dotnet.
View 2 Repliesin my ASP.NET applicaton I have ftpdata folder, where is MS Access 2010 somename.accdb file. On my local computer (Win XP), there is no problem to connect with OleDb to this file and read write datas into and from tables. But on server (Windows Server 2008), I cannot connect to the same file like on localhost.
View 3 Repliesi want to conncet to rss orignal website if connect is successfully write the rss to xml file and read from orignal website ,else connect failed read xml file (last information in rss original website) and show it how can do it .
View 1 RepliesI had this one working a while back i try to upload file to my root folder it works locally but when i try it from my website i get the following error: exception details: system.bet .webexception. unable to connect to the remote server
the code bomb at the following line
requestStream = uploadRequest.GetRequestStream() 'This is where the exception occurs
fileStream = File.Open(localFile, FileMode.Open)
[code]....
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.
Today I am facing the problem with Typed DataSet using DataSet.XSd file, And How to fetch, Delete and Update the Database through Dataset.xsd file.
View 9 Replieshow to add and connect iis5.1 and how to add web config..
View 2 RepliesI have the following code:
[code]...
and I'm trying to use that to submit to my database, but when I click on the submit button, no data is being inserted into my database, but I'm also not receiving any errors.
I moved to ASP.NET from PHP where the queries are run directly. So I always create Connection in the Page_Load Event, dispose it after I do all stuff needed, and access data with NpgsqlCommand. (Yes, I use Postgresql in my ASP.NET applications.)
After starting to learn ASP.NET MVC I was amazed how easy it is to access SQL with the LINQ to SQL thing. But... It works only with MS SQL. So my question is how to implement the same functionality in my applications? How to connect to databases easily?
I wrote my own wrapper classes for connecting to Postgresql. 1 class per a table.
This is a part of the Student class:
[Code]....
So as you see the problem here is that with every INSERT, DELETE, UPDATE request I'm using Connect() method which connects to the database. I didn't realize how stupid it was before I had to wait for 10 minutes to have 500 rows inserted, as there were 500 connections to the database.Using pooling while connecting does help, but still making the connection and making the server check the pool during every single query is stupid.So I decided to move Connection property to a static DB class, and it didn't work either, because it's a really bad idea to store such objects as connections in a static class.I really don't know what to do know. Yes, there's an option of manullay creating the connections in every Page_Load event and close them in the end like I'm doing it right now.
[Code]....
Login failed for user 'NT AUTHORITYNETWORK SERVICE'. Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.xception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYNETWORK SERVICE'. know just this is the problem about connection to SQL Server in C#.NETI don't use any username and password to login to SQL Server
View 2 RepliesI'm new to WCF web services never done anything with them before and I'm being asked to create a page to connect to a WCF web service I have no idea where to start and I've searched the internet with no success. Does anybody have an example of an asp.net page connecting to a WCF web service? I've set up the WCF web service on my server but do not have a clue on how to actually connect or query it to get my XML data back.
The WCF web service is set up as it's own URL and only has 2 files within the root one being the web.config. I somehow need to query this URL and get some XML data back from it.
I am trying to build a CRM database for my office, but would like to have the ability for users to use it from home as well, and possible an IPhone app to check contact information. I'd like to use WPF, so I could have an application at the office, but also be able to log in at home to the same database, and have multiple users.
Is it possible to have WPF connect to a hosted DB? And possibly have a web form interface, for access through a browser on outside of intranet machines? Or do I need to just go the route of creating a site, and use asp.net and everyone access that through the browser?
how to connect to SQL Server in Asp.net MVC?
View 10 RepliesThis is the code I use to connect to ExchangeServer. My account has 2 mailboxes assigned to it. Could this be the problem? I don't get any bug nor some result.
static void Main(string[] args)
{
ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2007_SP1);
service.Credentials = new NetworkCredential( "{Active Directory ID}", "{Password}", "{Domain Name}" );
service.AutodiscoverUrl("user@domain.com");
FindItemsResults<Item> findResults = service.FindItems(
WellKnownFolderName.Inbox,
new ItemView(10));
foreach (Item item in findResults.Items)
Console.WriteLine(item.Subject);
}
I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400.What do I have to install on my machine (or the AS400 server) inorder to connect?
(IBM iSeries Access for Windows ??)What are the components of the connection string?Where can I find sample codes on building the Data Access Layer using SQL commands?
I need to connect two ObjectDataSource tags.First will have a query string parameter and the second has a parameter, which is one of the fields in the result set of the first one. The relationship is one-to-one, so I can't put second one in a grid and use control parameter
<asp:ObjectDataSource ID="OrderObjectDataSource" runat="server"
SelectMethod="GetById"
TypeName=" MyProject.Business.Repositories.OrderRepository"[code]....
This does not work because AdvertiserObjectDataSource_OnSelecting is called before OrderObjectDataSource_OnSelected.
Which method is best for connecting with active directory.
View 6 RepliesI have 2 servers. the database server (DB1) which has sqlserver installed and the application server (WEB1) which has my web application. They are both on the same network and both have the same administrator login.
My web application on the application server needs to access the database on the database server. sqlserver is set to mixed mode in security. i created a random sqlserver user login that can only access my database and set it as the db owner. I use the username and password for this in my connection string. when i run my web application i can read information but i cant write to the database. My app is using windows thentication. I have set my NT AUTHORITYNETWORK SERVICE account to db_owner for my database as well... grabbing at straws!
Question 1: When my application talks to sqlserver does it use the administrator login or the NT AUTHORITYNETWORK SERVICE account which i got from using windowsidentity.getcurrent()?
Question 2: If I use ASP.Net impersonation, what does this do exactly? Because if i run the ndowsIdentity.GetCurrent() i get the username that i specified. How does this tie in with my connection string?
Question 3: If I dont use impersonation what and how do i have to configure sqlserver to accept my insert/update requests? Do i need to work with the NT AUTHORITYNETWORK SERVICE? or can i just use my user login? What do i need to add or remove from my connection string? (see below).
[code]....
i would like to use asax to check my database for every 5 min. if let say the database detect high in threshold.. it will send a notification to administrator. Anyone have done this before mind to share some code?
View 29 Repliesis there anyway i can connect to MySql through WebMatrix using asp.net
View 3 RepliesI got 2 pages on my iis7. None of them got a domain addy yet. So I wonder how I could connect to them with the server ip somehow?
like if i got all in the files in wwwroot and I can access to the web site like this..[URL]
I want to scan images/documents from client machine scanner and uploaded with thumbnails to server using my
web application (ASP.Net 2.0/C#)