Hi
the following code generates an error while executing dbServer.Databases("InvModel").Transfer dbTransfer
error description
[SQL-DMO]Invalid parameter type; must be string or numeric ordinal, or an object; check documentation for this property or method.
I am trying with sql2005 express edition. the code was one which we used for sql 2000
Code Block
Dim dbTransfer As New SQLDMO.Transfer2
Dim dbServer As New SQLDMO.SQLServer2
dbServer.Connect gStrSQLServerName, "sa", "NEWTECH001"
With dbTransfer
.DestDatabase = Trim(txtCompCode)
.DestLogin = "sa"
.DestPassword = "NEWTECH001"
.DestServer = gStrSQLServerName
.DropDestObjectsFirst = True
.CopyAllObjects = True
.CopyAllTables = True
.CopyAllViews = True
.CopyData = SQLDMOCopyData_Replace
.IncludeDependencies = False
End With
Screen.MousePointer = vbHourglass
prgbar.Value = 35
dbServer.Databases("InvModel").Shrink 1, SQLDMOShrink_Default
DoEvents
Screen.MousePointer = vbHourglass
prgbar.Value = 50
DoEvents
dbServer.Databases("InvModel").Transfer dbTransfer
DoEvents
Screen.MousePointer = vbHourglass
I've a dataset which is filled using a stored procedure in either MSSQL2005 or 2000.
The procedure may return sql-errors (f.ex 208 if a table is not found), but the procedure will anyway return data which shall populate the dataset, independent on 208 errors.
The procedure works fine if running it from f.ex. SqlMgtStudio, and the dataset is filled if the procedure triggers no errors.
However, if the procedure triggers an error like 208, then I get an exception in the application and the dataset is not populated with the data returned by the procedure.
Is there a way of telling the DataSet/SqlDataAdapter to fill the dataset even if the sql-code genererates som errors?
I have a program using SQLDMO object.When I use it on my computer and I have install sqlserverit works OK,but when I move the program to another computer without sqlserverthe program runs error the error message is com exception 80040154can the proram using SQLDMO running on computer without installing sqlserver?BTW: my System is win2003,and the other is windows xp
Hello All ...I am attempting to create a program that will run on the PocketPC 2003 environment. I have upgraded Visual Studio to SP1, I have installed SQL Server Compact Edition on my development machine and I have installed SQL Server Compact Edition Tools For Visual Studio on the development machine.I have created a new project Visual Basic - Smart Device - Pocket PC 2003. I have created a form for user input. I build and deploy the form to the Symbol Pocket PC to test - no connection to data and it works.I then add a reference to System.Data.SqlServerCE.dll and rebuild and redeploy the application to the handheld. When I attempt to open the form I receive the following error:psmPocket.exeNotSupportedExceptionSystem.Drawing.Bitmapat System.Resources.ResourceReader.LoadObjectV2() at System.Resources.ResourceReader.LoadObject() at System.Resources.RuntimeResourceSet.GetObject() at System.Resources.ResourceManager.GetObject() at System.Resources.ResourceManager.GetObject() at pmsPocket.frmSetSOPType.InitializeComponent() at psmPocket.frmSetSOPType..ctor() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.RuntimeContructorInfo.InternalInvoke() at System.Reflection.ContrcutorInfo.Invoke() at System.Activator.CreateInstance() at MyForms.Create__Instance__() at MyForms.get_frmSetSOPType() at psmPocket.SetSOPType.Main()Now the confusing part is that I haven't changed any of the forms or the code behind the forms, I have simply added the reference to the project.Any idea why adding the reference to System.Data.SqlServerCE.dll would cause the system to start generating these errors?I've checked, the install process has loaded the .NET 2 framework to the handheld. And as indicated at the beginning of this message, the application showed the form prior to my adding the reference.Thoughts?Thanks ...
It's OS / SQL related. I backup to a UNC device, and frequently get a network related error - but not always. And the error is also OS related...
The scene: 64 bit Windows Server 2008 hosts 64 bit SQL 2008 Standard, and devices are created to point to 64 Server 2008 Server B (ServerBSQL_backupsdvc_DB.bak). The database is backed up daily, on a job, and when run the following error is returned:
Date2009/08/08 06:43:30 AM LogJob History (Backup_AssetData_2009-08-08)
Step ID3 ServerSQL01 Job NameBackup_AssetData_2009-08-08 Step NameBackup Database - Second Attempt Duration00:05:33 Sql Severity16 Sql Message ID3013 Operator Emailed Operator Net sent Operator Paged Retries Attempted0
Message Executed as user: COMPANYSERVICE_USER. Processed 94096 pages for database 'AssetData', file 'AssetData' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AssetData', file 'AssetData_log' on file 1. [SQLSTATE 01000] (Message 4035) The operating system returned the error '64(failed to retrieve text for this error. Reason: 15105)' while attempting 'FlushFileBuffers' on 'dvc_AssetData( iscsrv-dcm04RISCSRV-SQL01_Backupsdvc_AssetData.bak)'. [SQLSTATE 42000] (Error 3634) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
The file is generated, the same size as a successful backup, but the job terminates unsuccessful.I have tried to delete the devices' file, and then the backup usually succeeds. This may point to a permissions' type error, but the user the job is run under is a domain admin. The destination server is not unavailable during this time, and the network shares also remain active throughout the excersize - although I haven't got a way to "prove" this.
I have a few databases that backup to the UNC described above (different files) that don't fail..My SQL2000 server backs up it's databases to the SQL2008 server, and those backups don't fail with this error.
My research has led me to understand that the 64bit OS tries to buffer the files it receives from another server, and I was wondering if this could be influencing the backups as the destination server is also 64 bit Windows Server 2008.
##20090812## UPDATE
I tried another way to do the backup; with the same results:
Backup database Infovest to disk = ' iscsrv-dcm04 iscsrv-sql01_backupsdvc_Infovest_Z.bak' with INIT,STATS=1
I developed an application in Vb.net and SQLDMO that backs up a database and performs certain operations on it once this is done. I have set the backup to backup to file which the user selects. However when i execute the backup i get an error message that " Backup device not found or error finding device" .THis error baffles me because i have not specified the backup to be to device can anyone help?
MOM connects to 19 instances without issue and fails on one (1). The failing instance resides on a server with two(2) other instances that do not fail. Security is setup the same on windows and sqlserver.
Receiving error in MOM: "Could not connect using SQLDMO to SQL Instance WEB. However, the instance is currently running."
Presents in Event Viewer as: "18452: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Troubleshooting so far: Created simple SqlDMO VBScript that uses a trusted connection. This works fine from my desktop to all twenty (20) instances yet fails on the one server that MOM is running on.
Here's a really annoying problem. Let's say you have a text file with 2 million rows.Delimiters all look good and rows are previewed well but the file has a missing row at say lin 1234567 - way deep in the file. When SSIS encounters the blank row, an error is raised and processing on the file STOPS! I verified this in by checking the SSIS log and have even developed an error routine to notify me via email when the error occurs (really cool if I do say so myself ). The main problem still remains - how to resume processing from the point of failure in the file? Any help is appreciated. Thanks.
I'm trying to create a simple Data transfermation. I have a flat file that came of a unix server.. it's 177 bytes wide.. thought it was 175, but when I created the flat file connector, I could see some extra characters on the end.
My output is going to be an excel spreadsheet, I only want two columns from the input. I created an oledb jet 4.0 connection. and followed instructions from here :
On my first attempt to dataflow, I ran into unicode errors and had to do this:
ran into a problem with unicode errors. went to the source for the flat file. for the output column in question changed to Unicode string [DT_WSTR].
When I run , here are the errors I get:
[OLE DB Destination [513]] Error: An OLE DB error has occurred. Error code: 0x80040E09. [DTS.Pipeline]
Error: The ProcessInput method on component "OLE DB Destination" (513) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009.
[GanchoFileSource [1]] Information: The total number of data rows processed for file "\ammia01dev04D$JCPcpmgancho_venta_20070321.sal" is 19036.
[GanchoFileSource [1]] Error: Setting the end of rowset for the buffer failed with error code 0xC0047020.
[DTS.Pipeline] Error: The PrimeOutput method on component "GanchoFileSource" (1) returned error code 0xC0209017. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.
I am trying to make a custom task. The custom task has one input, which i map to externalmetadata column in the task and one output.
When i run the task it fails with this error ( I am putting the whole SSIS message)
SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Flat File Destination [1855]: The processing of file "C:ole db eft data.txt" has started. Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning. Error: 0xC0047062 at Data Flow Task, Lib [2387]: System.ArgumentException: Value does not fall within the expected range. at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBuffer90.DirectRow(Int32 hRow, Int32 lOutputID) at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.DirectRow(Int32 outputID) at Lib1.LibPM.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket) Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "Lib" (2387) failed with error code 0x80070057. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0x80070057. Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread1" has exited with error code 0xC0047039. Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DD at Data Flow Task, Flat File Destination [1855]: The processing of file "C:ole db eft data.txt" has ended. Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Flat File Destination" (1855)" wrote 0 rows. Task failed: Data Flow Task Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package "Package.dtsx" finished: Failure. ----------------------------
This is my piece of code which is trying to put the data in the output buffer (ProcessInput function).
Hi,I am trying to write a method which needs to call a stored procedure and then needs to get the response of the stored procedure back to the variable i declared in the method. private string GetFromCode(string strWebVersionFromCode, string strWebVersionString) { //call stored procedure } strWebVersionFromCode = GetFromCode(strFromCode, "web_version"); // is the var which will store the response.how should I do this?Please assist.
Hi, I have application in which i am performing synchronization between SQL Server 2000 and SQL Server 2005 CE. I have one table "ItemMaster" in my database.There is no relationship with this table,it is standalone.I am updating its values from Windows Mobile Device.
I am performing below operations for that. Step : 1 Pull To Mobile
Code BlockmoSqlCeRemoteDataAccess.Pull("ItemMaster", "SELECT * FROM ItemMaster", lsConnectString,RdaTrackOption.TrackingOn);
Step : 2 Using one device form i am updating table "ItemMaster" table's values.
So i am getting an error on 3rd step. While i am trying to push it says, "The Push method returned one or more error rows. See the specified error table. [ Error table name = ]". I have tried it in different ways but still i am getting this error.
Note : Synchronization is working fine.There is not issue with my IIS,SQL CE & SQL Server 2k.
Can any one help me?I am trying for that since last 3 days.
I have a gridview and a dataset. When I start my application I see the results in my gridview. When I clic on edit and chanche some value and click on update it wil give me this error:ObjectDataSource 'ObjectDataSourcePersoon' could not find a non-generic method 'Update' that has parameters: naam, tussenvoegsel, achternaam, adres, woonplaats, telefoonnummer, original_id, Original_naam, Original_tussenvoegsel, Original_achternaam, Original_adres, Original_woonplaats, Original_telefoonnummer. Does someone know whats the problem??
We have a SQL Server 2000 in a Windows 2003 Server, and we were working very well with the VB 6.0, but after an update in the Windows 2003, the Open method in ADO results in an error -2147467259 sometimes, but if we try the same code in a computer with another domain there are not any problem, some advice?
I have a strange problem with calling packages from c# code. Packages start to execute, but never finish. Instead an error occures in eventlog:
(message is translated into english so it can sound a bit different)
Erring application AppName.exe, version 1.0.0.0, timestamp 0x4784c811, erring module ntdll.dll, version 6.0.6000.16386, timestamp 0x4549d372, exception code 0xc0000374, error shift 0x00000000000c87b7, process ID 0x1284, application start time 0x01c852ceb26bbad3.
In debuger, execution stoppes on line "DTSExecResult res = dtsPkg.Execute();", but no error is showed.
This behaviour occured unexpectally. Application worked correctly and in a minute I wasn´t able to execute any package from an application. I also tryed it from another computer and got the same error. Calling packages directly from management studio works fine.
OS: Windows Vista Bussiness 64b
Code:
Package dtsPkg = new Package();
Variables variables = dtsPkg.Variables;
Microsoft.SqlServer.Dts.Runtime.Application dtsApp = new Microsoft.SqlServer.Dts.Runtime.Application();
Hi, I just have a Dataset with my tables and thats it I have a grid view with several datas on it no problem to get the data or insert but as soon as I try to delete or update some records the local machine through the same error Unable to find nongeneric method... I've try to create an Update query into my table adapters but still not working with this one Also, try to remove the original_{0} and got the same error... Please help if anyone has a solution
I've got a CLR stored proc I'm trying to deploy to SQL2005, when I try to debug it I get the error message: Method, property or field 'usp_Evaluate_eTranscript' of class 'ACS_eTranscripts.StoredProcedures' in assembly 'ACS_eTranscripts' is not static.
The class & procedure are declared: Partial Public Class StoredProcedures Private Structure CalcGPA Friend intGrdTot As Integer Friend intCrsKnt As Integer End Structure <Microsoft.SqlServer.Server.SqlProcedure()> _ Public Sub usp_Evaluate_eTranscript(ByVal SSN As String)
When I change the sub's declaration to: Static Sub usp_Evaluate_eTranscript(ByVal SSN As String)
I get an error message that: Methods cannot be static.
So, is this a Catch 22 or what am I missing?
Any help would be greatly appreciated as this is a major project and I am woefully behind because of emergency surgery.
Has there been any fix for this bug? The workaround in the KB article did not work for me and I cannot run my entire application from the Windows directory even if it did.
Please help.
Original Thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PostID=274359
Workaround KB article: (I cannot run my app from Window directory) http://support.microsoft.com/kb/920272
I export data from a dozen tables of one database to another database on another server regularly and it works well. However, if i choose the option of "save SSIS package", I get the following error:
TITLE: SQL Server Import and Export Wizard ------------------------------
The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement issued has failed.
------------------------------ BUTTONS:
OK ------------------------------
I use management studio to do this, but the servers are 2000.
Hi, I've got the error message below: "Error 80040E2F. A duplicate value cannot be inserted into a unique index [Table name=_SysRDASubscriptions, Constraint name=c_LocalTableName]"
I'm using SQL Server 2005 Compact Edition and still cannot solve the problem although the KB article (920272) said it is fixed in V3.1.
What I need to do is to drop a table and then Pull it again to the PDA but it gives me that error message during pull method. However, I can use the same process to drop and pull other tables and works fine. Will that be the problem related to primary key or to the data of the table?
I'm trying to create a few report models in Visual Studio to demonstrate the Report Builder tool and I'm encountering an issue when I try to generate a Report Model.
I get the error message "Specified Method Is Not Supported" when I click Finish on the Report Model wizard. The error detail is:
=================================== Specified method is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.CreateSqlDsvStatisticsProvider(IDbConnection connection) at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.BuildModel()
Steps to reproduce: 1. Create a new Report Model project in Visual Studio 2005 against SQL Server 2005 2. Create a new data source. The data source was tested and works correctly 3. Create a new data source view. The data source view was also tested (clicked on Explore Data) and I was able to look at the data in the view 4. Right-click on Report Models and select "Add New Report Model" 5. Click next at the welcome screen 6. Select the data source view created in #3 7. Leave the selected options for report model generation rules for creating the data source view (Create Entities for all Tables, Create Count Aggregates, Create Attributes, Create Attributes for auto-increment columns, Create date variations, Create numeric aggregates, Create date aggregates, Create roles were all selected) 8. Click next 9. Select Update Model Statistics Before Generating (default option) 10. Click next 11. Click Run
Once I click run it processes for approx 3 seconds and then returns the error above.
If anyone could help me I'd appreciate it. Microsoft hasn't published any details on the namespace and I'm not sure why I'd be getting the error I am.
I have a Data Flow Task within an SSIS package where data is pulled from a Fixed Width flat file, goes through a conditional split, and sends data either to a SQL Server 2000 table, or to another fixed width flat file.
The first condition in the conditional split checks for the following; [Column 44] + [Column 45] != "D1" . If this is true, then those rows go to a SQL Server 2000 table destination. If false, then the rows go to another flat file.
The SQL Server 2000 table has a unique nonclustered index with ignore_dup_key. From what I can tell, it looks like the step fails when a duplicate record is encountered. However, it appears that the unique records still go into the table.
When I check the 'Progress' tab of the package, the following steps seem to be suspect;
[Populate Staging [786]] Information: The final commit for the data insertion has started. [Populate Staging [786]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Duplicate key was ignored.". [Populate Staging [786]] Information: The final commit for the data insertion has ended. [DTS.Pipeline] Error: The ProcessInput method on component "Populate Staging" (786) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009. [DTS.Pipeline] Information: Post Execute phase is beginning.
..and..
Task 2 Isolate Suspect Records and Insert Known Good Records failed
In one case, the source flat file had 74,101 rows. Each row tested true in the conditional split, and all but one row made it into the SQL Server table. The step failed, and the 'Progess' section containted the entries mentioned above.
The Connection Manager for the SQL Server table destination uses the Native OLE DBMicrosoft OLE DB Provider for SQL Server.
Is the 'error' that occurs when a duplicate row is encountered causing the Data Flow task to fail, or could it be something else?
Thank you for your help. Please let me know if you need more information.
I have a problem while trying to update the content of my page to the database by the means of a stored procedure string OcompConnection = ConfigurationManager.ConnectionStrings["GenUserCode"].ConnectionString; System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(OcompConnection); System.Data.SqlClient.SqlCommand ocmd = new System.Data.SqlClient.SqlCommand("Dealer_Insert", conn);ocmd.CommandType = CommandType.StoredProcedure; ocmd.Parameters.Add(new SqlParameter("@UserCode"), SqlDbType.NVarChar); ocmd.Parameters["@UserCode"] = TxtUserCode;
and also there is another error message saying that argument1: can not comvert from system.data.sqlclient.sqlparameter to string. What am i Missing??? Eventually there is the try{open} and finally{close}
I've been trying to create an async transform component and one of the things I'd like to do is add a new output and/or columns to existing outputs for each input column that is selected. I thought that the SetUsageType method would be a good place to do this as it will allow me to delete output's and columns based on the user's selections but, despite the fact that my code doesn't actually throw or cause errors, when I return from the SetUsageType method I'm informed that error 0xC0047041 (DTS_E_OBJECTNOTINHASHTABLE) has occurred . I pared the method down to an absolute minimum and found that a call to GetVirtualInput is enough to push it over the edge even if it does nothing! What is wrong here? Thanks Charlie
Sample: public override IDTSInputColumn90 SetUsageType(int inputID, IDTSVirtualInput90 virtualInput, int lineageID, DTSUsageType usageType) {
I trying to import from fixed width text files that may contain one or more empty rows at the bottom of the file (where an empty row is {CR}{LF}). By experimenting, I found it runs successfully with up to 32 blank rows, but with any more I get this:
Warning: 0x8020200F at Copy TBMO files to DW, TBMO text file source [1]: There is a partial row at the end of the file.
Error: 0xC0047038 at Copy TBMO files to DW, DTS.Pipeline: The PrimeOutput method on component "TBMO text file source" (1) returned error code 0x80020005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at Copy TBMO files to DW, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.
Error: 0xC0047039 at Copy TBMO files to DW, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Copy TBMO files to DW, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.
I have a SQL Server Agent job with a step to execute an SSIS package. The package has as one of it's connection managers the Connection Manager For Excel Files. When I run the job it fails every time. I have implemented logging and in the OnError event it states "The AcquireConnection method call to the connection manager "LOBMappingExcel" failed with error code 0xC0202009".
I've seen the previous threads on this (although maybe not all of them). However, i don't think I'm getting the error for the same reason. The full error I'm getting is:
I recently transferred my SQL DB from one server to another, I backed the DB up, copied across and restored it into the new location, the problem is that I get the following error.
System.Data.SqlClient.SqlException: Invalid object name 'Table Name'
I have created a new user for this database and changed my code accordingly.
Dim conPubs As SqlConnection Dim cmdSelectContacts As SqlCommand Dim dtrContacts As SqlDataReader
conPubs = New SqlConnection("Server=Treebeard;UID=Intranet;Pwd=glglgl;Database=Contacts") ConPubs.Open() cmdSelectContacts = New SqlCommand ("Select * From Clientdata", ConPubs)
dtrContacts = cmdSelectContacts.ExecuteReader()
While dtrContacts.Read() Response.Write( "<li>" ) Response.Write( dtrContacts( "c_forename" )) End While
I'm trying to copy all tables (including indexes, triggers, etc) from one db to another using the transfer sql server object task.
I seem to able copy small amounts of tables (sometimes), but when I select ALL the tables, I get this handy error:
"The requested objects failed to transfer"
I had a few problems when trying to copy certain tables that had foreign keys, but that's sort of expected: you can't stick a key onto a table that references another table that doesn't exist!
I get this error when trying to copy a few tables that do have keys. There are no primary or candidate keys in the referenced table 'Table1' that match the referencing column list in the foreign key 'FK_Table2_Table1'
Now, Table1 does have primary key on the source, but it seems to want to create the foreign key on Table_2 before the primary key on Table_1 has been created!
I have problem with LINQ. I have created SQL Server 2005 database Database.mdf in App_Data folder with two tables - Pages and PagesGroups. Table Pages consist of fields PageID, AspxForm, DescriptionEN, DescriptionPL, PagesGroupID, NavNameEN, NavNamePL, PageActive, NavToolTipEN, NavToolTipPL and table PagesGroups consist of PagesGroupID, NavGroupNameEN, NavGroupNamePL, NavGroupToolTipEN, NavGroupToolTipPL, GroupDescriptionPL, GroupDescriptionEN, GroupActive. I added example rows. I created DataClasses.dbml, where Pages is child of PagesGroups, and DataClasses.designer.cs, which cause error "No overload for method 'DataContext' takes '0' arguments", in App_Code folder. I started writing LINQ commands in master page (DataClassesDataContext db = new DataClassesDataContext(); var pages = from p in db.Pages select new { Description = p.PagesGroup.GroupDescriptionPL };). What should I write in DataClasses.designer.cs that errors does not occur? What is wrong in my DataClasses.designer.cs? I wrote source of DataClasses.designer.cs, MasterPage.master and error message below. App_Code/DataClasses.designer.cs:
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.Linq; using System.Data.Linq.Mapping; using System.Linq; using System.Linq.Expressions;using System.Reflection;
[System.Data.Linq.Mapping.DatabaseAttribute(Name="Database")] public partial class DataClassesDataContext : System.Data.Linq.DataContext { private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
public System.Data.Linq.Table<Page> Pages { get {return this.GetTable<Page>(); } } public System.Data.Linq.Table<PagesGroup> PagesGroups { get {return this.GetTable<PagesGroup>(); } } } [Table(Name="dbo.Pages")] public partial class Page : INotifyPropertyChanging, INotifyPropertyChanged {
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _PageID;
private string _AspxForm;
private string _DescriptionEN;
private string _DescriptionPL;
private int _PagesGroupID;
private string _NavNameEN;
private string _NavNamePL;
private bool _PageActive;
private string _NavToolTipEN;
private string _NavToolTipPL;
private EntityRef<PagesGroup> _PagesGroup;
public Page() { this._PagesGroup = default(EntityRef<PagesGroup>); }
[Column(Storage="_PageID", AutoSync=AutoSync.Always, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)] public int PageID { get { return this._PageID; } set { if ((this._PageID != value)) { this.SendPropertyChanging(); this._PageID = value; this.SendPropertyChanged("PageID"); } } }
[Column(Storage="_AspxForm", DbType="Char(10) NOT NULL", CanBeNull=false)] public string AspxForm { get { return this._AspxForm; } set { if ((this._AspxForm != value)) { this.SendPropertyChanging(); this._AspxForm = value; this.SendPropertyChanged("AspxForm"); } } }
[Column(Storage="_DescriptionEN", DbType="NText", UpdateCheck=UpdateCheck.Never)] public string DescriptionEN { get { return this._DescriptionEN; } set { if ((this._DescriptionEN != value)) { this.SendPropertyChanging(); this._DescriptionEN = value; this.SendPropertyChanged("DescriptionEN"); } } }
[Column(Storage="_DescriptionPL", DbType="NText", UpdateCheck=UpdateCheck.Never)] public string DescriptionPL { get { return this._DescriptionPL; } set { if ((this._DescriptionPL != value)) { this.SendPropertyChanging(); this._DescriptionPL = value; this.SendPropertyChanged("DescriptionPL"); } } }
[Column(Storage="_PagesGroupID", DbType="Int NOT NULL")] public int PagesGroupID { get { return this._PagesGroupID; } set { if ((this._PagesGroupID != value)) { if (this._PagesGroup.HasLoadedOrAssignedValue) { throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException(); } this.SendPropertyChanging(); this._PagesGroupID = value; this.SendPropertyChanged("PagesGroupID"); } } }
[Column(Storage="_NavNameEN", DbType="NVarChar(50) NOT NULL", CanBeNull=false)] public string NavNameEN { get { return this._NavNameEN; } set { if ((this._NavNameEN != value)) { this.SendPropertyChanging(); this._NavNameEN = value; this.SendPropertyChanged("NavNameEN"); } } }
[Column(Storage="_NavNamePL", DbType="NVarChar(50) NOT NULL", CanBeNull=false)] public string NavNamePL { get { return this._NavNamePL; } set { if ((this._NavNamePL != value)) { this.SendPropertyChanging(); this._NavNamePL = value; this.SendPropertyChanged("NavNamePL"); } } }
[Column(Storage="_PageActive", DbType="Bit NOT NULL")] public bool PageActive { get { return this._PageActive; } set { { this.OnPageActiveChanging(value); this.SendPropertyChanging(); this._PageActive = value; this.SendPropertyChanged("PageActive"); } } } private void OnPageActiveChanging(bool value) { throw new NotImplementedException(); }
[Column(Storage="_NavToolTipEN", DbType="NText", UpdateCheck=UpdateCheck.Never)] public string NavToolTipEN { get { return this._NavToolTipEN; } set { if ((this._NavToolTipEN != value)) { this.SendPropertyChanging(); this._NavToolTipEN = value; this.SendPropertyChanged("NavToolTipEN"); } } }
[Column(Storage="_NavToolTipPL", DbType="NText", UpdateCheck=UpdateCheck.Never)] public string NavToolTipPL { get { return this._NavToolTipPL; } set { if ((this._NavToolTipPL != value)) { this.SendPropertyChanging(); this._NavToolTipPL = value; this.SendPropertyChanged("NavToolTipPL"); } } }
... using System.Data.Linq; using System.Data.Linq.Mapping; using System.Globalization; using System.Linq; using System.Linq.Expressions;
... public partial class MasterPage : System.Web.UI.MasterPage {public void Page_Load(object sender, EventArgs e) { ... DataClassesDataContext db = new DataClassesDataContext(); ... if (Page.UICulture == "Polish") { ...var pages = from p in db.Pages where p.PagesGroup.GroupActive == true && p.PageActive == trueselect new { PagesGroupDescription = p.PagesGroup.GroupDescriptionPL }; } else {var pages = from p in db.Pages where p.PagesGroup.GroupActive == true && p.PageActive == true select new { PagesGroupDescription = p.PagesGroup.GroupDescriptionEN }; ... } ... } } Error:
Compilation 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: CS1501: No overload for method 'DataContext' takes '0' argumentsc:UsersAdministratorDocumentsMy Web SitesKamil Szmit (szmitek)App_CodeDataClasses.designer.cs(25,22): error CS1501: No overload for method 'DataContext' takes '0' arguments c:WindowsassemblyGAC_MSILSystem.Data.Linq3.5.0.0__b77a5c561934e089System.Data.Linq.dll: (Location of symbol related to previous error)
