Deployment Error

Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%CSIDL_PROGRAM_FILES%\PDA\PDADB.sdf'. Error 0x80070020: The process cannot access the file because it is being used by another process.
Device Connectivity Component

Hi I get this error when I try and deploy the emulator but it only happens when I run the database on the emulator it works fine before I do this. I run the database just to see if the database gets populated. Does anyone know how to solve this problem.Make sure to stop your application (or QA tool which would be opened if you "run" the database) before redeploying the database.|||How do I do that? Do I just shut down the emulator?|||If you are using the Query Analyzer on the emulator, select the Tools menu, and select Exit. If you are using your app to view the data, shut down the app by providing exit functionality. Or go to Start, Settings, System tab, Memory, Running Programs tab, and Stop any program accessing the database from there.sql

Deployment Error

Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%CSIDL_PROGRAM_FILES%\PDA\PDADB.sdf'. Error 0x80070020: The process cannot access the file because it is being used by another process.
Device Connectivity Component

Hi I get this error when I try and deploy the emulator but it only happens when I run the database on the emulator it works fine before I do this. I run the database just to see if the database gets populated. Does anyone know how to solve this problem.

Make sure to stop your application (or QA tool which would be opened if you "run" the database) before redeploying the database.|||How do I do that? Do I just shut down the emulator?
|||If you are using the Query Analyzer on the emulator, select the Tools menu, and select Exit. If you are using your app to view the data, shut down the app by providing exit functionality. Or go to Start, Settings, System tab, Memory, Running Programs tab, and Stop any program accessing the database from there.

Deploying SMO

Hello,

I am writing a commercial client application for SQL server 2000/2005 and probably I am going to use SMO dll's.

I would like to know if there is any restriction in order to deploy SMO objects with my software. Are they free? and moreover is possible to deploy only those dll's that i actually need, without installing the whole redist package.

thank you in advance!

Zoran Maksimovic

See http://blogs.msdn.com/mwories/articles/smofaq.aspx which contains a link to the SMO redist. This page also contains limitations (but you should be generally be free to redistribute it with your application).

Deploying SMO

Hello,

I am writing a commercial client application for SQL server 2000/2005 and probably I am going to use SMO dll's.

I would like to know if there is any restriction in order to deploy SMO objects with my software. Are they free? and moreover is possible to deploy only those dll's that i actually need, without installing the whole redist package.

thank you in advance!

Zoran Maksimovic

See http://blogs.msdn.com/mwories/articles/smofaq.aspx which contains a link to the SMO redist. This page also contains limitations (but you should be generally be free to redistribute it with your application).

Deploying MSDE

I am writing an application in VB.Net that includes a database. I could use
either an Access database (MS Jet) or MSDE. I would rather use MSDE because
it has useful features like triggers and complex stored procedures, but I am
worried about deployment.
My users have all kinds of machines, running anything from Windows 98 to
Windows Server 2003. Some may already have MSDE or SQL Server 2000 installed,
most will not. I will use Installshield Express 4 to make the deployment
package. Some users will download the package from my web site, some will
receive CDs.
I am worried that the complexities of deploying to such a wide range of
target machines may be too great and that I should revert to using a Jet
database.
Does anybody have relevant experience? Are there any useful books or
articles that I could read?
Many thanks
Peter
I have been thru a similar situation where I had a VB.NET Apps with MSDE and
Installshield for deployment on all win OS. I dont have any books or articles
for the same but I could do that. Installing MSDE on a m/c where it already
has a MSDE or SQL svr is not an issue as u should install MSDE with a new
unique instancename always.
siaj
"PeterH" wrote:

> I am writing an application in VB.Net that includes a database. I could use
> either an Access database (MS Jet) or MSDE. I would rather use MSDE because
> it has useful features like triggers and complex stored procedures, but I am
> worried about deployment.
> My users have all kinds of machines, running anything from Windows 98 to
> Windows Server 2003. Some may already have MSDE or SQL Server 2000 installed,
> most will not. I will use Installshield Express 4 to make the deployment
> package. Some users will download the package from my web site, some will
> receive CDs.
> I am worried that the complexities of deploying to such a wide range of
> target machines may be too great and that I should revert to using a Jet
> database.
> Does anybody have relevant experience? Are there any useful books or
> articles that I could read?
> Many thanks
> --
> Peter