ASP.NET, VS2005, SSE: Cannot Get Web Application Service
Nov 11, 2005
Hi everyone,
I am attempting to drag the SQLDataSource control to my webpage to initiate a connection to my SQLServer Express instance on the same system. The control will drop correctly, but when I click on the "Configure Data Source" in the SQLDataSource Tasks popup panel, I get the following error message:
Following error occured while getting connection string information from configuration."Cannot get web application service"
It then sends me to the configure data source window where it asks me to choose my data connection. However, there is nothing in the pulldown, and the "New Connection" button does nothing.
I have the SSE data connection defined and visible in the Server Explorer, and there is a connection string defined in the web.config file that points to the server and database I wish to access.
I'm on day 2 of my excursions with VS2005 Pro, so I feel that I'm missing something huge, but otherwise obvious that's different in the configuration of VS2005 as opposed to VS2003, which I have no issues with.
Thanks!Chris
View 1 Replies
ADVERTISEMENT
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
Feb 12, 2007
I'm attempting to setup the defaco MS security for membership and roles, using a newly created database under SQL 2005 (not express). I created the database using the aspnet_regsql.exe utility and that worked fine. I created my provider connection string logging in as 'sa' wit the proper password. All that seemed to work okay too. However when I attempt to change any of the settings like setting the authentication type or enabling roles, I get the follwing error message: The following message may help in diagnosing the problem: Attempted to perform an unauthorized operation. at System.Security.AccessControl.Win32.SetSecurityInfo(ResourceType type, String name, SafeHandle handle, SecurityInfos securityInformation, SecurityIdentifier owner, SecurityIdentifier group, GenericAcl sacl, GenericAcl dacl) at System.Security.AccessControl.NativeObjectSecurity.Persist(String name, SafeHandle handle, AccessControlSections includeSections, Object exceptionContext) at System.Security.AccessControl.NativeObjectSecurity.Persist(String name, AccessControlSections includeSections) at System.Security.AccessControl.FileSystemSecurity.Persist(String fullPath) at System.IO.File.SetAccessControl(String path, FileSecurity fileSecurity) at System.Configuration.Internal.WriteFileContext.DuplicateTemplateAttributes(String source, String destination) at System.Configuration.Internal.WriteFileContext.DuplicateFileAttributes(String source, String destination) at System.Configuration.Internal.WriteFileContext.Complete(String filename, Boolean success) at System.Configuration.Internal.InternalConfigHost.StaticWriteCompleted(String streamName, Boolean success, Object writeContext, Boolean assertPermissions) at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.WriteCompleted(String streamName, Boolean success, Object writeContext, Boolean assertPermissions) at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.WriteCompleted(String streamName, Boolean success, Object writeContext) at System.Configuration.Internal.DelegatingConfigHost.WriteCompleted(String streamName, Boolean success, Object writeContext) at System.Configuration.UpdateConfigHost.WriteCompleted(String streamName, Boolean success, Object writeContext) at System.Configuration.MgmtConfigurationRecord.SaveAs(String filename, ConfigurationSaveMode saveMode, Boolean forceUpdateAll) at System.Configuration.Configuration.SaveAsImpl(String filename, ConfigurationSaveMode saveMode, Boolean forceSaveAll) at System.Configuration.Configuration.Save(ConfigurationSaveMode saveMode) at System.Web.Administration.WebAdminPage.SaveConfig(Configuration config) at ASP.security_setupauthentication_aspx.UpdateAndReturnToPreviousPage(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)Anyone have any clue why this is happening? Do I need to add something to the database as far as users/roles go? I figured 'sa' would have free roam, but something permission-wise just isn't jiving.
View 2 Replies
View Related
Feb 6, 2006
I am developing a application on PDA using c# compact framework. I would like to do synchornisation of sql mobile 2005 database with sql server 2005 database using web service.
The reason for going to webservice is based on the client request.
Will anybody help me on this, how to perform conflict management etc.
View 4 Replies
View Related
Dec 14, 2006
Dear friends,
I am working in .net windows application with sql server 2000. My problem is like some times sql server service automatically stoped when restart my machine.Then i start the service manually.after that if i restart my machine it not affect the service.I mean only at first time restart the machine make this problem. Anybody know any solution for this problerm?.
Also how can i anable TCP/IP through application.
Thanks & Regards
Jesseja
View 1 Replies
View Related
Mar 23, 2007
Some of my receiving service side applications usually work offline, andthey only are supposed to get connected to the network once/few times a day,to send/receive Service Broker messages.Will my sending service side application (permanent connected to thenetwork) keep retrying repeatedly to connect to the receiver?- Is retrying like that time consuming?.- I don't like it keeping trying over and over. Is retrying behaviorconfigurable?thx
View 2 Replies
View Related
Apr 24, 2008
i am new for SQL server report service, i have a project that need to generate report and integrate or shown on my window application,
so i have a few questions as follows:
1) do i need to add web reference ( report ) to my window application?.
2) how can i preview and print .rdl report within my window application?
3) how to automatically printer report? can this be done by within a store procedure or trigger or in window application?
ps: view reprot manager, ---- http://localhost/reportserver$SQLEXPRESS
ask me name & password? what name should i type in sa? or Administrator or ?
many thanks,
C
View 4 Replies
View Related
Jan 23, 2007
Hi,
Please excuse me if I get some terms wrong - I am not a developer!!
I am working for a company who has a requirement to interface to a customer to query for work. The customer has an established Web Services that it uses for external interfacing, these services are passive at their end, in that it will be my clients who initiate all the communications using SOAP, receiving responses in XML.
There are, as I see it, seven conversations.
Receiving Datasets
1. Requests All new Jobs - This will be a post to a HTP with a list of job numbers sent back, These jobs will then need to be polled from the same webservice.
2. Job Changes - existing jobs that have changed definitions (costs etc..)- simular to above
3. Job Changes - Appointment Times
Sending Datasets
1. Completed Jobs - one at a time
2. Cancelled Jobs
3. Appointments (I believe this is responses to 1 and 3 above)
4. Subsequent Jobs - new work derived from initial Job.
I believe the sending datasets will be one way only (ie POST).
I have suggested using Service Broker for this application, with a custom App sitting inbetween ServiceBroker and the Web Service to deal with the HTTP POSTS and GETS, and communicating with the Service Broker, posting to queues and reading from them.
Is this viable??
Many Thaks
Lawrenso
View 1 Replies
View Related
Aug 14, 2007
hi all,
i want to create a service broker application between two different instances.
can i achieve the dialog security and transport security with out using certificate?
like we can achieve the transport security using windows authentication (both the instances are in same domain).
so how to achieve the dialog security with out using certificates.
if any body has any link plz provide me.
Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!!!!
View 3 Replies
View Related
Apr 30, 2008
In SQL 2005, is this an acceptable (prefered) way to give an application account EXEC permissions for sprocs and funcs in a specific database?
CREATE ROLE db_executor
GRANT EXECUTE TO db_executor
And then of course assign my user to this role on the database level.
I am trying to get away from adding exec to every sproc "manually" and then of course also having to add exec for any new sprocs that get added into the database.
View 3 Replies
View Related
Nov 21, 2006
Hi all,
I use SQL Express 2005 with my application that is deployed to the customers with the ClickOnce technology.
Now I want to upgrade automatically the SQL Express to che customers deployed with the Service Pack1.
How can I automated this process?
Thanks,
Bonato Pierantonio
View 1 Replies
View Related
Aug 17, 2007
hi ,
i am creating a service broker application between two different instance.when i am initiating a dialog from the source my message remain in the sys.transmission_queue.but its transmission_status column is empty.
i attached the profiler with both source and target by including all the service broker event.
in my source profiler i am getting the error like -- Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'. with event Broker:connection
and in the target profiler error is --This message could not be delivered because the security context could not be retrieved. with event Broker:Message Undelivarible.
i have checked my port also using telnet with remotely and localy both working fine. i am using port no. 4001
and i have mentioned the port no. in the address of the route.
bt still getiing the error.
please help!!!!!!!!!!!
View 3 Replies
View Related
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
Apr 13, 2008
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
View 1 Replies
View Related
Sep 14, 2007
Hi,
I was going to use Sql compact 2005 with vs2005 and use merge replication with MSDE2000. Unfortunately I found out this isnt possible (only possible if I use SQL Server 2000)
Has I can replicate with MSDE2000 with Sql CE 2.0 the question is:
Can I use sql ce 2.0 with vs2005 and windows CE 5???
Do I use the same System.Data.SqlServerCe assembly?
I hope someone can reply to this.
Thanks,
Luis
View 7 Replies
View Related
Aug 23, 2006
I am running VS2005 Pro edition. I have downloaded, but not installed, SQL Express with Advanced Services SP1. Can I install it over the VS2005 version of SQL Express or do I have to do some install work?
Also, regarding the Books Online July version, must I do a clean install or can I just install it over whatever came with VS2005?
Thanks
View 1 Replies
View Related
Jun 23, 2007
Hi, i'm looking for SQL CE 3.5 for Visual Studio 2005. I am currently using SQL CE 3.1 and wish to use the System.Transactions support which has been included in v3.5.
I know Orcas includes v3.5 but i need to continue using VS2005. Is there an installer or similair so i can develop applications with SQL CE 3.5 with my current development environment? I see there is a new SQL CE sync installer which includes the 3.5 runtime files, however ideally i would like the sdk so i can use the dataset designer. Is it possible?
Thanks
View 8 Replies
View Related
Apr 4, 2006
Hello I opened vs2005,new->project->analysis services project ,clicked OK, then dragged a data flow task from the toolbox to the area ,after I double clicked data flow task it gave me error message as shown in the link , what is wrong?
[URL=http://imageshack.us][/URL]
F16 LĂ?GHTĂ?NĂ?NNNG
<edit> To remove the shouting </edit>
View 2 Replies
View Related
Nov 19, 2006
Hi, not sure I have should ask this in here or in the VS forums - but here goes anyway!
My vb app is written using VS2005 with an SQL database. I'm now distributing this to users to use with SQL Express.
It's hard enough explaining to them how to attach the database without going into the backup routines etc!
So what I'd like to do is to have a "backup" button in my app, that backsup the database, trancates the log files & then shrinks the files.
Is this possible?
View 14 Replies
View Related
Feb 13, 2008
I'm a newbie to both Windows Forms development and SQL Server CE, so please bear with me...
I am developing a vocabulary builder application, and my data keeps reverting to the data set I originally imported. I keep losing the records I've added using the application I'm developing, or from within VS2005. I know about the 'Copy To Output Directory' option in the Solution properties and I set this to 'Do not copy'.
What gives? Not sure what other information you might need, but I suspect it's something really basic...
Thanks!
View 9 Replies
View Related
Mar 4, 2007
When I try to add a new database to App_Data in a VS2005sp1 project I get "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user interface".
I have SQL2005sp2 and SQL Express on the system, both services are running, and an instance of the latter called SQLExpress which I can use through SQL Server Management Studio. sp_configure user instances enabled is set to 1. The SQL Server Instance Name in Options | Database Tools | Data Connections is set to SQLExpress ...
I have no idea how to proceed .. any ideas anyone?
Thanks
John
View 3 Replies
View Related
May 22, 2007
Hi all,
I hope I am on a suitable thread. Sorry if I'm not. I just need to know if I need a license in order to write a commercial application using Visual Studio 2005. And, if so, is this license necessary to me as a developer or to my customer that will purchase the application at the end?
And something more. ASP.NET runs on IIS, which is shipped with Windows Server, correct? So, once my customer purchases Windows, he doesn't anything more in order to run a ASP.NET application (which will finally access the SQL Server DBMS). Is this correct?
Thanks in advance
Lambros
View 1 Replies
View Related
Oct 24, 2006
Can someone explain the generated sprocs of VS2005 if one column can be nullableDependentOfSeqID = @Original_DependentOfSeqID OR ((@IsNull_DependentOfSeqID = 1) AND (DependentOfSeqID IS NULL))In VS2003 the generated sprocs would beDependentOfSeqID = @Original_DependentOfSeqID OR ((@Original_DependentOfSeqID IS NULL) AND (DependentOfSeqID IS NULL))Which is the best?
View 1 Replies
View Related
Dec 3, 2006
I am busy with handling connecting to Sql2000,It said some error occured while connecting to SQL2005.
But actually i am using SQL2000.Can somebody give me a solution ?
By the way,I am a greenhand.
View 4 Replies
View Related
Nov 7, 2007
Hi Guys,Have a strange problem at the moment on a page I am working on. Basicly there are 2 SQLDataSource Objects and 2 GridViews(I will call them GV1 and GV2 and DS1 and DS2 (GV = GridView and DS=SQLDatasource if you didn't guess)). Right the problem.... DS2 and GV2 don't display anything yet the SQL being executed is more or less the same.SQL from DS1 is
Code:
View 1 Replies
View Related
Feb 20, 2007
Can SOmeone help me How to get access BIDS from VS2005 . SQL server is installed in different server other than VS 2005 PC
View 1 Replies
View Related
Jan 28, 2007
Hello, Need help about which should be installed first.
Because I am trying to install SQL Server2005 the following message is comming.
Uninstall the previous versions of Visual Studio, .Net framwork or SQL Server..
I have no SQL Server so I unstalled the .net framwork. Now I have only Visual Studio 2005 Professional on my system, but the same message occurs when I try to install SQL Server.....uffff
I have to uninstall Visual Studio too????? And then have to install SQL Server first and then Visual Studio???
View 1 Replies
View Related
Aug 25, 2006
hi all,
I created a new sql server 2005 database name wsat_demo in the
(lESSQL1)sql2k5 enterprise server
in the default website properties i added a connection string named WSAT1 to wsat_demo database using aspnet_user account with SA priveledge
i modified the machine.config to use WSAT1 connection string
Then i run the WSAT (website admin tools) to create users.
this error appears. "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. "
i've tried attaching the database created by the asp.net project located at app_data folder named it App_data1 database
do the same configuration as stated above. Viola! the WSAT connects to it.
After comprehensive investigation, App_data1 database shows that it contains many security objects builtin to it by asp.net 2 application.
QUESTION: How can I have WSAT_demo database to have the same object as App_data1 given the fact that my connection is enjoying SA priviledge?
thanks,
joeydj
View 4 Replies
View Related
Jan 31, 2007
Hello,
I've created a database in VS2005 for my mobile app, but I can't figure out how to establish the table relationships. I'm not new to databases, but I'm new to VS. Any help is appreciated.
Thanks,
View 6 Replies
View Related
Apr 3, 2007
I have create an application with VS2005, but couldn't build the cab file as said in Books On Line: Build > Build CAB file.
So how can I build a package to deploy the application on my device with vs2005?
Thanks for helping me out.
jd
View 1 Replies
View Related
Oct 24, 2006
I have installed SSEv runtime and VS2005 SP1 but I can't make a connection to SQL Everywhere in Server Explorer. When I Add Connection I don't see Everwhere or Mobile in the list of Data Sources. Is there any way to make this work? Is there a different client for creating databases?
View 4 Replies
View Related
May 30, 2007
Neither the SQLManagement Studio nor Visual Studio 2005 will open a 3.5 database. I understand that it's a "Orcas" technology but it works fine with vs2005 and Framework 2.0. I'm currently using VS2005 with CE 3.5 and using Rafik's Sync services, support for 3,5 would be a great help for the XSD and query creation.
Does anyone know when broader support for 3.5 will be available?
View 5 Replies
View Related
Jun 24, 2007
I've had VS2005 installed for quite some time but I just purchansed SQL Server 2005 Developer and installed it. How do I accomplish integeration with SQL Server 2005 to VS2005? I had C# express at one point and SQL Express with the full tool install. That provided me with a designer for SQL Server (which was simply VS2005) and a seperate development environment under C# express. How do I integerate them so all the functionality resides within VS2005?
Any help you can provide will be much appreciated.
Thanks,
Dane R. Vinson
View 1 Replies
View Related