Unable To Detach Database.
I need some insight if possible. I installed a new server (to replace an aging machine) with SQL 2000. After installing SQL on the new server I tried to detach a database from the old server so that I can attach it to the new instance of SQL. My problem is that when I do the process I am stopped with an error message.
“Error 8146: procedure sp_detach_db has no parameters and arguments supplied.”
This is happening with all of the user databases on the old server.
I have tried to run this using both the Query Analyzer and from the right-click menu option and both return the same error message. Any help would be greatly appreciated.
Thanks.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Detach Database .
Hello Everybody .. I am trying to detach and attach a database on SQL 7.0 Server with SP 2 through Enterprise manager . However if i right click o the Database and go to all task , i see the ' detach database' greyed out . The same thing is seen for ' attach Database 'when i try to attach the database . Although it can done through T-SQL commands also , does any body know the reason why this field is greyed out ? Does it depend on the SQL 7.0 Service pack or any kind of special permissions ? The same is visible on SQL 2000 Server Enterprise Manager . Has anybody come across this problem ? Many thanks in advance Yatin.
View Replies !
View Related
Detach Database.
hi Please help me .I have detached a database in sql server 2005 using object browser. Now i cant see the database in object browser of sql server management studio .I tried to attach it but the mdf file of that database is missing in the data folder. i had not created the backup. Can any one help me how to reattach that database.I will be very thankful to him.. thanks !! Ajeet Ajeet Kumar Software Developer Ustech India
View Replies !
View Related
Detach && Attach Database
I've just created ASPNETDB database with ASP.NET Security. Now, I want to send this db to orther computer.First, I detached this db, then when I used attach database in that computer, there is an error :Error 602: Could not find row in sysindexes for database ID 8, object ID 1, indext ID 1. RUN DBCC CHECKTABLE on sysindexes. Please help me .Thank.
View Replies !
View Related
Database Detach/attach
An original database (eg A.mdf) is imported/exported to a different server as named B.mdf. The detach of A.mdf was unitentionally not done. It seems that both the database were updated. A.mdf - 123000KB 25/12/2003 A_log.ldf - 14000KB 25/12/2003 B.mdf - 67000KB 25/12/2003 B_log.ldf - 1024KB 25/12/2003 In this case, which mdf & ldf should be the correct database? If I I remove A.mdf database by "detach", will B.mdf database work? SQL server 2000 and SP3 installed. Assistance is appreciated
View Replies !
View Related
Detach Database Greyed Out
I'm trying to detach a database and reattach to another server. When trying to detach it using Enterprise Manager, the command is greyed out. I've tried taking the database offline first but the command is still not enabled. I'm logged in as sysadmin. What gives?
View Replies !
View Related
Attach/Detach Database
In SQL when I right click on Databases the option to use Attach/Detach is greyed out. I don't understand why. I'm running SQL 7 on Win2000 server and I have Win2k at sp2 and SQL at sp2. Help please! Chris
View Replies !
View Related
Connection In Detach Database.
I open enterprise manager , right click and choose detach detach database. I see line : connections using this database. I think that this is connection from client connect to database.I feel that connection disappear automatically after time interval. I want to know how long time ? Thank you very much.
View Replies !
View Related
Database Detach Problem
Hi all, I'm trying to detach a database and after archive it for deliver to other server. The detach wents fine and the database is removed from the database tree list in Management Studio. The problem is that the mdf file is being locked by some process (maybe SQL) and I can't imagine why. Here is the code for this operation: USE master; GO ALTER DATABASE IMS_MCK_MIS SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE IMS_MCK_MIS SET EMERGENCY GO DECLARE @strDate NVARCHAR(8) DECLARE @strCmd NVARCHAR(255) SELECT @strDate = CONVERT(nvarchar(8), GETDATE(),112) EXEC sp_detach_db 'IMS_MCK_MIS' SELECT @strCmd = 'wzzip -ex -m C:Deliveryarchive_' + @strDate + '.zip E:DBSQLIMS_MCK_MIS.mdf' exec master..xp_cmdshell @strCmd Anyone have any idea how to quickly free the mdf file? Thanks and regards CG
View Replies !
View Related
How To Detach A Database With Replication Db?
There are two databases on two web servers, db01 is on server01, db01_replica is on server02, db02 is on server02, db02_replica is on server01. db01 and db02 are both for one system. Each time after doing performance test, I have to recover databses. I copy the data files in a folder, try to use detach and attach to recover databases. But with two replication dbs, I don't know how to do it. The replication db should also be recovered.
View Replies !
View Related
Detach Database From Code
I have the need to detach a database from code, at the moment I am using 'SSEUTIL -d' for this in my code and it works OK but now I want to change to using an SQLCommand. Here is my code so far: Code Snippet Dim conDatabase As SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=MyMDFPath"; Integrated Security=True;Connect Timeout=60;User Instance=True") Dim comDetach As New SqlCommand("EXEC master.dbo.sp_detach_db '" + MyMDFPath + "'", conDatabase) conDatabase.Open() comDetach.ExecuteNonQuery() conDatabase.Close() However, when I execute this I always get the following exception: Code Snippet Cannot detach the database 'MyMDFPath' because it is currently in use. It seems obvious to me that the problem is that to do the detach I create a connection - how do i get around this? Thanks!
View Replies !
View Related
Detach Database, Attach Database Without Log File
If I detach a database on a server, then attach the database with asingle file only using the data file...will I lose any transactionsthat were in the original log file? There is a debate going on here atwork where some people think that during the detach, transactions inthe log file are saved to the data file.Thanks!
View Replies !
View Related
Delete Or Detach A Suspect Database
Everything I read about sp_resetstatus says you must restart SQL after. Isthere a way around that (don't want to shut down production). The suspectdb is just an empty db that is not needed. I need to create another db withthe same name.Thanks.
View Replies !
View Related
Question On Detach/attach Database
Hi, all experts here, Thank you for your kind attention. I am having a question on detach/attach database. As when we detach/attach database, we have to copy both of .mdf and .ldf files to the targeted filepaths, in this case, when the database is large, then it takes a pretty while to copy the physical files though. In this case, I dont really see the point to detach/attach the database? Instead, backup/restore may be faster? (also, as detach the database, the files has to be taken offline) Just confused about the way we trasfer database files with detach/attach. I am looking forward to hearing from you shortly for any advices for that. With best regards, Yours sincerely,
View Replies !
View Related
How To Detach A Read Only Database From Sql Express
Need help I made a mistake an attached a read only database to the server (now it is grey marked). When I try to select this read only database in the MS SQL Server Management Studio, the server hangs up. I removed the read only attribute from the .mdf and .ldf File and made a reboot of the server. Still the same problem. How can I detach this read only database or how can I set the attribute to read/write (always hangs up the server, when I try to access this db) I tried also: alter database readOnly_dbname set read_write or USE master; GO EXEC sp_dboption 'readOnly_dbname', 'read only', 'FALSE'; Many thanks for an answer. Kusi
View Replies !
View Related
Using Detach/Attach Database To Copy/move
This might sound dumb, but BOL says you can use detach/attach to "MOVE" a database but can you detach and copy the files to a new server, leaving the files on the original and running the attach on the new and the old? (effectually a way to copy)? I know how to use data transformations/import,export was curious? Help appreciated!!
View Replies !
View Related
Detach,attach Db And Login,user And Master Database
I have similar question like Tim asked but from a different angle. I wish I pose my question here too anybody can help answer this. I tried to use detach and attach method to do backup of the user database (not master, maybe we can do master too) on another server, but it looks the login and permission credential would not go together. I come to see different kind of message I tried to login as non-sa user after I attatch the database on different machine. I would be denied for SQL timeout. It looks like loginand user dose not exist in new server because I did not move master database too. But even if I recreate the login when I tried to associate user with login I will see a message saying user or role already exist in database. If I go back to check the user it did not show up on enterprize manager on that database. So my question would be 1). how to move login and user together with user database. 2) do we have to move master database where the login infor. reside 3). if so how to move master database from one server to another when other server already have master database exist? Hope somebody can answer this. Wislon
View Replies !
View Related
Detach Aspnetdb Database Database
Hi, Iam facing problems to connect to the new database after detach the aspnetdb.Simply the new database disappear (In SQL 2005 Management studio express the database contents disappear ! and I get an error when try to open it).If I try to connectto aspnetdb again I get an error telling me it is used by another process.I don't understand what is going on could any one explain to me?
View Replies !
View Related
More ? To Craig: Detach,attach Db And Login,user And Master Database
Craig, Thanks for the suggustion. I am going to try your idea. I would like to clarify a couple of things before I take actions. 1). is there any difference betwwen dump, restore (the way you propose)and detach , attach(which is the way in my original message). I think detach and attach is quicker 2) how do update your master with new server name? 3)when you DTS or BCP user and login from primary server you have to do that on both sysusers and syslogins table, isn't it? I assume what you say about dropping all sysusers entries except the default is right because the userid has been given to existing users and can not have duplicate userid. what about syslogins table? do I have to do this also? It seems I have to turn on the option allow system table update in order to update these two tables. I don't know what consequences this would have. 4). I am not sure whether you can BCP the password into another server. Since I have try to reverse-engineer one database from one server into another server and I generate all SQL scripts including user and login, firstly they are encripted you have no way to verify whether they are correct or not. secondly if after I use those scripts recreate the database on other server I can see the entries for those user and login but I will be denied if using these login or users. I have to retype the correct password under those login entries in enterprise manager. I hope you can see this message soon. Thanks alot for help. Wislon
View Replies !
View Related
Backup/Restore Vs Attach/Detach 2000 Database To 2005
I'm trying to see the differences between Backup/Restore and Attach/Detach. I backup and detach a database from SQL Server 2000 SP3 and then attach and restore it to SQL Server 2005 SP1. The differences I noticed are: 1. The restored database has a much larger initial size (database size is same) for data and log. 2. The attached database has a last backup date 3. If the backup is restored over a database, the restored database is showing owned by the database owner of the database restored over but syslogins and sysusers do not match. I don't understand why #1 happens. Are there any other differences between Backup/Restore and Attach/Detach? Thanks, Peter
View Replies !
View Related
Detach Database File From Local SQL Server Express Instance By C#?
I am using the following C# code to establish a SQL connect to a SQL database file: // connection string // attach a SQL database file to a local SQL server express instance string _connectionString = @"Server=.SQLExpress; AttachDbFilename=C:BalanceDatabase_1.mdf; Trusted_Connection=Yes; User Instance=True"; // using System.Data.SqlClient; SqlConnection _sqlConnection = new SqlConnection(_connectionString); // open the connection _sqlConnection.Open(); // do something // close the connection _sqlConnection.Close(); So far, the connection works fine. However, next, I want to copy the database file to another folder. So the following codes: // source database file name string sourceDatabaseFileName = @"C:BalanceDatabase_1.mdf"; // target database file name string targetDatabaseFileName = @"D:BalanceDatabase_1.mdf"; // copy database file System.IO.File.Copy(sourceDatabaseFileName, targetDatabaseFileName, true); Then the program came with runtime exception: "IOException was unhandled: The process cannot access the file 'C:BalanceDatabase_1.mdf' because it is being used by another process." Is it because the database file was sill attached to the local SQL Server express instance? What can I do to bypass this problem? Detach the database file? or dispose the local SQL Server express instance? Many thanks indeed!
View Replies !
View Related
Unable To Update SQL Database
I'm using a formview to display, insert and update records and it appears to be working fine except when I try to update anything. It takes the update and goes back to diaply mode but the changes aren't reflected in the data for some reason. It's like I didn't change anything at all. Here's the SQL statement and parameters (I put elipses in to shorten it of course):... <body> <% 'Response.Write(Request.UserHostName)%> <form id="form1" runat="server"> <div align=center> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BGHelpdeskConnectionString %>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT RequestID, ReqDate, ReqGSN, ReqName ... FROM tblRequests ORDER BY RequestID DESC" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [tblRequests] WHERE [RequestID] = @original_RequestID AND [ReqDate] = @original_ReqDate AND [ReqGSN] = @original_ReqGSN AND ... [Other] = @original_Other AND [Comments] = @original_Comments" InsertCommand="INSERT INTO [tblRequests] ([ReqDate], [ReqGSN], [ReqName], ... [Other], [Comments]) VALUES (@ReqDate, @ReqGSN, @ReqName, ... @Other, @Comments)" UpdateCommand="UPDATE [tblRequests] SET [ReqDate] = @ReqDate, [ReqGSN] = @ReqGSN, [ReqName] = @ReqName, ... [Other] = @Other, [Comments] = @Comments WHERE [RequestID] = @original_RequestID AND [ReqDate] = @original_ReqDate AND ... [Other] = @original_Other AND [Comments] = @original_Comments"> <DeleteParameters> <asp:Parameter Name="original_RequestID" Type="Int32" /> <asp:Parameter Name="original_ReqDate" Type="DateTime" /> <asp:Parameter Name="original_ReqGSN" Type="String" /> ... <asp:Parameter Name="original_Other" Type="String" /> <asp:Parameter Name="original_Comments" Type="String" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="ReqDate" Type="DateTime" /> <asp:Parameter Name="ReqGSN" Type="String" /> <asp:Parameter Name="ReqName" Type="String" /> ... <asp:Parameter Name="Other" Type="String" /> <asp:Parameter Name="Comments" Type="String" /> <asp:Parameter Name="original_RequestID" Type="Int32" /> <asp:Parameter Name="original_ReqDate" Type="DateTime" /> <asp:Parameter Name="original_ReqGSN" Type="String" /> <asp:Parameter Name="original_ReqName" Type="String" /> ... <asp:Parameter Name="original_Other" Type="String" /> <asp:Parameter Name="original_Comments" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="ReqDate" Type="DateTime" /> <asp:Parameter Name="ReqGSN" Type="String" /> <asp:Parameter Name="ReqName" Type="String" /> <asp:Parameter Name="ReqPhone" Type="String" /> ... etc And here's my formview:1 <asp:FormView ID="FormView1" runat="server" DataKeyNames="RequestID" 2 DataSourceID="SqlDataSource1" Width="800px" BackColor="Transparent" BorderStyle="None" OnItemInserting="FormView1_ItemInserting"> 3 <EditItemTemplate> 4 <table id="Table4" cellpadding="10" cellspacing="5" class="Layout" language="javascript" 5 onclick="return TABLE1_onclick()" width="800"> 6 <tr> 7 <td bgcolor="#93bde7" colspan="3" style="height: 20px; text-align: right"> 8 <asp:ImageButton ID="ImageButton1" runat="server" CommandName="Update" ImageUrl="~/img/btn/check.gif" 9 ToolTip="Submit Form" /> 10 <asp:ImageButton ID="ImageButton2" runat="server" CausesValidation="False" 11 CommandName="Cancel" ImageUrl="~/img/btn/x.gif" ToolTip="Cancel Request" /></td> 12 </tr> 13 <tr style="color: #000000"> 14 <td rowspan="2" style="width: 400px; text-align: right" valign="top"> 15 </td> 16 <td rowspan="2" style="width: 135px" valign="top"> 17 Request Type: 18 <br /> 19 <asp:RadioButtonList ID="RadioButtonList1" runat="server" SelectedValue='<%# Bind("ReqType", "{0}") %>'> 20 <asp:ListItem>Starter</asp:ListItem> 21 <asp:ListItem>Leaver</asp:ListItem> 22 <asp:ListItem>Mover</asp:ListItem> 23 <asp:ListItem>Ad Hoc</asp:ListItem> 24 </asp:RadioButtonList> 25 </td> 26 <td rowspan="2" style="text-align: right"> 27 <img height="77" src="../img/CSBGLogoMed.jpg" width="226" /></td> 28 </tr> 29 <tr> 30 </tr> 31 </table> 32 <br /> 33 <table id="Table5" cellpadding="10" cellspacing="5" class="Layout" language="javascript" 34 onclick="return TABLE1_onclick()" width="800"> 35 <tr> 36 <td bgcolor="#93bde7" colspan="3" style="height: 20px"> 37 </td> 38 </tr> 39 <tr> 40 <td rowspan="2" style="text-align: right; width: 264px;"> 41 <asp:Label ID="Label6" runat="server" Text="Legal First Name:"></asp:Label> 42 <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>' Width="120px"></asp:TextBox> 43 <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="FirstNameTextBox">*</asp:RequiredFieldValidator><br /> 44 <asp:Label ID="Label8" runat="server" Text="Known As:"></asp:Label> 45 <asp:TextBox ID="KnownAsTextBox" runat="server" Text='<%# Bind("KnownAs") %>' Width="120px"></asp:TextBox> 46 <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="KnownAsTextBox">*</asp:RequiredFieldValidator> 47 <br /> 48 <asp:Label ID="Label10" runat="server" Text="Middle Name"></asp:Label> 49 <asp:TextBox ID="MiddleNameTextBox" runat="server" Text='<%# Bind("MiddleName") %>' Width="120px"></asp:TextBox> 50 <br /> 51 <asp:Label ID="Label12" runat="server" Text="Last Name:"></asp:Label> 52 <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>' Width="120px"></asp:TextBox> 53 <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="LastNameTextBox">*</asp:RequiredFieldValidator> 54 <br /> 55 <br /> 56 <asp:Label ID="Label14" runat="server" Text="Global Short Name:"></asp:Label> 57 <asp:TextBox ID="GlobalShortNameTextBox" runat="server" Text='<%# Bind("GlobalShortName") %>' Width="120px"></asp:TextBox> <br /> 58 <br /> 59 <asp:Label ID="Label16" runat="server" Text="Employment Type:"></asp:Label> 60 <asp:DropDownList ID="DropDown1" runat="server" SelectedValue='<%# Bind("EmpType") %>' Width=120> 61 <asp:ListItem Value="Employee ">Employee </asp:ListItem> 62 <asp:ListItem Value="Contractor">Contractor</asp:ListItem> 63 </asp:DropDownList><br /> 64 <br /> 65 <asp:Label ID="Label18" runat="server" Text="Contract Type:"></asp:Label> 66 <asp:TextBox ID="ContractTypeTextBox" runat="server" Text='<%# Bind("ContractType") %>' Width="120px"></asp:TextBox> 67 <br /> 68 <asp:Label ID="Label20" runat="server" Text="Agency:"></asp:Label> 69 <asp:TextBox ID="AgencyTextBox" runat="server" Text='<%# Bind("Agency") %>' Width="120px"></asp:TextBox> 70 <br /> 71 <br /> 72 <asp:Label ID="Label22" runat="server" Text="Hire Date:"></asp:Label> 73 <asp:TextBox ID="StartDateTextBox" runat="server" Text='<%# Bind("StartDate") %>' Width="120px"></asp:TextBox> 74 <br /> 75 EndDate:<asp:TextBox ID="EndDateTextBox" runat="server" Text='<%# Bind("EndDate") %>' Width="120px"></asp:TextBox> 76 </td> 77 <td rowspan="2" style="text-align: right; width: 222px;"> 78 Existing Position 79 <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("ExistingPosition") %>' Width="120px" /><br /> 80 Job Title: 81 <asp:TextBox ID="JobTitleTextBox" runat="server" Text='<%# Bind("JobTitle") %>' Width="120px"></asp:TextBox><br /> 82 Department: 83 <asp:TextBox ID="DepartmentTextBox" runat="server" Text='<%# Bind("Department") %>' Width="120px"></asp:TextBox><br /> 84 Site Location: 85 <asp:TextBox ID="SiteLocationTextBox" runat="server" Text='<%# Bind("SiteLocation") %>' Width="120px"></asp:TextBox><br /> 86 <br /> 87 Company Code: 88 <asp:TextBox ID="CompanyCodeTextBox" runat="server" Text='<%# Bind("CompanyCode") %>' Width="120px"></asp:TextBox><br /> 89 Cost Center: 90 <asp:TextBox ID="CostCenterTextBox" runat="server" Text='<%# Bind("CostCenter") %>' Width="120px"></asp:TextBox><br /> 91 <br /> 92 Function Code:<br /> 93 <asp:DropDownList ID="DropDown3" runat="server" SelectedValue='<%# Bind("FunctionCode") %>'> 94 <asp:ListItem Selected="True">Select one...</asp:ListItem> 95 <asp:ListItem>Commercial - Brand/Consumer Marketing</asp:ListItem> 96 <asp:ListItem>Commercial - Trade/Customer Marketing</asp:ListItem> 97 <asp:ListItem>Commercial - Marketing - Misc</asp:ListItem> 98 <asp:ListItem>Commercial - Sales - Account Mgmt</asp:ListItem> 99 <asp:ListItem>Commercial - Sales - Field Sales</asp:ListItem> 100 <asp:ListItem>Commerical - Sales - Misc</asp:ListItem> 101 <asp:ListItem>Commercial - Innovation/Activity Mgmt</asp:ListItem> 102 <asp:ListItem>Commercial - Licensing</asp:ListItem> 103 <asp:ListItem>Commerical - Franchise & Export</asp:ListItem> 104 <asp:ListItem>Commercial - Consumer Insight & Resch</asp:ListItem> 105 <asp:ListItem>Supply Chain - General</asp:ListItem> 106 <asp:ListItem>Supply Chain - QEHS (formerly Compliance)</asp:ListItem> 107 <asp:ListItem>Supply Chain - Manufacturing Indirect</asp:ListItem> 108 <asp:ListItem>Supply Chain - Distribution Indirect</asp:ListItem> 109 <asp:ListItem>Supply Chain - Procurement</asp:ListItem> 110 <asp:ListItem>Supply Chain - Manufacturing Direct</asp:ListItem> 111 <asp:ListItem>Supply Chain - Distribution Direct</asp:ListItem> 112 <asp:ListItem>Finance - Strategy</asp:ListItem> 113 <asp:ListItem>Finance - Finance</asp:ListItem> 114 <asp:ListItem>Finance - Business Process Support</asp:ListItem> 115 <asp:ListItem>Finance - Information Technology/RICS</asp:ListItem> 116 <asp:ListItem>Finance - SBS - General</asp:ListItem> 117 <asp:ListItem>Finance - SBS - HR</asp:ListItem> 118 <asp:ListItem>Finance - SBS - Finance</asp:ListItem> 119 <asp:ListItem>Finance - SBS - Customer to Cash</asp:ListItem> 120 <asp:ListItem>Finance - SBS - Corporate Services</asp:ListItem> 121 <asp:ListItem>Human Resources - Human Resources</asp:ListItem> 122 <asp:ListItem>Human Resources - Communications</asp:ListItem> 123 <asp:ListItem>Human Resources - External Affairs</asp:ListItem> 124 <asp:ListItem>Legal</asp:ListItem> 125 <asp:ListItem>Chief Executive's Committee</asp:ListItem> 126 <asp:ListItem>General Management</asp:ListItem> 127 <asp:ListItem>Science & Technology</asp:ListItem> 128 </asp:DropDownList> 129 </td> 130 <td rowspan="2" style="text-align: right"> 131 <asp:Panel ID="Panel2" runat="server" Width="100%"> 132 Manager:</asp:Panel> 133 <br /> 134 <asp:Panel ID="Panel1" runat="server" DefaultButton="MgrNameButton" Width="100%"> 135 <asp:TextBox ID="MgrNameTextBox" runat="server" Text='<%# Bind("MgrName") %>' Width="104px"></asp:TextBox> 136 <asp:Button ID="MgrNameButton" runat="server" Text="Check Name" OnClick="ValidateManager" CausesValidation="False" Font-Size="8pt" Width="72px" /> 137 <asp:Label ID="MgrNameLabel" runat="server" Text="Label" Visible="False" Width="184px" Font-Size="8pt"></asp:Label></asp:Panel> 138 <br /> 139 Phone: 140 <asp:TextBox ID="MgrPhoneTextBox" runat="server" Text='<%# Bind("MgrPhone") %>' Width="120px"></asp:TextBox><br /> 141 Email: 142 <asp:TextBox ID="MgrEmailTextBox" runat="server" Text='<%# Bind("MgrEmail") %>' Width="120px"></asp:TextBox><br /> 143 <br /> 144 Alternate Manager Information: 145 <br /> 146 Name: 147 <asp:TextBox ID="AltMgrNameTextBox" runat="server" Text='<%# Bind("AltMgrName") %>' Width="120px"></asp:TextBox><br /> 148 Phone: 149 <asp:TextBox ID="AltMgrPhoneTextBox" runat="server" Text='<%# Bind("AltMgrPhone") %>' Width="120px"></asp:TextBox><br /> 150 Email: 151 <asp:TextBox ID="AltMgrEmailTextBox" runat="server" Text='<%# Bind("AltMgrEmail") %>' Width="120px"></asp:TextBox><br /> 152 <br /> 153 HRAdmin: 154 <asp:TextBox ID="HRAdminTextBox" runat="server" Text='<%# Bind("HRAdmin") %>' Width="120px"></asp:TextBox></td> 155 </tr> 156 <tr> 157 </tr> 158 </table> 159 <br /> 160 <table id="Table6" cellpadding="10" cellspacing="5" class="Layout" language="javascript" 161 onclick="return TABLE1_onclick()" width="800"> 162 <tr> 163 <td bgcolor="#93bde7" colspan="2" style="height: 20px"> 164 </td> 165 </tr> 166 <tr> 167 <td rowspan="2" style="width: 246px; text-align: right" valign="top"> 168 ComputerType: 169 <asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Bind("ComputerType") %>' Width=120> 170 <asp:ListItem Selected="True">Use Existing Computer</asp:ListItem> 171 <asp:ListItem>New Desktop Required</asp:ListItem> 172 <asp:ListItem>New Laptop Required</asp:ListItem> 173 </asp:DropDownList><br /> Laptop Bag: 174 <asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("LaptopBag") %>' Width="120px" /><br /> 175 Laptop Dock: 176 <asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Bind("LaptopDock") %>' Width="120px" /><br /> 177 Monitor: 178 <asp:CheckBox ID="CheckBox4" runat="server" Checked='<%# Bind("Monitor") %>' Width="120px" /><br /> 179 Printer Type: 180 <asp:TextBox ID="PrinterTypeTextBox" runat="server" Text='<%# Bind("PrinterType") %>' Width="120px"></asp:TextBox><br /> 181 Long Distance: 182 <asp:CheckBox ID="CheckBox5" runat="server" Checked='<%# Bind("LongDistance") %>' Width="120px" /><br /> 183 SSN5: 184 <asp:TextBox ID="SSN5TextBox" runat="server" Text='<%# Bind("SSN5") %>' Width="120px"></asp:TextBox><br /> 185 SAP Midwest: 186 <asp:CheckBox ID="CheckBox6" runat="server" Checked='<%# Bind("SAPMidwest") %>' Width="120px" /><br /> 187 SAP Southwest: 188 <asp:CheckBox ID="CheckBox7" runat="server" Checked='<%# Bind("SAPSouthwest") %>' Width="120px" /><br /> 189 SAP Mirror: 190 <asp:TextBox ID="SAPMirrorTextBox" runat="server" Text='<%# Bind("SAPMirror") %>' Width="120px"></asp:TextBox><br /> 191 SAP Approve: 192 <asp:CheckBox ID="CheckBox8" runat="server" Checked='<%# Bind("SAPApprove") %>' Width="120px" /><br /> 193 Margin Minder: 194 <asp:TextBox ID="MarginMinderTextBox" runat="server" Text='<%# Bind("MarginMinder") %>' Width="120px"></asp:TextBox><br /> 195 Nextel Type: 196 <asp:TextBox ID="NextelTypeTextBox" runat="server" Text='<%# Bind("NextelType") %>' Width="120px"></asp:TextBox><br /> 197 MyCS: 198 <asp:CheckBox ID="CheckBox9" runat="server" Checked='<%# Bind("MyCS") %>' Width="120px" /><br /> 199 Notes DB: 200 <asp:TextBox ID="NotesDBTextBox" runat="server" Text='<%# Bind("NotesDB") %>' Width="120px"></asp:TextBox><br /> 201 Outlook Email: 202 <asp:CheckBox ID="CheckBox10" runat="server" Checked='<%# Bind("OutlookEmail") %>' Width="120px" /><br /> 203 Dept Share: 204 <asp:TextBox ID="DeptShareTextBox" runat="server" Text='<%# Bind("DeptShare") %>' Width="120px"></asp:TextBox><br /> 205 Share Point: 206 <asp:CheckBox ID="CheckBox11" runat="server" Checked='<%# Bind("SharePoint") %>' Width="120px" /><br /> 207 EPM: 208 <asp:CheckBox ID="CheckBox12" runat="server" Checked='<%# Bind("EPM") %>' Width="120px" /><br /> 209 CliqBook: 210 <asp:CheckBox ID="CheckBox13" runat="server" Checked='<%# Bind("CliqBook") %>' Width="120px" /><br /> 211 VPN: 212 <asp:CheckBox ID="CheckBox14" runat="server" Checked='<%# Bind("VPN") %>' Width="120px" /><br /> 213 Other: 214 <asp:TextBox ID="OtherTextBox" runat="server" Text='<%# Bind("Other") %>' Width="120px"></asp:TextBox><br /> 215 </td> 216 <td colspan="1" rowspan="2" style="text-align: right" valign="top"> 217 Comments: 218 <br /> 219 <asp:TextBox ID="CommentsTextBox" runat="server" Height="367px" Text='<%# Bind("Comments") %>' 220 Width="486px" TextMode="MultiLine" BorderStyle="Solid" BorderWidth="1px"></asp:TextBox><br /> 221 <br /> 222 </td> 223 </tr> 224 <tr> 225 </tr> 226 <tr> 227 <td background="../img/csbanner.jpg" bgcolor="#93bde7" colspan="2" rowspan="1" style="text-align: left"> 228 <asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="~/img/btn/check.gif" 229 ToolTip="Submit Form" /> <asp:ImageButton ID="ImageButton4" runat="server" CausesValidation="False" 230 CommandName="Cancel" ImageUrl="~/img/btn/x.gif" /> 231 </td> 232 </tr> 233 </table> 234 <asp:ValidationSummary ID="ValidationSummary1" runat="server" BackColor="Yellow" 235 DisplayMode="SingleParagraph" Font-Bold="True" HeaderText="Please fill in the fields indicated with a red asterisk (*)" 236 Width="800px" /> 237 </EditItemTemplate> 238 <InsertItemTemplate> 239 ... 240 </InsertItemTemplate> 241 <ItemTemplate> 242 ... 243 </ItemTemplate> 244 </asp:FormView>
View Replies !
View Related
Unable To Create Database
Hi, I need urgent help with this problem because I am unable to do any database development due to it. I am using visual web developer express edition with sql server 2005 express edition. The problem is that when I try to create a database in the app_data folder I get the following error message: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed". Regards, sandy
View Replies !
View Related
Unable To Connect To The Database
I just installed MSDE but when I try to connect to a database or create a new database I get the following message:"Microsoft ASP.NET Web MatrixUnable to connect to the database.General network error. Check your network documentation.ConnectionRead (rec()).TDS buffer length too largeTDS buffer length too large"Can anyone tell me how to correct this problem?Thanks,
View Replies !
View Related
Unable To Coonect To Database
I have created .aspx page which needs access to the database. I used datareader for reading the database. Everything is compiled and running, but when the page is trying to connect to database.. I'm getting the following error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. 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.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Source Error: Line 35: Dim flag As Boolean = False Line 36: Dim connect As New SqlConnection("data source=(local);initial catalog=Northwind") Line 37: connect.Open() Line 38: Dim cmd As New SqlCommand("Select Lastname , EmployeeID from Northwind.Employees Where LastName='@user'", connect) Line 39: Dim dr As SqlDataReaderPlz help me with this problem
View Replies !
View Related
Unable To Attach The Database
I had to detach the database to delete the transaction log as it tookthe hole disk space.No I am trying to attach database, however I am not able to do so.The engine is asking me whether I want to continue and create new logfile. I agree to it, however then I am receiving an error:Error 1813: Could not open new database 'db_name'. CREATE DATABASEaborted. Device activation error. The physical file name 'E:SQLDatabasesMSSQLDatadb_name.ldf' may be incorrect.Then after I have message than attaching database failed.In event viewer I have:17204 :FCB::Open failed: Could not open device E:SQL DatabasesMSSQLDatadb_name.MDF for virtual device number (VDN) 0.In the error log I have:2008-01-23 10:28:59.00 spid52 Starting up database 'db_name'.Do you have any ideas where the problem is?I have never had this problem before, only now. And I didn't have thisproblem with other databases for which I have deleted the log file.
View Replies !
View Related
Unable To Attach Database
A co-worker deleted the log file to a database that was running. At that point the database showed as suspect and stopped running. I was able to detach the database but I am unable to attach the database. I get a msg stating the logfile cannot be found would I like to create a new one. I select yes. I get the following error. Error 1813: Could not open new database 'dbname'. CREATE DATABASE is aborted. Device activation error. The physical file name 'fullpath to the original log file' may be incorrect. Any suggestions would be appreciated.
View Replies !
View Related
Unable To Connect To The SQl Database
i m having prob wiht connectivity to SQL Server Management Stdio Express. I am able to login thru only windows authentication. i changed setting to SQL authentication and windows both. i m creating the new login like security- logins - right click - new login- sqlauthentication and permission and all other opetion that i can checked i did but even though i m not able to connect. i have created a account from control panel and then try to do the same thign then it is giving me error that that login already excists. Plz help me here , it is driving me crazy. I am new in SQL Server plz help me out here.
View Replies !
View Related
Unable To Create New Database
I had a fully functioning SQL 2005 Exp install until today. All of my DBs work, Reporting Services works. But today I went to add a new DB for a DotNetNuke installation. Everything I have tried fails with the same error: ***************************************************** TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Create failed for Database 'TEST'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ A file activation error occurred. The physical file name 'G:TEST.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5105) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5105&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ ***************************************************** I have looked high and low for a solution only to come up empty handed. I only hope at this moment that someone here has seen this before. Thanks Jason
View Replies !
View Related
Unable To Create A Database In VB
I've recently installed VB Express and SQL Server Express (including Management Studio Express) on a laptop as well as a desktop PC. Everything looks the same on both. I can create an SQL database from VB without any problems on my laptop. However, when I try to create a new SQL database from VB on my desktop, I get the following message: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I've written a number of databases in Access, but never used SQL Server. This is about to drive my crazy. Thanks.
View Replies !
View Related
Unable To Attach The Database
I had to detach the database to delete the transaction log as it took the hole disk space. No I am trying to attach database, however I am not able to do so. The engine is asking me whether I want to continue and create new log file. I agree to it, however then I am receiving an error: Error 1813: Could not open new database 'db_name'. CREATE DATABASE aborted. Device activation error. The physical file name 'E:SQL DatabasesMSSQLDatadb_name.ldf' may be incorrect. Then after I have message than attaching database failed. In event viewer I have: 17204 : FCB:pen failed: Could not open device E:SQL DatabasesMSSQLData db_name.MDF for virtual device number (VDN) 0. In the error log I have: 2008-01-23 10:28:59.00 spid52 Starting up database 'db_name'. Do you have any ideas where the problem is? I have never had this problem before, only now. And I didn't have this problem with other databases for which I have deleted the log file.
View Replies !
View Related
Unable To Attach SQL Express Database
Hello, I have a SQL Express database created with VWD 2005 and I want to attach it to the server using the SQL Server Management Studio. It is not the first time when I attach a database, but now, I don't know from what reason, it is not working anymore. So, I copy/paste the mdf and ldf files from the website location (the SQL Server Management Studio is not opening the folder C:usersmyuser in Vista Home Premium, don't know why) to a new location and try to attach. The error message is: TITLE: Microsoft SQL Server Management Studio Express------------------------------ Attach database failed for Server 'GEORGE-PCSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Unable to open the physical file "E:SQLaria.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 ------------------------------BUTTONS: OK------------------------------ The file location is OK, what can I do? Thanks.
View Replies !
View Related
Unable To Insert Data To Database
HI all I've used textboxes to insert data to database but when i click save button everything is ok but when i check in the database the values are null evrywhere below is my code. i am trying to save to different databases pls help!! </table> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%; height: 32px;" bordercolor="#111111"> <tr><td width="100%" colspan="6" bgcolor="#eeeddb" align="center" style="height: 36px"> </td><tr> <tr><td width="100%" colspan="6" bgcolor="#ffcc33" align="center" style="height: 41px"> <font color="#000000">Passenger's Details</font></td><tr> <td bgcolor="#eeeddb" style="width: 164px; height: 16px;">Surname</td> <td bgcolor="#eeeddb" style="width: 160px; height: 16px;"> Name</td> <td bgcolor="#eeeddb" style="width: 129px; height: 16px;"> Initials</td> <td bgcolor="#eeeddb" style="width: 17%; height: 16px;"> Title</td> <td bgcolor="#eeeddb" style="width: 148px; height: 16px;"> Tel</td> <td bgcolor="#eeeddb" style="width: 234px; height: 16px;"> Fax</td> </tr> <tr> <td style="width: 164px"> <asp:TextBox ID="TextBox21" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 160px"> <asp:TextBox ID="TextBox22" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox24" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox26" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px"> <asp:TextBox ID="TextBox27" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 234px"> <asp:TextBox ID="TextBox28" runat="server" Enabled="False"></asp:TextBox></td> </tr> <tr> <td bgcolor="#eeeddb" style="width: 164px; height: 16px;">Frequent Flyer Number</td> <td bgcolor="#eeeddb" style="width: 160px; height: 16px;"> Seating Preference</td> </tr> <tr><td style="width: 164px"> <asp:TextBox ID="TextBox54" runat="server" Enabled="False"></asp:TextBox></td><td style="width: 160px"> <asp:TextBox ID="TextBox55" runat="server" Enabled="False"></asp:TextBox></td></tr> </table> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%;" bordercolor="#111111" height="32"> <tr><td width="100%" colspan="7" bgcolor="#eeeddb" align="center" style="height: 32px"> </td><tr> <tr><td width="100%" colspan="7" bgcolor="#ffcc33" align="center" style="height: 37px"> <font color="#000000">Flight's Details</font></td> </tr> <tr> <tr > <td bgcolor="#eeeddb" style="width: 154px;" height="16"> Routing：</td> <td style="width: 151px" bgcolor="#eeeddb" height="16" > From</td> <td style="width: 14%" bgcolor="#eeeddb" height="16"> To</td> <td bgcolor="#eeeddb" style="width: 17%;" height="16" > Dept Time</td> <td style="width: 148px" bgcolor="#eeeddb" height="16"> Arriv Time</td> <td style="width: 227px" bgcolor="#eeeddb" height="16" > Flight</td> <td bgcolor="#eeeddb" height="16" style="width: 137px" > Class</td> </tr> <tr> <td style="width: 154px"> <asp:Label ID="Label16" runat="server" Enabled="False" Font-Bold="True" Text="Leg 1"></asp:Label></td> <td style="width: 151px"> <asp:TextBox ID="TextBox38" runat="server" Width="120px" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox41" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox44" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px"> <asp:TextBox ID="TextBox47" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 227px"> <asp:TextBox ID="TextBox35" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 137px"> <asp:TextBox ID="TextBox82" runat="server" Enabled="False"></asp:TextBox></td></tr> <tr> <td style="width: 154px"> <asp:Label ID="Label5" runat="server" Enabled="False" Font-Bold="True" Text="Leg 2"></asp:Label></td> <td style="width: 151px"> <asp:TextBox ID="TextBox39" runat="server" Width="120px" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox43" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox45" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px"> <asp:TextBox ID="TextBox48" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 227px"> <asp:TextBox ID="TextBox36" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 111px"> <asp:TextBox ID="TextBox83" runat="server" Enabled="False"></asp:TextBox></td></tr> <tr> <td style="width: 154px; height: 25px;"> <asp:Label ID="Label8" runat="server" Enabled="False" Font-Bold="True" Text="Leg 3"></asp:Label></td> <td style="width: 151px; height: 25px;"> <asp:TextBox ID="TextBox40" runat="server" Width="120px" Enabled="False"></asp:TextBox></td> <td style="height: 25px"> <asp:TextBox ID="TextBox42" runat="server" Enabled="False"></asp:TextBox></td> <td style="height: 25px"> <asp:TextBox ID="TextBox46" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px; height: 25px;"> <asp:TextBox ID="TextBox49" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 227px; height: 25px;"> <asp:TextBox ID="TextBox37" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 137px; height: 25px;"> <asp:TextBox ID="TextBox84" runat="server" Enabled="False" Height="14px" Width="147px"></asp:TextBox></td></tr> </table> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%;" bordercolor="#111111" height="32" id="TABLE2"> <tr><td width="100%" colspan="6" bgcolor="#eeeddb" align="center" style="height: 38px"> </td><tr><tr> <td colspan="7" bgcolor="#ffcc33" align="center" style="height: 37px; width: 107%;"><font color="#000000">Accomodation's Details</font></td> </tr><tr> <td bgcolor="#eeeddb" style="width: 41px; height: 29px;">Routing：</td> <td bgcolor="#eeeddb" style="width: 76px; height: 29px;"> Hotel Name</td> <td bgcolor="#eeeddb" style="width: 14%; height: 29px;"> Check-in Date</td> <td bgcolor="#eeeddb" style="width: 17%; height: 29px;"> Check-out Date</td> <td bgcolor="#eeeddb" style="width: 113px; height: 29px;"> Room Type</td> <td bgcolor="#eeeddb" style="width: 113px; height: 29px;">Included</td> </tr> <tr> <td style="width: 41px; height: 31px;"> <asp:Label ID="Label9" runat="server" Enabled="False" Font-Bold="True" Text="Leg 1"></asp:Label></td> <td style="width: 76px; height: 31px;"> <asp:TextBox ID="TextBox30" runat="server" Enabled="False"></asp:TextBox></td> <td style="height: 31px"> <asp:TextBox ID="TextBox50" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px; height: 31px;"> <asp:TextBox ID="TextBox53" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 232px; height: 31px;"> <asp:TextBox ID="TextBox29" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox85" runat="server" Enabled="False"></asp:TextBox> </td> </tr> <tr> <td style="width: 41px; height: 26px"> <asp:Label ID="Label10" runat="server" Enabled="False" Font-Bold="True" Text="Leg 2"></asp:Label></td> <td style="width: 76px; height: 26px"> <asp:TextBox ID="TextBox33" runat="server" Enabled="False"></asp:TextBox></td> <td style="height: 26px"> <asp:TextBox ID="TextBox51" runat="server" Enabled="False"></asp:TextBox></td> <td style="height: 26px"> <asp:TextBox ID="TextBox56" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px; height: 26px;"> <asp:TextBox ID="TextBox31" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox86" runat="server" Enabled="False"></asp:TextBox> </td></tr> <tr> <td style="height: 20px; width: 41px;"> <asp:Label ID="Label11" runat="server" Enabled="False" Font-Bold="True" Text="Leg 3"></asp:Label></td> <td style="height: 20px; width: 76px;"> <asp:TextBox ID="TextBox32" runat="server" Enabled="False"></asp:TextBox></td> <td style="height: 20px"> <asp:TextBox ID="TextBox52" runat="server" Enabled="False"></asp:TextBox></td> <td style="height: 20px"> <asp:TextBox ID="TextBox57" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 148px; height: 20px;"> <asp:TextBox ID="TextBox34" runat="server" Enabled="False"></asp:TextBox></td> <td> <asp:TextBox ID="TextBox87" runat="server" Enabled="False"></asp:TextBox> </td></tr> </table> <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; width: 157%;" bordercolor="#111111" height="32" id="TABLE3"> <tr><td width="100%" colspan="6" bgcolor="#eeeddb" align="center" style="height: 38px"> </td><tr><tr> <td colspan="7" bgcolor="#ffcc33" align="center" style="height: 37px; width: 107%;"><font color="#000000">Vehicle's Details</font></td> </tr><tr> <td bgcolor="#eeeddb" style="width: 130px; height: 26px;">Company</td> <td bgcolor="#eeeddb" style="width: 20%; height: 26px;"> Group</td> <td bgcolor="#eeeddb" style="width: 129px; height: 26px;"> Pick-up Date</td> <td bgcolor="#eeeddb" style="width: 17%; height: 26px;"> Pick-up Time</td> <td bgcolor="#eeeddb" style="width: 113px; height: 26px;">Pick-up Addresss</td> </tr><tr> <td style="height: 20px"> <asp:TextBox ID="TextBox58" runat="server" Width="169px" Enabled="False"></asp:TextBox></td> <td style="height: 20px"> <asp:TextBox ID="TextBox59" runat="server" Width="163px" Enabled="False"></asp:TextBox></td> <td style="height: 20px"> <asp:TextBox ID="TextBox61" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 20px"> <asp:TextBox ID="TextBox62" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 20px"> <asp:TextBox ID="TextBox60" runat="server" Enabled="False"></asp:TextBox></td> </tr><tr> <td style="height: 22px"> <asp:TextBox ID="TextBox63" runat="server" Width="169px" Enabled="False"></asp:TextBox></td> <td style="height: 22px"> <asp:TextBox ID="TextBox64" runat="server" Width="163px" Enabled="False"></asp:TextBox></td> <td style="height: 22px"> <asp:TextBox ID="TextBox65" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 22px"> <asp:TextBox ID="TextBox66" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 22px"> <asp:TextBox ID="TextBox67" runat="server" Enabled="False"></asp:TextBox></td> </tr><tr> <td style="height: 20px"> <asp:TextBox ID="TextBox68" runat="server" Width="169px" Enabled="False"></asp:TextBox></td> <td style="height: 20px"> <asp:TextBox ID="TextBox69" runat="server" Width="163px" Enabled="False"></asp:TextBox></td> <td style="height: 20px"> <asp:TextBox ID="TextBox70" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 20px"> <asp:TextBox ID="TextBox71" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 20px"> <asp:TextBox ID="TextBox72" runat="server" Enabled="False"></asp:TextBox></td> </tr> <tr> <td bgcolor="#eeeddb" style="width: 14%; height: 16px;"> Drop-off Date</td> <td bgcolor="#eeeddb" style="width: 17%; height: 16px;"> Drop-off Time</td> <td bgcolor="#eeeddb" style="width: 129px; height: 16px;">Drop-off Addresss</td></tr> <tr><tr> <td><asp:TextBox ID="TextBox74" runat="server" Enabled="False"></asp:TextBox> </td> <td> <asp:TextBox ID="TextBox75" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 129px"><asp:TextBox ID="TextBox73" runat="server" Width="183px" Enabled="False"></asp:TextBox></td> </tr> <tr> <td style="height: 19px"><asp:TextBox ID="TextBox76" runat="server" Enabled="False"></asp:TextBox> </td> <td style="height: 19px"> <asp:TextBox ID="TextBox77" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 129px; height: 19px;"><asp:TextBox ID="TextBox78" runat="server" Width="183px" Enabled="False"></asp:TextBox></td> </tr> <tr> <td><asp:TextBox ID="TextBox79" runat="server" Enabled="False"></asp:TextBox> </td> <td> <asp:TextBox ID="TextBox80" runat="server" Enabled="False"></asp:TextBox></td> <td style="width: 129px"><asp:TextBox ID="TextBox81" runat="server" Width="183px" Enabled="False"></asp:TextBox></td> </tr> </table><table> <tr> <td style="width: 731px"> <br /> <br /> <asp:Button id="Button5" Text="Previous step" OnClick="PrevStep" runat="server"/> <asp:Button ID="Save" runat="server" Text="Save" /> <input id="Button3" hidefocus="hidefocus" onclick="printpage(this)" type="button" value="Print" /> <input id="Button4" onclick="exit()" type="button" value="Cancel" /></td> </tr> </table> </asp:Panel> <!--/fieldset--> </div> <br /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString7 %>" DeleteCommand="DELETE FROM [Accomodation] WHERE [AccID] = @AccID" InsertCommand="INSERT INTO [Accomodation] ([Routing], [Hotel Name], [Check in date], [Check out date], [Included], [Room Type]) VALUES (@Routing, @Hotel_Name, @Check_in_date, @Check_out_date, @Included, @Room_Type)" SelectCommand="SELECT [AccID], [Routing], [Hotel Name] AS Hotel_Name, [Check in date] AS Check_in_date, [Check out date] AS Check_out_date, [Included], [Room Type] AS Room_Type FROM [Accomodation]" UpdateCommand="UPDATE [Accomodation] SET [Routing] = @Routing, [Hotel Name] = @Hotel_Name, [Check in date] = @Check_in_date, [Check out date] = @Check_out_date, [Included] = @Included, [Room Type] = @Room_Type WHERE [AccID] = @AccID"> <DeleteParameters> <asp:Parameter Name="AccID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Routing" Type="String" /> <asp:Parameter Name="Hotel_Name" Type="String" /> <asp:Parameter Name="Check_in_date" Type="String" /> <asp:Parameter Name="Check_out_date" Type="String" /> <asp:Parameter Name="Included" Type="String" /> <asp:Parameter Name="Room_Type" Type="String" /> <asp:Parameter Name="AccID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:FormParameter Name="Routing" FormField="Label9" /> <asp:FormParameter Name="Hotel_Name" FormField="Textbox30" /> <asp:FormParameter Name="Check_in_date" FormField="Textbox50" /> <asp:FormParameter Name="Check_out_date" FormField="Textbox53" /> <asp:FormParameter Name="Included" FormField="Textbox85" /><asp:FormParameter Name="Room_Type" FormField="Textbox29" /> </InsertParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString8 %>" DeleteCommand="DELETE FROM [Flights] WHERE [FlightID] = @FlightID" InsertCommand="INSERT INTO [Flights] ([Routing], [Date], [From Date], [To Date], [Dept Time], [Arrive Time], [Flight], [Class]) VALUES (@Routing, @Date, @From_Date, @To_Date, @Dept_Time, @Arrive_Time, @Flight, @Class)" SelectCommand="SELECT [FlightID], [Routing], [Date], [From Date] AS From_Date, [To Date] AS To_Date, [Dept Time] AS Dept_Time, [Arrive Time] AS Arrive_Time, [Flight], [Class] FROM [Flights]" UpdateCommand="UPDATE [Flights] SET [Routing] = @Routing, [Date] = @Date, [From Date] = @From_Date, [To Date] = @To_Date, [Dept Time] = @Dept_Time, [Arrive Time] = @Arrive_Time, [Flight] = @Flight, [Class] = @Class WHERE [FlightID] = @FlightID"> <DeleteParameters> <asp:Parameter Name="FlightID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Routing" Type="String" /> <asp:Parameter Name="Date" Type="DateTime" /> <asp:Parameter Name="From_Date" Type="String" /> <asp:Parameter Name="To_Date" Type="String" /> <asp:Parameter Name="Dept_Time" Type="DateTime" /> <asp:Parameter Name="Arrive_Time" Type="DateTime" /> <asp:Parameter Name="Flight" Type="String" /> <asp:Parameter Name="Class" Type="String" /> <asp:Parameter Name="FlightID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="Routing" Type="String" /> <asp:Parameter Name="Date" Type="DateTime" /> <asp:Parameter Name="From_Date" Type="String" /> <asp:Parameter Name="To_Date" Type="String" /> <asp:Parameter Name="Dept_Time" Type="DateTime" /> <asp:Parameter Name="Arrive_Time" Type="DateTime" /> <asp:Parameter Name="Flight" Type="String" /> <asp:Parameter Name="Class" Type="String" /> </InsertParameters></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString4 %>" DeleteCommand="DELETE FROM [Passenger] WHERE [PassengerID] = @PassengerID" InsertCommand="INSERT INTO [Passenger] ([Surname], [Name], [Initials], [Title], [Tel], [Fax], [FrequentFlyerNumber], [SeatingPreference], [Account Number], [OrderNo], [VehicleID], [AccomodationID], [FlightID], [Travel Consultant]) VALUES (@Surname, @Name, @Initials, @Title, @Tel, @Fax, @FrequentFlyerNumber, @SeatingPreference, @Account_Number, @OrderNo, @VehicleID, @AccomodationID, @FlightID, @Travel_Consultant)" SelectCommand="SELECT [PassengerID], [Surname], [Name], [Initials], [Title], [Tel], [Fax], [FrequentFlyerNumber], [SeatingPreference], [Account Number] AS Account_Number, [OrderNo], [VehicleID], [AccomodationID], [FlightID], [Travel Consultant] AS Travel_Consultant FROM [Passenger]" UpdateCommand="UPDATE [Passenger] SET [Surname] = @Surname, [Name] = @Name, [Initials] = @Initials, [Title] = @Title, [Tel] = @Tel, [Fax] = @Fax, [FrequentFlyerNumber] = @FrequentFlyerNumber, [SeatingPreference] = @SeatingPreference, [Account Number] = @Account_Number, [OrderNo] = @OrderNo, [VehicleID] = @VehicleID, [AccomodationID] = @AccomodationID, [FlightID] = @FlightID, [Travel Consultant] = @Travel_Consultant WHERE [PassengerID] = @PassengerID"> <DeleteParameters> <asp:Parameter Name="PassengerID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Surname" Type="String" /> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Initials" Type="String" /> <asp:Parameter Name="Title" Type="String" /> <asp:Parameter Name="Tel" Type="String" /> <asp:Parameter Name="Fax" Type="String" /> <asp:Parameter Name="FrequentFlyerNumber" Type="String" /> <asp:Parameter Name="SeatingPreference" Type="String" /> <asp:Parameter Name="Account_Number" Type="String" /> <asp:Parameter Name="OrderNo" Type="Int32" /> <asp:Parameter Name="VehicleID" Type="Int32" /> <asp:Parameter Name="AccomodationID" Type="Int32" /> <asp:Parameter Name="FlightID" Type="Int32" /> <asp:Parameter Name="Travel_Consultant" Type="String" /> <asp:Parameter Name="PassengerID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:formParameter Name="Surname" formfield="Textbox21" /> <asp:formParameter Name="Name" formfield="Textbox22" /> <asp:formParameter Name="Initials" formfield="Textbox24" /> <asp:formParameter Name="Title" formfield="Textbox26" /> <asp:formParameter Name="Tel" formfield="Textbox27" /> <asp:formParameter Name="Fax" formfield="Textbox28" /> <asp:formParameter Name="FrequentFlyerNumber" formfield="Textbox29" /> <asp:formParameter Name="SeatingPreference" formfield="Textbox55" /> <asp:formParameter Name="Account_Number" formfield="Textbox18" /> <asp:formParameter Name="OrderNo" formfield="Label2" /> <asp:Parameter Name="VehicleID" Type="Int32" /> <asp:Parameter Name="AccomodationID" Type="Int32" /> <asp:Parameter Name="FlightID" Type="Int32" /> <asp:formParameter Name="Travel_Consultant" formfield="Textbox19" /> </InsertParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString5 %>" DeleteCommand="DELETE FROM [Vehicle] WHERE [VehicleID] = @VehicleID" InsertCommand="INSERT INTO [Vehicle] ([Company Name], [Group], [Pick Up Time], [Pick Up Date], [Drop Off Address], [Drop Off Time], [Drop Off Date], [Pick up Address]) VALUES (@Company_Name, @Group, @Pick_Up_Time, @Pick_Up_Date, @Drop_Off_Address, @Drop_Off_Time, @Drop_Off_Date, @Pick_up_Address)" SelectCommand="SELECT [VehicleID], [Company Name] AS Company_Name, [Group], [Pick Up Time] AS Pick_Up_Time, [Pick Up Date] AS Pick_Up_Date, [Drop Off Address] AS Drop_Off_Address, [Drop Off Time] AS Drop_Off_Time, [Drop Off Date] AS Drop_Off_Date, [Pick up Address] AS Pick_up_Address FROM [Vehicle]" UpdateCommand="UPDATE [Vehicle] SET [Company Name] = @Company_Name, [Group] = @Group, [Pick Up Time] = @Pick_Up_Time, [Pick Up Date] = @Pick_Up_Date, [Drop Off Address] = @Drop_Off_Address, [Drop Off Time] = @Drop_Off_Time, [Drop Off Date] = @Drop_Off_Date, [Pick up Address] = @Pick_up_Address WHERE [VehicleID] = @VehicleID"> <DeleteParameters> <asp:Parameter Name="VehicleID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Company_Name" Type="String" /> <asp:Parameter Name="Group" Type="String" /> <asp:Parameter Name="Pick_Up_Time" Type="DateTime" /> <asp:Parameter Name="Pick_Up_Date" Type="String" /> <asp:Parameter Name="Drop_Off_Address" Type="String" /> <asp:Parameter Name="Drop_Off_Time" Type="DateTime" /> <asp:Parameter Name="Drop_Off_Date" Type="String" /> <asp:Parameter Name="Pick_up_Address" Type="String" /> <asp:Parameter Name="VehicleID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="Company_Name" Type="String" /> <asp:Parameter Name="Group" Type="String" /> <asp:Parameter Name="Pick_Up_Time" Type="DateTime" /> <asp:Parameter Name="Pick_Up_Date" Type="String" /> <asp:Parameter Name="Drop_Off_Address" Type="String" /> <asp:Parameter Name="Drop_Off_Time" Type="DateTime" /> <asp:Parameter Name="Drop_Off_Date" Type="String" /> <asp:Parameter Name="Pick_up_Address" Type="String" /> </InsertParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:Travel BookingConnectionString6 %>" DeleteCommand="DELETE FROM [Order] WHERE [OrderNo] = @OrderNo" SelectCommand="SELECT * FROM [Order]" InsertCommand="INSERT INTO [Order] ([Date]) VALUES (@Date)" UpdateCommand="UPDATE [Order] SET [Date] = @Date WHERE [OrderNo] = @OrderNo"> <DeleteParameters> <asp:Parameter Name="OrderNo" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Date" Type="DateTime" /> <asp:Parameter Name="OrderNo" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="Date" Type="DateTime" /> </InsertParameters> </asp:SqlDataSource>Protected Sub Save_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Save.Click SqlDataSource1.Insert() SqlDataSource2.Insert() SqlDataSource3.Insert() SqlDataSource4.Insert() End Sub thanx in advance
View Replies !
View Related
Unable To Connect To SQL Server Database.
Hi, I am working through "Sams Teach Yourself ASP Dot NET 2.0 in 24 Hours" I am upto hour 20 where it says Configuring an ASP.NET Website to Support Membership To configure our website to support membership, we must launch the ASP.NET Website Administration Tool. To accomplish this, either click the ASP.NET Configuration icon at the top of the Solution Explorer or click the Website menu's ASP.NET Configuration option. Either way will open a web browser pointed to a page through which the ASP.NET site can be configured. Figure 20.1 shows the ASP.NET Website Administration Tool. To add user account support, click the Security link. This will take you to the Security screen shown in Figure 20.2. From this screen, you can specify the user accounts in your system, what roles for users exist, and the access rules for users. However when I click security I get the following error message; "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." If I test the provider I get this error; "Provider Management""Could not establish a connection to the database.""If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider." I am using MS VWD Express with MS SQL Express. I have run the 'aspnet_regsql' tool on my database which the book fails to mention and verified that the tables were created correctly. I have tried copying the MDF file directly into my 'app_data' directory but this made no difference. I have googled these errors and nothing seems to help. I can connect to the database through a 'SqlDataSource' and have had no trouble with the database in the previous sections of the book. I think it may have something to do with how I setup SQL Express or database permissions, I hope someone can help. Thanks in advance. Here is a copy of my web.config; <?xml version="1.0"?><!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings for your application. Use the Website->Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in WindowsMicrosoft.NetFrameworkv2.xConfig --><configuration> <connectionStrings> <add name="MyFirstDatabaseConnectionString" connectionString="Data Source=.;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyFirstDatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"providerName="System.Data.SqlClient" /> </connectionStrings><appSettings/> <system.web><!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. Visual Basic options: Set strict="true" to disallow all data type conversions where data loss can occur. Set explicit="true" to force declaration of all variables.--> <compilation debug="false" strict="false" explicit="true" /><pages> <namespaces><clear /> <add namespace="System" /><add namespace="System.Collections" /> <add namespace="System.Collections.Specialized" /><add namespace="System.Configuration" /> <add namespace="System.Text" /><add namespace="System.Text.RegularExpressions" /> <add namespace="System.Web" /><add namespace="System.Web.Caching" /> <add namespace="System.Web.SessionState" /><add namespace="System.Web.Security" /> <add namespace="System.Web.Profile" /><add namespace="System.Web.UI" /> <add namespace="System.Web.UI.WebControls" /><add namespace="System.Web.UI.WebControls.WebParts" /> <add namespace="System.Web.UI.HtmlControls" /></namespaces> </pages> <!-- The <authentication> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> <authentication mode="Windows" /> <!-- The <customErrors> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace. <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm"> <error statusCode="403" redirect="NoAccess.htm" /> <error statusCode="404" redirect="FileNotFound.htm" /> </customErrors>--> </system.web></configuration>
View Replies !
View Related
Unable To Attach Or Create Database
Hello, I just recently installed SQL Express 2005 on a new OS which is on Vista Ultimate. When I try to attach a database by clicking the add button, I receive this error: =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.SqlManagerUI.BrowseFolderHelper.GetBrowseStartPath(ISettingsStorage settingsStorage, ServerConnection serverConnection, Type controlType, String settingKey) at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.GetStartPath(String settingName) at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.buttonBrowse_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------Program Location: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteImmediate(String query) at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result) at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent) at Microsoft.SqlServer.Management.Smo.Environment.GetData() at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) =================================== The server principal "MyComputerKarl" is not able to access the database "model" under the current security context. (.Net SqlClient Data Provider) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476 ------------------------------Server Name: MyComputerSQLEXPRESSError Number: 916Severity: 14State: 1Line Number: 1 ------------------------------Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) When I try to creat a new database I receive this error: =================================== Create failed for Database 'TestDB'. (Microsoft.SqlServer.Express.Smo) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476 ------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() at Microsoft.SqlServer.Management.Smo.Database.Create() at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabaseData.DatabasePrototype.ApplyChanges(Control marshallingControl) at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender) =================================== An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------Program Location: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingOptions so) at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl() =================================== CREATE DATABASE permission denied in database 'master'. (.Net SqlClient Data Provider) ------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476 ------------------------------Server Name: MyComputerSQLEXPRESSError Number: 262Severity: 14State: 1Line Number: 1 ------------------------------Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) On my previous computer which had WinXp Pro I had no such problems Any Help would be much appreciated Thanks Karl
View Replies !
View Related
Unable To Add Connection To A SQL Server Database
All,I have a web application with a few linked dropdown lists that initially connect to a table in SQL Server database (remote server). I tried doing this using the "Configure Data Source" and then the "Add Connection" wizard but I have not been able to connect successfully. The only error message I get is "Timeout expired: The timeout period elapsed prior to completion of the operation or the server is not responding". However, I could connect to the same database from a different machine (using the same wizards). I could ping to the database server fine, and even open the table using a different database client from my machine. Also, I noticed that I could connect to a SQL Express database on the local machine without any problem. I am very new to ASP .Net. Any help would be great!Thanks
View Replies !
View Related
Please Help Me About :Unable To Connect To SQL Server Database.
To All Members,When I create a new project and try to use the ASP.Net web application administration :security tab, I get the following :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 am using Microsoft Visual Web Developer 2005 Express Edition with a local MS SQL Server 2000.I am new to all of this so a little help would be greatThanks.please mail me to dehackers@linuxmail.orgor izzuan@malysia.com
View Replies !
View Related
Unable To Connect To SQL Server Database
Hello all,I try to configure the website by using the built in tool of vs2005. When i click the button from Website -> ASP .NET Configuration.when the main page is displayed, i clicked the security, the error shows like:---------------------------------------- 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.---------------------------------------How to enable connection to sql server? Thanks
View Replies !
View Related
Unable To Attatch Database File?
I'm running ASP 2.0 with MS SQL EXPRESS 2005The following is my error msg, any idea where should i look? it runs well on my local hostServer Error in '/WebSite3' Application. An attempt to attach an auto-named database for file C:Webspaceigiri\wwwWebSite3App_DataDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. THANKS
View Replies !
View Related
Unable To Attach SQLExpress Database
This is by FAR, the most frustrating problem I have dealt with for a while.I have a project containing a SqlExpress database that I created in Visual Studio 2005. Everything works perfectly on my development machine. However, upon copying the site up to the webserver, I get an error stating:An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC shareI have read almost every article/forum post that resulted from a search with google. I also searched these forums, to no avail.Note - SQLExpress had just been downloaded and installed on the server, so it wasn't being used yet. Server is Windows Server 2003. Here are the following steps I have already taken:Used SSEUTIL.EXE to verify that another database of the same name was not already attachedUninstalled & reinstalled SQLExpress multiple timesTemporarily granted 'Full Control' permissions to 'Everyone' on the site folder to verify that it was not a permissions issue.Created a very simple website, with a new database, one page - with one listbox control, and a sqldatasource. Got the exact same error. Should rule out a problem with my application.Tried various flavors of the web.config connection string.Probably other stuff that I forgot about, but will add if I remember.The only things I could imagine being wrong are either a problem with my connectionString, or the fact that SQLExpress is installed on C:, and webstuff is on D: (Wasn't able to install SqlExpress to D: for some reason)Connection String <connectionStrings> <add name="ClassAdConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ClassAd.mdf;Integrated Security=true;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> So I have had like 12 strokes today. If anybody could help me get this fixed, I will spread tales of your awesomeness throughout the landsI have included some extra info below in case it is needed. Thanks, Adam.Entire Error An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 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.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Source Error: Line 1705: }Line 1706: ClassAd.CategoriesDataTable dataTable = new ClassAd.CategoriesDataTable();Line 1707: this.Adapter.Fill(dataTable);Line 1708: return dataTable;Line 1709: } Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesforms9d7c504b4b8a576eApp_Code.3dq8tdsl.9.cs Line: 1707 Stack Trace: [SqlException (0x80131904): An attempt to attach an auto-named database for file D:ContentwwwFMakerApp_DataClassAd.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 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.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107 ClassAdTableAdapters.CategoriesTableAdapter.GetCategoriesByPropCode(String PropCode) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesforms9d7c504b4b8a576eApp_Code.3dq8tdsl.9.cs:1707[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +358 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92 System.Web.UI.WebControls.ListControl.PerformSelect() +31 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26 System.Web.UI.WebControls.ListBox.OnPreRender(EventArgs e) +9 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
View Replies !
View Related
Unable To Acess Database In Webpages.
Hello,I am unable to access SQL Server 2005 (Express Edition) when i am creating wesites on localhost.But the same database can be accessed without any problem when websites are created on local file system.When creating the website on localhost and trying to access databse the following error is displayed: " Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."Anyone plz help me out of this? Thanks.Ashu.
View Replies !
View Related
Unable To Connect To SQL Server Database.
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, The above was what I get whenever I tried connecting to SQL Server database. I've got Windows XP Pro SP2, IIS 5.1, and is currently using Visual Web Developer. How do I rectify my problem of connecting to an SQL Server?
View Replies !
View Related
Unable To Connect To Database Server
HI all,I have hosted my ASP.Net application to a Hostingserver.My application fails to connect to the databaseserver, and promts error "Object refrence is not set to an instance of anobject"This Error is due to Drop Down Lists which query datafrom the database. I am using the connection string "Data Source=xxx.xxx.xxx.xx; Initial Catalog=shopadvizor;User Id=user1;Password=pass"The IP address above works fine when I Register andconnect the Remote database Srever with my Enterprisemanager. I can even query the database from my Local enterprise manager to the remote machine database server. Really Lost Need some help.Regards
View Replies !
View Related
Unable To Connect To The Database Server
Hey everybody, I have just installed Microsoft ASP.net Web Matrix and the MSDE database. When installing MSDE I entered the following text at the command prompt: setup SAPWD=password SECURITYMODE=SQLwhere password is my personal password. However, when I ask for a new connection on the data tab, I get the error message: Unable to connect to the database serverSQL Server does not exist or access denied. Connectionopen (Connect())Can anybody help me to resolve this. Thanks in advance for any help received.
View Replies !
View Related
|
TRACKER
