View Complete Post
I am attempting to use the 64-bit OLEDB Provider for Access found in the "Microsoft Access Database Engine 2010 Redistributable" to connect to and query an Access 2003 database that is on another server separate from my SharePoint server. I have not had
any success making the connection. My SharePoint server is Windows Server 2008 SP2 and I am running MOSS 2007 (patched up to the April 2010 CU)
Here is the connection info in my Application Definition XML:
<Property Name="AuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAuthenticationMode">RevertToSelf</Property>
<Property Name="DatabaseAccessProvider" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbAccessProvider">OleDb</Property>
<Property Name="rdbconnectionData Source" Type="System.String">\\server1\share1\Lessons.mdb</Property>
<Property Name="rdbconnectionProvider" Type="System.String&qu
I use in my ASP.NET MVC application repository pattern and I use in controller for example 3 models:
public class HomepageController : Controller
private IWebsitesRepository _repository_websites = new WebsitesRepository();
private IFirmRepository _repository_firm = new FirmRepository();
private IPhotosRepository _repository_photos = new PhotosRepository();
In WebsiteRepozitory, FirmRepository and PhotosRepository classes I have:
Database1Entities _entities = new Database1Entities();
So I have 3 connections to database ? Is it wrong ? How can I solve it ?
I created a new database with the help of Database Configuration Assistant !
I created with the scott account
Now i'm not able to connect to the database with the connect identifier with the scott account
The error i get is.,
Plz help !
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
MSDN Magazine August 2009
Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.
Alok Mehta and Daniel Williams
MSDN Magazine January 2002
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
I am using visual studio 2005 and sql server 2005.
I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:
<?xml version="1.0" encoding="utf-8" ?>
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
i have retrieved connection string property through configurationmanager class
and when i m connecting to database it gives me a runtime error:
Sql Exception was unhandled
System.Data.SqlClient.SqlException was unhandled Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located
I had successfully restored sql 2000 database to sql 2005. It works like charm
Now i am creating a database model in MVC
I follow these steps
Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name
But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error
"A network-related or instance-specific error while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.
Kindly help me with this
Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?
Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access
to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.
Regards, thanks for help.
when i open my central administation i get this error:
Cannot connect to the configuration database
Recently I have migrated my SharePoint BackEnd (Database) Server to new hard drive. The reason of migration was to deploy and configure real time database replication by
Symantec Veritas. After migration activity I was getting following error message
" cannot connect to the configuration database ".
But when I execute following steps, this errors message gone and everything got fine
1. Enable Named Pipe from SQL Server Configuration Manager >
Protocols for MSSQLSERVER
SQL Server (MSSQLSERVER) service (Note: This service was already running and status was set to automatic ) and
3. Start SharePoint Configuration Wizard
Now I need to know why every time I have to restart this service?
When I turned on my sharepoint server machines in the moring I have to restart this service ( SQL Server (MSSQLSERVER) otherwise same error message appears (cannot connect to the configuration database). After restarting this service everything
Any help in this regard will be greatly appreciated.
I'm trying to put a registration page together in Visual Web Designer.
I would like to send a confirmation Email after someone is leaving his registration data and pressing the INSERT button.
The key fields in my database are: Email, Name, Surname, Address
Before I send the confirmation Email I would like to check if the email value entered in the form is realy added to the database.
Please for help in this matter. I was copy past already some C code in my page, therefore it will be fine if the code can be in C.
Again, I need help to:
- checking if record is realy added to database after pressing INSERT button
- setup the confirmation Email
Thank you in advance.