C# - Connect To Local Database Via Website?
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
Similar Messages:
Jan 13, 2010
I had a database on a development server of which I am not the owner. The connection string was:
Dim MM_cnnTraining_STRING
MM_cnnTraining_STRING = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=xxx;Initial Catalog=Training;Data Source=xxx"
I copied this database to my local machine, In services MSSQL is set to logon with my computer username and password, I have no idea if this affects anything.Also the local database which I can view in MSSQL Server Management Studio, I can connect by Windows Authentication only. The database copied there seems to have maintained the same permissions.Im completely confused. I finally was able to copy to my local machine but now can not connect. I am using dreamweaver, but using the connection string above.
View 7 Replies
Sep 28, 2010
how to connect an asp.net application running in local IIS to a database residing in a remote web server ?
View 2 Replies
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
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
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
Mar 30, 2010
when a website is entered in a browser it should take to a login page (in localhost) and if the login succeed then the site should be loaded else an error page should be displayed. the login page will be connected to local database. how to do this?
View 6 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
Mar 29, 2011
I created a website using VS2010. When I run the website using built-in web server, everything works fine. The website recognizes javascript and aurigma uploader. When I publish the website to local folder and tried to access using IIS 5.1 on local pc,
the java scipt files did not work. I was getting yellow triangle sign at the bottom of the page indicating the object is expected. I tried to look online but i could not find any answer. I have included jquery and javascript file in the header section of master
View 3 Replies
Aug 29, 2010
for my website, i am trying to connect to the online DB from my local PC.when i put the following connectionstring:Data Source=88.8.88.88; Initial Catalog=dbname;user id=dbuser; password=dbpass; Min Pool size=50;Packet Size=32767;Connect Timeout = 200;pooling='true' 88.8.88.88 is the server ip, the databse over the server is sqlexpress 2008. the connection string is working with no issues over the server.i got the following error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)thanks
View 5 Replies
Jul 15, 2010
I want to have a PHP login form on my website. When the user enters a username and password and clicks submit, they should be directed to a remote website logged in (therefore skipping the login form on the remote site).
As mentioned in the title, the remote site is built using ASP.NET.
I've tried to search for a solution this but really not finding.
View 3 Replies
Jun 4, 2010
I'm new to ASP and was hoping to get some hands-on experience of web development, but have been having trouble getting started.
I followed the instructions in the [URL] setup video, and downloaded and ran the plaform installer. I noticed that the "Web Platform" section of the installer was didn't have the "Web Server" section at the top, as shown on the instruction video [URL] but it otherwise seemed to install ok.
When I tried to follow the tutorial videos on [URL] using MS Visual Web Developer 2010, I am unable to debug the application. The web page it loads just says: "The webpage "localhost:xxxxx" cannot be found" (where xxxxx is the five digit random port number).
I've tried uninstalling Visual Web Developer, and the various Microsoft .NET and SQL Server using the Vista uninstall functionality of the control panel (as bet as I could -I'm not sure if there was something I missed), and then re-installing, but I still get the same problem.
I've tried to find a solution on some developer forums, and I noticed there are posts relating to webdev.webserver.exe relating to the error message I've been getting. However I haven't been able to find any info on this for VS 2010.
I've checked, and I don't have webdev.webserver.exe in C:Program FilesCommon Filesmicrosoft sharedDevServer or in C:WindowsMicrosoft.NETFrameworkV2.0.50727, although I do have WebDev.WebServer20 and WebDev.WebServer40. inC:Program FilesCommon Filesmicrosoft sharedDevServer 10 (I'm not sure if one of these is the equivalent files for VS2010.)
I've also made Internet Explorer my default web browser, since some of the forum posts mention this. My firewall is on, but I don't get any error messages relating to the firewall when I run the app. However, I wasn't sure whether there was a particular program I should add to my "allowed" list before running.
I ran the diagnostic tool: [URL] and I get the following output:
THE FOLLOWING SCRIPT will check to make sure that .NET Framework 3.5 is installed properly and will tell you what is not configured appropriately WINDOWS VERSION: 6.0.6002 POTENTIAL ERROR: REGISTRYDUMP: reg query "HKLMSOFTWAREMicrosoftNET Framework SetupNDPv2.0.50727" /v "SP"
HKEY_LOCAL_MACHINESOFTWAREMicrosoftNET Framework SetupNDPv2.0.50727 SP REG_DWORD 0x2
ERROR: NetFx2.0 SP1 is not installed POTENTIAL ERROR: REGISTRYDUMP: reg query "HKLMSOFTWAREMicrosoftNET Framework SetupNDPv3.0" /v "SP"
HKEY_LOCAL_MACHINESOFTWAREMicrosoftNET Framework SetupNDPv3.0 SP REG_DWORD 0x2
ERROR: Netfx3.0 SP1 is not installed
I presume there's been some problem with installation and setup. However, I'm not sure what exactly I need to re-install (if anything) to fix it.
View 11 Replies
Aug 27, 2010
I just installed SQL Server 2008 Management studio Express on my Vista machine.i tried connecting to local machine using :
.sqlexpress, (local)sqlexpress, or .SQLExpress, MyPCNAMESQLExpress
nothing is working, getting this error:
-----------------------------
Cannot connect to PC-NAMESQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------
View 4 Replies
Nov 1, 2010
OLE DB provider "SQLNCLI" for linked server "xx.xxx.xxx.xxx" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
View 1 Replies
Mar 2, 2010
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
View 3 Replies
Mar 23, 2010
I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio.I believe the problem is related to a change I made to the connection protocols. Before the error occurred, I had Shared Memory enabled and Named Pipes and TCP/IP disabled. I then enabled both Named Pipes and TCP/IP, and this is when I started experiencing the problem.
I have now set Named Pipes and TCP/IP back to disabled. When I try to connect to the server with SSMS (with either my SQL server sysadmin login or with windows authentication), I get the following error message:
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"
My first question here is: why is it returning a Named Pipes error? Why isn't it using Shared Memory? It seems like it is not listening on Shared Memory for some reason?When I set Named Pipes to enabled and try to connect, I get the same error message.My windows account is does not have administrator priviliges on my computer.
View 3 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
Sep 1, 2010
I have production server on our intranet and we have website on remote server with its own database. Now we want to sync some tables from our local database to remote database at some interval of time. I have own idea that if data sync is fail than we should get email about that from remote database.
For above scenario I was looking some ideas from you guys and different method to do it. I know about replication of database how to do that. Can we do it by asp.net, SSIS package which will be easy.
View 3 Replies
Feb 11, 2010
I 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]
View 2 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
Feb 8, 2011
i have created a website and a project[containing form1]...in my website a page is der which shud call form1...but i dont know how to do it..is it possible.
View 4 Replies
Sep 27, 2010
I am new to this new version of Webmatrix. I developed a couple of web sites on the previous version about 4 years ago.
I have downloaded and installed all of the recommended products using Microsoft Web Platform Installer including IIS Express, Web Matrix and Visual Studio 2010 Express.
1) I followed the Start From Scratch and set up the Hello World web site.
When I click on Run, if I am not online Internet Explorer opens but does not display the Hello World site.
If I am online and click on Run the Hello World site does display.
2) The new Webmatrix does not not have different tabs like the previous one did: Design & HTML & Code. To see the Design I launched Visual Studio 2010 Express but it still only shows me the code. In Tools/Options I have selected both Design view and Split View but both still only show me the code.
View 1 Replies
Apr 8, 2010
Can a user connect to my web site using an Orkut account ? Just like Google Friend Connect or Facebook, but with Orkut.
The idea is, the user goes to my web site, I have a "Connect using Orkut" button there, on click takes him to the Orkut login page, once s/he logins and grants access to my app, get's redirected to my web site with the Orkut ID as a parameter. The same procedure that works for Google Friend Connect and also Facebook Connect....
I haven't seen an example of this with Orkut. Can it be done ? Is there an Orkut Connect or similar ?
A sample in c# would be excellent, but I would be happy with a sample in any language.
View 1 Replies
Oct 6, 2010
how do I stop the default website from trying to connect to sql server?The web.config has no connection strings but yet I get "network related or instance specific error occurred while establishing a connection to sql server".i do not want to connect to sql server, have not told it to connect to sql server.
View 2 Replies
Jan 12, 2010
i am currently trying to make a website for my internship , my assignement is to make a login procedure using date and passwords from the active directory, i'm using visual web developer 2008 express edition to make this website, does annyone know how i could get the names , functions and passwords of the users from the active directory?
View 3 Replies
