CREATE ASSEMBLY Failed Because It Could Not Open The Physical File (The Device Is Not Ready.).

Mar 23, 2007

I have a simple class libarray that I have compiled into DLL using csc.exe

Source code is as follows: -



using System;

using System.Collections.Generic;

using System.Text;

using System.IO;

using Microsoft.SqlServer.Server;



namespace RTFTextParser

{

public class ParseText

{

[SqlFunction(DataAccess = DataAccessKind.None)]

public static String ParseRTFText()

{

return "Imtiaz";

}

}

}

When I try to run the following

CREATE ASSEMBLY RTFTextParser FROM 'E:Class1.dll'

I get the following error

Msg 6501, Level 16, State 7, Line 1

CREATE ASSEMBLY failed because it could not open the physical file 'E:Class1.dll': 21(The device is not ready.).

View 10 Replies


ADVERTISEMENT

Cannot Attach Mdf: Create File Encountered Operating System Error 5 While Attempting To Open The Physical File...

Sep 5, 2006

I have used the copy database wizard, but I realized I had forgotten to shrink the transaction log file. So I canceled the wizard. My database, detached by the wizard, has now disappeared. The mdf file is still there, but when I try to attach it manually I get the "create file encountered operating system error 5 while attempting to open the physical file..." error.

Any way I can recover it?

Thanks.

View 4 Replies View Related

DB Engine :: BACKUP LOG Command Failed - Device Is Not Ready

Oct 6, 2015

When I execute the following transaction log backup TSQL in SSMS

BACKUP LOG ProductDB 
TO DISK = 'D:Database_BackupTransProductDB.trn';

I get this error:

Msg 3201, Level 16, State 1, Line 2
Cannot open backup device 'D:Database_BackupTransProductDB.trn'. Operating system error 21(The device is not ready.).
Msg 3013, Level 16, State 1, Line 2
BACKUP LOG is terminating abnormally.

I also have a daily database backup job that puts the backup file under this directory.

D:Database_BackupData

So I changed the path to this and it still fails.

BACKUP LOG ProductDB 
TO DISK = 'D:Database_BackupDataProductDB.trn';

However if I change it to this path, it works:

BACKUP LOG ProductDB 
TO DISK = 'MyServerDataProductDB.trn';

This turns out to be the path I used a few weeks back when I backed up the log for the very first time.  But I now wanted to store my transaction log backups in D:Database_BackupTrans.  

View 10 Replies View Related

Device Activation Error . The Physical File Name

Nov 8, 2006

rajesh writes "Hi All

When i attach my production database i got an device activation Error
cannot
attach database."

View 2 Replies View Related

Failed To Open Malformed Assembly 'mscorlib'

Aug 29, 2006

Hi,

I was using one of features provided in Microsoft samples regarding StringUtilities.dll. It was running fine for couple of month. Suddenly I am getting the following error message when try to execute this command

Select * from dbo.Split('123,25')

Msg 6507, Level 16, State 2, Procedure Split, Line 1

Failed to open malformed assembly 'mscorlib' with HRESULT 0x80070008.

Please Guide

Thanks

View 1 Replies View Related

Unable To Open The Physical File.....

Apr 7, 2006

Hi, i'm trying to interface a c# application with an sql database created with Visual Web Developer Express.
I have published the site (and the db) on iis 5 (xp pro).
Everithing goes fine on accessing the database from internet,but when i try to connect the db while it's opened with my c# program  i keep an error in the sqlconnection open command:
Unable to open the physical file "C:myApp_Datamydb.mdf". Operating system error 32: "32(The file is in use by another process.)".
My connection string from webconfig:
<add name="MYDBCS" connectionString="Data Source=.SQLEXPRESS;Database=&quot;C:myApp_Datamydb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
.....and  the connection string for the c# program:
"Data Source=.\SQLEXPRESS;Database=c:myapp_datamydb.mdf;Integrated Security=False;Connect Timeout=30;User ID=abc;Password=abc;Trusted_Connection=False;";
I have used a user to connect the database because there was a conflict trying to open the db with Integrated Security=True.
 
Does anyone have an idea where is the error?
Many  thanks
Max

View 1 Replies View Related

Unable To Open Physical File ...

Apr 24, 2008

Using SQL Server 2005 Express SP2.

Scenario : I have VC++ 2005 Express IDE open and use the database explorer to browse tables in a database. Then I open SQL Server Managament Studio Express and try to browse the same database. I get "Unable to open the physical file ... The process cannot access the file because it is being used by another process".

What is this "other process" that is trying to open the file? I thought the whole point of a database server was that clients talk to the server, and the server accesses the physical file. So only one process should be accessing the file. Do VC++ IDE and SSMSE work directly with the physical file, or do they channel their requests, etc. through the server.


Or is it something completly different?

Thanks,
Russel Dirks

View 4 Replies View Related

Unable To Open The Physical Mdf File Or Log File Because It Is Being Used By Another Process

Dec 4, 2007


Unable to open the physical mdf file or log file because it is being used by another process

I am trying to write a Windows Application using ASP.NET 2.0, C#2005 EXPRESS, and SQL 2005 EXPRESS.

I had followed the introductory video to create a connection to the Database using Windows Authentication, and use the wizard to create a dataset and checking all the tables in the database.

After that I dragged a table from the data source created from the above process. The Details Grid so created is able to perform update, delete and addition of records.

But when I went back to the database at my PC I wasn€™t able to connect to the database. And if I opened the database first and then load the windows application and perform some database operations and went back to the physical database I wasn€™t able to open the tables in the database.

The error message is that the physical database connection cannot open the .mdf file or log file because another process is using the database. I guess it refers to the Windows Application.

Is this normal? Will it have any implications after the application is deployed? I suppose that there isn€™t a scenario where a Windows application and a physical process will access the database at the same time.

Will appreciate some feedback and advice on this scenario and whether it is a problem.

Thanks and regards

OldStd

View 7 Replies View Related

Failed To Open Malformed Assembly 'MyAssembly' With HRESULT 0x80040154

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

Help - Error: Unable To Open The Physical File

May 17, 2007

Hi, I've just finished creating my first ASP.NET website. I created it on my laptop and it works perfectly, but I'm having some problems deploying it to my web server (PC).The site works ok, but when I try to log in to my client area, I get this error:
"Unable to open the physical file "c:inetpubwwwrootONeillStrataApp_Dataaspnetdb.mdf". Operating system error 5: "5(Access is denied.)".An attempt to attach an auto-named database for file c:inetpubwwwrootONeillStrataApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I've searched far and wide for a solution and have read many articles, but none seem to be able to fix my problem. I've tried using that SEUtil tool, but that didn't work, I've made sure the App_Data directory on the web server isn't read only (the read-only checkbox isn't ticked, but it DOES have that little green square which I can't get rid of), I've assigned the ASPNET user as a db owner and that didn't work and I've manually attached the database to the web server's instance of SQL Express 2005.When I launch the solution in VS2005 on the web server, I can browse through the database and see the tables and data etc, but when I try to run the application, I get that message above...
Surely it shouldn't be this hard to get it going?Any help would be massively appreciated.

View 2 Replies View Related

Unable To Open The Physical File. Operating Error

May 9, 2006

Hi.. !!

I am working in a C# database application quick test where I basically use two types of access to an SQL Server Express database.
In the first part of the code, I use the traditional connection declaring a SqlConnection. When I just use only this kind of connection I do not have any problem. The issue starts when I access to the same database using Data Bindigs at the same time. When I start the application I got and error as soon as the instruction goes to open the data base connection.
The reported error is "Unable to open the physical file "<Niños.mdf>". Operating System Error 32: (Process does not have access to the file because is being using by another process)"

For additional information my connection string is:

"Data Source = localhost\SQLExpress; Initial Catalog = Niños; Integrated Security = True; User Instance = false"

Does anyone have any idea on how to solve this problem?

Thanks
Alfredo.

View 1 Replies View Related

SQL 2012 :: Unable To Open Physical File - Operating System Error 5

Nov 6, 2015

I am trying to attach a database. But I am receiving below error:

Unable to open the physical file "D:databasepc.mdf". Operating system error 5: "5(Access is denied.)".

I have added service accounts to administrator group.

I have provided full control to service account on the D drive and on the .mdf file also.

My self has full permissions on the drive and .mdf file, and I am in administrator group.

Restarted the SQL Server services.Still same error.

View 9 Replies View Related

DB Engine :: Unable To Open Physical File - Operating System Error 5

Apr 16, 2008

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.
 
I get the following message: Unable to open physical file "C:ArrowSQLArr@DataArrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".
 
I have loaded SQL and the database fiel and directory with the same user account which is a local administrator on this machine. I have checked that I have read/write access to the file.
 
The machine runs Windows Vista Business. SQL has SP 2 loaded. What causes this?

View 56 Replies View Related

Unable To Open The Physical File Test.mdf. Operating System Error 5 :on Windows Vista.

Aug 25, 2007

Hello,

We are trying to attach a database in Sql Server 2005 Express on Windows Vista.It will Show the following Error.

"Unable to open the physical file "Test.mdf". Operating system error 5 :". And then we installed the SQL Server 2005 Service pack 2. This error again comes.Could you please give me the steps to resolve the problem.

Thanks,

Mahesh



View 2 Replies View Related

Setup And Upgrade :: System Cannot Open Device Or File Specified

May 22, 2013

When I install SQL 2012 on  MS Server 2008 R2, I get this error..The following error has occurred: The system cannot open the device or file specified. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

The file in question is Install_VSShell_CPu32_Action. when I retry, the error is..The following error has occurred:SQL Server Setup has encountered an error when running a Windows Installer file.Windows Installer error message: This update package could not be opened. Verify that the update package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer update package. Windows Installer file:

Windows Installer log file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20130522_143111VSShell_Cpu32_1.logClick 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

View 7 Replies View Related

CREATE ASSEMBLY Failed Because Method 'UpdateVersion'

Jan 16, 2006

I'm working on a CLR Stored Procedure and have code that builds using

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

When i try to create the assembly i get this:

CREATE ASSEMBLY failed because method 'UpdateVersion' on type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageVersionUpdate90' in safe assembly 'Microsoft.SqlServer.DTSRuntimeWrap' has invalid attribute 0x1003.

View 25 Replies View Related

CREATE ASSEMBLY Failed Because Method 'get_Count'...

Jan 23, 2006



Hi All,

I am trying to create and assembly which saves the results of a XML query.

The dll, when called from a exe, works and saves the results to file as expected.

However, when trying to create the assembly I get the error:

"

Msg 6215, Level 16, State 1, Line 2

CREATE ASSEMBLY failed because method 'get_Count' on type 'ADODB._Collection' in external_access assembly 'Interop.ADODB' has invalid attribute 0x1003."



Any ideas?



Cheers,

Crispin

View 9 Replies View Related

CREATE ASSEMBLY Failed: Not Authorized For PERMISSION_SET = EXTERNAL_ACCESS

Apr 19, 2006

CREATE ASSEMBLY ClrSql from 'C:ClrSql.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS

gives me this . . .

Msg 10327, Level 14, State 1, Line 1

CREATE ASSEMBLY for assembly 'ClrSql' failed because assembly 'ClrSql' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission.

How do I allow EXTERNAL_ACCESS and UNSAFE permissions? The property appears grayed out, and I am the dbo.

View 8 Replies View Related

The Device Is Not Ready Error When Executing Package On The Server

Nov 15, 2006

Hi,

I have a package which reads an XML file from a certain folder and parses it.

I deployed my package onto the server. Copied XML files on the D: drive the following folder on the server.

Dim reader As New Xml.XmlTextReader("D:AppsRequestClientsClientsStatus.xml") is fine.

But

Do While (reader.Read())

generates "The Device is not ready"

I think it is still trying to read it from my desktop on which I don't have a D drive.

Any help is appreciated.

 

 

 

View 13 Replies View Related

Transaction Log Physical Device

Mar 18, 2008

Are there any problems or issues with backing up a transaction log to a physical file with the ".bak" extension? We are having some trouble with are hourly trans log backups and I was wondering if this could be part of the problem. Tom.

View 4 Replies View Related

Failed To Load Expression Host Assembly. Details: StrongName Cannot Have An Empty String For The Assembly Name.

Jan 12, 2006

I previously had an ASP.NET 1.1 site running on my IIS 6.0 server (not the default website) with Reporting Services running in a subdirectory of that website.  I recently upgraded to ASP.NET 2.0 for my website and was greeted with an error when trying to view a report.  The error was very non-descript, but when I checked the server logs, it recorded the details as "It is not possible to run two different versions of ASP.NET in the same IIS process.  Please use the IIS Administration Tool to reconfigure your server to run the application in a separate process."

 

First of all, I could not figure out where and how to do this.  Secondly, I decided to try to also change the Reporting Services folders to run ASP.NET 2.0 and when I did, I was greeted with the following message when attempting to view a report:

 

"Failed to load expression host assembly. Details: StrongName cannot have an empty string for the assembly name."

Please help.

View 7 Replies View Related

Physical Path For Backup Device From Enterprise Manager

Jan 20, 2000

View 1 Replies View Related

How To Open SDF File Stored On Windows Mobile Device From A Windows Desktop App?

Apr 14, 2008

Long story short -

Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.

Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)

What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?

Thanks for reading.

View 3 Replies View Related

Error: Fcb::close-flush: Operating System Error 21(The Device Is Not Ready.) Encountered

May 23, 2007

We are using sql server 2005 Enterprise Edition with service pack1



I got the following error messages in the SQL log



The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

I got these errors for about 2 hrs and after that I see these messages in the sql log



Starting up database ' '
1 transactions rolled forward in database '' (). This is an informational message only. No user action is required.
0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required.
Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required.
CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required.



Can anyone please help me in troubleshooting this issue. Why this migh have happened.



any help would be appreciated.



Thanks



View 5 Replies View Related

Error Registering Assembly Using CREATE ASSEMBLY

May 1, 2008

We have written a test CRL stored procedure to test replacing one of our complex stored procedures but can€™t get it deployed to our SQL server that hosts a mirrored configuration of our production database (very locked down). It works fine on our development instances (not very locked down). It only references the default assemblies that were added when we created the project. All it does is use Context Connection=true to get data, loops though some records and returns the data using SQLContext. CLR is enabled on SQL server, the assembly is strongly signed, and we tried deploy using the binary string with the SAFE setting.


CREATE ASSEMBLY for assembly 'SQLCLRTest2' failed because assembly 'SQLCLRTest2' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
[ : SQLCLRTest2.StoredProcedures::GetLift][mdToken=0x600001e] Type load failed.
[token 0x02000008] Type load failed.

View 8 Replies View Related

Access Denied | Connection Open | Create File()

Aug 18, 2001

When i try to connect my sql client to my sql server on the internet i get a error message :" Access denied | connection open | create file()"

plz help

shailesh

View 2 Replies View Related

Error: CREATE ASSEMBLY For Assembly

May 31, 2007

I am trying to deploy a Database Project with Visual Studio 2005 and SQL Server 2005 Standard.
I import €œSystem.IO€? and have therefore set the permission levels to EXTERNAL_ACCESS.

I am receiving the same error message that many folks have received.

CREATE ASSEMBLY for assembly 'Images' failed because assembly 'Images' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.
The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or attached this database, make sure the database owner is mapped to the correct login on this server. If not, use sp_changedbowner to fix the problem. Images.

My CLR access is €œon€?

I have tried

1) From master run: GRANT EXTERNAL ACCESS ASSEMBLY to [BuiltinAdministrators].
2) From master run: GRANT EXTERNAL ACCESS ASSEMBLY to €œMy Windows Authentication ID€?.
3) Run ALTER DATABASE MYDATABASE SET TRUSTWORTHY ON
4) In Visual Studio .NET 2005 Set the permission levels to €˜external€™
5) Tried BuiltinAdministrators and my SQL Server Windows Authenticated Login ID for the ASSEMBLY OWNER.

I can compile BUT NOT DEPLOY

Any help would be greatly appreciated.
Regards Steve

View 8 Replies View Related

CREATE ASSEMBLY Using Assembly Binary?!?!

Mar 8, 2006

I was trying to understand how VS.NET2005 was deploying .NET CLR assemblies to SQL2005 so I ran a trace and found some interesting results.

VS.NET creates some SQL that looks pretty interesting:

CREATE ASSEMBLY [AssemblyNameHere]
FROM 0x4D5A90000300000004000000FFFF000......<continue binary data>
WITH PERMISSION_SET = EXTERNAL_ACCESS

Boy howdy!

I have tried to reproduce this and create my own deployment application but I cant figure out how they create this binary stream. The info in BOL is not much help and I have not found any samples anywhere on how to create this stream in c#.

Anyone out there been able to get this to work?

-Ben

View 4 Replies View Related

Cannot Open Backup Device

Dec 17, 2007

DEAR ALL, I RUN THIS CODE FROM SQL QUERY ANALYSER FOR SQL EXPRESS

USE CPHONE

GO

BACKUP DATABASE CPHONE

TO DISK = 'C:CPHONE.Bak'

WITH FORMAT,

NAME = 'Full Backup of CPHONE'

GO

-- Optionally, create a logical backup device,

-- AdventureWorks_Backup, for this backup file:

USE master

EXEC sp_addumpdevice 'disk', 'CPHONE_Backup',

'C:CPHONE.Bak'



I RUN EITHER LOCALLY OR FROM ANALYSER OF OTHER PC

AND THEN I TOOK THIS ERROR


Msg 3201, Level 16, State 1, Line 1

Cannot open backup device 'C:CPHONE.Bak'. Operating system error 5(error not found).

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.


ANY IDEAS PLS ??

View 3 Replies View Related

Error Msg 6522, Level 16, State 1 Receives When Call The Assembly From Store Procedure To Create A Text File And To Write Text

Jun 21, 2006

Hi,
I want to create a text file and write to text it by calling its assembly from Stored Procedure. Full Detail is given below

I write a code in class to create a text file and write text in it.
1) I creat a class in Visual Basic.Net 2005, whose code is given below:
Imports System
Imports System.IO
Imports Microsoft.VisualBasic
Imports System.Diagnostics
Public Class WLog
Public Shared Sub LogToTextFile(ByVal LogName As String, ByVal newMessage As String)
Dim w As StreamWriter = File.AppendText(LogName)
LogIt(newMessage, w)
w.Close()
End Sub
Public Shared Sub LogIt(ByVal logMessage As String, ByVal wr As StreamWriter)
wr.Write(ControlChars.CrLf & "Log Entry:")
wr.WriteLine("(0) {1}", DateTime.Now.ToLongTimeString(), DateTime.Now.ToLongDateString())
wr.WriteLine(" :")
wr.WriteLine(" :{0}", logMessage)
wr.WriteLine("---------------------------")
wr.Flush()
End Sub
Public Shared Sub LotToEventLog(ByVal errorMessage As String)
Dim log As System.Diagnostics.EventLog = New System.Diagnostics.EventLog
log.Source = "My Application"
log.WriteEntry(errorMessage)
End Sub
End Class

2) Make & register its assembly, in SQL Server 2005.
3)Create Stored Procedure as given below:

CREATE PROCEDURE dbo.SP_LogTextFile
(
@LogName nvarchar(255), @NewMessage nvarchar(255)
)
AS EXTERNAL NAME
[asmLog].[WriteLog.WLog].[LogToTextFile]

4) When i execute this stored procedure as
Execute SP_LogTextFile 'C:Test.txt','Message1'

5) Then i got the following error
Msg 6522, Level 16, State 1, Procedure SP_LogTextFile, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'SP_LogTextFile':
System.UnauthorizedAccessException: Access to the path 'C:Test.txt' is denied.
System.UnauthorizedAccessException:
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, ileOptions options)
at System.IO.StreamWriter.CreateFile(String path, Boolean append)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)
at System.IO.StreamWriter..ctor(String path, Boolean append)
at System.IO.File.AppendText(String path)
at WriteLog.WLog.LogToTextFile(String LogName, String newMessage)

View 13 Replies View Related

Cannot Open User Default Database. Login Failed. (only When IDE Is Open)

Sep 7, 2007

I get the below error only when my IDE open. It connects well when it is found closed.
[SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'JPASPNET'.]
I could solve this by giving the logged in windows user to impersonate under IIS window > WEBSITE > ASP.NET tab > EDIT CONFIG > APPLICATION tab
But I wish someone could give me the proper solution.
I almost tried all from giving ASPNET user as a administrator to configuring the same in Express management tool.
Environment: XP pro, VWD and SQL Express

View 3 Replies View Related

SQL 2012 :: Cannot Open Backup Device

Sep 2, 2014

When performing a backup I'm reciving the error message: "System.Data.SqlClient.SqlError: Cannot open backup device. Operating system error 5(error not found). (Microsoft.SqlServre.Smo)

This is backing up to a network location and I'm able to backup other database on the same server/instance without error so it shouldnt be a permissions issue?why I can backup some databases to this location and not others?

View 1 Replies View Related

Open Database In A Connected Device

Jan 19, 2007

Hi Everybody:

I'm writting an standar application in c# that comunnicates with a sql server 2005 in a mobile device. The mobile device is connected to the pc with an usb wire. In the sample I've made, I've inserted in the form main a datagridview. I go on the wizard to select the data source. I choose a Microsoft SQL Server Mobile Edition data connection. The data source is tge activesync mobile device. I create a new database in the mobile device called test.sdf. The wizard has a button to check the conecttion and it rules. A new connection appears in the server explorer. I add rows through a query. I build the solution and no problem, but when I start the debug session an sqlceexception occurs: Data Source not found. In the database connection that the project has created the connection string is: Data Source ="Mobile Device est.sdf";

I didn't write any code. I just went on the wizards. All the code has been inserted by visual studio 2005.

Any idea?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved