I'm building an online file management system for a certain workflow. One of the services of this system should be as follows:
whenever a fax is received, it should be saved in a certain table in the database as a PDF file.
I'm using ASP.NET with C# ..
Is it possible to perform that task without the need for a middle desktop application?
Does anyone know of a tutorial on this? I know i would need a wcf service but how can i get it to connect asp website to windows form?
View 1 RepliesHow to connect our site with facebook and twitter websites and display tweets in home page?
View 1 RepliesCould not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. I have set up a db locally which mimics the production DB, THe production db and website has no has no issues.
THis used to work till i had hard disk failure and had to reinstall all software and do the db from scratch. Used the table scripts and ran the aspnet_regsql. I am using sql server express 2008 asp.net 3.5 I am using custom provider for Roles and custom membership provider for Memberships. Pretty sure the problem is in the db permissions, though I have set up Users in the Security of the DB.
[Code]....
I have recently combined my aspnet membership database and main website database into one database file, I'm happy with the schemas, stored procedures etc. (This is a development project not yet a production project.)
My problem is that I can no longer simultaneously connect to the database from Visual Studio if a user is logged in to the website.
EG:
Scenario 1: No user is logged in to the website. I can go to the Data Connection window in VS, choose "Add Connection" and then inspect the contents and schemas of the database. This is fine.
Scenario 2: A user is logged in on the website. I try to connect to the website in VS and get the error:
"Cannot open user default database. Login failed. "
Scenario 3: I am connected to the database in VS and nobody is logged into the website. If someone tries to log into the website they get the following error:
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
So it seems from the above that there can be only one connection to the database at a time? However this was not the case before I combined the membership database with the main website database. I could always make changes as a user logged into the website and at the same time see those changes through the connection in Visual Studio.
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
I come from a coldfusion background, where setting up a connection to a database (Oracle, MYSQL SQL Server etc) was was easy as filling in a few fields in the datasource screen in the Coldfusion Administrator web app.
Then in the web application to connect to the database I would use <CFQUERY datasource="oracledb" name="test"> and in the body of the application I would write my SQL query and display the results of this query in a <CFOUTPUT>#variablename#</cfoutput> block of code, or to insert data into a db table I would use the
<CFQUERY datasource="oracledb" name="insertdata">
INSERT INTO table (columnname, columnname2, columnname3)
VALUES (
<cfqueryparam cfsqltype="cf_sql_number" value="#columnname#">,
<cfqueryparam cfsqltype="cf_sql_varchar" value="#columnname2#">,
<cfif isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>,
</cfquery>
How does this process work in .NET? as I have to create a simple web application/form where on submission of the form the data would be stored in a MYSQL database.
what I have seen so far it seems a far more long winded and complicated process with .NET over Coldfusion with ultimately the same result, and I am desperately trying to understand how it works in .NET as surely it must be a similar process to that of Coldfusion?
I have done the MusicStore Tutorial and it is working fine, but as I have tried to make my new project I running into trouble, big one, last three days I have been on my Pc everywhere on body id paining now; neck, back, ...The problem is as I create new Empty MVC3 project using Web developer express edition, and I add App_Data folder with new database with Product Table and Product Class in Model folder I try to install EFCodeFirst just as I did on the Tutorial from <Tools<LibraryPackageManager<AddLibraryPackageRefrence; and choose EFCodeFirs it says dependence is missing so install it from PowerShel Console which I did and I can see that it is installed but but as i try to run the project it saysInvalid object name 'dbo.Products'. this my homecontroller code
[Code]....
I have developed a web application in asp.net with C# in visual Studio 2005. And i used sql server 2008 as back end. When i run the program, it shows the following error..An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 2 RepliesI already have an existing sdf file that is used in a windows application by looking at the current programs folder to find it. I want to use this same database (a copy of it) on an ASP .Net website so won't be hosted in a sql server anywhere want's to be accessed directly, is this possible?
View 1 RepliesI'm trying to learn how to do both of them at the same time on my own, while working on a project. All the examples in the MSDN are using databases that are a local SQL Server (Express) file. I am not going to be able to just upload the project (including the file) and have it work, am I? The thing is - I want to be able to write code vs. a database that is actually going to work online so I can start putting a project together and know that it is going to work online.
I don't want to get everything done, and then discover it breaks as soon as I upload everything. Assuming I can't just upload the database file and have it work - I have a hosting account that I am using for something else and I would like to set up a database to use (preferably MySQL because my SQL Server database quota is used up and I'd have to pay extra for another, but I will if I have to because it's not that much). I can do that, correct?
I have never used reporting services before. My boss just started teaching me how to use them. I was told something by my boss that I find hard to believe. In our environment we have 3 databases: Development Beta Production According to my boss, the connection string has to be hard coded in the reports. Therefore every time you move a report from one environment to another you have to manually change the connection string so that it points to the correct database.
View 9 RepliesI currently have an internal system that I need to link up to an API offered by a company. I am not looking for hand-holding on this, I really need to understand where and how to get started really.
Here is the developer resource for the API I am looking to work with:
[URL]
Further, my systems are currently in ASP/ASP.NET & SQL, and I'm familiar with VB so I would rather stay that direction instead of C#.
or one of my project, I use Access 2007.I have application written by Access, that use database : Sql-Server 2007.I am using XP for the any company computer.The dsn file is on network, and include connectionString with username + password,ut I want to access the database from any user with automatic authentication (no need for user and password).
View 3 RepliesI've installed the Components from the links below. But I still can't find any SQL references when I try to add them? I'm wondering if anyone would know the reason for this? I just started with asp.net. I've found several other questions regarding code for connecting but I can't find anyone who've had trouble with the Connector/components before?
MYSQL connector
[URL]
Microsoft Data Access Components (MDAC) 2.8
[URL]
how do i connect visual web developer to sql server express 2008? in the Database Explorer, i right click on Data Connections, click Add Connection..., and in the Data source box i choose Microsoft SQL Server (sqlClient), which i'm guessing doesn't connect me to a database file, but to sql server express itself(?). in the server name box when i click the drop down box, there's nothing there and that's where i get stuck.
View 3 RepliesThere is a website that I've programmed that sometimes takes a long time to load. I will click on a browser bookmark to load the page which should take me to a login page. The code that the Page_Loads for the MasterPage and the initial Login page contain is minimal; no service, database, etc. executions. I even just commented everything out and the problem remains. Sometimes it takes 5/10/maybe more seconds for the simple Login page to load. I'm trying to figure out what the issue is, but I'm having a hard time. When I put breaks on the Page_Loads and debug, it loads immediately. Then, seemingly randomly sometime after that, it will again load slowly.
It wouldn't seem like any of my code is the issue since, when I debug, it loads quickly. I'm not calling any services or database methods so, AFAIC, that can't be the issue. I separated all of my websites in my IIS to use their own app pool the other day so if there is a memory leak in another site, it won't affect this one. The only thing I can think of now is some issue with my network which I wouldn't have the slightest clue at starting to debug. I can have IT investigate, of course, is that is a probable cause.
I've a problem with my web application. I hosted a web site in IIS and initially its working good. After sometime ( i dont know the time diff exactly ), if i try to access my page its not working and after re-starting my application only its working. Let me explain about my project.
I've only 4 pages ( ex: main, a1,b1,c1 ) in my site. In main page i used IFrame to show other 3 pages by clicking the appropriate tab. Before this main page load, i'm connecting to DB (Oracle 10g) and i used "System.Data.OracleClient" class to communicate with oracle. Every time after retrieved data from DB i'll close the connection. Then i'll display the main page and assign other page url's to the tab.
Now the problem is after sometime if i access the main page, its not connecting to DB at all then i'll show some static message like "site is unavailable at this time". And i'm not using connection pooling concept. And also this problem is not occurring all time.
I'm trying to write a method in VB.net so that when I click a button it queries the database and returns all the values which match a textbox which is located next to the button. I have no idea how to do this, I assume in the onclick method for the button I will need to pull in the value from the textbox, connect to the database and display the results to a gridview?
View 2 RepliesI am getting this error while connecting to IBM MQ. I know that this is because of privileges, but is there any way just to check the connection with IBM MQ?
View 2 RepliesI have a set of productIDs in a DataTable.
I would like to display the relevant data about the specific productIDs in the DataTable in a DataList with the Product data being drawn another Database called Products.
How do I do this?
And how do I write the select statement in VB.net in the SqlDataSource of the Gridview?
I thought of a SELECT .. WHERE .. IN?
I am using this code to connect to my exchange server using POP3.I am trying to retrieve an inbox of basically emails that have not been read however, i am just getting a bunch of gibberish and its reading an email. modify my code to just read the most recent messages.
Try
tcpClient.Connect(hostName, 110)
Dim networkStream As NetworkStream = tcpClient.GetStream()[code]...
when i use top instead of retr i get this
+OK X-MimeOLE: Produced By Microsoft Exchange V6.5 Received: by xch0p.com id <01CB58CE.A6A4EA@p.com>; Mon, 20 Sep 2010 09:17:07 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CB58CE.81A6A4EA" Content-class: urn:content-classes:message Subject: What we need to do?? Date: Mon, 20 Sep 2010 09:17:07 -0500 Message-ID:
Can you connect to a SQL Server in ASP.NET? If so how?
View 2 RepliesI'm trying to connect my app to my database hosted on my web space. I have a newbie query.Do I have to install Connector/Net 6.8.3 on my web space's server, or, can I install it locally and just change a config file of some sort on my server version? If the latter is possible, what is my best (and easiest) way of developing / testing in two DB environments? the testing server will be my online one so I don't mind having to manually edit something each time after I publish it.
View 2 RepliesI m facing an error in connecting my Access Database using ASP.NET. I have placed the below code in Web.Config
Code:
<connectionStrings>
<add name="ConnString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|PerformanceDb.MDB"/>
</connectionStrings>
And used below code for connection
Code:
OleDbConnection myConn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("ConnString"))
but it gives error
Non-invocable member 'System.Configuration.ConfigurationManager.ConnectionStrings' cannot be used like a method