Opening SQL Command From SQL Server 2008?
Feb 24, 2010I cannot find where the sqlcmd is? i just want the prompt.
View 1 RepliesI cannot find where the sqlcmd is? i just want the prompt.
View 1 RepliesI have inherited a project which has many .ddl file's, I just need to get access one of them. I have managed to amend the .ddl file by using Reflector which outputted all the files into a specific folder on my C: drive. So now I have a bunch of files outside of my project. How can i recompile these files to create the new .ddl file so that i can overwrite the old one in my project? I have tried adding the new files as a new class project and building the site again, but no luck.
View 3 RepliesThe problem is I have a laptop that I take to University with me to all my lessons and lectures and it has Visual Studio 2008 installed on it and I work on my assignments in Visual Studio just fine. However when I get home I would like to use my desktop PC which has the exact same copy even from the very same disk of Visual Studio 2008 that is installed on my laptop. The problem is no matter what I do I can't open and work with any projects that I have created on my laptop.
Now if I create the project on my desktop PC it will open just fine on my laptop and I can continue to work with the project but the minute I save and take that project over to my desktop I get the self same error message shown below. [URL] I did do a little research and I found what looked like a solution for some people and that was to change the "SQL Server Instance Name" to SQL2008. As shown below it was set to SQLEXPRESS which is the same as what it says on my laptop copy. [URL] But all this did was present me with a new message as shown below. [URL] Uploaded with [URL] I'm completely at a loss as to what the issue is. Both my laptop and desktop run a fully updated copy of Windows 7 64Bit and have the same copy from the same CD of Microsoft Visual Studio 2008.
I have a site that is running on a Windows Server 2008 machine with IIS 7.0, when I try to open it with Visual Web Developer 2010, it says the following:
error: unable to open site: ... The Web server does not appear to have FrontPage Server Extensions installed.
Looking on the server Frontpage Extensions 2002 are installed, so what could be wrong?
The thing is, I used to be able to open the project and work on it, etc...
Open Website -> Remote Site -> Enter remote site name -> tries to open & error above!
Visual Studio (SP1) runs fine until I try and view .aspx source files with the lines
<style type="text/css">
</stlye>
anywhere in them, upon which it freezes (i.e is totally unresponsive) and I have to use the task manager to shut it down.
I have read a lot of questions about Visual Studio 2008 crashing on viewing some source files. However, I still can't fix this problem.
I have systematically deleted and re-included all other code and it comes down to these two lines, which is very confusing. Sometimes it happens as soon as the lines are added, sometimes it doesn't freeze until I build the solution with any of the problem pages open. I can add external style sheets, and it only started recently.
I had Resharper 4.5 installed and have since uninstalled it, and do not have anything else installed.
Also, it happens to other people with the same source code, and re-installing Visual Studio does not fix the problem. So I have several questions:
Is there any way I can find out what's happening? I don't understand how the code (the css tag itself) could crash Visual Studio, and am thinking that this is unlikely and it must be something else within my solution, would this be a safe assumption? Could this have anything to do with installing Office 2010?
I add a 'Command Field' in a data gridview, and i put a code in DataGridView1_RowDeleting and it is working..my problem now is how i can put a confirmation message before deleting a record in a datagrid?
View 1 Replies[Code]....
C# CODE :
[Code].... Opening SSRS 2008 report in VS 2010 with Report Viewer?
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 can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 RepliesI have the following X.aspx code..to download excel file from Server
[code]....
The file you are trying to open 'x.aspx', is in a different format that specified by the file extention....
How can I let excel know the correct file name ..
I have saw this done before I thought. Where you have a web application, and a debugger can output server side messages. I am trying to do something similar to this. I am not getting a Console from it though.
public class Global : System.Web.HttpApplication
{
protected void Application_Start(object sender, EventArgs e)
[code]...
what should be the database schema for online account opening form with joint account holders and every participants (in a joint account) have seperate contact and personal detials.
View 1 RepliesI have looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it.was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go.
Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking!
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.
I am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
View 2 RepliesI have a web service that runs a query (from C#) to get a dataset from sql server. I get the following time out error. Googling on this error says, you can set the timeout on command object. But I am not using command object to set the timeout. This is the code I am using to get the dataset.
code:
[code]....
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 RepliesI want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 RepliesI want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
View 2 RepliesI am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj;
OdbcCommand cmdObj;
OdbcDataAdapter daObj = new OdbcDataAdapter();
public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) {
conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
[code]....
we can not add .mdf file to the project in vs2008 and sql server2008 when i am adding .mdf file its displaying an error message so it is not possible to add
View 2 RepliesWhen i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
I have a grid within another grid. In the detail grid I have image button for which I am giving the URL of documents in the source itself. On clicking on Image button, document can be opened for which I am using a Handler. The code for opening the document is written in the handler.This code is as below:
[code]....
The document can be opened when clicked on Image Button. but, the problem is taht after opening the document, I am unable to perform any other action in the grids.... Other actions like...selection in checkboxes(master grid contains few check boxes),other link buttons in detail grid....etc etc...I am getting the following errr:
PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled
This is because after opening any document,for any action again Handler is being called.
I have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection object using the .open() method on the object instance. The upload and writing of the file to the file system works fine but I get an error when trying to open the file on our production server only. The application works fine on two other servers (development and testing servers).
string connectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";") + "Extended Properties="Excel 8.0""
OleDbConnection connection = null;
connection = new OleDbConnection(connectionString);
connection.Open();
The exception comes on production server at connection.Open() some times, when I reset the asp.net worker process it started to work but after some hours/days It occurs again. how can I fix this issue which comes in production some times but very irritating, or there is some other work around.
[Code]....
Using above code, I got succeeded in printing PDF file through command line. But it runs the Acrobat Reader and opens Save dialog box.
In my case, I want to suppress Save dialog box and save the file on other location using c# coding. I mean I want to save a PDF file behind the scene.