How To Connect SQL Database On Website From Windows Forms App
Jan 16, 2011
I've returned again to my problem of trying to connect to the SQL database on my website from a Windows forms application. I had some success but then I was playing around with some things and deleting stuff etc to see what would happen. I deleted the Database that I successfully connected to and added a new database for reasons I won't go into. Now when I try to connect to the new database I don't have success.
View 39 Replies
Similar Messages:
Dec 18, 2010
we are migrating existing windows form application to asp.net(3.5) intranet portal, there is a requirement whereby database connection should be made by the logged in windows user. Is it possible to achieve this functionality?
View 1 Replies
May 7, 2015
I have amazon cloud aws, i am developing a website in asp, i have remote RDP access to my server..
So i have not installed postgreSQL etc.. but i am unable to connect to that database.. and when i install and run on my local system, it connect.
View 1 Replies
Jan 11, 2011
I have a website used by clients for reporting purposes and would like to give clients the option of my website reading their local database directly (instead of them providing data in a file format).In most instances their database would be SQL Express setup on their localhost.
How can I connect to a clients local SQL server via my website, using asp.net / javascript etc? If the client provides their connection string properties, localhost would just refer to my server's localhost...
Consider the following :Most people connect to the internet via an ISP. THeir database will run on their localhost and will not have a public address as such.Ideally, the client must supply some connectionstring (database name, login etc.) and my server must connect.VPN's wont work for this - I must connect to them (in a programmatic way) and pull data, not the other way around.
View 3 Replies
Jul 18, 2010
I am getting this error when trying to connect a database from another computer in my home network:
System.Data.SqlClient.SqlException : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
this database is using windows authentication. sqlserver 2008.
What is the connectionstring that I need to use in order to get the database?
View 1 Replies
May 26, 2010
i was trying to create new user for using login which i have created (user id and pswd) so i click asp.net configuration ,then after clicking security to add new user i got error as shown in bracket(There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.) in asp.net website administrative tool .......
View 2 Replies
Feb 2, 2010
I am have problem getting the security selection to view properly. Instead of getting roles and so on I get this following error message:There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem:Unable to connect to SQL Server database.
View 2 Replies
Oct 16, 2010
I wanted my local iis running application to connect my database in sql authentication mode rather than windows mode,
but it is showing errors of " Cannot open database "aspnetdb" requested by the login. The login failed.
Login failed for user 'DBUser'. ". i also ublocked port from firewall,and allowed remote connection of mssql from sql manager, enabled TCP/IP and named piped protocols from SQL surface config, and with sql manager i also changed server authentication mode to sql from windows.
my datastring is <add connectionString="Data Source=PARTHIV-PCSQLEXPRESS;Initial Catalog=aspnetdb;User ID=******;Password=******/" name="LocalSqlServer" providerName="System.Data.SqlClient" />
i made a user named DBUser in database as well i don't understand where it gone wrong ???
here is error log
[Code]....
View 4 Replies
Sep 10, 2010
I have a website that occasionally needs to have a handful of the tables in its database updated. The updates come from another system that exports to comma delimited text files. I can then either FTP the text files to the web server, send them in through an admin upload page, or manually log in to Remote Desktop to download the text files. I have all my C# code written to parse the files, check the database contents, and decide what to do.
Should I code the sync logic to be part of a file upload page, protected in the admin section of the site or should I create a Windows Service that constantly looks for files to process in a particular directory that I can drop files in through FTP?
I have used Windows Services in the past and they have worked great, but if I ever have to make a change to the code it can take longer than it would if I just had to modify an ASPX.
Are their security benefits one way or another?
Performance benefits?
ASPX page wins the "ease of maintenance" category.
View 1 Replies
Dec 30, 2010
I have been trying to avoid the windows login userid and password window when I use the Windows Authentication mode for a web site. I need to capture the the windows logon user name without prompting for the user id and password and display that on the web site. I had tried almost everything... changed authentication,security setups on IE and IIS etc... still not being able to avoid the window...
View 1 Replies
Mar 24, 2011
I'm trying to enable automatic Window authentication working on our ASP.NET Intranet. I've changed the Authentication on our IIS 7.5 server from Anonymous to Windows Authentication Enabled only, and changed the Web.config file for the website to:
<authentication mode="Windows" />
<authorization>
<deny users="?" />
</authorization>
The Windows login box appears when accessing the website via IE 8, I enter valid credentials, but the login window keeps reappearing as if it does not accept my credentials. By repeatedly cancelling the login box it disappears, and my login name can be viewed on the website. Is there any possible reason for the login box to keep popping up even though valid credentials are being entered? I've restarted the servers / cleared browser cache etc. Also, ideally I would like the user to enter the login details once in the login box and not be required to reenter login details whenever he reopens the browser.
View 3 Replies
Mar 16, 2011
In IIS i have a website Web1 and Web2 .Web1 is working fine.in web 2 i tried redirect to URL option.but it is not working now my reqirement is
1.If i type www.web2.com then the web1.com should come and in the browser address should be web2.com
2.if i type www.web1.com ,then the address should be web2.com and web1 should come.
View 4 Replies
Dec 17, 2010
to connect the MS Sql server 2008 using windows authentication in ASP.Net 4.0 without change IIS user (ASPNet) permission.
View 1 Replies
Feb 25, 2010
I'm running windows 7, so I installed on my machine the oracle client version 11.1.0.7.0 (ODP.NET - Oracle.DataAccess version 2.111.7.20) .
I'm trying to deploy an asp.net web application to a server that is running windows 2003, which has the oracle client version 11.1.0.6.0 (ODP.NET - Oracle.DataAccess Version 2.111.6.20)
In my web.config file I have:
<add assembly="Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
(which for my surprise it compiles just fine).
Now when I compile my application and deploy it in a setup project (as pre-compiled). The start page of my web app tires to connect to Oracle and it returns the following error message:
"Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified."
Which is super weird because, cause the web.config file as shown above has Version=2.111.6.20.
Now the strange part is that if I copy the source code from the client to the server, the same code, same config file, it works just fine.
So I'm thinking that the pre-compiled version is telling the server to load Oracle.DataAccess Version=2.111.7.20, maybe in one of the dlls, not in the config file for sure.
Has anyone run into this problem?
what's the best approach to deploy to servers with different oracle client version? (I have a similar problem trying to deploy to a 64 bit machine)
View 2 Replies
Sep 22, 2010
I have an existing windows .net application that has an access database as the backend.
I want to place the access database on a web server and it was suggested that I create a web service in order to communicate with the database.
I've been looking at some tutorials but am still confused about the basic config needed. Here's some questions I have:
1) Does the web service need to be created inside my current project by right clicking on the solution and choosing to add a new web site...and then selecting web service?
2) If it's set up like this, what files do I place onto the web server?
3) Where does the database reside? Do I need to place the database inside the web server that I create?
4) My current project has existing sql that gets data and I'm uncertain how to re-write in order to retreive the data. e.g. which part goes into the client and which part goes to web service pages? here's an example of a procedure that currently exists...I'm getting data to populate a dropdown:
[code]....
View 8 Replies
Nov 9, 2010
I have got this error
Unable to connect to the remote server
when I call the web service from the windows service. But I can visit this web service through IE and I also wrote another console application to call the web service and it works fine, too.
The exception infomation is below:
A socket operation was attempted to an unreachable network 127.0.0.1:8888
Here is my code:
WebImageSVC webSvc = new WebImageSVC();
ConfigManager.LoadConfigManager();
webSvc.Url = ConfigManager.WebSvcAddress;
webSvc.Proxy = null;
webSvc.CanUpload(0, "");
I try many methods, like turn off the firewall and anti-virus software, set the web services proxy property to null. but still cannot solve this issue.
View 2 Replies
Feb 21, 2011
I have an ASP.Net app, that runs using windows authentication. The connection to the SQL Server is usually done by creating a sql server account and using that in the connection string.
However, in this specific very restrictive hosting environment, we have been asked to use a specific WINDOWS/active directory account to connect to the SQL Server.
note it is not the windows credentials of the user of the website, we need to connect to the SQL server with - it is one specific windows/AD account.
How do I configure that in my connection-string?
View 2 Replies
Jan 24, 2010
I have a ASP.Net application, that has barcode scanning functionality built into it.If a user is on regular computer like laptop or desktop, then I can simply connect the USB barcode scanner to the USB port and the barcode functionality works fine.But if a user is accessing the ASP.Net application over a windows mobile device, then how can a barcode scanner be connected to his/her mobile device?
View 1 Replies
Feb 21, 2011
in 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 Replies
Mar 6, 2010
I have a new development machine running windows 7 professional 64 bit. On loading up a website project Im getting this error
'The Web Application Project 'websitename' is configured to use IIS. To access local IIS websites, you must install IIS components:
IIS 6 Metabase and IIS 6 Configuration Compatibilty
ASP.net
Windows Authentication
In addition you must run Visual Studio in the context of an administrator account
As far as Im aware, I am an administrator of my own pc and I have the .net framework installed.
View 4 Replies
Feb 13, 2010
My workstation does not have Internet access, but it uses a DNS server on the LAN. Every time I start any ASP.NET application from Visual Studio with either F5 or Ctrl-F5, the workstation (I don't know whether it's Visual Studio or Webdev.Webserver.exe) asks the DNS server for the IP address of "time.windows.com". The application is not started until the LAN-only DNS server returns an error, which results in a 10-second delay, during which the Internet Explorer is started, but displays a white background. Is there any way to prevent these connection attempts?
View 2 Replies
Nov 3, 2010
im trying to connect a loginname to a data base so when ever a button is pressed the name in the loginname is inserted into the database i tried this code but didnt work :
[Code]....
how can i do that
View 2 Replies
May 7, 2010
start with database connectivity and web form, i have created a simple web form like user name with email address, i just want to maintain a database for it.
View 1 Replies
Mar 30, 2011
I have created a web application and an SQL database using Web Developer 2010 Express. I have SQL Server 2008 and SQL Server Management Studio Express. In order to deploy the database to my hosting space I need to create a .BAK file from my new database. I think I can do this from with the Management Studio, but can't figure out how to get it to connect to the database. I have used Management Studio before to retore another SQL database and the only connection I see when I open the Management Studio is the old connection to the old database. How do I connect to my new database?
View 6 Replies
Jan 20, 2011
i am making a simple login page in asp.net using c#. I didnt want to use the Login control available. how am i suppose to connect to the database which will store the information about the user id and password. And then will redirect me to a new page.
View 5 Replies
