.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error in attaching database file and creating a new connection

Posted By:      Posted Date: September 05, 2010    Points: 0   Category :ASP.Net
I am having problem when i was trying to attach .mdf file while create a new connection of SQL server, create a new connection of SQL database file and open the database in Server Explorer. I am using VS 2010 Ultimate and SQL Express 2008 R2.Can anyone please tell me what is the problem I am facing?Here are the error message.1. Attach .mdf in SQL database file and open the database in Server Explorer2. Create a new SQL server and attach .mdf

View Complete Post

More Related Resource Links

Creating Database gives error : "Directory lookup for the file "xxxxx.mdf" failed with the operating

Hello FriendsI am creating Database using SQLDMOcode is as follows... Code Snippet SQLServer2Class server = new SQLServer2Class();server.EnableBcp = true;server.Connect(WebConfigurationManager.AppSettings["ServerName"] ,WebConfigurationManager.AppSettings["UserName"],WebConfigurationManager.AppSettings["Password"]);DBFileClass dbFile = new DBFileClass();           dbFile.Name = dbName;          dbFile.PhysicalName = "C:\\" + dbName + ".mdf";          dbFile.Size = 300;          dbFile.FileGrowthType = SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB;          dbFile.FileGrowth = 25;          dbFile.PrimaryFile = true;          LogFile2Class dbLogFile = new LogFile2Class();          dbLogFile.Name = dbName + "_log";          dbLogFile.PhysicalName = "C:\\" + dbName + "_log.ldf";          dbLogFile.FileGrowthType = SQLDMO_GROWTH_TYPE.SQLDMOGrowth_Percent;          dbLogFile.FileGrowth = 10;          Database2Class newDb = new Database2Class();          newDb.Name = dbName;          newDb.FileGroups.Item("PRIMARY").DBFiles.Add((DBFile)dbFile);          newDb.TransactionLog.LogFiles.Add((_LogFile)dbLogFile);          server.Databases.Add((_Database)newDb); This Code Generates Following Error !!]Microsoft][ODBC SQL Server Driver][SQL Server]Directory lookup for the file "D:\Projects\my_system\mySys

Need Oracle Data Provider .CS File for Oracle 10g Database connection !



I need a 'Wrapper.cs' file which takes care of the Database connection ( Oracle 10g) where

i can just call the method with my SQL Query


Gridview1.DataSource = SampleWrapper.ExecuteDatatable("THE SQL QUERY");


Plz Post the link if there is any open source !    

SQL Server managment studio (Error occur Attaching a .mdf file )

An exception occur while executing a Transct-SQL statement or batch. (Microsoft.SQL server.express.Connection info)   Enable to open the physical file "E:\OutsourceProjects\shuja\MyProject_mdf\MyProject.mdf" (Operating System error 5: "5 (Access is denied.) " (Microsoft SQL server error E:5120)   Hello         I have an error while attaching a .mdf file to SQL server management studio,kindly solve my problem,i shall be very thankful. Thanks Regards Kh Hammad

Restoring 2008 Database with Filestream - Process cannot access file error

I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked. Did a trace with procmon, didn't see anything. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. I've run out of ideas on how to debug further. Looking up the error online wasn't much help either. Msg 3634, Level 16, State 1, Line 1 The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'X:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-0000aaa6-00f6'. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ' SQL Server 2008 SP 1, MS Server 2008 R2 Server

"Database schema could not be retrieved for this connection" Error using VWD 2010

After downloading VWD 2010 Express. I drag the SQL Data Source, When trying to establish any type of connection get the error below. I CAN connect using the OLE  (.NetFrame data provider for OLE DB work) but CAN NOT connect using (.NetFrame data provider for SQL server) I have VWD 2008 in another PC and work just fine. I did google and tried several solutions that other had with no luck. I know they were not using VWD 2010 but it was the same error. Again no luck with those solutions. If anyone can share it would be greatly apreciated! Thanks in advance!Jimmy "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. This server version is not supported. You must have Microsoft SQL Server 2005 or later."    

Database connection error

Hi,I am trying to connect to a database in visual studio 2008, and I get this error. The database 'C:\~\VISUAL STUDIO 2008\PROJECTS\~\APP_DATA\ASPNETDB.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.Could not open new database 'C:\~\VISUAL STUDIO 2008\PROJECTS\~\APP_DATA\ASPNETDB.MDF'. CREATE DATABASE is aborted.An attempt to attach an auto-named database for file C:\Users\Nick\Documents\Visual Studio 2008\Projects\myFacebook\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.This project was developed in VWD 2008 and I just installed visual studio. But the database gives this error. Anyway I can fix this?Thanks!

Error with database connection - API client not supported

I keep getting a weired alert on the SQL Server 2005 Box, I would appreciate if some one can assist me in this. However my application is running smoothly, just wondering if any of you have seen such an error 'Alert 1:  Critical Failure in log file for Monitor_DB: Monitor_DB: :__FAILURE__: error with database connection 'HOSTNAME\INSTANCE@master' with error message: API client not supported' I am not sure what API client is trying to connect, I have a BizTalk server which connects to the SQL Server box, and the connections and processing are going on smooth, but still I keep getting this error. Can anyone assist me. Thanks in advance.

how to attach sql database file to creating .exe setup in c#

I create a Setup file and put data folder, in data folder i put database file , but the problem is i have to mannualy attach database file in sql server 2005. I have to automatically attach database file when installing setup file.

VS2010 Deploying Database Project - Error: Cannot create file [...]MSSQL10.MSSQLSERVER\MSSQL\DATA\m

I had SQL Express from a previous installation of VS2010. I uninstalled All SQL and VS2010 and re-installed VS2010 (without Express) and then re-installed SQL Server 2008 Developer Edition. Now when I try to deploy a database project I am receiving the following error:     Creating EDDY.Cheetah.Database.Server... ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 5170, Level 16, State 1, Line 1 Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf' because it already exists. Change the file path or the file name, and retry the operation. ...\sql\debug\Server.sql(38,0): Error SQL01268: .Net SqlClient Data Provider: Msg 1802, Level 16, State 4, Line 1 CREATE

An error occurred within the report server database. This may be due to a connection failure, timeo



I can't get Reporting Services to work with Sharepoint.

I've followed the instructions for installation of Reporting Service in SharePoint Integrated Mode, and completed the indicated steps on the SharePoint Central Administration Site successfully.  When I try to create a page with a Reporting Services Webpart, I get the following error:


Invalid object name 'History'.
An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)


I have SQL 2008 R2, SharePoint Enterprise 2010, and Report Builder 3.0.  SQL and Sharepoint are installed on the same server.

I'm certain that there isn't a disk or timeout problem, so I'm assuming that it's a connection failure, but don't know what steps to take to troubleshoot and correct this.


Need to restore MDF or LDF file from BAK without creating database.

I need to restore the actual MDF or LDF files within a BAK file without creating/restoring to another database. I just need the physical MDF or LDF files only. Is there a way to do this?
What is not explicitly allowed should be implicitly denied

Getting connection error to a database when page loads...occasionally...


So occasionally after a run to the database I am getting the following error;

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

It always happens after this query is executed during a page Load:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        myconnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True")
        myda = New SqlDataAdapter("Select * from diaryDates", myconnection)
        myda.Fill(ds, "diaryDates")
    End Sub

What does the error mean and how can I resolve it ?

DataBase error - An attempt to attach an auto-named database for file ...


I m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:

 An attempt to attach an auto-named database for file C:\Users\malek.safa\Documents\test vb\SavingFileInDB\SavingFileInDB\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.


 m not getting errors inside my code, just this one appearing on the web page. any idea? thanks

Error in Creating a Sharepoint Configuration Database on a SQL server 08 during installation


I have a three server environment – T1 – a domain controller and T2 and T3 for SharePoint  and SQL Server 08 and respectively, where each is a virtual machine.


These servers are on a domain separate from our company domain.

While installing sharepoint on t2, I get the following error at the step that creates a config database (on T3 SQL Server)



  Failed to create the configuration database.

An exception of type System.SystemExcep

Error while creating subscription from the backup file






='marcus8-test', --> Name of the publication



Error when creating Issues Web Database: The formula contains a syntax error or is not supported.



I have been trying to create an Issues Web Database on one of our MOSS 2010 servers, but I keep getting the error "The formula contains a syntax error or is not supported" when I try to. I have tried this on one of our other 2010 environments and it works fine but for some reason it happens just one this one.

In the error logs I found this:

Error updating field: List: Issues, SchemaXml: <Field DisplayName="OpenedDate" Type="DateTime" Required="TRUE" Format="DateOnly" xmlns="http://schemas.microsoft.com/sharepoint/soap/" Name="OpenedDate"><DefaultFormula>=TODAY()</DefaultFormula><DefaultFormulaValue></DefaultFormulaValue><Validation Message="Value must be greater than 1/1/1900.">=OpenedDate&gt;=DATETIME(1900,1,1,0,0,0)</Validation></Field>. Exception: Microsoft.SharePoint.SPException: The formula contains a syntax error or is not supported.

Does anyone have an idea as to what the cause might be?


Error creating package - Failed to save package file



I have Windows Server 2008 R2. I had just installed SQL 2008 SP1 Dev Ed. on my box and got an error message when I tried to create a package using the BI IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again. 

Following is the text of the error details:


Error creating package (Microsoft Visual Studio)


Failed to save package file "C:\Users\<UserName>\Local Settings\Temp\2\tmp8C4E.tmp" with error 0xC020207E "The file name is not valid. The file name is a device or contains invalid characters.".

Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
   at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.SaveToTempFile(Package package)
   at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.AddPackageToProject(Package package, String itemName)
   at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.CreateAndAddPackageToProject()
   at Microsoft.DataTran

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend