SQL Server Vs Windows Application Project Maintenance?

Oct 6, 2006

I'm a database newbie, trying to decide whether to create an SQL Server or Windows Application project that uses SQL Server 2005 Express. As I understand it, the advantage of an SQL Server project is that the app deploys somehow as part of the database. If that's the case, how would I handle the scenario where the database has been updating at customer site and I need to install just a new release of the software? Would I be better of creating a Windows Application project and connecting to the database explicitly? Thank you.

View 5 Replies


ADVERTISEMENT

Problem In Opening The Project..Make Sure The Application For The Project Type (.dtproj) Is Installed.

Jun 24, 2007

Hi,

I have been working on some SSIS packages for a while now and today while i was working i was trying to create a new connection and in the process there was an error and it said the BIDS has to be closed and i closed it but later when i open BIDS and try to open my project(.sln) from the file menu to work on the half done package it pops up an error which shows the path to my project location on the first line and next statement on the pop up error box says:



"Make Sure the application for the project type (.dtproj) is installed."



I tried to check some forums in which some suggested to try installing SP1 which i tried but ..i dont know why but the SP1 fails to install (i dont know if its causing problem becoz i already installed SP2 as i had some other problem before for which the cure was to install SP2).



Did anyone here face such a problem before ?

I'd really appreciate if the experts here can tell a cure for this problem.



thanks,

Ravi

View 4 Replies View Related

Windows SharePoint 3.0 And Project Server 2007- Error On Rebuild Of Site

Nov 13, 2007

My site crashed, so I had to rebuild the Project Site.

I used the SharePoint products and technologies configuration wizard to disconnect from the server farm (only actually running on the single server).

I then reran SharePoint products and technologies configuration wizard to setup the site.

Configured the Project Service and attached to the existing dB's.

Previously, I used the url http://servername.domain.forest/PWA/default.aspx .

Now when I attempt the use the same URL, I get the following error:

"An unexpected error has occurred"

I have tested this one 3 servers now and I receive the exact same result. Is there a path I should apply to the servers in order to allow fully qualified server names after a reinstall of the system?

View 1 Replies View Related

Package Execution Fails In Windows Service But Runs Fine As A Windows Application.

Jun 23, 2006

I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.

The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.

Again, the app will run all packages just fine. The data is imported and the results return as "Success."

The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)

Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult

pkgLocation = sPackageFolder & PackageName & ".dtsx"

pkg = app.LoadPackage(pkgLocation, Nothing)

Dim vars As Variables = pkg.Variables

vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath

pkgResults = pkg.Execute()

View 3 Replies View Related

SQL Server 2005 - Windows Application And Website

May 25, 2007

Hi there,
I have a question which I put the company that host my website but I didnt get a conclusive answer. Maybe someone here will be able to advise or help me with my situation.
I want to build a database that I will run on my local server and the front end of this will be run using a windows application. I have a website which I run the database on the remote server. What I would like to do is to be able to synchronize certain tables between the two databases (such as updating products table, or orders table). I am using sql server 2005 and I am using the sql server management studio to access my database on the remote server. I did notice there is a synchronzie button. I also came across some 3rd party tools. Not sure if that is the way to go.
If anyone as done this before or can give me any suggestions, I would be delighted.
Thanks
 Anthony

View 2 Replies View Related

How To Deploy SQL Server Everywhere With My Windows Form Application?

Jul 25, 2006

Hello!

I've been creating a vb.net 2005 windows form application using Everywhere and it has been going pretty well. However, I haven't had much luck finding any help on how to deploy my Everywhere database file(s) and Everywhere itself. To install redistribute Everywhere, can I just add the the 8 .dlls found in the Everywhere directory into my VS setup project? Also, what database file(s) do I need to deploy in my windows setup?

Thanks!

View 4 Replies View Related

Windows Application With Connection To Database On A Server

Apr 21, 2008



Hi all,

I think I can do this, just want to check

Can I have an sql server database (mdf file) on a server and allow windows applications at different site manipulate the database.

As far as I am concerned the only thing that needs to be configued is the connection string..is this correct.

[i would rather use windows applications rather than asp pages]

If I can, the best way to manipulate the database is to use stored procedures. How would I do the following to create and execute the following proposed procedure:

Insert data into a table
Update another table as a result

Execute the store procedure on a form to execute these two statements

Thanks in advance

Peter

View 5 Replies View Related

SQL Server Events Logged In As Windows Application Event

Jul 10, 2003

Hello Everyone,

I am backing up my all the databases (around 50 servers and 500 database) using scheduled jobs. I backup my transaction log files at every two hours of interval and databases on daily basis.

I have set option of "Write to Windows Application Event Log" - When job fails during the creation of job in the "Notification Tab" of Create New Job.

As per documentation SQL server automatically records some of the events to windows application event log. After succesful completion of Log backup and DB backup, event gets logged in Windows Application Event Log. And when job fails, I get two events logged in the Windows Application Event Log file, one due to my setting and other automatically by SQL Server.

Due to this Windows event log file is growing much faster and I have to clear it in every 3-4 days.

My quesiton - Is there a way such that to get only failures event logged in Windows Application event log file and any successful backup jobs should not go to Windows application event file?

Can any suggest some idea what should I do?

I am using SQL Server 2000 with SP3 on Windows 2000 Advanced server. Some of my databases are still using Version 7.0/6.5 on NT.

Thanks.

View 5 Replies View Related

Viweing Sql Server 2005 Reports In Windows Application

Oct 16, 2007



Hi,

I want to show sql server reports in windows application.

i code like this,

ReportViewer1.ProcessingMode= ProcessingMode.Remote

Dim userCredentials as New System.Net.NetworkCredential (€œdomain username€?,€? domain user password€?,€? Domain name€?)

ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials= userCredentials

ReportViewer1.ServerReport.ReportPath=€?folder name
eport name€?

ReportViewer1.ServerReport.ReportServerUrl = New Uri (http://servername/reportserver)

ReportViewer1.RefreshReport()


If i don't use network credentials it gives me unauthorized error.

But exactly which credentials should we give for network credentials?
We can not get domain user password at run time right?

Or is any other way without using network credentials?

Regards,
Harshada

View 6 Replies View Related

MSDE Install On Windows 2003 SP1 Application Server

May 23, 2006

I am trying to install MSDE 2.8 on this OS. When I try to install, I receive the following error: Fatal error setup This setup does not support installing on this operating system



Any ideas?

View 4 Replies View Related

Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)

Apr 3, 2008

Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
 

View 4 Replies View Related

MSDTC - Remote Accessing SQL Server 2005 From A Desktop Application - Windows 2003 Server

Dec 6, 2007

Hi,

I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.

But my SQL Server allows remote connection, and I am able to do a select statement.
But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?

View 1 Replies View Related

Connection Failure To SQL Server 2000 In Remote Machine From Application In Windows Server 2003

Dec 25, 2007

Hi!!

I'moving my asp application to a new hosting server.

So when i tried the setup locally with the live DB & application in my test machine...
The DB access is denied when application tries to hit the DB.


DB is in seperate machine with SQL Server 2000 & application(ASP) is in Windows server 2003.....
Kindly help me with your suggestions....on what went wrong?

View 1 Replies View Related

Can't Connect To SQL2000 On Windows 2003 Server Through UDL Of VB6 Component Of ASP Application

Feb 1, 2008

I have problem connecting to a SQL 2000 server that is hosted on a Windows 2003 server. My application uses classic ASP with VB6 components. VB6 components connect to SQL server and return data to ASP application. Everything was working fine when the application and SQL server was hosted on NT machine. Recently we have shifted to Windows 2003 server. Since then we could not establish connection to SQL2000.


I'm using UDL as connection string.
IIS and SQL2000 hosted on the same machine with Windows 2003 OS.
This seems to be a security issue. Earlier I faced this issue for a .net application which I resloved adding a domain account to both SQL server and IIS directory security.
Request your input to solve this problem.



Sunandajit Ray
Infrasoft Technologies Limited

View 1 Replies View Related

Installing Onto Windows 2003 Server For Multi-user Application

Apr 22, 2006

Good Day,

I have an application that is being developed on Visual Studio 2005 (VB) and SQL Express. The application is set up to use the SQL Express on the development computer, and if an Internet or CD install is built, it installs SQL Express as expected. The question is, when it is time to deploy and put the SQL Express database on the 2003 server, how should the install on the server be done and how should we set the database path to the server?

Thanks,

Dave

View 1 Replies View Related

How Can I Access Data To SQL Server 2005 Using Windows Application,ADO.net And .Net Remoting.

May 3, 2007

How can I access data to SQL server 2005 using Windows form application,ADO.net and .Net remoting?

Can anybody help me? please...

View 5 Replies View Related

The Application For The Project 'c:C....dtproj' Is Not Installed

May 11, 2007

Hello!

I am trying to open a SSIS solution and get the error:

"The application for the project 'c:C....dtproj' is not installed

Make sure application for the project type(.dtproj) is installed."



I have been running this application for nearly a month and suddenly it dose not work. It still works for my college that execute through a different user.



I have checked what is associated with the file type .dtproj and it seems to be correct.



What has happen? Thankful for any suggestions.



Best regards,

Tina

View 7 Replies View Related

Error Provider Cannot Be Found. It May Not Be Properly Installed. After Deploying Application On Windows 2003 Server

May 23, 2007

hello folks

i have recently started to work with the analysis services and i am having some problems.

i have made a web application that for now just tries to connect to an analysis server.

The server is installed on an xp sp 2 system.

for testing, i used my local computer, which is running also win xp sp2. After deploying, the application can connect to the AS server on the other machine. the problem occurs when i try to deploy the applicatuion on the production server, which is running win 2k3 server on 32 bit. When deploying, i use the same connection string, so it should try to connect to the AS server installed on a win xp sp2 system.

The first thing that came to my mind was to check the MDAC versions, be cause of the message: "Provider cannot be found. It may not be properly installed."

on my computer, where the application worked ok, the version is MDAC 2.8 SP 1 Windows XP SP 2

on the win2k3 server, the MDAC version is : MDAC 2.8 SP2.... i thought it was the version of the service pack, so o searched for the update of MDAC 2.8 SP1, trying to install mdac 2.8 sp2 to see if i was to see the same error, but i found that mdac 2.8 sp2 is only for win2k3 server, and for win xp is mdac 2.8 sp1, according to this link: http://support.microsoft.com/default.aspx/kb/884103

Now i got confused and have no clues how to make this work...

Can anybody give any hint?

View 2 Replies View Related

Automatically Open A Default Project On Application Launch

Oct 31, 2006

I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches.

Perhaps there's a certain registry key I could edit?

View 1 Replies View Related

Message Make Sure The Application For The Project Type (.rptproj) Is Installed.

Oct 3, 2007

Hi,
We are running :
- Visual Studio 2005 Team Edition for Software Developers
- SQL Server 2005 Express (SQLEXPR32.EXE)
Installed :
- SQL Server with Advanced Services (SQLEXPR_ADV.EXE) incl. Reporting Services
- SQL Server Toolkit (SQLEXPR_TOOLKIT.EXE)

We have a VS Solution with a Reporting Project

When opening Visual Studio, the following message appears :

"Make sure the application for the project type (.rptproj) is installed."

I have no idea why this message appears.

Is this a known problem/bug ? Anybody any idea how I can solve this ?

Many thanks in advance.

Vincent

View 2 Replies View Related

Message : Make Sure The Application For The Project Type (.rptproj) Is Installed.

Oct 3, 2007


Hi,
We are running :
- Visual Studio 2005 Team Edition for Software Developers
- SQL Server 2005 Express (SQLEXPR32.EXE)
Installed :
- SQL Server with Advanced Services (SQLEXPR_ADV.EXE) incl. Reporting Services
- SQL Server Toolkit (SQLEXPR_TOOLKIT.EXE)

We have a VS Solution with a Reporting Project

When opening Visual Studio, the following message appears :

"Make sure the application for the project type (.rptproj) is installed."

I have no idea why this message appears.

Is this a known problem/bug ? Anybody any idea how I can solve this ?

Many thanks in advance.

View 1 Replies View Related

PSI: How To Update Custom Field Value For A Perticular Project Using PSI(Project Server 2007)

May 6, 2007

Hi,



I want to update value of a custom field for a perticular project in Project Server 2007 using PSI.



I have created 5 enterprise custom fields(A,B,C,D,E) through PWA/Server Settings.



I want to search all Projects on Server. If any project is having value for custom field A then I want to update rest of the custom fields(B,C,D,E) for that perticular project.



I dont know how to do it please help.





Thanks in Advance



Madhukar

View 5 Replies View Related

Unable To Use Project Professional To Establish Connection To Project Server

Jul 23, 2007

I fail to use project professional 2003 to access to the project server 2003 using MSDE 2000 in local area network, following message was shown,



Connection failed:


SQLState: '01000' SQL Server Error 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.



I have seen these pages with similiar cases but can't help.

http://support.microsoft.com/kb/818047/

http://support.microsoft.com/kb/837653/en-us



Can anyone help me?? Thanks a lot!

View 1 Replies View Related

Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application

Mar 23, 2006

Hello,

I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.

The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.

The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".

Did I miss something to install ?
Do you know how I can resolve the problem ?

By advance, thank you for any answer.

--
Gregoire

View 9 Replies View Related

Team Project In TFS - SSIS Project Sets Itself As The Startup Project

May 29, 2008



For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.

I am using Visual Studio 2005 SP1.

View 3 Replies View Related

Windows Application With MSDE

Jun 28, 2004

I am developing a windows application that will run on every client station. This application will refer to a database located on a server station. Can I use MSDE for such application and if so how many remote concurrent connection can be open simultaneously?

Eric

View 1 Replies View Related

VS2005 And C# Windows Application

Nov 8, 2006

I am working on a windows application (C#) that utilizes ODBC to acces paradox tables (works fine thought this would be the problem database) and a WinMobile database(.sdf) in order to sync table records. What I need to do is copy the .sdf file from the winmobile device then access it with this application to check for changed records on the PC and in the mobile database then copy it back to the mobile device via RAPI.

The program compiles fine but when I try to run the application I get this error. Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) .

I have already copied the System.Data.SqlServerCe.dll to my projects bin folder and then added a reference to it in the projects Reference dialog. These were also copied to the bin folder of the project





sqlceca30.dll


The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.



sqlcecompact30.dll


Provides the compact database functionality. Required if your application will use compaction.



sqlceer30[language].dll


Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.



sqlceme30.dll


Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.



sqlceoledb30.dll


Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.



sqlceqp30.dll


The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.



sqlcese30.dll

I also added using System.Data.SqlCE to the form and the dataset designer.cs

From this code in the dateset.Designer.cs file after the run is started the eroror occurs.

[System.Diagnostics.DebuggerNonUserCodeAttribute()]

private System.Data.SqlServerCe.SqlCeDataAdapter Adapter {

get {

if ((this._adapter == null)) {

this.InitAdapter(); Error on this line....

}

return this._adapter;

Already tried this

http://msdn2.microsoft.com/en-us/library/ms171861.aspx

Is it possible to fix this? Or work around it?



Thanks Jon Stroh

View 3 Replies View Related

My SQL Application On Windows Mobile 5

Jan 30, 2006

Hi

My application :

On PC : Access application + Access DB
On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB

I synchronise my DBs through ActivSync.

It runs good before Windows Mobile 5.

My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported.

So what are my solutions ?

My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now.
My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc ....

Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ?

Joël

View 6 Replies View Related

Windows Application Log Settings

Jan 16, 2008

Is there a way to control some of the windows application log settings from within the logging process of a package. Specifically the 'source' parameter which comes out as 'SQLISPackage' which i'd like to be the actual name of the package which wrote to the log, and similarly 'Category' which comes out as 'none' and I'd prefer to assign something more meaniful ?

THX

View 1 Replies View Related

Create SQL Server Project In VB.NET 2.0 (Database Project)

Mar 13, 2008

Hi all  How can create trigger in sql server project in VB.NET 2.0 ?thanks in advance   

View 1 Replies View Related

Connect DtSearch From Windows Application

Mar 13, 2008

I have to search the keyword from windows application using dtSearch. when user enter the list of keywords in UI, i have to connect to dtSearch tool and based on the output return, the matched keyword should be added to database table.

Now, i have problem in connecting this tool from my application.

Thanks in advance.

View 2 Replies View Related

Windows Mobile 5.0 Application &&> Xml File &&> Sql Ce 3.5

Mar 12, 2008



Hi there, i am building a mobile app using vs 2008, the app has about 8 - 12 forms that collect data.. i am thinking of

i am trying to decide how i want to save the temporary work data while the user fills the data collection forms.

when the user selects to create a new report, i will

create a new xml file...
as user moves from form to form, i will update the file
when the user has finished filling up all the data i will create a transaction and insert the data into the sql ce database and delete the file...

i will be using sql ce 3.5
i think it supports transactions
i think it also supports identity.... i am using sql management studio 2005 standalone , so i cannot visually modify the 3.5 sdf.,..,. is there a tool for 2008 that will let me visually modify the table(s)? i dont want to use the 2008 feb community edition...

is there a better way to do this? should i skip the xml and go directly into sql ce insert (for the first record creation) and updates? i think this will be a performance killer on a win mob devilce (5.0)

p.s. i cannot store data in a class, and then commit the class to the transaction because if the application crashes i will loose class data, so xml file will be needed.,

suggestions?

View 7 Replies View Related

Windows Application - How Can I Save The Values In Table?

Feb 10, 2008

HelloI use vs2008 and i try to make a simple windows program with add records to a database. The problem is the database don't store the values that i add. When i run my program (in design mode) everythynf looks fine, but if i close vs2008 and restart it again the database is empty.
Why?
Thank you

View 1 Replies View Related







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