Operating On .xls File
Oct 23, 2007
Hi All,
I am working on a server movement work.The application is moving from sql server 2000/windows 2000 to sql server2005/windows 2003.I have a DTS package including some stored procedures which operates on the sql server.
I am using xp_cmdshell for copying and deleting excel files.And I am using microsoft.jet.4.0 to fill the excel file with data from a temp table.
The dts goes fine but it is not copying the excel template from one location to other.Again while deleting the 2 months old file i got an error saying cannot delete the files.
It was running correctly in sqlserver 2000.I have enabled the xp_cmdshell feature in the configuration.
Please help me and suggest me.
Thanks
View 4 Replies
ADVERTISEMENT
Sep 5, 2006
I have used the copy database wizard, but I realized I had forgotten to shrink the transaction log file. So I canceled the wizard. My database, detached by the wizard, has now disappeared. The mdf file is still there, but when I try to attach it manually I get the "create file encountered operating system error 5 while attempting to open the physical file..." error.
Any way I can recover it?
Thanks.
View 4 Replies
View Related
Dec 21, 2006
Hi,
I am facing a problem on a server which has raid 5 solution (3 disks), the raid controller went down 2 of the disks were off in the Bios.
We added the 3 disks to a different server identical in brand and architecture, the raid controller was able to reconfigure the virtual drive H:.
All files were there, we installed sql server 2005 on the new server, but when we tried to attach the database we got the error below:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'myserver'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x00000000af0000 in file 'C:Datamylog_log.LDF'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Operating system error 38(Reached the end of the file.) on file "C:Datamylog_log.LDF" during ReadFileHdr.
Could not open new database 'mydb'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 823)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=823&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I tried the following steps but it always failed:
- create a new db with the same name of the lost db;
- put the db in emergency mode;
- stop sql service and replace the mdf file;
- start sql service;
- Run Dbcc checkdb('mydb')
we got the error below:
Msg 945, Level 14, State 2, Line 1
Database 'ism0506' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Any HELP please ?
Thanks,
Tarek Ghazali
Sql Server MVP
View 5 Replies
View Related
Apr 10, 2001
I need to interrogate the date/time stamp on a network file. Any suggestions?
View 1 Replies
View Related
Feb 27, 2008
Is there any idea regarding query to delete any operating system file from sql server.
Basically i want to delete temp files in tmp folder of Windows.
-----
sim
View 3 Replies
View Related
May 9, 2006
Hi.. !!
I am working in a C# database application quick test where I basically use two types of access to an SQL Server Express database.
In the first part of the code, I use the traditional connection declaring a SqlConnection. When I just use only this kind of connection I do not have any problem. The issue starts when I access to the same database using Data Bindigs at the same time. When I start the application I got and error as soon as the instruction goes to open the data base connection.
The reported error is "Unable to open the physical file "<Niños.mdf>". Operating System Error 32: (Process does not have access to the file because is being using by another process)"
For additional information my connection string is:
"Data Source = localhost\SQLExpress; Initial Catalog = Niños; Integrated Security = True; User Instance = false"
Does anyone have any idea on how to solve this problem?
Thanks
Alfredo.
View 1 Replies
View Related
Nov 6, 2015
I am trying to attach a database. But I am receiving below error:
Unable to open the physical file "D:databasepc.mdf". Operating system error 5: "5(Access is denied.)".
I have added service accounts to administrator group.
I have provided full control to service account on the D drive and on the .mdf file also.
My self has full permissions on the drive and .mdf file, and I am in administrator group.
Restarted the SQL Server services.Still same error.
View 9 Replies
View Related
Apr 16, 2008
I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.
I get the following message: Unable to open physical file "C:ArrowSQLArr@DataArrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".
I have loaded SQL and the database fiel and directory with the same user account which is a local administrator on this machine. I have checked that I have read/write access to the file.
The machine runs Windows Vista Business. SQL has SP 2 loaded. What causes this?
View 56 Replies
View Related
Feb 22, 2008
I had few databases developed in SQL Server 2005 Developer Edition. I have detached all the databases and stopped developing anything new other than taking reqular backup of detached .mdf and .ldf files. I installed Vista on the other Hard drive that corrupted my XP installation drive letters so I had to reinstall XP OS. I have reinstalled SQL 2005 Dev edition. Now I am trying to attach the database it is giving error of Operating system error 5: "5(Access is denied.)". I tried to copy those .mdf and .Ldf files through windows explorer and it is not letting me copy past in the other place. I am getting Access denied from OS. I have about 5 databases and only one has this problem.
What is going on and how do I solve this? Is the OS has locked the file? My home computer is not in a domain. I tried to right click the file to see if I can set access permission on the file. There is no such security options. Any help is appreciated.
Thanks,
Vijay
View 1 Replies
View Related
Oct 24, 2007
Hi,
We have a very severe issue in our production, and this is very very ugent to fix this issue, there was a job started on server on 10th October, 2007, for backup of database of 3.2 TB, which caused this issue on 18th October, 2007.
I cancelled that job and even restarted the server, but still there is same issue on the server.
I am using this command to expand the physical file,
ALTER DATABASE [ODS] MODIFY FILE ( NAME = N'ODSFG33File1', SIZE = 307200000KB )
Error:
MODIFY FILE encountered operating system error 1450(Insufficient system resources exist to complete the requested service.) while attempting to expand the physical file.
Server:
64bit Itanium Server with 4 Processors
4TB of SAN Storage
24GB of RAM
MS Windows 2003 Enterprise Edition with SP1
MS SQL Server 2005 (9.0.3152) Enterprise Edition with SP2
Database:
3.2 TB Size of Partitioned Database with 60 File Groups
Every File Group contains One month data in its only one physical File.
Physical Files are of different size between 10GB and 300GB.
Kind Regards,
Muhammad Imran.
View 8 Replies
View Related
Jan 23, 2007
I am facing a issue with bulk upload on Test Server.
Issue: When running Openrowset command from SQL server other that Test Server query runs fine when trying to run the same command from Test Server it gives error.
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because the file "\ServerNameinputFileName.csv" could not be opened. Operating system error code 5(Access is denied.).
For example: If the command is run from System A connecting to SQL Server instance on Test Server Test Server it gives this error. If the same command with same rights is run from any other SQL server instance say Dev1 its running fine.
If the command is run from Test Server connecting to any SQL Server instance including Test Server it is running fine.
Tried: 1) Given the read/write rights on shared folder, to user under which the SQL server service is running on Test Server
2) Given the read/write rights on shared folder to everyone.
Query:
SELECT DISTINCT * FROM OPENROWSET
(
BULK '\ServerNameinputFileName.csv',
FORMATFILE='\ServerNameFormat.xml'
)
AS FileList
Please provide me with some solution. What can be the reason for such behaviour?
View 22 Replies
View Related
Aug 25, 2007
Hello,
We are trying to attach a database in Sql Server 2005 Express on Windows Vista.It will Show the following Error.
"Unable to open the physical file "Test.mdf". Operating system error 5 :". And then we installed the SQL Server 2005 Service pack 2. This error again comes.Could you please give me the steps to resolve the problem.
Thanks,
Mahesh
View 2 Replies
View Related
Dec 3, 2007
Hello all,
I am running into an interesting scenario on my desktop. I'm running developer edition on Windows XP Professional (9.00.3042.00 SP2 Developer Edition). OS is autopatched via corporate policy and I saw some patches go in last week. This machine is also a hand-me-down so I don't have a clean install of the databases on the machine but I am local admin.
So, starting last week after a forced remote reboot (also a policy) I noticed a few of the databases didn't start back up. I chalked it up to the hard shutdown and went along my merry way. Friday however I know I shut my machine down nicely and this morning when I booted up, I was in the same state I was last Wenesday. 7 of the 18 databases on my machine came up with
FCB:pen: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred while creating or opening file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf'. Diagnose and correct the operating system error, and retry the operation.
and it also logs
FCB:pen failed: Could not open file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf for file number 1. OS error: 32(The process cannot access the file because it is being used by another process.).
I've caught references to the auto close feature being a possible culprit, no dice as the databases in question are set to False. Recovery mode varies on the databases from Simple to Full. If I cycle the SQL Server service, whatever transient issue it was having with those files is gone.
As much as I'd love to disable the virus scanner, network security would not be amused. The data and log files appear to have the same permissions as unaffected database files. Nothing's set to read only or archive as I've caught on other forums as possible gremlins. I have sufficient disk space and the databases are set for unrestricted growth.
Any thoughts on what I could look at? If it was everything coming up in RECOVERY_PENDING it's make more sense to me than a hit or miss type of thing I'm experiencing now.
View 13 Replies
View Related
Mar 22, 2006
HI ,
This is a problem I encountered when I had to detach a database file (type .mdf):
1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.
2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful
3) However when I tried reattaching the database file, I got this error:
CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "CProgram FilesMSSQL ServerMSSQLData<databasename>.mdf'
Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?
Thanks much
Tonante
View 42 Replies
View Related
Sep 18, 2002
I have created a VB 6.0 application that reads data from old db files into the SQL Server 2000 database using DTS stored structure files.
The application works fine with Windows NT but I keep getting an error in Windows 2000 environment.
"-2147220441(80040427) Execution Canceled By User"
Any ideas why?
View 1 Replies
View Related
Sep 13, 2001
Hi,
How can I run operating system command like "DIR" in a stored procedure?
Thanx
View 1 Replies
View Related
Jun 12, 2008
I currently run SQL Server 2005 64-bit Developer Edition (Service Pack 2 - it will be SP 3 as soon as I can get hold of it). I am running this on a stand-alone box with Windows Server 2003 as the OS.
Soon, I will be buying another computer for a colleague who will be running SQL Server as specified above. However, I am not happy with Windows Server and am wondering about changing to either XP 64-bit or Vista 64-bit. The machine will not be networked.
I would welcome advice on this since, in some ways, I would be happy enough to use XP or Vista, and think that 64-bit development is more likely on Vista than on other Windows OS's. However, I am not convinced that SQL Server 2005 works with Vista and, like everyone else, have heard plenty of complaints about Vista.
All advice gratefully received.
Thanks.
Chris
View 5 Replies
View Related
Sep 10, 2007
Hi SQL TEAM
Can someone please assist, we have a Database roughly 10GB in size,
For the past 2 days now we get the following errors.
////////
FCB::Open failed: Could not open file D:MSSQL.1MSSQLDataHelpdesk.mdf for file number 1. OS error: 32(error not found).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
////////
FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'D:MSSQL.1MSSQLDataHelpdesk.mdf'. Diagnose and correct the operating system error, and retry the operation.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
////////
Can someone tell me what is causing this error?
View 4 Replies
View Related
Jan 25, 2008
What are the advantages and disadvantages of installing 32-bit SQL server 2005 editions on 64-bit operating system?
1) Does odbc drivers have any problems
2) Memory issues
Have anyone been in this situation. Expert advice will be appreciated.
View 1 Replies
View Related
Jul 23, 2005
I have code that instantiates a sqlserver object and starts a job. Ihave used this on numerous XP workstations successfully, when I triedto move this to a Windows 2000 Application Server attached to a SmallBusiness Windows 2003 network and run the code, I am receiving theerror:Automation Error. The Operating System Cannot Run %1.(Error Number -2147024714)The following is a code snippet:*********Dim app As New SQLDMO.ApplicationDim oSQLServer As New SQLDMO.SQLServerDim oJob As SQLDMO.JoboSQLServer.LoginTimeout = 30 ' ERROR OCCURS HEREoSQLServer.LoginSecure = True**********The code fails when setting the LoginTimout parameter. The SQLDMO.dllhas been registered successfully on the server.Any ideas whey the behavior of this code is different on my applicationserver vs the client workstations on the network?ThanksMike G
View 2 Replies
View Related
May 14, 2007
Are there any restrictions in the restored database after database mirroring?
I mean, Is it full mirror of my primary database?
What I want to do:
If my machine A(with primary database) will down I will redirect my clients to a real-time copied database - mirror server. I don't want to create cluster, but I want to use database mirroring function in ms sql 2005.
Can I use DB Mirroring to solve my problem?
p.s. sorry for my english
View 1 Replies
View Related
May 21, 2008
We were installing SQL Express 2005 on a Vista machine. This PC has a 64 bit CPU and a 64 bit Vista operating system. I know that we need to use WOW 64 to run SQL Express 2005. My question is how do I turn on WOW64 so I can run SQL Express 2005
Vista
Thank you,
Photomultiplier
View 5 Replies
View Related
May 1, 2000
How to insert or retrieve images type data in sql server?I want to put a jpeg file in sql server.How can I accomplish that?>How to input into the table and how to retrieve that from the table
I have a table contacts.The fields are
ID int
Name Varchar
Photo Image
Can anyone help me with this?
View 1 Replies
View Related
Sep 11, 2003
Hi, who have ever met the following errors, share an information of what could cause it??? I can't find any info that could help me find the reason. My DB went to SUSPECT mode and in the log file I got:
ForwardLogBlockReadAheadAsync: Operating system error 997(Overlapped I/O operation is in progress.) encountered.
Operating system error 997(Overlapped I/O operation is in progress.) on device 'd:MSSQLdataiservice_Log2.ldf' during ForwardLogBlockReadAheadAsync.
Error: 3414, Severity: 21, State: 1
Error: 9001, Severity: 21, State: 1
Unexpected error while commiting a ShrinkFile operation
/*************************/
What is weird the 997 error occured twice during last night and the DB went into suspect mode only after the sencond one.
The database restored but it's a second time for the last month just getting a bit annoying.
Thanks for any help
Dim
View 5 Replies
View Related
Sep 19, 2006
ARIAL
HOW can you view operating system of the sql server 2k??
View 2 Replies
View Related
Apr 19, 2006
Hi
Im trying to run dtsrun twice in one OSC job step e.g.
DTSRUN /F "path to dts package" /E
DTSRUN /F "path to dts package2" /E
Im finding that it always runs the first line but never the second. I tried swapping the lines around and it then runs the other because tht is the first line. Again the second line won't run.
Am I trying to do something that isn't possible?
Neil.
View 4 Replies
View Related
Jul 10, 2006
Hi All,
Iam using HP iPAq hw6500 series PDA. My application in installed in the PDA and when i try to open the application by taping on the application icon, Iam getting the following error.
Error: 0x80004005 E_FAIL
Native Error: (25080)
Description: The operating system does not support encryption. [,,,,,]
Interface defining error: IID_IDBInitialize
Param. 0: 0
Param. 1: 0
Param. 2: 0
Param. 3:
Param. 4:
Param. 5:
The application is builded on embedded VC++4.0
Can anyone help to figure out the possible reason for this error?
Thanks & Regards
Rajeev
View 5 Replies
View Related
Sep 27, 2007
Hi,
We are using SQL Server Compact Edition v3.1. We have 2 users running on Windows XP with Service Pack 2, who are getting errors that the Operating System does not support encryption when creating a new database. The problem is not with the code, one of the users installed the same software on a different Windows XP system and the software operates correctly. We also have many other installations that are working properly as well, so it appears to be something specific to these 2 computers.
We've had the user try repairing their .NET Framework 2.0 install, in addition to confirming that the
Crypt32.DLL and CryptUI.DLL dependencies are both present and of the correct version in WindowsSystem32. We've also verified that the users do have write access in the directory we are trying to create the database.
Is there something we can do to fix encryption on these users systems or something the users may have done to disable encryption?
Thanks
View 4 Replies
View Related
Apr 28, 2008
Hi Folks,
I'm just learning Transact-SQL, so pardon if this is a dumb question. I would like to perform operations on neigboring rows in a database table column, and I have no idea how to do this. Say I have the following table:
Date (smalldatetime) | Value (money)
date1 | value1
date2 | value2
...
dateN | valueN
What I would like to compute is:
average(value2 / value1, value3 / value2, ..., valueN / valueNminus1)
How would I pose this as a transact SQL statement?
Thanks,
Adam Cataldo
(If it helps, I'm running SQL Server Express 2005)
View 4 Replies
View Related
May 13, 2002
Does SQL Server 7.0 work with the Windows 2000 operating System?
Thanks you for your help.
Regards,
Mark
View 1 Replies
View Related
Mar 22, 1999
hi, I am working on SQL server 6.5 using a desk top. Now I am about to buy a note book and do some development work. As far as I know, win 95,98 does not support SQL server 6.5
But SQL sever 7.0 does support win 95,98 Am I correct?
I am confuzed, what notebook operating system shall I buy which will allow me to work on sql development on the road.
another issues is what if I choose to use win 98 for sql server 7.0 what are the things that I will be missing . In other word, what are the limitation that I may have when acquiring win 98 as an operating system for sql server 7.0..
thanks for your advice
regards
Ali
View 5 Replies
View Related
Apr 11, 2007
Hi there. Could someone help me out.
I'm performing a log restore and getting the following error within the SQL Server Error Log.
During restore restart, an I/O error occurred on checkpoint file 'G:MSSQL.1MSSQLBackupdxsh.CKP' (operating system error 1784(error not found)). The statement is proceeding but cannot be restarted. Ensure that a valid storage location exists for the checkpoint file.
IT's a very basic Restore command and i do have not specified it to Restart.
Having checked the MS website for 1784 it suggests the following:
The supplied user buffer is not valid for the requested operation
Can anyone tell me what is wrong here and why it is creating a checkpoint file or even what it is and how to overcome the error message.
TIA
View 12 Replies
View Related
