I need to do synchronization My PDA's database with Desktop Computer's database manually. M woking with VB.Net Compact framework... So plz Give me some intial code frm which i can start My Project....
Xcept RAPI if is there any thing thn POST BACK me ???
1. Im insterting records in a recently created EDB databse for WM 5.0, but only 16 records can be witten, does any body knows where is the property to accept more than only 16 records???
2. is there ann RAPI for manage EDB. because my aplication use a lot the RAPI that comes for CEDB, but what about EDB??? does it exist?
I'm trying to migrate to VS2005 and prepare for future Windows Mobile releases. My app uses MFC, CCeDBDatabase, and RAPI from the desktop to sync with the device version of the app. Works great now, but I'm worried about how many different ways it will be broken in the future .
My questions - first, are we pretty certain that CEDB will NOT be supported after WM5? Next, is there, or will there be, a CCeDBDatabase class for EDB? VS2005 seems to know nothing about CCeDBDatabase. What should I be doing with the CCeDBDatabase; do I need to re-write everything using only API calls? Also, there is no RAPI for EDB, is this correct? If so how can I switch to EDB and still communicate/sync with the desktop using RAPI? As always, any advice is greatly appreciated, thanks!
I have a windows forms application that runs on my PC that populates a SQL Server Compact 2005 database and then transfers that .sdf file to my mobile device. The communication between the mobile device and PC is done using the Desktop RAPI class from OpenNetCF (http://www.opennetcf.com/FreeSoftware/DesktopCommunication/tabid/90/Default.aspx)
Anyway, I was previously using SQL Server Mobile 2005 and my populated .sdf was around 1.7 MB and I could transfer it to my mobile device in a minute. Once I switched to SQL Server Compact 2005, the transfer process began taking 3 minutes with a 1.5 MB .sdf file. The SSCE also got bloated more easily so I added in the Compact operation each time after I fully populate the SDF to keep the file size at 1.5 MB, but even then it still takes 3 minutes.
I've done a few tests where I simply switch between the two database versions and that simple switch of the version changes the transfer time. I am dumbfounded trying to figure out what the cause might be. Since it is just a file transfer, why would the version even matter unless somehow SSCE is really not compacting and lying about its actual size.
Has anyone run into anything similar to this or may have any ideas what might be going on?
I did a small package with only one ODBC connection (Merant 3.70 32-Bit Progess). This package runs well in Visual Studio and fails when runs by SQL Server Agent.
Configuration:
SQL Server Agent on a 32Bit server.
The ODBC connection configuration in available on System DSN on this server.
The user of Server Agent have full access (Admin).
Connect Manager Provider: ".Net ProvidersOdbc Data Provider"
SQL Server version: 9.0.3042
Error Message:
Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:50:33 Error: 2007-06-11 16:50:33.62 Code: 0xC0047062 Source: Data Flow Task DataReader Source [1] Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon... The package execution fa... The step failed.
I created a .bat file with this instruction and It's run well:
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.
We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.
There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!
What do I need to tell you to get some idea of where to go next with this?
Hi, I have suddenly run into a problem. I have a DTS which was running well till few days ago. Now when ever it runs, it crashes the server, any body have any idea why???
I have created a Web assistant job which select and displays data from a table (very small amt of data) on to the webpage. the job is schedule to run every 1 minute. the job is not running, in job view history its gives the error msg "could not open the output file" 16821 Error no.
I've been running into a small problem. There are two people that usually create local packages to be executed by the DTS. Either my boss or I. The problem that I have been running into is, there are some local packages that will not execute when I try to run them. These packages are that my boss has created. When she runs them they work fine. But when I run them they just don't run. The only way I can run the local package is if I log in into the server and run it from there.
The error that I keep getting is:
Unspecified Error [Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified.
What would I be able to do so that I can execute this local package from my computer?
I'm trying to run a job that will convert a load of data but it keeps failing at the first step. If I run the scripts in each step on their own then they run fine. The error message I get is 'The process did not produce any output. Process exit code 1. The step failed'. I think this may be some kind of security problem but I cannot see where. The command I'm using for the first step is as follows:
Hi, I am trying to create a job to run a ssis package. The job fails. Looking at the history log, there is no proper information on why the job failed. It just says: The job failed. The job was invoked by user ...
please note that the ssis package runs fine on it's own i.e. in the designer by pressing the run button. Thanks
I have a package which works fine when i ru if from VS but when i schedule it iam getting an error on one of the data reader source. I am not able to figure it why its giving error when its working fine from VStudio
Message Executed as user: NAdbasvc-alticor. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:28:25 AM Error: 2007-07-10 11:28:26.21 Code: 0xC020838F Source: Staging LKPDataReader Source [1] Description: An error occurred executing the provided SQL command. End Error Error: 2007-07-10 11:28:26.21 Code: 0xC004706B Source: Staging DTS.Pipeline Description: "component "LKPDataReader Source" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2007-07-10 11:28:26.21 Code: 0xC004700C Source: Staging DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-07-10 11:28:26.21 Code: 0xC0024107 Source: Staging Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:28:25 AM Finished: 11:28:26 AM Elapsed: 0.906 seconds. The package execution fai... The step failed.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Line 57: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Line 58: Dim ds As New DataSet Line 59: SqlDataAdapter1.Fill(ds) Line 60: Line 61: DataGrid1.DataSource = ds
Stack Trace:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) jtio8.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootjtio8WebForm1.aspx.vb:59 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain()
Now, I've created a new login to the SQL server using the ASPNET user id (as well as several others for testing), set up the premissions for each UID and I'm still getting this error.
I have also tried to setup the user info in the connection string by doing the following:
Hello,I'm trying to create a new SQL Express database in VWD, and I get the error: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.What is this error all about? I don't understand it.Thanks.
I have this line of db connection code that works in vb.net but not in c#: con = new ADODB.ConnectionClass(); //for vb.net I used ADODB.Connection() instead and it workscon.Open("Provider=SQLOLEDB;" + ConfigurationSettings.AppSettings["connectionString"]); Error message:CS1501: No overload for method 'Open' takes '1' arguments Searched the web but can't find the answer... Does anyone have a clue?
I trying to FTP Files about 37 files each 3 GB. The FTP is just stuck. It fails half way through. I use IIS 4.0 in Clustered Network and MSSQL 7.0. IIS 4.0 does not support transfer of files more than 4 GB.Is there any other tools that I can use to FTP the dump files. Does anyone have any ideas.
I have a job that has 2 steps.In the first step iam using a group by clause.The column on which I use group by, sometimes has null values.During such case the job is failing at the first step throwing a warning. Warning: Null value eliminated from aggregate. [SQLSTATE 01003] 1)If i want to override this, is it appropriate to use set ansi_warnings off for my session? 2)If there is some other error will that be detected or will that be overridden too? Any help appreciated! TIA Regards, kinnu
I have a script that is generated from main frame. This script updates about 113,000 rows. I keep getting an error message 225, 16. From Books on line 225 "Refrenced object (name %*.s) dropped during query optimization"
16 Too many table names in the query. The maximum allowed is %d. knowing that it updates only one table this message does not make sense. It is on sql server 6.5.
Any help will be very much appreciated. Thanks in advance Al
When I schedule a DTS export job,I am getting this error. But if I run it with 'run immediately' option while creating the job,it runs fine! Any clue?? Thanks.
''DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Transfer SQL Server Objects DTSRun OnError: Transfer SQL Server Objects, Error = -2147221504 (80040000) Error string: Error source: Help file: Help context: 0 Error Detail Records: DTSRun OnFinish: Transfer SQL Server Objects DTSRun: Package execution complete. Process Exit Code 1. The step failed.''
when I create a DTS export job,it is running o.k when I select 'run immediately' option.But the same job is not running as a job.Any idea??? Thanks for any help.
Hi , While running the load cmd - 'Load database dbname1 from disk='c:empdump1.dat' through ISQL I am getting the following error 1 transaction rolledback dbid error 7.But when I tried restoring using enterprice manager UI it is working fine.Any body knows why it is happening like this . Thanks in advance Jiji
I set up a DTS package to run every night on my SQL 7 Server. It is supposed to write a text file of modified rows every night. It was working fine until I changed the password for sa, now it fails. Also in Enterprise Manager, when I try to look a the package properties, I get a "login failed for user sa" package error.
I have stored procedure that uses the xp_cmdshell procedure to use the dts run to run some dts packages. This package exports data into an Access 97 database. When I run it I get this error: Error: -2147467259 (80004005); Provider Error: -533791822 (E02EFBB2)
Error string: Could not update; currently locked by user '(unknown)' on machine ''.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003218
If I right click on the local package and select execute it runs with no problem. Any ideas what is going on?
I have a DTS package set up to push data out to several sites. When I execute the package it runs perfectly. When I schedule it as a job it fails. I checked the proxy account in the SQLAGent properties and there is a check mark there. But the job still fails.
Ok I had a server crash the master was bad or corrupted. I tried to rebuild the master but that failed. I had to reinstall sql and then attach the databases.
I need to know why the master all of a sudden just stopped working. Any ideas where to look or what would cause this?
Sorry about that first post I hit the wrong button.
I have a BIG problem. One day about a week ago I came into my office and everything was working fine, except for the fact that the drive of the NT server was a little fragmented. This machine is a dedicated server and since everything was relatively ok I turned the monitor back off and left the machine alone, after starting Diskkeeper to take care of the fragmentation. Later I go to check on the machine and the following message had appeared on the screen, NT system corrupt service can not continue with an OK button. So I sighed an pressed the ok button already to figure out what service needed to be restarted, unfortunately my best laid plans were soon destroyed when again the message popped up till I had shut down every program and had to reboot.... That is when the real fun started, it never rebooted, I had shut it down properly. So now I had a central server, that had never been backed up before that needed windows NT reinstalled. So I started reinstalling NT. I recently came in to this position and the people before me had not made and backup what so ever. So I had no Emergency Disk, and the systems files, i.e. User database, stuff that would normally be on a Emergency Disk were somehow corrupt and I could no recover them. Well after getting NT up, I worked on restoring the functions of the server, file sharing and web hosting. I still have a lot of programs to reinstall as the reinstall of NT left the actual program files alone, but has rendered them unusable. Now that I`m done with the background, I have now made a copy of what was left on the drive, so I could restore the data files. When I go to reinstall SQL 6.5, it will not let me use the upgrade part. So I try to do a complete install, I`m getting desperate here! Well it starts the install no problem asks me for info and I tell it. I have tried this with a new directory and the old one with the files intact. Well as the install goes along it allows the copying of the files, and then goes to a screen where it has the little hour glass thing in the SQL window setting up the server. A few minutes later it changes the title on the screen to read Microsoft SQL Server 6.5 Setup and brings up a window with the error The SQL Server installation could not be successfully completed Setup was not able to connect to the SQL server the only button is Exit to windows NT. I`m out of ideas. HELP me please.
Guys I was wondering if you can help me figure out the problem with the script.
1) I am getting the following error message on one of the job which is backing up all the databases on the server.
...ges for database 'AdminWorkFlow_Reports', file 'AdminWorkFlow_Reports_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AdminWorkFlow_Reports', file 'AdminWorkFlow_Reports_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore operation successfully processed 433177 pages in 64.328 seconds (55.163 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 113720 pages for database 'BMSRep', file 'BMS_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'BMSRep', file ' BMS_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore operation successfully processed 113721 pages in 17.200 seconds (54.162 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 208 pages for database 'EmailAddress', file 'EMailAddress_STGE_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'EmailAddress', file 'EMailAddress_STGE_Log' on file 1. [SQLSTATE 01000] (Message 4035) Backup or restore operation succe... The step failed.
Not sure where to start. I looked up the backup script it looks fine.
BackUp Database AdminWorkFlow_Reports to Disk = 'q:\AdminWorkFlow_Reports12-17-2007.bak'
-- -- -- --
BackUp Database EmailAddress to Disk = 'q:\EmailAddress12-17-2007.bak'
2)Also I have another script which for some reason doesn't run on some nights. Its enabled and the job is scheduled daily but its not running for about a week.
I'm running NT4 SP3 SQL 6.5 SP5. I have one major database (son_db) which is being backed up (along with others) using this command:
DUMP DATABASE son_db TO DBTape WITH NOUNLOAD , STATS = 10, NOINIT , NOSKIP
The task is completing successfully each night. However, we want to test the restore of this database, so we created a test table (test_table) which resides in the son_db database, added some data, and then let the backup run.
Next day we alter some data and try to restore the single table, but consistantly get the following message after clicking on the restore button:
[SQL Server] invalid source table "test_table" specified in LOAD TABLE. Could not find table in SYSOBJECTS in dump.
After this error, the table (test_table) is now completely empty.
MS website is no help, so I would really appreciate a bit of guidance on this,
Hi I have C++ Client application writes data using sp in SQL Server. After inserting more than 150000 records, i am unable to insert data , simply it hangs and no more connection are not allowing.If I close the application, it is working fine. What could be the reason?
