I have problem accessing an SQL server DB on a remote server.Actually, I had no problem with creating a connection string to it using the Visual Web Deveoper 2005 Express Edition GUI, however, I have problem connecting to it through the code.This is the connection string created by the GUI, and connection test on the connection wizzard GUI just works fine.
[code]...
i built an web application that need to work with sql server 2005, i'm using
linq to sql for my queries, and i'm using the dataclasses.dbml object.
the problem is that i can't see the database in the server explorer, so, i can't drag and drop
the tables to the dataclasses.dbml object, i understand that the application need to be rgistered
in the sql server to be able to do so and to be able to read and write to it.
I'm having a hard time really grasping this concept. I've done a lot of development with Microsoft Access, so I'm very familiar with the structure of tables, queries, and all that sort of thing. And maybe that's really hindering me with understanding what to do with ASP.NET/VB.NET development.
I have an ASP.NET web application, and I want to pull a UserName and the date that this user was created and last logged on. UserName is in the ASPNETDB's aspnet_Users table, and date created and last logged on is in the membership table. So in database explorer in Visual Web Developer, I opted to create a "New Query". It brought up the UI and I selected these two tables. Linked them with the primary key of UserID. Then I selected the three necessary fields (UserName, date created, and last logon date). Looks good, viewed the data. But there is no way to save this query to programatically reference it. I want to see what user is logged on, and then look through this query to get the other two pieces of data. But there is no way to save/reference this query.
All of examples on web assume the remote server which we are going to debug remotely is on the same network. I have only a static IP address and using RDP I connect to server.
I've installed Remote Debugger on remote machine but cannot set the static IP address as Qualifier in visual studio -> debug -> attach to process
I have an ASP web Applicaton using C# that runs great on my local host where I can access the documents via Fully qualified path (e.g., C://MyProjects/MyProject/File.xls).However once I publish this to a server (and it is a virtual server) I can no longer provide a fully qualified path name I can only give something like (//server/project/File.xls - which is the path I publish to) and it doesn't like this at all. First it doesn't publish the documents to the server even though I added them to my project. So I put them on the server manually and even tried adding the documents as embedded resources but that doesn't allow me to edit and open them as needed. This is really a pain. Why can I not just put them in the file path and access them using "File.xls" like I used to in the old days? I don't like this change at all. It should not take me a day to figure out how to access a document on a server.
View 2 RepliesI installed SQL server along with Visual Studio 2008 Express edition Developer edition.
1. I want to access this server via Management Studio Express( I installed later) how can do it? Windows authentication or Sql server authentication - give me step by step procedure.
2. How to use the server in asp.net programs - how to give connectionstring
I'm trying to debug my web application on my localhost machine in Visual Studio 2010 and I keep getting this error: "unable to start debugging on web server. The Microsoft Visual Studio remote debugging monitor(MSVSMON.exe) does not appear to be running on the remote computer."
Is there a way I can turn this off as I'm not trying to make any attempts debugging remotely.
While running an app from the server where it is deployed the website works fine, however when trying to access it from a different machine(placed in same network), using the same credentials, it shows that I am not an authenticated user.
[code]....
writing a web Service and one of its web method, I want it to download a png file in form
of buffer from remote server. And My consume application will write that buffer retured by Web service in to file on User's Computer.
However, I am able to do this using Local Web Service but when I published that service on my web server, I always get null retuned
And even in one of my test code while copying file from that server , I always get Access Denied.
Following things I have done for above issue.
1] I even tried making the Anonymous user for the web service the system administrator (with the correct password), to no avail.
2] I also tried sharing out the folder I'm pulling files from to allow access from Everyone.
[Previously same service was working fine on another remote server with IIS 7.0, we checked server IIS Settings but in vain.]
if you know where we are mistaken guide me to resolve this issue as its very urgent.
I'm still trying to deploy this site, but with every problem I solve, another arises. Anyways - I've set up the database at my hosting to allow remote connections, and it is running Sql Server 2005. On my development machine, I am working with Sql Server 2008.
I've installed the asp.net schema on my hosted database, and have created several users from the ASP.NET web administration interface, as well as tested that the login works. Running the application locally with the remote connection string nets the same results. However - I'm able to run my scripts and generate my tables and stored procedures without errors - but when the site is run I get the following error on all of my .aspx pages that try to access a stored procedure:
Server Error in '/' Application. Incorrect syntax near 'LoadProfileData'. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'LoadProfileData'.
Source Error:
Line 62: adapter.SelectCommand.Parameters.Add("@ProfessionalName", SqlDbType.VarChar).Value = professionalName;
Line 63: DataSet profile = new DataSet();
Line 64: adapter.Fill(profile, "Profile");
Line 65: return profile;
Line 66: }
Is this a possible Sql 2005 vs 2008 issue? I'm hoping someone else has seen this issue in a similar scenario and can point me in the right direction. The server is running asp.net 2.0, 3.0 and 3.5 and IIS 7.0.
I'm getting "Cannot connect to ASP.NET development server" almost every time I stop the ASP.NET server before restarting the project in debug mode. It can take between 15 seconds and 2 minutes to get the error message, and Visual Studio is frozen.
Sometimes I get three in a row, and I have to wait 2 minutes each time, or go into Task Manager and kill to process. Then I have to start Visual Studio 2010 again, which is at least three times slower than Visual Studio 2008 to open.
It's *extremely* annoying. I know I don't have to close the server if the code has changed, but sometimes I simply want to restart my website in debug mode (there is a cache on most web service calls, so this clears the cache). A workaround is to add "foo" code to a class and restart the project.
I'm running Visual Studio 2010 Professional on Windows Server 2008. I'm running the Visual Studio Power Tools too, with the latest update.
sorry for buther I'm a newbie in ASP.NEt MVC and I have some issue deploying my application on IIS, that use a logo image within my main master page declared as
<img src="../../Content/logo.bmp" alt="logo" />
When I use the internal visual studio web server work well but not on my other IIS Server.
What's the mean of ../../Content ? Is this directory deployed with particular rules?
I've installed visual studio 2010 full version and worked on couple of assignments. Right now, I'd want to connect to SQL server database to move ahead and store and retrieve data into the database. Can someone please point me in theright direction or walk me through the configuration. I see sql server 2008 has come with Visual Studio 2010. Not really sure if i need to install anything else. Also, post a sample application code to connect and fetch data using a select statement ??
View 23 RepliesI want to use SQL Server 2008 Web Edition with Visual Studio 2010 Professional. (Both are installed fine on Windows 7).I know I can change the entry in Data Connection (in VS Options) to the named instance of my Web Edition but, when I do this then try to add a database to an App_Data folder (via Add New Item...) I get an error saying I need the Express version of SqlServer 2005 or 2008 (I opted NOT to install this during installation as I knew I'd be using the full Web Edition instead).
I CAN add a data connection to a database created in the Web Edition instance by Sql Server Management Studio so VS can use the Web Edition instance.So, if I've changed the Data Connection to the Web Edition instance, why can't I add a database using that instance to my App_Data folder? Can I ONLY add Express instance databases to this folder?
How to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I have installed a vs 2010 ulitimate . it's have Sql server 2008, but i want to Open SQL Server Management Studio 2008,
View 1 RepliesAfter I installed Visual Studio 2008 Standard edition, then I upgrade "SQL Server Express 2005" to "SQL Server Express 2008 SP2". Process upgrading SQL Server Express 2008 was going succesfully (none of the process was fail).
But when I create a New Website I could not add a new item "SQL Server Database" into my website file. Because Visual Studio always rejected any new "SQL Server Database" by giving message below (underline):
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.
Would something be missing, not working, or confusing if I do this? First, install SQL Server 2008 Standard, and SP1. Then, install Visual Studio 2010 Professional, unchecking SQL Server 2008 Express option. Or would I need to fix any configurations afterwards?
View 1 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 Repliesi acess vss from lan with no problems and now i want acess from a remote computer not in a Lan
I need access over the Internet
What are settings i need to set up in the server and my client machine
I'm looking to upgrade from the express editions and I was wondering if Visual Studio Pro edition came with SQL server 2008 R2 developer edition.
View 4 RepliesDebugging running remote web application
View 1 RepliesOverall debugging works, but each step through code takes dosens of seconds.
I've already closed all additional windows like stack trace,watches,autos; deleted all breakpoints.
server and dev machine are located in different domains, so i set up local user on both, with matching password. remote debugger is running as service.
looking at security log, I found quite a lot of entries about remote debugging account logging in (record about every minute).
how i can speed up remote debugging?
dev computer: quad core, 8 Gb mem, win 7 x64 , visual studio 2010 ultimate target server: asp.net website , 2xdual core xeon, 2Gb mem, remote debugger 2010communication channel: vpn , 5 mbit , latency about 20ms. (seems that debbugging never uses more than 20 kb/s)
My website application is developed with Visual Studio 2008. The programming is written and tested with a project saved on my local hard drive. Afterwards the program is transferred to my http site with the Copy Web Site function of VS 2008. Previously Visual Studio always knew the location of the remote web site. It always started the Copy Web Site function with my source site as the http site and the remote site as the site on my hard drive.
Recently, Visual Studio demands that I enter the remote site. Of course, I can do this and cause the Copy Web Site function to work. However, when VS knew the remote web site, it could easily notify me as to what changes had occurred on the Remote site since the last Copy Web site function. This helped me in determining which files needed to be copied to the http Source web site. How can I permanently link my hard drive file location as the source site in the Copy Web site function of Visual Studio 2008?
How to connect to a remote oracle database with Visual Studio?
I know how to create the connectionSting in web.config. I wonder if I can connect to an oracle database when creating a LINQ class so that tables will show in the Server Explorer.