when i am running both sql server management studio and beb developer and i try to connect to a database in web developer simultaneously it gives me error
file used by another process file located on UNC share
but if i am only running web developer it gives me no error
so please tell me how to connect to a same database simultaneously
hello eveyone..i have just downloaded and installed the visaul web developer 2005 express edition and sqlserver 2005 express edition.On top of that i even downloaded and installed the northwind database.But my problem is when i am connecting to the northwind database by clicking toos menu>connect to the database>choose datasource>new connection>..i have provided it with the required information..but as soon as i press "Test Connection" button the following error box displays.. "an error has occured while establishing a connection to the server.when connecting to the sql server2005,this failure may be caused by the fact that under default settings sql server doestnot allow remote connections.(provider:Named piped providers,error:40-couldnot open a connection to sqlserver.)" i have no idea whats is all about..can anyone get me pass this error..
View 2 Replies View RelatedHere is the error message I get:http://img109.imageshack.us/my.php?image=error2ug.jpgI have just installed both packages and havent done much in the way of configuration... What do i need to do? Thanks!
View 2 Replies View Relatedlo all,
when i try and connect web developer to a sql file i get "An error
occurred while establishing a connection to the server.When connecting
to sql server 2005,this failure may be caused by the fact that under
the default settings SQL server does not allow remote
connections(provider:Named Pipes Provider,error : 40-Could not open a
connection to SQL server)"
thx for any help
Charlie
hi., i need help.,i Created a database using the SQL Server 2005 Express SQL Server Management Studio Express (SQL Server MSE)but i don't know how can i get the database that i made to put it in the Folder "App_Data" in my Visual Web Developer (VWD). is there any process or something to connect my database that i make using the SQL Server MSE to the VWD?Please help me, THanks
View 3 Replies View RelatedHi, i am now using the visual web developer 2005 express edition. i have tried to create a search button to search for my SQL database by using the VB in VWD. i tried to enter the code but i dun seems to get it right... can any 1 help me by teaching me steps" by steps".?
View 1 Replies View RelatedI can access an SQL Server 2005 database from VWD, but for ease of uploading to a server and to maintain the database within just VWD environment would like to import it directly into VWD and its App_Data folder from the local machine SQL Server.
I guess this is more than copy and paste ('especially since this is not allowed becase the database is being used by another program').
I've seen posts about the reverse process but not this way. Any simple pointers please?
I would occasionally get the error below when trying to access a database in my project/App_Data folder using Visual Web Developer Express 2008.
I would re-boot and the problem would go away.
I now have the problem all the time and am unable to access my database file in the App_Data folder nor ASPNETDB.mdf.
I am not trying to access a remote database. I have not knowingly changed any settings.
Has anyone seen this problem?
Can anyone help?
Thanks,
Charles Smith
ERROR MESSAGE:
€¦ under the default settings SQL Server doesn't allow remote connections. (provider: SQL Network Interfaces, error 26 €“ Error locating Server/Instance specified)
I have made my website using SQL Server Express edition. It is totally database driven and manypages use databases to display data. My problem is that after paying for webhosting fees my web host told me that they do not support SQL Server express edition. Instead they have support for MySQL and Ms Access. Except that there is this MS 2000 Database service for an additional cost. Any recommendations what I should do except changing the host? If I pay for MS 2000 Database servicem, will my website work? My user management(i.e ASPNETDB database) was created by Visual Web developer and I don't want to do user management myself. Any advice?
View 2 Replies View RelatedThere are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
in visual studio web developer express edition 2008 i added a new item this was a sql server database which i called test2. I added a table called comments, and the fields name, email, comments, IPAddress, and Date and in my comments.aspx page i added a name textbox, a texbox for email, a textbox for comments and the submit button i double clicked on the submit button and added the following code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mydS As New SqlDataSource mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString1").ToString mydS.InsertCommandType = SqlDataSourceCommandType.Text mydS.InsertCommand = "INSERT INTO comments(Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)" mydS.InsertParameters.Add("Name", TextBox1.Text) mydS.InsertParameters.Add("Email", TextBox2.Text) mydS.InsertParameters.Add("Comments", TextBox3.Text) mydS.InsertParameters.Add("Date", Date.Now) mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR")) Dim rowsaffected As Int16 = 0 Try rowsaffected = mydS.Insert Catch ex As Exception Server.Transfer("errors.aspx") Finally mydS = Nothing End Try If rowsaffected <> 1 Then Server.Transfer("errors.aspx") Else Server.Transfer("confirm.aspx") End If End Sub Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged End Sub but when i run it it gives me a problem with this line mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString2).ToString and says something abt unidentified object and I want to know how do i set the connection string or alternatively where?????? and my table does not update with the corresponding values i enter on the webpage. i also changed the authentication mode to forms instead of windows as i was advised but i'm still having a problem
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data.
Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing).
When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server.
Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine?
Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic?
The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I
was about to order SQL Server Developer Edition 2005 on Amazon, to use
with Visual Web Developer 2005 Express, when I read a user comment that
the two are incompatible with each other. Does anyone know for sure if
that is true?
What I'm wanting to do is develop an ASP.NET web
application on a web host using a SQL Server database. I use VS2003 and SQL
Server Enterprise 2000 at work, but I'd like to learn the 2005 editions
for this side project. I don't own any of the developer tools/IDEs
personally, so I'm trying to find the most affordable way to do this
for my home business.
Thanks for any advice,
Keith
Hi, Can I use Sql Express Edition with Visual Web Developer at the same time? I tried but I always get a permission error. Also, when I try to attach a database (that I created in Visual Web Developer) to the SQL Express i cant find the .mdf file, I don't know why? Is there is a way where I can specify a folder where I can keep the mdf and allow both applications to access it?
View 2 Replies View RelatedHey,
Im trying to make a website that I can enter information on the website and have it transfered to the database the problem is the website and database are on two different computers , how do I copy the data base onto the other computer and have it will be ready to take information from the website and store it in the database?
hi
i found these books for learnning sql server
which better to read for Visual Basic Developer ??
http://www.sqlserver2005books.com/1-3805-0735622507-%20Microsoft_SQL_ServerTM_2005_Reporting_Services_Step_by_Step_Step_by_Step_Microsoft.html
------------------------
http://www.sqlserver2005books.com/1-3805-0735622078-%20Microsoft_SQL_ServerTM_2005_Database_Essentials_Step_by_Step_Step_By_Step_Microsoft.html
thank you
Yes I am a newby (or is that newbie) and this is my first post.My Visual Web Developer site work really well on my PC, I read the books took it slowly, created logins and sql tables and then found a good hosting company with Server 2005 ... I though I was one step away from the road to success ... then I hit the big brick wall. Spent hours on Google trying to find some answers without joy ... all I found were lots of users with the same or similar problems ... and some answers that caused more problems !1) Please can someone give my a 'step by step' idiots guide on how to convert my ASPNETDB.MDF content to run on Server 2005. I have Server Management Studio so I am happy about loading the translated files but I don't understand how to break them down into tables and logs.2) Once the files are across can I run a connection string from VWD directly to the tables on the server instead of SQL local ? I assume that is set in web.config !!.... normally I am happy to learn by trial and error. But I can't get around or over this brick wall.Welcome assistance, advice or a ladder ... with simple instructions ?
View 2 Replies View RelatedI'm trying to attach to my database that Visual Web Developer Express (VWD) created through SQL SMS, however I cannot. When I try to locate the database, the file tree stops at: c:Documents and SettingsMeWhen I check the location in VWD, it shows my database at:c:Documents and SettingsMeMy DocumentsVisual Studio 2005WebsitesmySiteAPP_DATAASPNETDB.MDF When I navigate in explorer, the file is there. When I try to copy and paste the address, SQL SMS gives me an error of:Access Denied. Error 5133 I have shut down all process using the database. Ideas?
View 2 Replies View Relatedhi i added a new table to my existing database in visual web developernow when i am running this i get an error Invalid object name 'TestTable'.with this sql command string sqlCmd = "INSERT INTO [TestTable] ([Employee], [Client] ,[Project] ,"+ "[TimeSpent],[TimeSpentOnline] ,[Description],[Incident], [Billable],[AfterHours],[Pending],"+ "[OnSite] ,[WorkOrder]) VALUES( '" + employee + "' ,'" + client + "','" + project + "','" + timeSpent + "','" + timeSpentOnline + "','" + desc + "'," + iactive + "," + bactive + "," + ahactive + "," + pactive + "," + osactive + "," + woactive + ")"; but it was working fine i was using this table which is exactly the same thing just a different name ..by the way i didnt create the tracking table string sqlCmd = "INSERT INTO [Tracking] ([Employee], [Client] ,[Project] ,"+ "[TimeSpent],[TimeSpentOnline] ,[Description],[Incident], [Billable],[AfterHours],[Pending],"+ "[OnSite] ,[WorkOrder]) VALUES( '" + employee + "' ,'" + client + "','" + project + "','" + timeSpent + "','" + timeSpentOnline + "','" + desc + "'," + iactive + "," + bactive + "," + ahactive + "," + pactive + "," + osactive + "," + woactive + ")"; i have already double checked the data types and also have made sure that everything was saved properly..... Can any one plz help me out on this
View 1 Replies View RelatedI'd like to be able to query a database to get the value of a
certain row. However, I'd like to save this value into a variable
and use them as I'd like, NOT nessessarily display them in a data
control such as a gridview etc. I've been able to find a lot of
information on binding datasourses to predefined data controls, but I
can't find anything on simply querying a database for values and using
those values to display a page as I want.My basic end goal is to create what's basically a shopping site like Amazon only for about 100 or so products.Thanks
in advance for any help. I'm just getting into Visual Web
Developer so please excuse my ignorance and lack of posts.
i have visual web developer make the asp.net.mdf that it auto made, for the users and roles, i added 2 more coloms to the database in the membership table called address and phone
when i make a sqldatasource and give it a select and insert command, i also give it a couple dummy values to test it this is my code,
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs)
SqlDataSource1.InsertCommand = "INSERT INTO aspnet_Membership(Address, Phone) VALUES ('9', '2')"
End Sub
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:saveaddnphone %>" SelectCommand="SELECT Address, Phone FROM aspnet_Membership"></asp:SqlDataSource>
Instance failure.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Instance failure.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: Instance failure.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
OK ... so like thousands of others I am a Visual Studio Newbie. I want to learn, I want an ASP website, I have worked hard with Visual Web Developer, bought the books read the articles .... then bang walked into SQL ... ouch ... that did hurt !!
Downloaded SQL Management Studio ... thought I had found the solution. Like all the Express products it looks great ......so what is the problem ? It is a simple problem and from looking at hundreds of other forum posts it seems I am not alone !!
Nobody has provided a simple guide to the steps you need to take to get MDF's out of Visual Web Developer onto a Server. (in my case 2005) - ideally written by an expert who can avoid the temptation of wondering into 'techguruspeak'.
I know nothing is straightforward - I accept that it may depend on your hosting setup - but when you are going round and round in circles just a few arrows showing the way out of the circle will stop you falling over (ouch ... not again !!) and start you on the pathway towards success.
So can someone please explain the process of transferring databases from VWD through SQL Management Studio. All I want to do is get the site up .... make progress ... get motivated ....then I will come back and start tweaking !!
So is there anyone out there who can write :A 'simple step by step guide for newbies' for moving VWD databases to SQL Server' in words us morals can understand !
No quesswork please ... let's have someone who can run SQL transfers from VWD while blindfolded ... at least that way we will have something in common !!
If you are that SQL 'superstar' who has used the Studio packages ... you have a unique opportunity to make 'thousands of people very happy' .... that can't happen every day !!
I'm trying to attach to my database that Visual Web Developer Express (VWD) created through SQL SMS, however I cannot.
When I try to locate the database, the file tree stops at:
c:Documents and SettingsMe
When I check the location in VWD, it shows my database at:
c:Documents and SettingsMeMy DocumentsVisual Studio 2005WebsitesmySiteAPP_DATAASPNETDB.MDF
When I navigate in explorer, the file is there. When I try to copy and paste the address, SQL SMS gives me an error of:
Access Denied. Error 5133
I have shut down all process using the database.
Ideas?
When attempting to use VWD Express' built-in web server I recieve the following error in browser window:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I've done the following:
Followed advise on How to: Configure Express to accept remote connections
Retrieved port_address from SQL Server Configuration Manager (i.e. SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS > Select TCP/IP Protocol name > RT click on Properties > IPALL - TCP Dynamic Ports port_address
netstat -ano | findstr "port_address" shows the following
TCP 0.0.0.0:2247<-port_address 0.0.0.0:0 LISTENING 1620
Attempted to connect to SQLEXPRESS service using dynamically assigned port_address with this command
F:Program FilesMicrosoft SQL Server90ToolsBinn>SQLCMD -S .sqlexpress,2247
HResult 0x2AF9, Level 16, State 1
TCP Provider: No such host is known.
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I can successfully connect to SQLEXPRESS using SQLCMD with flags
- S .sqlexpress
and
-S np:\:\.pipeMSSQL$SQLEXPRESSsqlquery (named pipes)
Using VWD Database Explorer I have connected to my SQL Server 2005 Express databases and the Test Connection button on the Modify Connection form reports the connection strings are good. Lastly SQL connection string property field User Instance = True and neither database resides in "My Documents" folder.
Questions:
Does VWD local web server require configuration?
Is this a Named Pipe or TCP/IP configuration problem? Should Shared Memory be disabled?
Should I give up on VWD local webserver and install IIS instead?
Hi,
Can anyone help me on;
how to insert an image into 'MS Visual Web Developer'?
I would be v. helpful for your help
From Dec(15)
Hi,
I'm new to SQL Server and am now learning how to operate SQL Server Express 2005.
I'm getting the following error when attempting to install Visual Web Developer 2005 SP1.
"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch"
My machine runs on XP Pro SP2, .NET Framework 3.5.
Currently, what i have got on the computer are as follows
Microsoft SQL Server 2005: SQL Server Management Studio Express, SQL Server Configuration Manager.
Hi to all and thanks in advance.
I´m newbie with SQL Server & VWD Studio, and I´m trying to develop a little web application.
The issue is that my application can´t upgrade the DB fields if you introduce a NULL value.
When I created the table, I denied the NULL value introduction. I cant insert NULL values using the SQL Server Management Studio, but I can introduce these values using code.
Do someone have any suggestion to hadle properly this issue ?
B/R
I'm developing using Visual Web Developer and want to have a web page that shows the contents of a table. I get the error message when testing the connection through database explorer "Login failed for user ''. The user is not associated with a trusted SQL Server connection".
The database is located on a server running IIS and has SQL Server Express installed.
I'm developing using Visual Web Developer and want to have a web page that shows the contents of a table. I get the error message when testing the connection through database explorer "Login failed for user ''. The user is not associated with a trusted SQL Server connection".
The database is located on a server running IIS and has SQL Server Express installed.
Hello Everyone,
I have just installed then above softwares and I am trying to work on a very simple application.On my Default.aspx I created a Gridview and connected it to the dabase.Everything works fine?When I try to work on the Security under Website->ASP.NET_Configuration I get the error:
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. I see that a lot of people get this problem. Can someone sugest a way out?Thnaks in advancePati2005
Hi, i'm using visual web developer 2005 express and visual basic .net, and sql server, i'm trying to execute a stored procedure to make a bulk insert from a text file into sql server table, but i'm facing problems when i get here: Dim myCommand As New SqlClient.SqlCommand(strsql1, objConn) 'Try myCommand.CommandType = Data.CommandType.StoredProcedure myCommand.Parameters.AddWithValue("path", "C: est.txt") myCommand.Connection.Open() myCommand.ExecuteNonQuery() myCommand.Connection.Close() myCommand.Dispose() when i get to the line in bold i receive a message saying that couldn't find the file "Cannot bulk load. The file "C: est.txt" does not exist." , but the file is there on C: and visual web developer can't find it. Bellow i pasted the stored procedure. Seems that my code can't find the file. set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[sp_ed_insert]@Path varchar(max)AS--Step 1: Build Valid BULK INSERT StatementDECLARE @SQL varchar(2000) BEGIN -- Valid format: "John","Smith","john@smith.com" SET @SQL = "BULK INSERT Ed_order_temporary FROM '"+ @Path +"' WITH (FIELDTERMINATOR = '"",""') " END--Step 2: Execute BULK INSERT statementEXEC (@SQL)--Step 3: INSERT data into final tableINSERT Ed_order (ed_order_number)SELECT CASE WHEN order_header = 'O' THEN SUBSTRING(ed_order_number,1,DATALENGTH(ed_order_number)-1)end FROM Ed_order_temporary--Step 4: Empty temporary tableTRUNCATE TABLE Ed_order_temporary Any help is welcome. Thanks.
View 1 Replies View RelatedHi,
I use Visual Web Developer 2005 Express Edition. Anybody help me how can i use reports and subreports with parameters in it. I am new to ASP.NET. Please give me a sample. Thanks in advance.