Can anyone think of a reason for whilst configuring my SqlDataSource using the wizard in VS2005, when I click Advanced the Generate Insert, Update and Delete Statements option is greyed out. Been using them plenty of times already elsewhere in the site, yet for no apparent reason it won't work on a couple of pages.
View 3 RepliesI have not found anything useful on the Wizard control. Anything I can find gets to the last step and then just takes the info you supplied and applies them to a bunch of Label.Text's - none that do work.
So I am building a Wizard control for an HR system that will insert the information into SQL through a SqlDataSource. The problem is, only the controls that are present in whichever step is currently selected in VWD will appear in the Command and Parameter Editor.
I tried to work around it by selecting the first step, then applying the controls in step 1 within the Parameter Editor, but when I go back to do step 2, it erases everything I just did for step 1.
How do I implement the Wizard with a SqlDataSource?
hello all... I have a sql2005express database that I am trying to use a sqldatasource control on. I drop the control on to the page and click the configure data source link. I choose a db connection that I have setup previously. on the next step where you are supposed to select the table or view you want to use I only see views, no tables.
I can use the SQL statement option to get data from the table. and I can drag the table from the database explorer window onto the design surface, which will create all of the sql statements (select, insert,update,delete)
I am using a specific userid to access data but I do not really have any special permissions setup
any help or suggestions would be appreciated. Thanks
I have a create user wizard. On the created user event. I am calling a datasource.insert to insert the email, userid, and opt in to newsletter option into another table.
For some reason it is inserting the value twice into the database. I have checked possibilities for why this might be happening. I am pulling my hair out.
Any ideas?
Andrew
I've added an SqlDataSource control to my web page and selected "Configure Data Source" on it. This brings up a "Choose Your Data Connection" wizard, and it asks you to select from a dropdown list of presumably pre-existing connection strings in my web.config file. However none of my connection strings will display in that dropdown list. The only thing i can do is hit the "Create New Connection" button and this adds yet another connection string to my web.config file. I've already ran through the wizard once, created a new connection string, but when i run through the wizard again, even the new connection string - the one created by the last wizard will not appear in the dropdown list. Any suggestions? Jason
View 3 Replies View RelatedCreating custom Register form That inserts user info in to database via storeprocgetting following errorCompilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30456: 'ValidateInput' is not a member of 'System.Web.UI.WebControls.TextBox'.
Source Error:
Line 3496: Me.__BuildControlTree(Me)
Line 3497: Me.AddWrappedFileDependencies(Global.ASP.partfrm_aspx.__fileDependencies)
Line 3498: Me.Request.ValidateInput
Line 3499: End Sub
Line 3500:
>.ASPX <asp:Wizard ID="AddParticipantWizard" OnFinishButtonClick="AddParticipant_FinishButtonClick" FinishDestinationPageUrl="~/partReg.aspx" runat="server">
<WizardSteps>
<asp:WizardStep ID="WizardStep1" runat="server" Title="Register Participant">
<h3> Register: </h3>
<hr />
<table border="0">
<tr>
<td align="Left" colspan="2">
<h3>
PARTICIPANT INFORMATION: </h3><hr />
Please enter information for the attendee and click 'continue'.</td>
</tr></table>
<table border="0">
<tr>
<td align="right"> Registrant Information
</td>
<td style="width: 232px">
<asp:CheckBox ID="CheckBox1" runat="server" /> Register Me</td>
</tr>
<tr>
<td align="Left" colspan="2">
<table border="0">
<tr>
<td align="right">
<asp:Label ID="FirstNameLabel" runat="server" AssociatedControlID="firstname">First Name:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="firstname" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="FirstNameRequired" runat="server" ControlToValidate="firstname"
ErrorMessage="First Name is required." ToolTip="First Name is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="LastNameLabel" runat="server" AssociatedControlID="lastname">Last Name:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="lastname" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="LastNameRequired" runat="server" ControlToValidate="lastname"
ErrorMessage="Last Name is required." ToolTip="Last Name is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="EmailLabel" runat="server" AssociatedControlID="Email">E-mail:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Email" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="EmailRequired" runat="server" ControlToValidate="Email"
ErrorMessage="E-mail is required." ToolTip="E-mail is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr><td style="width: 232px"><br /></td></tr>
<tr>
<td align="right" style="height: 32px">
<asp:Label ID="StreetLabel" runat="server" AssociatedControlID="Street">Street:</asp:Label>
</td>
<td style="width: 232px; height: 32px">
<asp:TextBox ID="Street" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="StreetRequired" runat="server" ControlToValidate="Street"
ErrorMessage="Street is required." ToolTip="Street is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr><td></td>
<td> <br />
<br /> ".
</td></tr>
<tr>
<td align="right">
<asp:Label ID="CityLabel" runat="server" AssociatedControlID="City">City:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="City" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="CityRequired" runat="server" ControlToValidate="City"
ErrorMessage="City is required." ToolTip="City is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="StateLabel" runat="server" AssociatedControlID="State">State:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="State" runat="server" Width="18px">
</asp:TextBox><asp:RequiredFieldValidator ID="StateRequired" runat="server" ControlToValidate="State"
ErrorMessage="State is required." ToolTip="State is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr><td></td>
<td> <br /> <br /> </td></tr>
<tr><td style="width: 232px"><br /></td></tr>
<tr>
<td align="right">
<asp:Label ID="PostalCodeLabel" runat="server" AssociatedControlID="Zip">Postal/Zip<br />
Code:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="PostalCode" runat="server" Width="28px"></asp:TextBox>
<asp:RequiredFieldValidator ID="PostalCodeRequired" runat="server" ControlToValidate="PostalCode"
ErrorMessage="PostalCode is required." ToolTip="PostalCode is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="OrganizationLabel" runat="server" AssociatedControlID="Organization">Organization:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Organization" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="OrganizationRequired" runat="server" ControlToValidate="Organization"
ErrorMessage="Organization is required." ToolTip="Organization is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="TitleLabel" runat="server" AssociatedControlID="Title">Title:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Title" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="TitleRequired" runat="server" ControlToValidate="Title"
ErrorMessage="Title is required." ToolTip="Title is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="DepartmentLabel" runat="server" AssociatedControlID="Department">Department:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Department" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="DepartmentRequired" runat="server" ControlToValidate="Department"
ErrorMessage="Department is required." ToolTip="Department is required." ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="PhoneNumberLabel" runat="server" AssociatedControlID="Phone">Phone Number:</asp:Label>
</td>
<td style="width: 232px">
<asp:TextBox ID="Phone" runat="server" Width="195px"></asp:TextBox>
<asp:RequiredFieldValidator ID="PhoneRequired" runat="server" ControlToValidate="Phone"
ErrorMessage="Phone Number is required." ToolTip="Phone Number is required."
ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="RequestLabel" runat="server" AssociatedControlID="Request">Any special request:</asp:Label>
</td>
<td style="width: 232px">(e.g, )
</td>
</tr>
<tr>
<td align="right">
</td>
<td style="width: 232px">
<asp:TextBox ID="Request" runat="server" Width="235px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequestRequiredFieldValidator1" runat="server" ControlToValidate="Request"
ErrorMessage="Request is required." ToolTip="Request is required."
ValidationGroup="AddParticipantWizard">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:RegularExpressionValidator ID="EmailRegExp" runat="server" ControlToValidate="Email"
Display="Dynamic" ErrorMessage="The email format is invalid." ValidationExpression="S+@S+.S+"
ValidationGroup="AddParticipantWizard"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td align="center" colspan="2" style="color: red">
<asp:Literal ID="ErrorMessage" runat="server" EnableViewState="False"></asp:Literal>
</td>
</tr>
<tr><td></td>
<td align="right">
</td></tr>
</table>
</td>
</tr>
</table>
<asp:SqlDataSource ID="InsertPartDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" InsertCommand="PartInsert" InsertCommandType="StoredProcedure">
<InsertParameters>
<asp:ControlParameter ControlID="firstName" Name="firstName" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="lastName" Name="lastName" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Email" Name="Email" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Street" Name="Street" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="City" Name="City" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="State" Name="State" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="PostalCode" Name="PostalCode" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Organization" Name="Organization" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Title" Name="Title" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Department" Name="Department" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Phone" Name="Phone" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="Request" Name="Request" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="Assistance" Name="Assistance" PropertyName="SelectedValue"
Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</asp:WizardStep>
<asp:WizardStep ID="WizardStep2" runat="server" Title="Completion">
<p>
Your account has been successfully created.
</p>
<asp:Button ID="ContinueButton" runat="server" CommandName="Continue"
Text="Continue" />
</asp:WizardStep>
</WizardSteps>
</asp:Wizard> > CODE-BEHIND 'This event handler fires when the user clicks Finish. We need to insert the new participant record into the database
Protected Sub AddParticipant_FinishButtonClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.WizardNavigationEventArgs) Handles AddParticipantWizard.FinishButtonClick
'Insert the Participant into the database
InsertPartDataSource.Insert()
'Send the user back to the homepage
Response.Redirect("~/PartReg.aspx")
End Sub
Thanks for your time:
Using the SQLdatasource wizard, selecting "Specify a custom statement or Stored Procedure", but the "Stored Procedure" radio button and drop box are NOT enabled (greyed out) and cant be selected. Login has sa and no schema's are implemetned yet... Help?
Is there a setting I'm missing? (like how table needs a primary key set for wizard to allow auto-generate statements)
Otherwise, Is there a work-around I can use?
With a Gridview Control, I set the SqlDataSource to be a stored procedure in a Sql Sever database.
Using the wizzard to configure the datasource, the test returns lots of rows. After completing the wizzard, the gridview control does not show the column names in the VS2005 designer. For the gridview column headers the values are Databound Col0, Databound Col1, Databound Col2, ....) This tells me I have a problem.
I tried the same thing with a simpler stored procedure. This test stored procedure does not call anything else, takes several input parameters, returns rows. The column names show in the gridview control as expected.
So I am trying to figure out why the first case of gridview with sqldatasource is not working and the second case works . The stored procedure that is not working with my gridview calls multiple inner stored procedures and has #TEMP tables. My complex stored procedure ends with Select * from #Temp.
Could the calling of other inner stored procedures and use of #temp tables contribute to the problem? If yes then what is the strategy for using a gridview and loading it with the data that the complex stored procedure returns?
Hi All,
I have become frustrated and I am not finding the answers I expect.
Here's the gist, we support both Oracle and SQL for our product and we would like to migrate our Clients who are willing/requesting to go from Oracle to SQL. Seems easy enough.
So, I create a Database in SQL 2005, right click and select "Import Data", Source is Microsoft OLE DB Provider for Oracle and I setup my connection. so far so good.
I create my Destination for SQL Native Client to the Database that I plan on importing into. Still good
Next, I select "Copy data from one or more tables or views". I move on to the next screen and select all of the Objects from a Schema. These are Tables that only relate to our application or in other words, nothing Oracle System wise.
When I get to the end it progresses to about 20% and then throws this error about 300 or so times:
Could not connect source component.
Warning 0x80202066: Source - AM_ALERTS [1]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
So, I'm thinking "Alright, we can search on this error and I'm sure there's an easy fix." I do some checking and indeed find out that there is a property setting called "AlwaysUseDefaultCodePage" in the OLEDB Data Source Properties. Great! I go back and look at the connection in the Import and .... there's nothing with that property!
Back to the drawing board. I Create a new SSIS package and figure out quickly that the AlwaysUseDefaultCodePage is in there. I can transfter information from the Oracle Source Table to the SQL Server 2005 Destination Table, but it appears to be a one to one thing. Programming this, if I get it to work at all, will take me about 150 hours or so.
This make perfect sense if all you are doing is copying a few columns or maybe one or two objects, but I am talking about 600 + objects with upwards of 2 million rows of data in each!!
This generates 2 questions:
1. If the Import Data Wizard cannot handle this operation on the fly, then why can't the AlwaysUseDefaultCodePage property be shown as part of the connection
2. How do I create and SSIS Package that will copy all of the data from Oracle to SQL Server? The source tables have been created and have the same Schema and Object Names as the Source. I don't want to create a Data Flow Task 600 times.
Help!!!
What is the C# code I use to do this?
I'm guessing it should be fairly simple, as there is only one row selected. I just need to pull out a specific field from that row and then insert that value into a different SqlDataSource.
i am using visual web developer 2005 with SQL Express 2005 with VB as the code behindi have one database and three tables in itfor manipulating each table i am using separate SqlDataSource() is it sufficient to use one SqlDataSource() for manipulating all the three tables ? i am manipulating all the tables in the same page only please help me
View 1 Replies View RelatedI have downloaded SQL Server Express Service Pack 1, SQL Express Management, SQL Express Toolkit, as well at the DTS Wizard and installed all, looked for Program filesMicrosoft SQL Server90DTSBinn and it isn't tere, did a search on my cjomputer for DTSWizard.exe and cannot find it. Any suggestions? Thanks
View 1 Replies View RelatedHere's the scenario: i've got Sql 6.5 server running on our network with about 6 databases.I have ran up another server on the network running sql 7,my
aim is to migrate from the 6.5 server all the databases...etc to the new server running SQL 7, is using the DTS wizard the best way for migration!!I have limited SQL experience and need some advice??I would be most grateful to all you sql gurus out there for any help
Cheers del.
hi all,
i have a problem.. i tried installing Microsoft SQL Server 2005 Express Edition Toolkit so that i can have the DTS wizard to import my data. however, i have encountered some problem.
the following components that you chose to install are already installed on the machine. to view a report of available options and alternatives click on details
greyed out - workstation components and development tools 9.2.3042.00
therefore i can't complete the installation. anyone can help me?
thanks.
I have created a dimension table for a star schema and included the following columns for treatment of historical changes:
[StartDate] datetime,
[EndDate] datetime,
[Current] varchar(5),
[IsInferred] bit
My Business key is code and the historical attribute is code_desc.
I run the wizard and nominate the Current attribute to be set to True or False. What should the type of this column be as it is not being populated ?
TIA,
Michael Morrissey.
I need to upload a very large access database to sql
2005. Do I break this down by tables, queries or what? Will
it take a long time. I believe that database is 3488,888 kb in
size. Thank youDee
Hi there
Apologies if I'm in the wrong post. I have a strange problem. I installed Sql Express Toolkit with the sole purpose to offer the import/export functionality in the Microsoft SQL Server90DTSBinn folder. After installation I did a quick test to make sure it works and it did. Suddenly now I get an error when I run the wizard file saying that it is not a valid win 32 application. I have a clean Windows XP S2 installation and definitly no virussus/worms etc. I have a simmilar problem when I try to run ASP.Net web starter kit files (.vss or something like that...)
PLEASE help me!
Greetings,I have been trying to use the DTS Import Wizard to import data, but SQL Server seems to have a bug that Microsoft has not yet addressed (or have they?)Basically, when I import data from a text file into one of my existing databases that contains a field with an identity, I run into problems. Basically, SQL gives an error and refuses to import my data if the column is set to having an identity. In the Column Mappings, I set that row to "ignore." I also tried checking Enable Identity Insert, and I tried unchecking it. Nothing works. I receive this error message: "...The statement has been terminated. Cannot insert the value NULL into column 'MovieID', table 'myproject.dbo.MovieStars'; column does not allow nulls. INSERT fails."I thought that checking "Enable Identity Insert" would automatically tell DTS to insert an incremental identity value.When I use this transformation code, it doesn't work either:Function Main() DTSDestination("MovieName") = DTSSource("Col001") DTSDestination("MovieStar") = DTSSource("Col002") Main = DTSTransformStat_OKEnd FunctionThis gives me a different but similar error: "Insert error, column 1, ('MovieID', DBTYPE_I4), status 10: Integrity violation; attempt insert NULL data or data which violates constraints. Unspecified error"I think this is a SQL Server bug. My google searches have revealed MANY people with this similar problem, but their problem almost never gets answered. If anyone could please offer assistance, that would be great, as my head is turning black and blue from banging it on my desk for the past 3 days.Thanks
View 3 Replies View Relatedvery simple question but I do not know the answer.
Why I can not find the version upgrad wizard from my program -> sqlserver 7.0 ->?when it is installed ? How can I install this utility?
Thank you very much.
JD
Chaps,
Im trying to upgrade to SQL 7.0 from 6.5. I currently have both installed on the
same machine in a switching enviornment.
I start the upgarde wizard and successfully get to the screen where you
enter the name of the 6.5 import server and 7.0 export server, I click next
and nothing happens (appart from the services stop and restart)!
Any ideas???
On one of our test server I am trying to upgrade SQL Server 6.5 sp4 to SQL Server 7. The test server has a copy of all the live database systems and user accounts. I am using the Upgrade Wizard.
The process of upgrade stops after the following message
“Verify that code page ‘0’ is installed on your Windows NT Server”
I have no idea as to how I can over this problem. What I do know is that a code page can refer to character set. And that on the server I am upgrading the code page is 850 Multilingual.
Any help please.
Hi...
Anybody out there who can help me on how to view the whole import process (DTS package created using Import DTS wizard) in SQL codes? Is there a possibility to view the process using Query Analyzer?
please help.
MyPast
SQL2000
I'm looking for the upgrade wizard to port from 6.5 to 2000. I must be blind as I cannot find the damn files ...
Any assistance would be appreciated.
Thanks,
Craig
Hi,
Having a problem with DTS Wizard crashing in XP, has anyone experienced similiar problems?
Using XP with SP1, transfering excel file to an oracle serve.
Hello AllI have SQL Server versions 6.5 and 2000 installed on a Windows 2000server.I installed 6.5 first, coppied a backup of a database to the server andrestored it. I then installed 2000. I am trying to use the upgradewizzard.On the first screen I keep the default settings, export and importobjectsand data, use a named pipe. Its all on the same server, give it the sapassword for both installations (its the same). All services arerunningunder local system account.It switches between the two versions a couple of times then comes upwiththis error message:Couldn't create or register the SQLUpgrade DSNAnybody got any idea what it means?RegardsMatt
View 2 Replies View RelatedI'm trying to backup several databases to UNC folders. I'm able to do itmanually for each database, but when I set up the maintenance plan it failsbecause SQL tries to use the SQL administrator account to push the data.The million dollar question is how does one change which account is runningthe maintenance?
View 2 Replies View Related Hi,
Please someone tell me the procedure of implementing the Slowly changing Dimension without using a wizard.
Thanks,
Chandana.
I ran the msi file but thereis no ADS wizard on my programs list, even after a reboot. When I run it again it does a repair but there is still no program. How do I find the right cab file for my device (DellAxim X51 With WM2005)
Is there a way to identify the wizard in C:programs?
I have (finally) successfully gotten through the maze and 'published' my database to a folder:
Physical path: I:SqlReplication
unc: WarrenassocSQLReplication
Since I'm running XP pro, I don't have the options of assigning specific read/write permissions to a folder.
However it appears the problem is with accessing the snapshot and the logon's there.
When I run the IIS Web Configure wizard I error out at the snapshot share permissions step (see report below)
Wizard Settings:
Click Finish to perform the following actions:
Modify a virtual directory immediately.
Copy the ISAPI dll 'sqlcesa30.dll" to 'I:SqlReplication" immediately.
Set NTFS permissions immediately.
The virtual directory 'SqlReplication' will be configured with the following options:
On server 'WARRENASSOC'.
Use 'SqlReplication' as the alias.
Use 'I:SqlReplication' as the physical path for the virtual directory.
Use 'Anonymous' as the authentication method(s).
Do not require secure channel.
Set user permissions to 'Execute'.
Clients can use 'http://WARRENASSOC/SqlReplication/sqlcesa30.dll' as the Internet URL.
'sqlcesa30.dll' will be copied from 'C:Program FilesMicrosoft SQL Server 2005 Mobile Editionserver' to 'I:SqlReplication'.
'WARRENASSOCEd Warren' will get the following NTFS permission:
'Read & Write' on physical path 'I:SqlReplication'.
'Read & Execute' on the ISAPI DLL 'I:SqlReplicationsqlcesa30.dll'.
'Read' on share physical path '\WarrenassocI$SqlReplication'.
'Read' on the share '\WarrenassocI$SqlReplication'.
- Modifying the virtual directory (Rolled back)
- Copying the ISAPI DLL (Rolled back)
- Setting the directory permissions (Rolled back)
- Setting the server agent permissions (Rolled back)
- Setting the snapshot directory permissions (Rolled back)
- Setting the snapshot share permissions (Error)
Messages
The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)
- Modifying the Virtual Directory configuration file. (Stopped)
When I created the snapshot I used my personal logon (admin rights) at each step
I've tried all combinations of setting the permissions in the wizard from requiring a login and providing my personal login to no requirements and I get the same error.
I'm trying to set up to copy a database from my SQL Server 2005 --> SQl Server CE 31 RC1
to see it it meet my development needs.
I'm at a loss as to how to navigate the security maze!!
Thanks Edward Warren.
Hi,
I'm trying to import data from Microsoft Access. I already have all the
tables in SQL Server and also the relationships, but I can't seem to
import any data without deleting the relationships. Is there a way to
do this without deleting them?
A few days ago I installed SQL Server 2005 Express edition and successfully used the upsizing wizard to convert a MS Access database to SQL Server database. Today I found I could get VB.Studio Express. The instructions said to delete SQL Server Express and .NET before installing VB Studio because it would re-install them both. I faithfully did that but since then I have been unable to get the upsizing wizard to work again. I have uninstalled SQL Server and re-installed it but still cant get it working. From SQL Server Configuration manager I can confirm that Shared Memory and TCP/IP protocol are both enabled for both protocols for clent and protocols for SQLEXPRESS Both the SQL Server and the SQL Browser are running. And from SQL Server Surface Configuration I can confirm that OPENROWSET AND OPENDATASOURCE SUPPORT is disabled; CLR Registration is disabled; OLE AUTOMATION is enabled; and xpCommandshell is disabled.
When I run the upsizing module it goes through the motions but the report at the end says "table was skipped or export failed" for each of the tables in the database.
I have looked everywhere I can think of to try to find a solution but no one so far has been able to help.
Hi friends
I have created a setup wizard for an application in vb.net and I tested in my system, it is working perfectly. But if i tried to install in another pc , the installation process go success, but once i open the new installed application, it is producing an error telling that it the applicatoin has encountered a problem and need to close it. im even not able to load the application. i will explain my project details below:
1 .It's a windows application and using connectivity to an sql cerver ce database (.sdf).
2. I removed all the default dataset and databinders from the program that i have written the coding for all connectivity.
3. im using system.data.sqlserverce for the connectivity
can anybody help me out please. the error is not producing in my system.
Im confused, whether it is required that the SQL server to be installed in the system or for .sdf files connectivity it is not required ?
please advice me on both issues.
thanx in advance
Nahas
I'm trying to configure web synchronization using the wizard, It errors out on step "Setting The snapshot share permissions". The error I get is
The operation completed successfully. (Exception from HRESULT: 0x80070000)
Then all the other steps rollback. I'm using the default location for the snapshot i.e in REPLDATA folder. When creating the publication I used a UNC path to specify the snapshot folder. For testsing purposes I'm using a windows account that has admin privilages on the box that is running IIS. I'm just testing this merger replication over https, so I have IIS and the distributor on the same box. I created the publication, and the snapshot. I was walking through the wizard, all seems to be OK but can't get past this pesky error, which is strange seeing it says it complete successfully.
Help, any ideas?