How do I specify a port number for a Data Connection in the Server Explorer of Visual Studio 2008. It would use 1433 as a default but the administrators changed it for security purposes.
View 2 RepliesFailed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. make sure the user has a local user profile on the computer. The connection will be closed.
View 1 Replies Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
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: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
Is there any way to increase the number of tab in VS 2008?
View 5 RepliesI am making application with portable data terminal which connected to serial port. User will go with portable data terminal and scan data with it than we will connect it to PC and read all the data from it.
View 2 RepliesWhich version of Visual Studio 2008 do you currently use with NHibernate? I would like to test out NHibernate at home, but I'm not sure if I want to shell out $500 plus for VS 2008 professional edition. Has anyone had any luck with NHibernate on VS 2008 standard or even one of the VS express editions?
View 4 RepliesI'm using Visual Studio 2008 Query Builder and am trying to pass a value to a parameter that uses the IN OPERATOR.Here is my sql from qb:
SELECT COURSE_TITLE, INSTR_NAME, ADMIN_UNIT
FROM vwHRIC_EC_ContractSummary
WHERE (ADMIN_UNIT IN (@ADMIN_UNIT))
The trouble I am having is that if the parameter @ADMIN_UNIT contains more than one value such as (8X, CV) that the query doesn't return any data. If I run the same query with only one value such as (8X) it works fine.I have tried different formats like (8X, CV), ('8X', 'CV'), (8X; CV) but none have worked.I ran this same query in SQL Server Management Studio and and it returns data no problem but can't get it to work in Query Builder for my aspx application.Does anyone have any experience with this problem and how did you correct it?
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
I created and populated a database inside Visual Studio 2008 instead of using Management Studio.I need to run the script to create the schema for users and roles.The database does not show up in ASP.NET SQL Server Setup Wizard or in Management StudioThe only databases that do show up are master, model, msdb, and tempdb
Is there anything I can do to fix this or would it be easier for me to just create a new database starting in Management Studio and then connect to it from within Visual Studio?
Is there any tool for Visual Studio 2008 which can reformat ASPX code to make it more presentable (eg insert line breaks, format the lines so they wrap when necessary, etc)?
View 5 Repliesis it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem
Anyone know if I can maintain a VS 2008 (.net 3.5) project by using the VS 2010 IDE ?
View 1 RepliesI have in my laptop VS 2003, VS 2005 and VS 2008. I am making some SMS application in which I am using some DLL which need asp.net 3.5 so I am making application VS 2008. Now in my application I am using DAL and BLL method where in I am making .xsd file with TableAdapted from that I am making BLL files.
I added Formview in my aspx page configure it with Objectdatasource . IDE was not invoking the wizard for objectdatasource after lot finding. I got from some forum that after removing bin folder from application. It will start working. This was the first problem now I add gridview in my aspx page now and configure with Object data source. But when I go property builder of gridview I cannot see Edit Template, I can see only Empty template and Pager Template. Here my question this is new in VS 2008 as when i was working with VS 2005 I could see all Template. Next thing when change anything through property builder, I can see changes in the design view mode but I cannot see any changes in HTML source view. Again when I switch back to HTML source view to design mode all changes will go away. Why is it so !! For more info I will put my aspx, aspx.vb page code here.
[Code]....
Can Visual Studio 2008 Gridview control do grouping? And how?
View 1 Repliesi have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database
View 1 Repliescan Visual Studio 2008 be All-In-One tool to integrate source code continuously from team members, build, unit test?
Having used Visual Studio Team Edition 2005, unit testing each method within VS itself. I strongly believe that it is feasible to add-on tools. Example ankhsvn tool to use SVN from Visual studio [URL]
In my investigating i have come across number of tools(shown below) to use with Visual Studio 2008 professional
Development tool:- Visual Studio 2008 professional using Subversion as source control tool. Continuous Integration:- Hudson or Cruise control Build tool:- NAnt Testing:- NUnit, Selinium As Visual Studio 2008 can be used for unit testing I think NUnit is out of consideration.
In the same way i would like to have any other tools/add-ons to Visual studio to implement continuous integration, building and unit testing. This process should be automated such a way source code between team members is continuously integrated, built and unit testing is done as configured.
Objective is to use few number of tools as add-on to Visual Studio or achieve most from Visual studio itself (example unit testing). Visual Studio should be all in one tool.
I am aware that Team Foundation Server best suits my requirement, but it is out of scope due to its cost.
I downloaded Visual Studio 2008 Professional Edition via torrent.
It was working fine for months & i formatted my comp & when i tried to reinstall it is not getting installed !
It shows the following error !
and the error log file seems to be like this...
BUT.,
I'm able to use Visual Studio & i'm able to work in it....
I'm re-installing since 2 days for more than 4 times...
I have VS 2008 Professional Edition.....I want to test a function like this:
public int getIdByName(string name)
{
var item=from x in DATAB
where x.name=name
select x.id;
.
.
return idValue;
}
now I test end I have:
[TestMethod()]
public getIdByNameTest()
{
string name="Bob"
int expected = 1;
int actual;
actual = ClassGET.getIdByName(name);
Assert.AreEqual(expected, actual);
Assert.Inconclusive("Verify the correctness of this test method.");
}
The error in "test run" is:
Failed ......[Class]....... Test method threw exception: System.ArgumentException: The specified named connection is either not found in the configuration that is not for use with the EntityClient provider or thought is invalid
How can I ensure that web application converted from 2003 visual studio to 2008 visual studio
to have two files as it is when create a web file in visual studio 2008.The web application is in Chsarp. I have converted these filesfrom 2003 to 2008 but they still have three files each.
I am trying to convert guidance package of vs2008 to vs2010,
followed instructions as per this link {http://msdn.microsoft.com/en-us/library/ff697211.aspx}
and getting error as
Error 1 The "GenerateMenuResource" task failed unexpectedly....
i am downloading thr Visual Stuio 2008 Professional Version from microsoft website which is a 3.1GB software and a trial version which expired after 90 days, i want to know this trail version includes everything ?
i am confused by reading this on the VS2008 download page :
"Instructions
Visual Studio 2008 Professional Edition is a comprehensive set of tools that accelerates the process of turning the developer's vision into reality. Visual Studio 2008 Professional Edition was engineered to support development projects that target the Web (including ASP.NET AJAX), Windows Vista, Windows Server 2008, the 2007 Microsoft Office system, SQL Server 2008, and Windows Mobile devices.
This Trial Edition is fully functional but will expire after 90 days. This trial software is not supported by Customer Services and Support (CSS)"
[URL]
In visual studio 2005 for windows application , there is option where you can add New datasource by going to menu Data>Add New Data source, I know you can connect to database by using Dim con as connection, Dim cmd as command, Dim da as ataadapter, then query database and get result
View 1 RepliesIs there anything special you have to do to retrieve Filestream data using a SqlDataSource? I'm using VB and have this as my sqldatasource:
<asp:SqlDataSource ID="SqlDataSourceReadPD" runat="server" etc...
SelectCommand="SELECT [PDIPAttachment] FROM [PositionDescriptions] WHERE ([CP_IDString] = @CP_IDString)">
<SelectParameters>
<asp:Parameter Name="CP_IDString" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
PDIPAttachment is a FILESTREAM column in my table called PositionDescriptions
and this is some of my VB cod:
Dim dv As DataView = DirectCast(SqlDataSourceReadPD.Select(DataSourceSelectArguments.Empty), DataView)
Dim dr As DataRowView
For Each dr In dv
Dim data as Byte() = System.Text.Encoding.ASCII.GetBytes(dr("PDIPAttachment").ToString())
Next
The Filestream data has a PDF file in it, but what I"m getting back in "data" are 13 bytes consisting of: "System.Byte[]".
I'm trying to create a sql script that will connect to 1 server, backup 2 dbs, then connect to another server and restore the dbs. know i could create an application easily, use sqlcmd too but I wanted to do it on SQL Server Management Studio. I'm running version 10.0.2531.0
View 3 Replies