I 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 Replies
I am able to create Virtual Directory on local machine, but I want to create it on a remote machine.
View 2 RepliesIn 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();
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
I was logging in to my app, but my app always takes me back to log on page, so I set a break point at 'If Not (HttpContext.Current.User Is Nothing) Then' to see if the HttpContext.Current.User is Nothing.
After I clicked log in button, my app was processing a while then pop up the error message.
The error message is:
Unable to automatically step into the server. Connecting to the server machine 'xxx' failed. The debugger cannot connect to the remote computer. This may be because the remote computer does not exist or a firewall may be preventing communication to the remote computer.
My app doesn't have any codes to ask connecting the server machine xxx and it is not suppose to connect to a remote server; and I don't know what xxx is for.
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 RepliesMicrosoft recommends testing older versions of IE with the following virtual machinesThis is all fine and good, except that the virtual machines can't see the Dev Server from Visual Studio. This makes it very difficult to develop or debug since I have to copy or deploy to IIS for every little change I make. I've tried using ARR, but it seems it can only forward to one specific port at a time, whereas i need to have the port typed in the address bar of the virtual machine to match the port that it is connecting to on the host machine. Is this possible?
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 RepliesWe have staging server and production server for website. We will move the changes from the staging server to the Production server through the FTP.
Since we have the product release for every 3 months. So, we need to redirect to the latest version in the Production server IIS. Is it possible to access the Production server IIS and redirect the web site link from staging server ?
How can I call a C# program located in a Virtual Directory?
View 4 RepliesI am trying to access a wcf service hosted on a server running on a virtual machine on a windows 2008 R2 hyperv. When i access this service when running my asp.net website through code everything works fine how ever when i deploy the application on the local IIS , in the deployed mode i am getting an securityaccessdeined exception. My Asp.net app is running on a IIS server on another virtual machine. The stack trace is as given below :
Environment Info: My asp.net app has built on .NET 4.0 framework using VS2010. My WCF services are based on .NET2.0 framework.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 14-07-2010 13:56:54
Event time (UTC): 14-07-2010 08:26:54
Event ID: dd1986e7e7dc4473beb908754c75a580
Event sequence: 4
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/StratosTest-1-129235696025728041
Trust level: Full
Application Virtual Path: /StratosTest
Application Path: C:inetpubwwwrootStratosTest
Machine name: MC-NEWCODE
Process information:
Process ID: 1752
Process name: w3wp.exe
Account name: IIS APPPOOLASP.NET v4.0 Classic
Exception information:
Exception type: SecurityAccessDeniedException
Exception message: Access is denied.
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()
at Default2.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Request information:
Request URL: http://localhost/StratosTest/Dashboard.aspx
Request path: /StratosTest/Dashboard.aspx
User host address: ::1
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOLASP.NET v4.0 Classic
Thread information:
Thread ID: 4
Thread account name: IIS APPPOOLASP.NET v4.0 Classic
Is impersonating: False
Stack trace: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()
at Default2.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
How do I load a definition file which contains some start up logic at Application_Start?
I only know the virtual path but not the server physical path. How do I convert the virtual path to server path without Server.MapPath()
I am not sure I can access httpcontext or not in the application start stage.
I'm using VS2010 and need to give my remote server asp .net account (IUSR_istereos) access to my local intpub folder
how do I do that?
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 RepliesQuick question. When updating aspx.cs files on a virtual dedicated server does it require a restart of the virtual server for the changes to take effect?
View 5 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 Repliesconnecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
View 1 RepliesAs a follow on from this question I'm building a custom server control to be placed on a Sharepoint 2010 master page. The idea behind this is that it will display a menu that is dynamically populated from the database. As this is a server control, I'm building it in a dll but I've run into a small snag. As it has to connect to the database, I need to store the connection string somewhere (and have it able to be configured based on target configuration (dev/test/prod). I was intending to the user the Entity Framework as my ORM but i'm confused as to where the connection string is to be stored. In a normal ASP.NET web app it goes in the web.config, but this is a server control in a external DLL.
Where do I store the connection string so that I can just build and deploy the assembly containing the server control.
EDIT:
Before I post a bounty, I have tried using an embedded resource XML file to hold the connection string and while this works, I'm curious as to if this is best practice/a better way?
so i have a code which gets me the ip address of a machine i am wroking on.
so if my gui is published on the server and i access it from my local machine it gives me tha address of my local machine and when i access the gui from the server itself it gives me the server address.. which is fine.
But when i put the gui on a VM server and run it from a VM server itself i dont get the ip address. this works fine if i access it from another machine but does not work only when accesing gui on VM server..
[code]....
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.
I'm new to .NET and while starting to learn ASP .NET MVC2 framework I see that you can create a .mdf file inside the App_Data folder and connect to it or you can connect to a SQL Server.What is the difference between these to methods of interacting with a database? What are the advantages/disadvantages of one over the other?
View 1 RepliesI have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
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 have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
I have a Windows 7 machine hosting a Windows 7 virtual machine. I am developing a web application using visual studio 2010 on my host machine. I want to run the application in debug mode and access my localhost server from a browser on the virtual machine. (The purpose of this is to be able to debug an application that uses Windows Authentication using different users without having to log off and on for different users on my host machine...)
I am using a bridged connection for the virtual machine. I googled how to solve this problem and most of the threads that I found said that if I was using a bridged connection, I could access the server on the host machine by just entering the IP address of my host machine into the url in the browser of the virtual machine. I have tried some different urls using the IP but none of them have worked.
As an example, suppose I run my web application in visual studio on my host machine and its url is
http://localhost:62789/MyPage.aspx
Assume also that I ran ipconfig in CommandPrompt on my host machine and found out that the IP address for my host machine is xxx.xxx.xxx.x. What url should I enter on the virtual machine to access my web application?
EDIT:
I set up IIS to host the web project. After that, I just added the following line (xxx.xxx.xxx.xxx is my IP) to my hosts file and I was able to access the website from the virtual machine:
xxx.xxx.xxx.xxx MyWebsite.net
I also had to edit my firewall settings.
