I have MS SQL Server2005 enterprise edition. And MS VS.NET 2008. And have IIS 5.0 (which is available in XP professional). Now I want to run .net web application in our intranet (LAN). But I can't access database. Only static pages remain ok....but can't invoke database
View 16 RepliesCan we perform Database connectivity without using ado.net?
Can we create our own architecture to connect to database?
I'm just starting development on a new website and am trying to do it correctly, that is, with a DAL and not with queries in code which I had before. I understand the principles of it all, but I am finding this DAL with table adapters and wizards that do too much to be really messy to work with. Does anyone have any recommendations on what I should be using instead and a link to a tutorial on how to get going quickly with it?
View 5 RepliesI have Visual Studio.When a create a new ASP website (so not a project), I can go to the configuration management and enable roles and an aspnetdb.mdf is automatically created in the app_data directory.When I create a new ASP (MVC 3) project, the configuration management says: can not load MvcApplication1.MvcApplication .Is there some configuration setting for this?
View 3 RepliesHow to create a JSON webservice in ASP.NET that connect to MS SQL Database and update/delete values from the database?
This webservice will eventually be used to communicate with iPhone SDK.
I am working on an asp.net (or winforms) app that is supposed to detect wifi connectivity and strength. The intention is to provide the field agents with an indicator that they can connect to our main office
What would I need to detect wifi connectivity?
Is it possible to integrate Nokia connectivity API with asp.net? If so, How to get started?
View 1 RepliesI'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 Repliesi would like to ask about how to sync data from client sybase database import to our sql server database regularly(set time to sync everyday) by create a file in our sql server database
View 1 RepliesI have a development database and one in production. There are two different sets of data in each database. On my dev system, I have mostly dummy data that I test with and in production is the real data for my web application. I recently added a new feature to the app that required a new table, and a new field for a foreign key in an existing table. I now need to upload that new structure to the production database without overwriting the live data with my test data.
If I run the Database Publishing Wizard, and choose "Schema Only" will it import the new structure and leave the existing data alone, or will it drop the records in my production database tables?
I am not able to use
String connectionString = ConfigurationManager.ConnectionStrings["DevBackup"].ConnectionString;
I am getting error 'The name 'ConfigurationManager' does not exist in the current context' I have used namespaces
using System.Data.SqlClient;
using System.Data.Sql;
what should be done..?
I have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 RepliesI have a dropdownlist which is connected to object data source for displaying data, now what I need is to connect to database using semicolon seperated list from web.config connection strings and then connect that to dropdownlist.
View 5 RepliesI have an asp.net3.5 app. It has multiple client folders in the root folder. There are multiple web.config files. One is in root folder and one each in client folder. The web.config in client folder contains connection string for the database to be connected. I am using FORMS authentication. Each client has a specific page which are lying in root folder. This page redirects to the client specific folder and user logs in the application using the one more login page which is in client folder. And this page uses the connection string which in this client specific folder web.config.Now my problem is that I am not able to connect to the database using the client specific web.config on my live server. Live server is a Windows 2008 Datacenter and IIS7 machine. And my local system is XP IIS6 machine.Please help me to resolve this issue. Or how can I configure my application on IIS 7 &Win2008 DC system in WINDOWS authentication mode?
View 2 RepliesIve integrated a custom asp.net web application into a Sharepoint site by creating a virual directory, that contains my web app files, that points to a directory in the Sharepoint inetpub folder.
On my local dev server I can access all my web app pages just fine by typing in /virtualdirectoryname/page.aspx
My Problem is that: When I deploy to my Live Test server that is internet facing, none of the pages that make a MS-Access database call will work.
The Error I receive is '[SecurityException: Request for the permission of type 'System.Data.Odbc.OdbcPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]'
I have researched the issue online and tried numerous solutions which include giving all the assemblies in my application a strong name, and modifying the security policy to trust this strong name.
My Custom Web App consists of 2 projects
1. A Class Library Project (Data Layer)
2. A Web Application Project (Web Layer)
My .mdb database file is stored at root level within the Virtual Directory.
I have 1 class in the Data Layer (ClassConnect.cs) that when instantiated, creates the ODBC connection for all other pages to use (OdbcConnection dbConn = new OdbcConnection();)
I have a Connection String stored in the web.config file that is as such. When I deploy to the Live Test Server I change the path in this connection string, because I haven't figured out yet how to get a relative path that works.
I also place the dll's for my 2 projects in the Sharepoint bin folder.
Could anyone suggest what might be the dfference between my Local Dev Server and the Live Test Server and why I might be getting these errors.
what code should i write in web.config for the connection string for DB connectivity woth ado.net component??
View 2 RepliesI have added a web reference using the wsdl file that was provided to me. I also created an instance from the proxy class as follows :
Code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim DLObj As New WebReference.DrivingLicenseInfoServiceService
But after this am totally confused on the next steps and how to pass username and password and test the service connectivity.I have attached the autogenerated code.
First off, I am just getting started with ASP.NET so I expect this is something that I am doing.
i am trying to make a connection to a MS SQL database on my local machine.
I have the following in web.config
[code]....
when I make restore to backup database display this error :
The backup set holds a backup of a database other than the existing 'elib' database. (Microsoft.SqlServer.Smo)
how I can solve this error ?
This is a very common error as evidenced but the very large number of problems and suggested solutions on the web. I finally got around it last week but can't remember what was the step that did it. At that time, I was building a web application rather than a web site. Is that the difference? As you can see, it is no longer in the APP_DATA folder and is named membership.mdf rather than aspnetdb.mdf. I ran aspnet_regsql.exe to create it and actually had it working and was updating it successfully. But for other reasons, I had to scrap the application and decided to re-create it from scratch as a web site rather than a web application. I had been using Visual Studio 2008 to build the web application but am now using Visual Web Developer 2008 Express Edition to build the web site. Unfortunately, the Visual Studio application will no longer open so I can't verify that the web application still works. Can anybody help? (Please!!!) BTW, ASPNET and NETWORK SERVICE both have full control over the membership.mdf.
View 1 RepliesI use VB.net and use sql database. My database' name is database.mdf. I create one button and one textbox controls. When put some words in the textbox and click button, the words will recorded in to database.mdf. How can I do it? If I put a paragraph of sentence maybe 1000 words, is it also ok?
View 1 RepliesI have multiple database running in my SQL Sever , in that I need to lock only one database is there is any inbuilt method in SQL Server 2008
View 1 RepliesI have a bunch of views in my database that I want to use in my application. What's the best (fastest and/or easiest) way to use these? I'm using a sql server database.
View 5 Replies