I've written a program for one of my clients, and they are making alot of changes. Typically when I make a change, I have to go into the office and re-install the updates to every system that uses the application. I would like ot be able to install the application in a central location, and then run shortcuts to everyones PC so when I update the application I just have to install it in one place. How can I do this? Also they clients are running a windows domain in the office. How can I accomplish this task?
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 ?
i have an application that uses sqlce.. now i want to install sqlce with my installer instead of seperate installer... could you please guide me how can i do this? i have created installer for my application but how to integrate sqlce with it...
I am thinking of using my web database as the database to use for my program, though not sure how feasible due to connection speeds and having to transfer that info.
what I am using as the connection string is
con.ConnectionString = "Data Source=databse ipadress inserted here; Initial Catalog=databasename here;Integrated Security=True"; with real data obviously inserted into the ip and tables, but when i try and send values there it just hangs and then crashes. I am thinking its not finding the database. Is there something else im to do?
I am using the exact same code as when i use my own machine as the server, and it works great that way, only thing different is the trying to send to the web server.
I was thinking of replacing my desktop programs I do in Microsoft Access to SSEE. I am getting up to speed by some books and tutorials.
How would I distribute a program that has a SSEE database? I currently have in my application startup path a folder called "Database" that contains the .mdb, could I do the same thing with SQL Server. If so, what does that do to the connection string.
Hi,I am quite puzzled how SQLServer manages transactions.Whatever the isolation level I set when performing an insertion, otherconnections do not have access to the table in select mode.Example in SQL Analyzer:create table foo (id numeric(10),data varchar(100))On Connection 1SET TRANSACTION ISOLATION LEVEL READ COMMITTEDGOBEGIN TRANSACTIONinsert into foo(id,data) values (1,'data');On Connection 2SET TRANSACTION ISOLATION LEVEL READ COMMITTEDselect * from foo-> QUERY HANGSOn Connection 1COMMITOn Connection 2Get the resultUsing READ COMMITTED level, I was expecting not to lock the table whenperforming the select.Thanks in advance for your help,Cedric
I am interested in synchronising 2 sdf files which are sitting on 2 different PDAs and I want to synchronise both of them with or without desktop application. C# applications are used to talk to the applications.
Is it possible or not and if possible how can i do that. Any code snippets or any links to similar forum posts or anything will be of great help. I am a C# programmer but not SQL Developer.
The sample application provided with Access Database Synchronizer fires a "A request to send data to the computer running IIS has failed. For more information, see HRESULT." exception on my WinCE 4.2 device.
I debugged it with VS2005 to see what was going on and found that the problem resides in the line:
m_connDesktop.Pull("MSysObjects","SELECT Name FROM MSysObjects WHERE Type=1 and flags=0",accessSysConnectString,RDATrackOption.TrackingOff,"Err_MSysObjects");
It seems that connection m_connDesktop is ok but calling Pull method fails.
I've verified that SSEvAccessSync service is started when ActiveSync detects device connection and that firewall rules are correctly updated.
Also, i verified my System.mdw and i discovered that there is no "MSysObjects" table (only MSysGroupList, MSysGroupMembers, MSysUserList and MSysUserMemberships queries are there).
Do you think the problem is there?
How can i solve it without damaging System.mdw?
I cannot figure out what's the purpose of this line of code, can you help me?
I was migrating one of my applications to VS.NET 2008 to start testing the new platform and encountered an error. One of my application requires the use of System.Data.SqlServerCe namespace to create a SQL Server CE database on a desktop machine.
The error is raised when I try to use a SqlCeCommand to insert rows in a table using parameters. If the order of the fields in the INSERT command does not match the order of the fields in which the table was created, an error is raised.
Investigating further, I noticed that the INSERT command was trying to insert the value of a parameter in an incorrect field. For example, the value for the field23 was being inserted into field22.
It looks like the SQL CE engine is rearranging the fields in the INSERT command to match the order of the fields in the table, but forgets to rearrange the parameters of the SqlCeCommand as well.
I give the example codes in the next posts. I will give it in both VB.NET and C#.
For both versions, you just need to create a Windows Application and add a reference to System.Data.SqlServerCe.dll. Insert the corresponding code into the Form1 partial class.
In the example, the constant RaiseError can be set to Boolean.True in order to raise the error. Set it to Boolean.False to execute correctly.
I am writing a Desktop application accessing a SSCE database. I am running Windows XP SP2, VS2005 SP1, and have SQLServerCE3.1 installed. Debugging the application shows that ds.m_spInit->QueryInterface() returns E_NOINTERFACE. I have checked that SSCE runtime library is installed, IDBCreateSession uuid exists in the registry and m_spInit.CoCreateInstance(CLSID_SQLSERVERCE_3_0) return S_OK. Can you suggest me what need adding/installing to get the CSession.Open(datasource) working?
I'm new to vs.net 2005, before we switch to sql server 2005, i've been using vs.net 2003, and sql server 2000, and 3rd party sql reporting services 2000. so i use vs.net for front end, sql as back end, 3rd party as reports printed out of front end.
but now.. i have an installer of sql server 2005, and when i install it, it includes a vs.net 2005 w/c i can use also to create my reports.. but about the vb.net? does it have anything installed with it? is there a seperate installer for vb.net that i need to purchase? or maybe download from?
i created some reports from business intelligence and i have the report.. but i need to make its user interface using vb.net.. and i can't find it
Am I correct in assuming that installing a SQL EE application on to a local runtime desktop would require a lot of experienced user intervention to install the SQL to each local cpu? Can a SQL app be installed automatically w/o a user intervening?
We have a small office network consisting of 6 workstations and a server. I want to know if it is possible to be able to run sql server from the workstations and host the created sql databases on the server rather than an individual pc? If so how do i do this?
I am running a vba procedure ( adp file ) that executes successively 5 stored procedures . however it happens that the execution breaks at the middle of the code thus giving a situation where only 2 tables among 5 are updated.
Is it any solution to rollback transactions update already done before the code breaks due to error ?
I was thinking about combining all stored proc on a big one and use Begin transaction - commit transaction and rollback transaction ... however i am not sure wheter updates involving several tables can be handled on one transaction.
Hi there,I sincerely hope that someone out there can help. I have twoinstances of the SQL 2000 Desktop Engine running. One is on my localmachine for development and the other is on another machine on ournetwork which is the production environment. I have built an Access2003 front end application which connects to this database. Thisworks fine locally, as you would expect. I successfully installed thedatabase on the production machine and am able to connect to it viaAccess 2003 (using the Data Link Properties window) and from thirdparty database manager software (similar to Enterprise Manager). I amnot able to to connect to the database via my application.I am using the "sa" account with a strong password. This is myconnection string:strConnection = "Provider=sqloledb;DataSource=server02;UserId=sa;Password=strong;Initial Catalog=Test"The error I'm getting is:"Connection cannot be used to perform this operation. It is eitherclosed or invalid in this context."The connection string is the only thing that changes in my code when Iswitch from my local to my production database. Is there some reasonthat I can't use the "sa" account in this fashion that I'm not awareof? I'd rather not use integrated security for simplicity's sake asthis is a small, internal application. Also, I would have thoughtthat if that was the issue, I couldn't use "sa" at all, even locally.I'm going to post to the Access group as well but thought someone heremight have some advice to offer as well.Thanks,Barb
I am currently using SQL Server 2005 Express to run a social networking website on a dedicated server (Windows Server 2003, code is written in ASP.net). Obviously express is too limited to run this site, but for now I am still getting the site operational so the demands are low. Soon I will begin advertising and adding many users to the site - can anyone recommend a version of SQL Server that I would need? My programmers say I should go with enterprise, but that seems overkill (and my hosting provider - theplanet.com does not even offer it). Would workgroup be enough, or should I go with standard edition?
To be honest I do not trust my programmers experience with SQL server which is why I am asking for help here (they are outsourced from India, and I am becoming more and more convinced that I need an onshore IT manager for them - finding that is another issue...). Also, are there built in backup features with SQL Server? My programmers told me recently that they will need to put in significant work to setup a backup system, but it seems to me like one might already be built in.
I am using the personal edition of sql server 2000 and i have a number of databases stored on the harddrive, how would i set up a connection with other PC's to be able to view/modify/delete the data through an access 2000 front end. The other PC's will not have SQL server on them but will have Access 2000, they will need to go via the network which is non-microsoft compliant.
Thank you very much for you help it would be very much appreciated.
A first chance exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll Public member 'Variables' on type 'IDTSPackage90' not found.
when i install vs.net2005 , so .net framwork 2 installs with it ,then when i m trying to install sql2005 it give me to uninstall .net framwork, and by default .net framwork 2 beta comes with it which is not compatible for vs.net 2005 , shortly when i run vs.net2005 ,sql2005 is not working and viseversa
hi, Can any one tell me which is better suitable for web applicaiton Stored Procedure or transaction for regural process in the table.. can you explain me why..?
We are using - MSSQL Server 2000 on windows 2000 advanced server. PB 7.0 for client server front end tools.
Prior to few days our application works fine, rightnow it get slow or not responding after few (4/5) transaction. We don't know wht it is, If anyone has same experience so that is helpfull for us.
It is possible to write an application which monitors the Microsoft SQL Server 2005 database's transaction log and captures data modified (values after modification) by transactions? Can you point me to some tutorial and API specification?
It is possible to write an application which monitors the Microsoft SQL Server 2005 database's transaction log and captures data modified (values after modification) by transactions? Can you point me to some tutorial and API specification?
I have a network of all win2000 machines. The server is win2000 and is a domain controller running sql 2000. I've been having intermittent problems with our software staying connected to sql and found that installing the sql client networking package fixes it. The problem I'm having is that users with admin rights work just fine, but users with just user rights aren't. I set up client neworking by moving named pipes above tcp and setting the alias to the sql server but the user machines doesn't remember the alias. Here's a list of what I've tried:
log in as admin and enter alias
create .reg file of proper registry settings and import but got a key is in use error, cannot import registry
created shortcut to cmd and set shortcut to run as diff user, log in as admin, run .reg file, imports fine, alias still missing in user computer.
Any ideas what might make the alias not stick? The users cannot install software and there might be some other security setting or restriction keeping it from sticking but I have yet to find it.
In my SSIS project, i have to retrieve data from an oracle 10g database. On my personal laptop it works, but on our test-env i get the error below, when i try to test my connection to the oracle datasource.
Could this because i have oracle XE installed yet on my personal laptop, and it is not installed on the computer of our test environment where the SSIS runs? If that's the reason, it sounds very strange, because it would mean i have to install an oracle environment also on the computer with SSIS, just to make a connection to another oracle server...
Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
I have SQL server admin id and password, and I want to do some create/delete new database, or mimium do some select statements. What do I need to install on my workstation in order to connect to SQL server remotely? What's the equivalent tools as SQLPlus in Oracle?
I am no longer able to manage SQL Server at the server explorer in Visual studio. i.e. create, modify and delete for Diagrams, Tables, Views, Stored Procs & Functions. Further more, it missing Diagram and function folder. I can only view or read data.
Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted.
I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.
