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


ADVERTISEMENT

Package Runs Fine In BIDS, Fails When Scheduled

Dec 28, 2007

I have a 7 step SSIS package that manipulates some data on a DB2 database. The package executes perfectly in Business Intelligence Development Studio. I save the package to my SSIS store and then point my scheduled task to it and it fails after about 9 seconds everytime. I have an identical job that works with a different DB2 database that works without any problem. The only difference is the database it's pointing to.

The package is executing as the same user who created it, which has sysadmin to both the SSIS store and the SQL instance the package is executing on. When I saved the package I selected "Rely on server storage roles for access control" for the protection level.

This one is driving me crazy, can't figure it out. Any idea's?

View 7 Replies View Related

SSIS Package Runs Fine; SQL Job Fails (DBF Involved)

Jun 14, 2007

I have created an SSIS package which, as its 2nd step, picks up a .dbf table and does a Data Flow Task of putting the .dbf table into a SQL Server 2005 table (which was just truncated in Step 1).



The Connection Manager that works on the .dbf table is Native OLE DBMicrosoft Jet 4.0 OLE DB Provider.



The entire SSIS package runs perfectly when i run it from my development environment.



I then assigned this Package to a SQL Server 2005 Job. The entire package is the sole step of the job.



But when I run the SQL Job, the Job fails immediately on Step 2.



Here is the error message in View History of the SQL Job:

-----------------------------------------------------------------------------

Executed as user: DBASE01SQLExec. ...on 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:48:37 AM Progress: 2007-06-14 11:48:37.91 Source: DBF to ScanUS_Process Validating: 0% complete End Progress Progress: 2007-06-14 11:48:37.91 Source: DBF to ScanUS_Process Validating: 33% complete End Progress Error: 2007-06-14 11:48:37.91 Code: 0xC0202009 Source: DBF to ScanUS_Process ScanUS DBF Output File [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. End Error Error: 2007-06-14 11:48:37.91 Code: 0xC02020E8 Source: DBF to ScanUS_Process ScanUS DBF Output File [1] Description: Opening a rowset for "scanus_process" failed. Check that the object exists in the database. End Error Error: 2007-06-14 11:48:37.95 Code: 0xC004706B Source: DBF to ScanUS_Process DTS.Pipeline Description: "component "ScanUS... The package execution fa... The step failed.

-----------------------------------------------------------------------------



Could someone suggest why this works OK within SSIS but not when the SSIS Pakcage is called from SQL?



thx very much/spirits.



seth j hersh

View 7 Replies View Related

DTS Package Manually/locally It Runs Fine. But The Scheduled Job Run And Fails

Oct 16, 2007

I was facing some issue on MP. Yesterday I changed the SQL services to use the local admin account. That didn't help my MP issue. But it may have created another issue.
When I run the package manually/locally it runs fine. But the scheduled job run and fails with the Title string.
---------------------------------
Executed as user: IL06EDM00SYSTEM. ...tart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005) Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 18452 (4814) Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147467259 (80004005) Error string: Login failed for user '(null)'. Reason: Not associated with ... Process Exit Code 2. The step failed.
--------------------------------------------------------------

Any ideas.

View 1 Replies View Related

SQLConnection Fails From Windows Service

Nov 24, 2006

Hi,

I'm currently writing a windows service which will generate XML documents for FTP upload. When running the service the goal is to get records from a stored procedure, then generate the XML documents.

When running the service (lokal service account) the connection fails; instead of using the supplied connection string, it defaults to the LocalService account. How can this be solved?

Thanks in advance

View 6 Replies View Related

SQL Server 2000 Installation Fails On Windows XP With Service Pack 2

Nov 29, 2005

Hi,
i tried to install SQL Server 2000 Developer and MSDE the whole day on my Windows XP SP2.
MDAC is the latest, that come with WinXP SP2 (2.81). The installation fails at the end after 100% complete.

It says:
Translated: "the setup programm starts the server and installs the configuration you chose..."
("das setup-programm startet den server und installiert die von ihnen gewählte konfiguration...")

then it takes some time and the failure appears, saying:
"the setup programm could not configure the server. you can find more
information in the server-failure-log files and in
"C:windowssqlstp.log."

sqlstp.log last couple of lines:
22:42:10 C:WINDOWSTEMPSqlSetupBinscm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
22:42:10 Process Exit Code: (0)
22:42:10 StatsGenerate returned: 2
22:42:10 StatsGenerate (0x80000000,0x1,0xf000000,0x200,1031,303,0x0,0x1,0,0,0
22:42:10 StatsGenerate -1,toebens)
22:42:10 Installation Failed.



I already read several knowledge base articles on this... removed keys in the registry...and so on...nothing worked :(

this **** makes me angry. please help me.
thanks
 

View 5 Replies View Related

Windows Service Vs Package

Mar 26, 2008



HI,
Recently i had to maintain few SSIS packages. One of the packages keeps running indefinitely to monitor a folder for new files using FileSystemWatcher. Once new file is arrived, it simply renames file and calls another package for further processing. My first impression was that windows service might be a better choice for such functionality.

Any idea about these two approaches to implement this functionality i.e Continuously running a package using indefinite loop as compared to a windows service.

Thanks

Saeed

View 3 Replies View Related

SSIS Package Permissions (Windows Application Log) Question

Jul 20, 2007

Hello all,



I have an issue where the DBAs have informed my group that they need to get to a model where an SSIS package which presently needs Admin perms on a box in order to write to the Windows Application Log, no longer needs those perms to write to the log.



I am new to SSIS packages, though familiar with DTS packages (and ETL), so I'm wondering if their concerns (1) can be verified; and (2) if so, is there a better way to allow the package to write to the log without Admin perms (on the box). At the moment, the preference would be to do so without using .Net, in an effort to keep the implementation simple.



Scenario: A single package is scheduled to run at a predetermined time. Once complete it writes to the Windows Application Log.



Thanks in advance,

Henry

View 4 Replies View Related

How To Launch Package From A Windows Service

May 20, 2006

I'm developing a Windows Service to watch for an e-mail and then launch a package.  It extracts some parameters from the e-mail that I then need to pass to the package.  What is the best way to launch the package from the service?  Should I run it in a new thread? I don't want the service to have to wait for the package to complete.  How would I pass the parameters?  Should I use dtexec?  If the service fails or is stopped and the package is still running, it would terminate the package also, correct?  Any way to avoid that?  Thanks.

View 3 Replies View Related

SSIS Package Runs Fine Except As A Scheduled Job

Mar 14, 2006

I have an SSIS package created from a SQL 2000 DTS using the Migration Wizard. The package imports data from a MySQL database to a SQL 2005 64-bit database running on 64-bit windows server 2003. The package runs fine when executed from SQL Server Management Studio but when I schedule it as a job it fails with:

Executed as user: [the domain admin account]. The package execution failed. The step failed.

I've tried a lot of different ways to make this work including creating a new SSIS package. Again, the package ran fine except when it was scheduled as a job.

Any ideas would be appreciated.

thanks!

View 20 Replies View Related

SSIS Package Failing When Run As A Job But Runs Fine In BI Studio

Sep 12, 2007



I'm at a bit of a loss. I've written a package that has about a dozen data flow tasks and each one loads data from text files into tables in a db. It's possible that some of the fields in the text files may have data that would need to be truncated upon insert into the db.

In the data flows, I've set the fields in the data sources I know this could happen to to ignore truncation errors. When I run this within BI Studio, everything works fine. I then loaded the package into the SSIS store on the db server and if I attempt to run it from the SSIS store or if a job executes it, the package appears to be failing because of these truncation errors that I've told it to ignore.

Am I missing something? Thanks!

View 7 Replies View Related

Remoting Timeout When Calling SSIS Package Execute From A Windows Service

Sep 12, 2007

When running an integration services package from a windows service I get the "Object ... has been disconnected or does not exist at the server." exception after aproximately six minutes of execution.

This is *not* my windows service failing. I can loop indefinately while tracing to a log file within the service and it will run forever. While calling the mypackage.execute(...) method however, after six minutes (give or take) the exception is thrown...

my code looks something like this:
<code>
dim foo as Microsoft.SqlServer.Dts.Runtime.Application
mypackage = foo..LoadPackage(strimportPkgFilename, pkgevents)
results = myPackage.Execute(Nothing, Nothing, pkgevents, Nothing, Nothing)
</code>

<error>
A first chance exception of type 'System.Runtime.Remoting.RemotingException' occurred in mscorlib.dll
Exception in: frmMyForm.DoImports
Message: Object '/b76f98a0_5bd9_49d8_a524_eeb49d55b303/bqbhkjnaofq_ifr_cwz+srid_1.rem' has been disconnected or does not exist at the server.
</error>

oddly, this same code works perfectly if I run it within a windows form application no matter how long it takes.

It also runs fine if the package can complete in under six minutes.

Any suggestions?

Mark

View 2 Replies View Related

Package Runs Fine From BIDS But Dtexec On Same Box Gives Insufficient Product Level Error

Mar 16, 2006

Running eval. edition of Sql Server Standard 2005. "Insufficient product level" error is thrown during validation phase of an OleDBCommand data flow task. This task type is not licensed in Sql Server 2005 standard? The component runs a very simple sql update statement against a one row table in Sql Server 2005.

If it works from BIDS, should it not work from dtexec.exe on the same box?

Does dtexec run under the security context of the logged in user?

Thanks,

Ken

View 6 Replies View Related

Dtexec Problem For Excel Source -- Runs Fine Using Execute Package Utility

Mar 3, 2008

I have this problem executing an SSIS pkg using dtexec.



dtexec /f d:smappsssis_pkgsdts_SOAR.dtsx /REP E





Code Snippet

Started: 10:28:58 PMEnd Error



Error: 2008-03-03 22:28:59.00

Code: 0xC0202009

Source: dts_SOAR Connection manager "SourceConnectionExcel"

Description: An OLE DB error has occurred. Error code: 0x80040154.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

End Error

Error: 2008-03-03 22:28:59.00

Code: 0xC020801C

Source: Data Flow Task Source - CHANNEL_DATA [1]

Description: The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC0202009.


Code Snippet







However, it runs fine when I double click the package and execute it using the Execute package utility. That really puzzles me.


The package transfers data from worksheets in excel to SQL Server 2005 DB.

Both source and destination are on the same system.
Please advise.

View 4 Replies View Related

SSIS Package That Runs Fine Through Command Prompt, XML Error When Run Through SQL Server Agent Job CmdExec

Aug 17, 2006

I have an SSIS package that runs fine through command pormpt although when I try to run it from a SQL Servr Agent Job CmdExec step it bombs out.  Please help this has me stumped...the SSIS package uses an XML connection string so certain key settings such as connection strings and email info can be changed easily.  Currently this is all on the same machine.  I have not moved it beyond where I am developing.

 

On the command line I am using the following command...

dtexec /F "S:connectionscontacts.dtsConfig" /DE "password"

 

Below is the output log...

 

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  6:59:40 PM
Progress: 2006-08-16 18:59:41.29
   Source: Data Flow Task
   Validating: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.29
   Source: Data Flow Task
   Validating: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.71
   Source: Data Flow Task
   Validating: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.73
   Source: Data Flow Task
   Validating: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.77
   Source: Data Flow Task
   Validating: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.77
   Source: Data Flow Task
   Validating: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.77
   Source: Data Flow Task
   Validating: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.77
   Source: Data Flow Task
   Validating: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.79
   Source: Data Flow Task
   Prepare for Execute: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.79
   Source: Data Flow Task
   Prepare for Execute: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.79
   Source: Data Flow Task
   Prepare for Execute: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.79
   Source: Data Flow Task
   Prepare for Execute: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.81
   Source: Data Flow Task
   Pre-Execute: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.84
   Source: Data Flow Task
   Pre-Execute: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.90
   Source: Data Flow Task
   Pre-Execute: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.90
   Source: Data Flow Task
   Pre-Execute: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.92
   Source: Data Flow Task
   Post Execute: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.92
   Source: Data Flow Task
   Post Execute: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.92
   Source: Data Flow Task
   Post Execute: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.92
   Source: Data Flow Task
   Post Execute: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.92
   Source: Data Flow Task
   Cleanup: 0% complete
End Progress
Progress: 2006-08-16 18:59:41.93
   Source: Data Flow Task
   Cleanup: 33% complete
End Progress
Progress: 2006-08-16 18:59:41.93
   Source: Data Flow Task
   Cleanup: 66% complete
End Progress
Progress: 2006-08-16 18:59:41.93
   Source: Data Flow Task
   Cleanup: 100% complete
End Progress
Progress: 2006-08-16 18:59:41.95
   Source: Send Mail Task
   The SendMail task is initiated.: 0% complete
End Progress
Progress: 2006-08-16 18:59:42.09
   Source: Send Mail Task
   The SendMail task is completed.: 100% complete
End Progress
DTExec: The package execution returned DTSER_SUCCESS (0).
Started:  6:59:40 PM
Finished: 6:59:42 PM
Elapsed:  1.984 seconds

 

 

When I try to use the same command within SQL Server Agent Job using a CmdExec step I get the following error...

 

Description: The package is attempting to configure from the XML file "S:connectionscontacts.dtsConfig".  End Info  Warning: 2006-08-16 18:40:03.15     Code: 0x80012012     Source: contactsPackage Description: The configuration file name "S:connectionscontacts.dtsConfig" is not valid. Check the configuration file name.  End Warning  Warning: 2006-08-16 18:40:03.15     Code: 0x80012059     Source: contactsPackage Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.  End Warning  Info: 2006-08-16 18:40:03.20  ...  Process Exit Code 1.  The step failed.

 

Thanks in advance for any help!!!

View 2 Replies View Related

Integration Services :: FTP Task Runs Fine From SSIS Package Store Always Times Out In Scheduled Job

Mar 27, 2014

SQL Server 2012VS 2010 SQL Server data toolsFTP Connection Manager - port 21, chunk size 1kb, passive mode=false, saved plain text pwDownloads 1 csv file to local directory on SQL Server box.This always works when run from the package.  And always gives a timeout error when scheduled.

Message
Microsoft (R) SQL Server Execute Package Utility
Version 11.0.2100.60 for 64-bit
Started:  11:04:59 AM
Error: 2014-03-27 11:05:31.12
   Code: 0xC001602A
  
[code]...

SQL Server Agent is set to Logon As my domain account, and in the package history it says "logged on as " my account.

View 10 Replies View Related

Job Running SSIS Package Keeps Failing But The SSIS Package By Itself Runs Perfectly Fine

Aug 30, 2006

Hey, I've a few jobs which call SSIS packages. If I run the SSIS package, it runs fine but if I try to run the job which calls this package, it fails. Can someone help me troubleshoot this issue? None of my jobs that call an SSIS package work. All of them fail.

Thank you

Tej

View 7 Replies View Related

Does SQL 2005 Runs On Other Platforms Them MS Windows ?

Sep 12, 2006

I could not find in the documentation but someone told me that there is a way.



View 1 Replies View Related

Can MSSQL7 Runs On Windows Server 2003?

Oct 27, 2004

anyone has tried? please advice possible issues, workarounds

tks

View 1 Replies View Related

HELP: Package Runs...job Fails!

Dec 18, 2000

I'm trying to run a job which moves data from one machine to another. I can manually execute the package successfully, but the job always fails. I get the dreaded error message 18456, "login failis for user "". I have double checked the logins for both machines,(sql server agent AND the sql server authentication).
Also, I can run a select statement (from server_ to server_2) successfully from query analyzer i.e.

Select *
from <linked_server_name>.<database>.<database_owner>.<table_name>

however, if I run this query from server_2 to server_1 I get the failed login message similar to the error message found in the job history. Since both servers accept nt logins, where is my problem? They are both set up as linked servers, and they are both mssql oledb.
Any suggestions will be appreciated!
thanks

View 1 Replies View Related

Job Fails Though Package Runs

Dec 31, 2007



Like the name says, I'm trying hard, but I'm obviously missing something. Okay, I'm new to SSIS. I'm trying to write a job that deletes some Excel files on the server, copies some Excel files from a Sharepoint instance to the location where the deleted files were, runs an executable to manipulate those files, and then imports them to my SS instance.

the package runs fine when I run it from Managment Studio after installing it on the server. The 'execute task' fails when I run the job containing the package. After creating a proxy to have the SQL Server agent Service run with appropriate permissions, I thought I would have been rid of permissions issues (I gave the proxy way too much permission in an effort to narrow in on my issue), but I could still be missing something.

The job doesn't get into the package enough to even start writing to my log file, and all I get in the job history is the very cryptic 'DTExec: The package execution returned DTSER_FAILURE (1) ' error. If anyone has ideas, I would greatly appreciate being shown the error of my ways.

Thanks!

View 6 Replies View Related

Does The SSRS Web Service And Windows Service Share A Common Engine?

Sep 27, 2007

All,

I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.

My question is:

Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?

Any help is greatly appreciated!

Mark

View 4 Replies View Related

Lookup Fails When Package Runs In Development On Another PC Than The One Where It Was Created Error: 0xC020824E

Feb 27, 2007

Hi all,

I try to make SSSIS packages made on my pc accesible to an other user of SSIS (both running on Windows 2000). The packages are on a shared drive in our LAN.. Some configurationfiles are use to configure the Oracle DBconnection.The same files are on the same location on both PC's

The other user can open and run the packages but from the moment the lookup buffers are loaded, we get the following errors:

Error: 0xC0202009 at AB_ADDRESS_DF, LOOKUP_POST_ID [22801]: An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "".

Error: 0xC020824E at AB_ADDRESS_DF, LOOKUP_POST_ID [22801]: OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties.

Error: 0xC004701A at AB_ADDRESS_DF, DTS.Pipeline: component "LOOKUP_POST_ID" (22801) failed the pre-execute phase and returned error code 0xC020824E.

Any suggestion would be most welcome.

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

Windows Update Fails And Won't Go Away

Sep 12, 2007

I had installed SQL Server 2005 developer on my machine (Vista 64-bit) prior to installing Visual Studio 2005. When I installed VS, I used the default installation, which installed SQL Server Express. Soon thereafter, I started getting notifications in Windows Update about an update to SP2. However, when I try to install it, it fails with "Code 7367", and provides no other useful information. I tried downloading SQL Server Express SP2 myself but it would not let me update the existing instance on my machine. So I totally removed the instance from my machine through add/remove. However, I restarted and the update is still showing up and won't go away!! Does anybody have any ideas of getting this problem?

View 14 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

KB918222 Windows 2003x64 R2 Fails

Jul 12, 2006

When I try to apply this post SP1 patch to SQL Server 2005 x 64 on a Windows 2003x64 R2 system it fails everytime. The following is the HOTFIX log:

07/12/2006 15:02:06.781 ================================================================================
07/12/2006 15:02:06.781 Hotfix package launched
07/12/2006 15:02:08.046 Product discovery successfully completed during the install process for MSSQLSERVER
07/12/2006 15:02:08.046 SP Level check successfully completed during the install process for MSSQLSERVER
07/12/2006 15:02:08.046 Product language check successfully completed during the install process for MSSQLSERVER
07/12/2006 15:02:08.046 Product version check successfully completed during the install process for MSSQLSERVER
07/12/2006 15:02:08.046 Command-line instance name check completed during the install process
07/12/2006 15:02:08.046 Baseline build check completed during the install process
07/12/2006 15:02:13.875 Attempting to install instance: MSSQLSERVER
07/12/2006 15:02:13.875 Attempting to install target: <System Name>
07/12/2006 15:02:13.890 Attempting to stop service: SQLSERVERAGENT
07/12/2006 15:02:17.890 Successfully stopped service: SQLSERVERAGENT
07/12/2006 15:02:17.890 Attempting to stop service: MSSQLServer
07/12/2006 15:02:19.890 Successfully stopped service: MSSQLServer
07/12/2006 15:02:19.890 Attempting to check for locked files: sqlrun_sql.msp
07/12/2006 15:02:19.906 Attempting to check for locked files: \<System Name>E$SoftwareSQL2005sppostsp1hotfixsqlFilessqlrun_sql.msp
07/12/2006 15:02:19.906 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.out
07/12/2006 15:02:25.109 MSP returned 1603: A fatal error occurred during installation.
07/12/2006 15:02:25.125 Unable to check MSP file: \<System Name>E$SoftwareSQL2005sppostsp1hotfixsqlFilessqlrun_sql.msp
07/12/2006 15:02:25.125 The following exception occurred: Unable to install Windows Installer MSP file Date: 07/12/2006 15:02:25.125 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 689
07/12/2006 15:02:25.125 Restarting SQL Service MSSQLServer since it was previously running
07/12/2006 15:02:25.125 Attempting to start service: MSSQLServer
07/12/2006 15:02:30.031 Successfully started service: MSSQLServer
07/12/2006 15:02:30.031 Restarting SQL Agent Service SQLSERVERAGENT since it was previously running
07/12/2006 15:02:30.031 Attempting to start service: SQLSERVERAGENT
07/12/2006 15:02:31.312 Successfully started service: SQLSERVERAGENT
07/12/2006 15:02:31.312 Failed to install instance: MSSQLSERVER
07/12/2006 15:02:31.328
07/12/2006 15:02:31.328 Product Status Summary:
07/12/2006 15:02:31.328 Product: SQL Server Database Services 2005 (64-bit)
07/12/2006 15:02:31.343 MSSQLSERVER - Failure
07/12/2006 15:02:31.343

Any Ideas?

View 13 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

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