HResult E_Fail Error
Dec 6, 2006
From a couple of days I have a strange and annoying problem on my development machine. Every time that I try to use the Import/Export wizard in the Management Studio I receive the error HResult E_Fail error refererencig to the dtsruntimewrap.
If I try to open a SSIS package and to check the setup of the connection I receive instead a message stating Could Not Edit OleDB Connection, error E_FAIL(0x80004005). (System.Data)
What can I do to fix this problem?
Thank you
View 6 Replies
ADVERTISEMENT
Oct 8, 2007
i have restored site using stsadm, site get successfully restored.
all user of the site able to access the site but the unable to access from same machine on which it is restored.
i got the error
The file exists. (Exception from HRESULT: 0x80070050)
View 1 Replies
View Related
Apr 12, 2007
I guys,
I have this store procedure which does a bulk insert to a session table from a XML file. This store procedure used to work fine until couple of month ago and now all of the sudden it stopped working. Whenever this procedure is executed I get following error:
Msg 6511, Level 16, State 82, Procedure up_XNetSessionBulkInsert, Line 42
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later.
I also tested same procedure on the development sql server and it works fine. the settings on the production and development are same.
I was wondering if any of you have a solution for it. Here is the procedure which causes error.
dbo.up_SessionBulkInsert '<sessions><s id="6" val="45465465" len="9" /></sessions>'
ALTER PROCEDURE [dbo].[up_SessionBulkInsert]
(
@sessionXml text
)
AS
SET NOCOUNT ON
declare @handle int
exec sp_xml_preparedocument @handle output, @sessionXml
INSERT INTO SessionTb
(
sessionID
,session
,length
)
SELECT
sessionID
,dbo.udf_DecodeBase64StringToBinary(session) as RawBytes -- Base64-decode to byte[] before we insert.
,length
FROM
OpenXml(@handle, '/sessions/s', 1)
WITH
(
sessionID varchar(88) '@id'
,session varchar(max) '@val' -- This value should be a base64-encoded string
,length int '@len'
)
select @@rowcount
exec sp_xml_removedocument @handle
SET NOCOUNT OFF
View 11 Replies
View Related
Feb 5, 2008
What is the cause of this failure to install (Microsoft SQL Server 2005 9.00.3042.00 fetched from http://download.microsoft.com/download/1/5/8/15840bb5-30d9-4ba2-b6bd-32424d22f0f9/SQLEXPR_ADV.EXE) :
Code Snippet
Machine : DX5150
Product : SQL Server Management Studio Express
Error : An error occurred during the installation of assembly 'msddsp,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="8.0.0.0",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020.
--------------------------------------------------------------------------------
Machine : DX5150
Product : Microsoft SQL Server Management Studio Express
Product Version : 9.00.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_DX5150_SSMSEE_1.log
Last Action : InstallFinalize
Error String : An error occurred during the installation of assembly 'msddsp,Version="8.0.0.0",Culture="neutral",PublicKeyToken="b03f5f7f11d50a3a",FileVersion="8.0.0.0",ProcessorArchitecture="MSIL"'. Please refer to Help and Support for more information. HRESULT: 0x80070020. assembly interface: IAssemblyCacheItem, function: Commit, component: {FB603825-921B-4781-9FF3-1B1800281E29}
Error Number : 1935
View 2 Replies
View Related
Jan 30, 2007
hi,
I'm working on "MERGE REPLICATION"...i followed the procedure same as the book
"SQL SERVER CE DATABASE DEVELOPMENT WITH the .NET COMPACT FRAMEWORK"Author Rob Tiffany, ch9,10
i got one error msg that..."a request to send data to the computer funning IIS failed,for more information seeHRESULT " ..When my program hits rep.Syncronize()...
here my codes
\\\\\\\\\\\
rep = New SqlCeReplication
rep.InternetUrl= "https://seawolf/fieldagentrda/sscesa20.dll"
rep.InternetLogin = "robtiffany"
rep.InternetPassword = "pinnacle"
rep.Publisher = "seawolf"
rep.PublisherDatabase = "IntelligenceData"
rep.PublisherLogin = "sa"
rep.PublisherLogin = "apress"
rep.Publication = "IntelligenceDataPublication"
rep.Subscriber = "subscriber"
rep.SubscriberConnectionString="Datasource=My Documents" & _"IntelligenceData.sdf;" & _ "SSCE:Database Password=apress"
If File.Exists("MyDocumentsIntelligenceData.sdf") Then
rep.Synchronize()
Else
MessageBox.Show("You must first create a database", "Error")
End If
\\\\\\\\\\\\\\\\\\\
can anyone help me ,how to solve this issue?
Thanks in advance
View 2 Replies
View Related
May 8, 2006
I am modifying the aplication to visual.net from visual studio 2005 but I have problems ( in this moment i working in my pc , with sql 2000 personal ,windows xp , sql mobile and pc pocket emulator for window ce 5.0)
I don't know but i can't make the Pull in the server.
1) the http://localhost/driver2005/sqlcesa30.dll?diag is correct
2) I don't have the windows firewall
3)the anonimous user have all the permition in the virtual directory..
Where is the error ?
Thanks
View 5 Replies
View Related
Mar 25, 2008
hello all
i m getting the following error while exporting an excel file in SSIS
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
is this a bug?
pls suggest a workaround.
View 2 Replies
View Related
May 16, 2007
Hello,
I get following error trying to use SQLCMD OR OSQL
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
I searched this forum for answers and I found one solution where it was said that Remote connections for TCP and Named Pipes needs to be enabled. I have them enabled, but I still get this error. I had working SQL server before, but I had to uninstall it. Now after installing ti again I started to get this error.
Anything else besides disabled remote connections cause this problem? I'm trying a local connection. I heard elsewhere that this could be firewall related, but shouldn't it use local connection always when I try to connect it with sqlcmd and no other parameters given?
View 2 Replies
View Related
May 2, 2007
Where can i get the full error when viewing the report in visual studio...
"An unexpected error has occurred (Exception from HRESULT: 0x800300FD (STG_E_UNKNOWN))
This seems strange.. I am using a cube.. and the second I drag certain field to the grid in the query designer it crashes. When I take that field out its fine.. in my report I have NOTHING. just an empty report with a dataset.
please help.. urgent!
Regards,
Neil
View 3 Replies
View Related
May 12, 2006
I have ran into the same problem ... Importing from Access into SQL 2005 using SSIS and get the error:
[Connection manager "SourceConnectionOLEDB"] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
View 3 Replies
View Related
Feb 22, 2008
I work with February CTP of SqlServer 2008.
I have an Assembly with several UDTs inside. Version of assembly is 1.0.*
I use CREATE ASSEMBLY statement to register this assembly, and it runs without any errors. Then I rebuild CLR solution without doing any changes in source code. In that case the only difference between new and old assemblies is version (difference in fourth part of version).
Then I try to update assembly in SqlServer. I use
ALTER ASSEMBLY <name>
FROM <path>
WITH PERMISSION_SET = UNSAFE, UNCHECKED DATA
statement for this. Statement runs with error:
Msg 6509An error occurred while gathering metadata from assembly <Assembly name> with HRESULT 0x1.
I found the list of condition for ALTER ASSEMBLY in MSDN:
ALTER ASSEMBLY statement cannot be used to change the following:
· The signatures of CLR functions, aggregate functions, stored procedures, and triggers in an instance of SQL Server that reference the assembly. ALTER ASSEMBLY fails when SQL Server cannot rebind .NET Framework database objects in SQL Server with the new version of the assembly.
· The signatures of methods in the assembly that are called from other assemblies.
· The list of assemblies that depend on the assembly, as referenced in the DependentList property of the assembly.
· The indexability of a method, unless there are no indexes or persisted computed columns depending on that method, either directly or indirectly.
· The FillRow method name attribute for CLR table-valued functions.
· The Accumulate and Terminate method signature for user-defined aggregates.
· System assemblies.
· Assembly ownership. Use ALTER AUTHORIZATION (Transact-SQL) instead.
Additionally, for assemblies that implement user-defined types, ALTER ASSEMBLY can be used for making only the following changes:
· Modifying public methods of the user-defined type class, as long as signatures or attributes are not changed.
· Adding new public methods.
· Modifying private methods in any way.
But I havent done any changes in source code, so new version of assembly satisfies all this conditions.
What could be the reason for such behavior?
P.S. Ive got the same error, if I add or change any method in assembly before rebuilding.
View 9 Replies
View Related
Oct 24, 2006
I'm running sql server ver 7.0 SP4.I have an access project (.adp) that runs a view which is nothing morethan a select statement. Access locks up solid when I try to run thisquery - with NO error messages what-so-ever.If I sign onto the server, and run the view from enterprise manager - Iget:"the data provider or other service returned an E_FAIL status" !?!?!There is NO ERROR number, or further explanation of the message!!Now - this query DID work last week - all of a sudden I get this error- I've:1) repaired / compacted this database2) rebooted the server3) spent several hours searching websites & groups for an explanationa) I don't care how useless some people think enterprise manager is -at least it gave me SOME kind of error; where access just locks up!b) There are no issues with null values, or problem date fieldsanywhere in these tables.4) tried MANY variations on the query, and am now more confused thanever.5) I've RUN THIS QUERY IN AN ACCESS MDB WITH LINKS TO THE SQL SERVER -AND IT WORKS!?!?!?!?The query I'm using follows; if I remove ONE field from the selectstatement - this query RUNS!!!It doesn't matter what field I remove! It's as if, I can only have somany fields in the select statement!?!?!?This is clearly ridiculous since the query ran fine last week with thesame number of fields, not thatthat should have anything to do with this, as sql shouldn't care howmany fields I request.I'm not actually requesting any fields in the last table - but if Iremove this table it works!? If I leave this table, and select fieldsfrom it, but remove another table - again it works!So my questions:1) What [T-] is going on here?2) Why would an mdb be able to run a query that an adp can not!?!?3) When will microsoft ever release a product that provides usefulerror messages?I really don't expect an answer to #3, because I know the answer isNEVER - microsoft doesn't want to make solving problems easy.Here's the query I'm using:SELECT codes.proj_id, answers.report_date,answers.release_date, answers.notes,answers.answer_date, answers.answer_person,answers.answer, answers.answer_status,answers.answer_person2, codes.cust_idFROM dbo.codes LEFT OUTER JOINdbo.demos ONdbo.codes.code = dbo.demos.code LEFT OUTER JOINdbo.answers ON dbo.codes.code = dbo.answers.codeany help appreciated - TIABob
View 2 Replies
View Related
May 15, 2007
after converting database from sql server 2000 to sql server 2005. my program on vb6 is facing runtime error. i.e.data provider or other service returned an E_Fail status .
how can i get rid this problem
View 2 Replies
View Related
Apr 22, 2007
Dear all,
I am running an Access adp application with SQL Server 2005 as back end database. I run a query by using Management Studio query window, and it returned correct results with some columns containing NULL value. But when I run this query through MS Access client side, popup an error "Data provider or other service returned an E_FAIL status" and crash the Access application. I moved the database back to SQL Server 2000, and it runs perfect on both client side and server side returning the correct result. This query is important for the application. Please help!!!!
Query as followed:
SELECT TOP (100) PERCENT dbo.VWINFO312FYTRStreamEnrolments.StudentID, dbo.RequiredStreams.StreamType,
dbo.VWINFO312FYTRStreams.StreamCode + CAST(dbo.VWINFO312FYTRStreams.StreamNo AS varchar) AS FullStreamCode,
dbo.DaysOfWeek.DayCode, dbo.VWINFO312FYTRClasses.StartTime, dbo.VWINFO312FYTRClasses.EndTime, dbo.VWINFO312FYTRClasses.Room,
dbo.Tutors.TutorName, dbo.Tutors.PhoneExtn, dbo.Tutors.OfficeHours, dbo.DaysOfWeek.DaySequence, dbo.RequiredStreams.StreamOrder
FROM dbo.RequiredStreams INNER JOIN
dbo.VWINFO312FYTRStreams ON dbo.RequiredStreams.PaperID = dbo.VWINFO312FYTRStreams.PaperID AND
dbo.RequiredStreams.StreamCode = dbo.VWINFO312FYTRStreams.StreamCode INNER JOIN
dbo.VWINFO312FYTRStreamEnrolments ON dbo.VWINFO312FYTRStreams.PaperID = dbo.VWINFO312FYTRStreamEnrolments.PaperID AND
dbo.VWINFO312FYTRStreams.StreamCode = dbo.VWINFO312FYTRStreamEnrolments.StreamCode AND
dbo.VWINFO312FYTRStreams.StreamNo = dbo.VWINFO312FYTRStreamEnrolments.StreamNo LEFT OUTER JOIN
dbo.DaysOfWeek INNER JOIN
dbo.VWINFO312FYTRClasses ON dbo.DaysOfWeek.DayCode = dbo.VWINFO312FYTRClasses.DayofWeek ON
dbo.VWINFO312FYTRStreams.PaperID = dbo.VWINFO312FYTRClasses.PaperID AND
dbo.VWINFO312FYTRStreams.StreamCode = dbo.VWINFO312FYTRClasses.StreamCode AND
dbo.VWINFO312FYTRStreams.StreamNo = dbo.VWINFO312FYTRClasses.StreamNo LEFT OUTER JOIN
dbo.Tutors ON dbo.VWINFO312FYTRClasses.ResponsibleTutor = dbo.Tutors.TutorID
View 4 Replies
View Related
May 17, 2007
Main_Module.STRCNNN1 = "driver={SQL Server};server=" & Main_Module.Server_Name & ";" & _
"uid=SA;pwd=;database=" & Main_Module.Common_Database
error msg is
runtime error
data provider or other service returned an E_Fail status in sql server 2005
when i am fetching record from view using order by clause in select statement then error is coming
as
select * from vew_emp where grade='C' order empno
at the first time it fetching record with order by
but when i am using recordset.Requiry
it cud not fetch the record
i think when the recordset is open with the record of view
i am deleting ,inserting record in the view base table then the main recordset is not working
without using order by it is running and working well
plz reply me quickly
View 3 Replies
View Related
Jan 6, 2006
We have a SSIS package that intermittently fails on the deployed server (works fine on our dev server) with the following error:
"The variable "%1!s!" is already on the read list. A variable may only be added once to either the read lock list or the write lock list."
This seems to happen right at the start when the variables are processed before any tasks happen. It also only fails half the time.
I just don't even know where to begin. Any clues?
View 11 Replies
View Related
Mar 15, 2006
Hai all,I am getting an DB_E_ERRORSINCOMMAND exception when I try to open arecordset or execute query in VC++. But when I run the same query inQuery Analyzer, it is working fine. I am sure the connection string iscorrect. I am running a collection of queries and finally commit thetransaction, but everytime it not throwing the exception on same query,eachtime different queries throw exception randomly.Can anyone tell whats the problem?Urgent, Please help...Looking forward for the response..Thanx in advance...
View 3 Replies
View Related
Mar 22, 2007
Hi, there;
I created a SSIS package in a ASP.NEP application which importing data from some .dbf file. "Exception from HRESULT: 0xC0048004" happened to two tables. I had a look this exception at http://msdn2.microsoft.com/en-us/library/ms345164.aspx, it says: The index is not valid. But there is no index defined in my destination table.
Does anybody how to resolve it?
Thanks
View 1 Replies
View Related
Jul 25, 2007
Dear Group,
we recently installed the sourceforge forum system on our server (MS SQL 2005) and were excited how well it worked.
However, after the most recent MS update, and using the compiler Visual Webdeveloper Express, we are suddenly receiving the error message:
"An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)"
Can you help us?
Many thanks,
Robert "Bobby"
View 3 Replies
View Related
Jul 19, 2007
Hi,
I have a dump file retrieved from SqlServer 2000. The file name reads something like this: concorde_db_dump.200706070105
I have been trying to import it to SqlServer 2005 but always receiving this message:
Not enough storage is available to process this command.
(Exception from HRESULT: 0x80070008) (mscorlib)
The error details are as follows:
Program Location:
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRIn
ternal(Int32 errorCode, IntPtr errorInfo)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Editors.Scri
ptFactory.ProcessDroppedFilesAsyncInternal(StringCollection
filesToOpen)
Does anyone know what's wrong? Thanks!
View 2 Replies
View Related
Apr 5, 2006
I created a packsge, set up a connection and the connection is tested OK. Then I created a OLE DB Source, gave the created connection and a table. When I click "Preview" button, this is what I got:
Error at DTStask_DTSDataPumpTask_3(OLE DB source[1]): An error occured due to no connection. A data connection is required when requesting metadata.
Additional informatin:
Exception from HRESULT 0xC0202022: (Microsoft.Sqlserver.DTSPipelineWrap)
Please tell me what I did wrong? or have I broken something?
View 2 Replies
View Related
Apr 18, 2008
hi all,
I am using SSIS package to transfer data from 4 tables of one Server to another server(Using SQLConnection).
All works fine while runinng in Debug mode.
But while running the application(Which calls SSIS and creates Pacakage),it is creating only one package instead of creating 4 and resulting in error.
"Exception from Hresult:0xc0202009"
Please help me to solve this issue.
Thanks in advance,
Sangeet
View 8 Replies
View Related
Apr 30, 2007
Hi,
I write a custom component (destination component) that handle the error of my dataflow.
The custom component works fine on design time and runtime by using BIDS.
When I'm using the same package that use my custom component with DTEXEC,
I got the following error :
System.Exception: AcquireConnections : Exception from HRESULT: 0x80131904
at SSISGenerator.SSISErrorHandler.ErrorHandlerDestination.AcquireConnections(
Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnectio
ns(IDTSManagedComponentWrapper90 wrapper, Object transaction)
The error message point out that the problem is in acquireconnections method.
This is the code i'm using in my custom component for the acquireconnections method.
public override void AcquireConnections(object transaction)
{
try
{
if (ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager != null)
{
ConnectionManager cm = Microsoft.SqlServer.Dts.Runtime.DtsConvert.ToConnectionManager(ComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager);
ConnectionManagerAdoNet cmado = cm.InnerObject as ConnectionManagerAdoNet;
if (cmado == null)
throw new Exception(String.Format(MSG_ACQUIRECONNECTIONS_ADONET,cm.Name));
this.sqlConnection = cmado.AcquireConnection(null) as SqlConnection;
if (this.sqlConnection == null)
throw new Exception(String.Format(MSG_ACQUIRECONNECTIONS_ADONET, cm.Name));
if (sqlConnection.State != ConnectionState.Open)
this.sqlConnection.Open();
}
}
catch (Exception e)
{
throw new Exception(MSG_ACQUIRECONNECTIONS + e.Message);
}
}
Does someone got an idea ?
Mathieu
View 3 Replies
View Related
May 17, 2007
Hello,
I am having problem while bulding my C# project in Visual Stodio
Error acures at this stroke of the code:
Engine = new SqlCeEngine(ConnectStr);
and the error is: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
any one had such problem before?
programm is running under Vista 64bit.
thnx
View 3 Replies
View Related
May 16, 2008
Hi All,
I have created SSIS package which will refresh cubes daily. Actually i am using IBM db2 provider since ETL table and SSAS 2005 are resides in IBM db2 database.
I have a scenerio where i will update lastprocessedtime in this ETL table once my cubes get processed. So i am using SQL Execute TASK for this operation. Here in SQL STATEMENT i am using update statements. when i click parse query, I am getting error like "SQL TASK : Exception HRESULT: 0xC0202009".
Can anyone tell me what might be the problem?
Thanks in advance,
Anand Rajagopal
View 2 Replies
View Related
Jul 23, 2007
I guess this may not strictly be a CLR integration question, because what I'm actually doing is using sp_OACreate in a T-SQL batch to call a COM object written in C#. Not as nice as using full CLR integration, but unfortunately the T-SQL must run without error on a SQL 2000 server before it is upgraded to 2005, and I preferred this option to using reams of dynamic SQL.
The first call to sp_OACreate fails with hRes 0x80131022. MSSQLServer also logs the following error to the app event log:
"Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80131022. You may fix the problem and try again later."
Please can anyone suggest why this is happening? I've tried repairing the .NET framework (v2) installation, and reinstalled SQL Server Express. I've double checked both CLR integration and OLE Automation are allowed in the Surface Area config tool for SQL Express. I've tried running SQL Express using both LocalSystem and the administrator account on the machine. I've even checked there is plenty of free memory (including virtual memory). Nothing has helped though.
Thanks in advance for any help or suggestions you can provide,
Rob
View 5 Replies
View Related
Mar 2, 2006
I have an OLE-DB Command transformation that inserts a row. If the insert SQL command fails for some reason, I use the "Redirect Row" option to send the row to another OLE-DB Command transformation that logs the error on that row to a "failed rows" table. In this table I log the ErrorCode and ErrorColumn values that come with the error path from the first OLE-DB Command.
OK, that's all working great. However, here's the kicker: there's no error description value. The ErrorCode value, naturally, is the decimal form of an HRESULT--for example, -1071607696. Without some further information, however, this code is not useful for troubleshooting.
Has anyone figured out a trick here? I'm not even certain that this is an SSIS HRESULT, since it could for all I know be from the OLE-DB layer, the database layer, or somewhere else.
Thanks,
Dan
View 7 Replies
View Related
Oct 21, 2005
I'm working on developing a C# application using an SSIS package. I'm using the code example from BOL: "Adding and Configuring a Component". When I run the sample I get the above error. This could be one of several things, including:
View 7 Replies
View Related
Apr 17, 2007
i get the following exception HResult -2146233088
[Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException] {"No description found"} Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException
when i try to use this following code snippet
try
{
ConnectionManager objOLEDBConnection;
Microsoft.SqlServer.Dts.Runtime.Package objPackage = new Microsoft.SqlServer.Dts.Runtime.Package();
objOLEDBConnection = objPackage.Connections.Add("OLEDB");
}
catch(Exception ex)
{
ex.Message ;
}
could you please help me out with this ?
View 2 Replies
View Related
Jun 8, 2006
Hi,
Hope someone can help... :)
I have installed SQL Server 2000 and SQL Reporting Services 2005... gone thru the setup process and i am unable to initialize via Reporting Services Configuration.
When i attempt to deploy a report or just browse //<server>/reports i get the following error...
Keyset does not exist (Exception from HRESULT: 0x80090016) (rsRPCError)
All advise welcomed
Cheers
View 6 Replies
View Related
Mar 30, 2007
Hello,
I wrote SQL Stored Procedures in C# and I am trying to register the asembly with SQL Server 2005 (Express Edition) using CREATE ASSEMBLY statment. I get this following error.
"Failed to open malformed assembly 'MyAssembly' with HRESULT 0x80040154"
Does anyone know how to solve this problem? It is driving me nuts for the last few days. I did enable CLR for SQL Server and also tried re-install SQL Server, but still I get this error.
Thanks in Advance,
Ravi
View 6 Replies
View Related
Oct 17, 2005
I am trying to access a SQL 2005 database on a seperate machine, using a COM+ proxy which is installed on my machine. I keep getting this error:
View 5 Replies
View Related
Jan 1, 2008
I'm new to ADO.NET and need help with this error.
Currently running Vista Home Premium 64 and Visual Studio 2008 Trial.
1. Create Win form app.
2. Add new data source...
3. New connection - SQL Server Compact 3.5 - Northwind.sdf
4. Highlight Products and Suppliers.
5. Drag both onto Win form
6. Run with debug
7. Error message "Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
some blogs advice change dir in SQL Server Compact 3.5 in regedit but regedit doesn't even have SQL Server Compact 3.5; only SQL ServerSQLExpress.
reinstall SQL Server Compact 3.5 and problem still exists.
anyone knows how to fix this problem?
View 35 Replies
View Related
