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?
View 1 Repliesits sql server 7.0 and im looking for the service network utility and service manager that it didnt come with.. where can i download it?
View 1 Replies View RelatedHi,
I have question regarding the MSDE and its service pack information.
For example,
How i can get the installed MSDE version and its service pack information in a given desktop?
Is there any way to find the above using APIs?
Can anybody help me in this
Thanks in Advance
Regards,
Alagumani Boju.
Software Engineer - Developer.
I am needing to know if there is a way to edit .sdf files from my local desktop ( I need to copy the .sdf file to my local machine and edit the information if necessary)
Our mobile devices use SQL CE 2.0.
Thanks for your help
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...
View 1 Replies View RelatedAll,
I'm running Windows Xp Pro With SQL 2005 Dev edition with Adventure Works sample db installed. I am the local administrator on my desktop, the services are up and running and I specified local connections only since this is the DEV edition of SQL05.
When I try either one of these connection strings: Data source=(SQLDEV05); initial catalog=AdventureWorks or Data source=(local); initial catalog=AdventureWorks.
I receive this error message:
TITLE: Microsoft Report Designer
-----------------------------
A connection cannot be made to the database.
Set and test the connection string.
----------------------------
ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
================================
Thanks in advance!
>Scott
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.
Thanks for any suggestions beforehand.
Hi All,
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.
Regards
Trushar
can we open a sqlce databse stored on desktop hard disk in desktop application ?
Regards
Mukesh Gupta
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?
Hi,
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.
Hello
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?
Thanks
Ares,
hi
i want to know that how to manage the sql server transaction in a
big desktop networking application?
for example
there are 200 tables in
database. many of that tables have relatationship. i have a form in
frontend which holds nere ablut 50 tables deffrent calculated amount. i
want to ADD, EDIT and DELETE, SAVE(commit), CANCEL(roll back) them and
same time another use will do the same work from another pc. if there
are 100 user does the same work (add, edit, delete, save, cancel) how
could i magage my sql server data???
i also want to know that
1 kind of
proffessionsl way to use sql server and vb.net?
2 what kind of septs to
develop a desktop networking application with sql server?
3 how i could
manage the transaction in sql server when there are many-many user
working in the same database(add, edit, delete, save-commit,
cancel-rollback).<img src="images/emoticons/smile_baringteeth.gif">
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
View 2 Replies View RelatedHello, PLEASE Help me.I have just installed the Quick Starts on my local machine, and it mentions that you will need a new instance of SQL called (local)/NetSDK.I already have the MS Personal Edition and the tutorials say to download the MS Desktop Engine. So what do i need to do in order to get teh Quick Start samples to work locally???Can i not just use my own instance and use the Grocer and other Databases there???Please Help
View 1 Replies View RelatedHello!
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
Hi guys, need help again.
I'm running packages from C# code and thus I need to create an instance of SqlServer.DTS.Runtime.Application.
In my maching, creating the application instance doesn't even take 1 sec but when the application was deployed to our QA server creating the instance took 30 secs (always ... every single time with no exception).
this single code is taking the 30 secs:
Application integrationService = New Application();
Does anyone have any idea what I need to check or configure to make this faster?
Hi,
I have a VB.NET program which creates a Job (Microsoft.SqlServer.Management.Smo.Agent.Job) and schedules it, to load and run a existing SSIS package, which is on a different server.
I'm using the following assemblies for this purpose.
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum.dll
To make this application run in my application server, do i have to install any SQL server components or SSIS rumtime components? Or Is it enough if i copy only the above mentioned dlls to my applications bin directory, in my application?
Note: I have the enterprise edition of SQL Server 2005 installed on my database server.
Thanks in advance.
Karthik
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee
I have an application that uses an MDF file as a database. Debug mode of application on developing machine works fine.
I synchronize my project to my home computer so that I can work home too. (I use AllwaySync for synchronisation, it copies newer file from the old location overwriting the old ones).
I also have a setup project in my solution for that app.
When I create and install the application on my local computer everything works fine. But when I install it one a different computer and then run it, it cannot connect to database. The error occures while conencting to database saying:
Code Snippet
Unable to open the physical file "C:Program Files........VBDB.mdf". Operating system error 5: "5error not found)".
Unable to open the physical file "C:Program Files........VBDB_log.ldf". Operating system error 5: "5error not found)".
Cannot open user default database. Login failed.
Login failed for user 'EKAROMAEka''.
File activation failure. The physical file name "C:Program Files........VBDB_log.ldf" may be incorrect.
the second time I try run my application I get the following error (and all following tried where resulted in this error):
Code Snippet
Cannot open user default database. Login failed.
Login failed for user 'EKAROMAEka'.
These exceptions are caught by "try catch" when feeding data into DataGridView om my main form.
I have the sam username and password on my Home and Work computers.
I'm not very good at MSSQL security. I don't know how to solve this problem. I can't even understand wheather this is a security that's built in an MDF file or some kind of a Database server issue.
the connection string that I use for connecting to SQL Server is this:
Code Snippet
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|VBDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=False
Thanks in advance.
I would like to deploy several reports to production server, Do i need to install reporting services entire software in order to run the reports or is it possible to just have runtime files installed on it to run the reports.
please help, i have almost 100 reports to be deployed on this server which is located in other country.
Thanks for the helpful information.
(i am using SQL server 2005 / reporting services 2005.)
I installed Postscript fonts on my local machine and they show up in the font dropdown for Office applications, but when I open a report in Visual Studio 2005 report designer, the Postscript fonts do not display in the font dropdown. How do I get the new fonts to be accessible in the report designer?
Thanks,
Brian
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
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.
Can I use SQL_Mobile as PC desktop server or PC local cache server?
I want many data to be cached at user's PC,
and call for this data to be created transparently as for remote
main SQL server.
Is it possible to do without creating complex structure of doubling functionality
of main queries to single SQL server ?
some articles, samples, links, keywords ?
thanks you
Hi All,
I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.
I would now like to install my application on another workstation and connect remotely to the database located on my development machine.
The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?
Thanks!
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?
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 ?
I have created an application which uses a SQL Express database. The program runs fine on the the computer where I built the app, however when I install the app on another computer I get an error telling me that under default SQL Express does not allow remote connections. The problem is that I dont want a remote connection I want a local connection, the database file is on the commputer. How can do get my application to look for the database on the local machine.
My connection string is:
Data Source=(local)SQLEXPRESS;Initial Catalog="C:DOCUMENTS AND SETTINGSADMINISTRATORPLDAQ.MDF";Integrated Security=True
I have made sure that the file is in the correct directory.
Any help would be greatly appretiated
I saw a video on how its possible to create a local database so that when the application is being deployed, the mdf file will be deployed with it and will contain the enter data. The instructor(Beth Messi) showed that all I need to do is to add the .mdf file using the "Rightclick Project name in solution explorer > select add > add new item > then in the dialog that opens, select SQL database and click ok. I did this but the Visual Studio kept saying: "An error occored while extablishing a connection with the server. When connecting SQL Server 2005, this failure may have been caused by the fact that under the default settings of SQL Server does not allow remote connections. (Provider: Shared memory provider, error: 40 - could not open a connection to SQL Server)"
Honestly, I don't know how to go futher with this. The SQL server am using is the professional edition and I have been able to use it through Visual Studio to create Databases. It connects alright in that senario. Please I really need help here.
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
Hi all,
I read the Tang and Lennan's book 'SQL Server 2005 Data Mining'. It frequently says
about changing the value of the algorithm's parameter. I tried changing values for
MINIMUM_PROBABILITY in one occasion. However, the dialog box refuses to
change the value; for any of 'Value', 'Default', and 'Range'. Similar thing happens
when I tried to change the value.
What I can do is delete the parameter, then add it again. Even so, I can only supply
the value, not the default value and range (of values).
What happen? Again, is this because I'm using evaluation copy?
Thank you,
Bernaridho