I am attempting to install the MS SQL Server Desktop Engine. I have the
MSDE2000A.exe file and it unpacks successfully. I then run the setup and get
an install fail with the following:
Install message:
Setup failed to configure the server. See the server error logs and setup
error logs.
The only server error log I can find sez the following:
2005-02-11 14:09:52.11 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
server Copyright (C) 1988-2002 Microsoft Corporation.
server All rights reserved.
server Server Process ID is 2716.
server Logging SQL Server messages in file 'C:\Program Files\Microsoft
SQL Server\MSSQL\LOG\ERRORLOG'.
server SQL Server is starting at priority class 'normal'(1 CPU detected).
server SQL Server configured for thread mode processing.
server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock
Owner Blocks.
spid3 Warning ******************
spid3 SQL Server started in single user mode. Updates allowed to system
catalogs.
spid3 Starting up database 'master'.
server Using 'SSNETLIB.DLL' version '8.0.766'.
spid5 Starting up database 'model'.
spid3 Server name is 'BART9550'.
spid3 Skipping startup of clean database id 5
spid3 Skipping startup of clean database id 6
spid3 Starting up database 'msdb'.
spid5 Clearing tempdb database.
server SQL server listening on Shared Memory.
server SQL Server is ready for client connections
spid5 Starting up database 'tempdb'.
spid3 Recovery complete.
spid3 SQL global counter collection task is created.
spid3 Warning: override, autoexec procedures skipped.
spid3 SQL Server is terminating due to 'stop' request from Service
Control Manager.
The application event log sez:
Event Type:Warning
Event Source:MSSQLServer
Event Category:(8)
Event ID:19011
Date:2/11/2005
Time:3:22:01 PM
User:N/A
Computer:BART9550
Description:
The description for Event ID ( 19011 ) in Source ( MSSQLServer ) cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be able
to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event:
(SpnRegister) : Error 1355.
Also another entry sez:
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:2/11/2005
Time:3:22:00 PM
User:N/A
Computer:BART9550
Description:
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be able
to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event: 17834,
Using 'SSNETLIB.DLL' version '8.0.766'.
How do I get this install to work as I have an application that requires SQL
desktop.
Thanks...
Read the readme files that come with MSDE. You can't just run the setup.exe
with no parameters an expect to install SQL Server exactly like you would
like it configured. MSDE a developer's tool so act like a developer and do
some investigative work before trying to install it.
Jim
"BartC" <BartC@.discussions.microsoft.com> wrote in message
news:555AF044-A697-401C-8D08-0121BCFAFDD4@.microsoft.com...
>I am attempting to install the MS SQL Server Desktop Engine. I have the
> MSDE2000A.exe file and it unpacks successfully. I then run the setup and
> get
> an install fail with the following:
> Install message:
> Setup failed to configure the server. See the server error logs and setup
> error logs.
> The only server error log I can find sez the following:
> 2005-02-11 14:09:52.11 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
> server Copyright (C) 1988-2002 Microsoft Corporation.
> server All rights reserved.
> server Server Process ID is 2716.
> server Logging SQL Server messages in file 'C:\Program Files\Microsoft
> SQL Server\MSSQL\LOG\ERRORLOG'.
> server SQL Server is starting at priority class 'normal'(1 CPU
> detected).
> server SQL Server configured for thread mode processing.
> server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock
> Owner Blocks.
> spid3 Warning ******************
> spid3 SQL Server started in single user mode. Updates allowed to
> system
> catalogs.
> spid3 Starting up database 'master'.
> server Using 'SSNETLIB.DLL' version '8.0.766'.
> spid5 Starting up database 'model'.
> spid3 Server name is 'BART9550'.
> spid3 Skipping startup of clean database id 5
> spid3 Skipping startup of clean database id 6
> spid3 Starting up database 'msdb'.
> spid5 Clearing tempdb database.
> server SQL server listening on Shared Memory.
> server SQL Server is ready for client connections
> spid5 Starting up database 'tempdb'.
> spid3 Recovery complete.
> spid3 SQL global counter collection task is created.
> spid3 Warning: override, autoexec procedures skipped.
> spid3 SQL Server is terminating due to 'stop' request from Service
> Control Manager.
> The application event log sez:
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 2/11/2005
> Time: 3:22:01 PM
> User: N/A
> Computer: BART9550
> Description:
> The description for Event ID ( 19011 ) in Source ( MSSQLServer ) cannot be
> found. The local computer may not have the necessary registry information
> or
> message DLL files to display messages from a remote computer. You may be
> able
> to use the /AUXSOURCE= flag to retrieve this description; see Help and
> Support for details. The following information is part of the event:
> (SpnRegister) : Error 1355.
>
> Also another entry sez:
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 2/11/2005
> Time: 3:22:00 PM
> User: N/A
> Computer: BART9550
> Description:
> The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be
> found. The local computer may not have the necessary registry information
> or
> message DLL files to display messages from a remote computer. You may be
> able
> to use the /AUXSOURCE= flag to retrieve this description; see Help and
> Support for details. The following information is part of the event:
> 17834,
> Using 'SSNETLIB.DLL' version '8.0.766'.
> How do I get this install to work as I have an application that requires
> SQL
> desktop.
> Thanks...
|||Hi Jim,
Thanks for the put down. Most appreciated.
I am not a developer. I am simply a computer user trying to use a program
that requires MSDE. And, I did not think that MSDE was a developer tool,
but simply a db engine that apps could plug into. But clearly you know more
than I.
And, with a little research by this end user I switched on no back out so I
could read the install log, and I supplied the setup.ini file with the
following:
BLANKSAPWD=1
SQLSecurityMode=SQL
By stopping the back out I now have SQL server running. but can not install
ODB connectivity drivers. ODBC 2.8 install was attempted in safemode.
Thanks Jim,...
Looking forward to your next put down.
BTW, I was directed to this forum by MS support as the place to receive help.
"Jim Young" wrote:
> Read the readme files that come with MSDE. You can't just run the setup.exe
> with no parameters an expect to install SQL Server exactly like you would
> like it configured. MSDE a developer's tool so act like a developer and do
> some investigative work before trying to install it.
> Jim
|||I'm sorry, my comment was most inappropriate. I'll try to help you with your
problem any way that I can.
If MSDE is running then MDAC (and the ODBC drivers) must already be
installed - SQL Server can't run without it.
I find it surprising and disappointing that the application you are trying
to install, that requires MSDE, does not make the installation of MSDE
seamless to you. What is the name of the program you are trying to install?
Jim
"BartC" <BartC@.discussions.microsoft.com> wrote in message
news:931E2080-068B-4120-BCC8-5F548C5C5B79@.microsoft.com...
> Hi Jim,
> Thanks for the put down. Most appreciated.
> I am not a developer. I am simply a computer user trying to use a program
> that requires MSDE. And, I did not think that MSDE was a developer tool,
> but simply a db engine that apps could plug into. But clearly you know
> more
> than I.
> And, with a little research by this end user I switched on no back out so
> I
> could read the install log, and I supplied the setup.ini file with the
> following:
> BLANKSAPWD=1
> SQLSecurityMode=SQL
> By stopping the back out I now have SQL server running. but can not
> install
> ODB connectivity drivers. ODBC 2.8 install was attempted in safemode.
> Thanks Jim,...
> Looking forward to your next put down.
> BTW, I was directed to this forum by MS support as the place to receive
> help.
> "Jim Young" wrote:
>
|||"Jim Young" wrote:
> I'm sorry, my comment was most inappropriate. I'll try to help you with your
> problem any way that I can.
> If MSDE is running then MDAC (and the ODBC drivers) must already be
> installed - SQL Server can't run without it.
> I find it surprising and disappointing that the application you are trying
> to install, that requires MSDE, does not make the installation of MSDE
> seamless to you. What is the name of the program you are trying to install?
Hi Jim,
Thank you. We’ll start fresh. Here’s the deal.
OS= WinXPpro.
App=ACT! 2005 (version7)
And yes, I have gone around and around with BEST software (makers of ACT!)
about the need to support the install of SQL MSDE. They claim that it is a
MS problem. However, I have used this install of XP for 2 or 3 yrs with
hardly a BSOD or any other problem. 70 or 80 programs run just fine. (Of
course not all at once). FYI ACT! Is a contact manager. I have been using
v6 with a great deal of success. However, v7 is a total rewrite and uses
SQL. It is essentially version one. I don’t know that I want to trust my
data to a program that is such a problem to install, and relies on some
else’s db engine.
On to the problem:
I could only get MSDE up and running when I switched on don’t back out on
failure:
setup.exe DISABLEROLLBACK=1
I did this based on a clue that the last line in the SQL error log was:
SQL Server is terminating due to a ‘stop’ request from Service Control
Manager.
My thought was that if it can be stopped it must be running. Lo and behold
on reboot the little computer icon is in the system tray. And Task list
shows SQL server running, and sqlmangr running.
However, the drivers tab in ODBC do NOT show SQL Server. And, when I
attempt to install MDAC v2.8 it bombs out.
Part of my problem is that I don’t under stand the functional relationships
between all these elements. My thought is that SQL MSDE is the db engine,
and that MDAC drivers in the ODBC are essentally middle ware allowing the
application to access the db.
Before SQL was running, when I last attempted to install ACT! v7 the error
out was 1603 can not configure server. I have not tried to reinstall yet
wanting to get as many ducks in a row as possible.
Looking forward to your post.
Thanks
BartC
|||You're correct MSDE is the database engine, MDAC is the communication layer
between the application and the database.
The DISABLEROLLBACK option is an option for the Windows installer to not
rollback any changes to your system if the installation fails. The original
error your received, 1603, is basically a general error reporting back that
the MSDE installation failed.
It seem to me that although MSDE is apparently running, the installation is
in an inconsistent state. What I would recommend is completely unistalling
MSDE. The following link is to a KB article for manually removing MSDE from
your system.
http://support.microsoft.com/default...b;en-us;320873
On your system go to Control Panel | Add Remove Program and see if there is
an entry for removing MSDE (it may be referenced as SQL Server). If you find
it then uninstall it. If that is successful then continue with the Remove
Files and Folders part of the KB article and finish the rest of the steps on
the article, removing registry entries.
If this is all successful then you have a system that is cleaned of MSDE.
Next I would try installing MDAC 2.8 and see if you get through that
successfully. If you don't then I would not attempt to install MSDE, since I
doubt it will succeed.
Next reinstall MSDE by running setup.exe with the following command line
parameters. You could use an .ini file for the SECURITYMODE or BLANKSAPWD
options if you want. Personally, I find using the command line easier.
/Lv c:\MSDEsetup.log SECURITYMODE="SQL" BLANKSAPWD=1
This will install a default instance of MSDE to the default directories
(c:\program files\Microsoft SQL Server) with a blank sa password.
If the install fails then you should have a verbose log on the root of drive
C. Post to this group the tail end of the log where the installation start
to break down; you'll see where there is first a failure and then rollbacks
of registry entries and files.
A lot embedded database application are moving their data storage over to
MSDE. It's a very powerful and reliable environment (once you get it
installed!). The problem is that SQL Server is much more complex of an
application to install than a simple flat file database or an Access based
solution. When the installation of MSDE goes sideways, recovering from it
can be quite a lot of trouble, as you've experienced.
Good luck - I hope you are able to get MSDE finally installed.
Jim
"BartC" <BartC@.discussions.microsoft.com> wrote in message
news:1D534BF8-4C6F-49D9-A7F8-CB426F7A8EE8@.microsoft.com...
> "Jim Young" wrote:
> Hi Jim,
> Thank you. We'll start fresh. Here's the deal.
> OS= WinXPpro.
> App=ACT! 2005 (version7)
> And yes, I have gone around and around with BEST software (makers of ACT!)
> about the need to support the install of SQL MSDE. They claim that it is
> a
> MS problem. However, I have used this install of XP for 2 or 3 yrs with
> hardly a BSOD or any other problem. 70 or 80 programs run just fine. (Of
> course not all at once). FYI ACT! Is a contact manager. I have been
> using
> v6 with a great deal of success. However, v7 is a total rewrite and uses
> SQL. It is essentially version one. I don't know that I want to trust my
> data to a program that is such a problem to install, and relies on some
> else's db engine.
> On to the problem:
> I could only get MSDE up and running when I switched on don't back out on
> failure:
> setup.exe DISABLEROLLBACK=1
> I did this based on a clue that the last line in the SQL error log was:
> SQL Server is terminating due to a 'stop' request from Service Control
> Manager.
> My thought was that if it can be stopped it must be running. Lo and
> behold
> on reboot the little computer icon is in the system tray. And Task list
> shows SQL server running, and sqlmangr running.
> However, the drivers tab in ODBC do NOT show SQL Server. And, when I
> attempt to install MDAC v2.8 it bombs out.
> Part of my problem is that I don't under stand the functional
> relationships
> between all these elements. My thought is that SQL MSDE is the db engine,
> and that MDAC drivers in the ODBC are essentally middle ware allowing the
> application to access the db.
> Before SQL was running, when I last attempted to install ACT! v7 the error
> out was 1603 can not configure server. I have not tried to reinstall yet
> wanting to get as many ducks in a row as possible.
> Looking forward to your post.
> Thanks
> BartC
|||Hi Jim,
Well I see one error of my ways. I was installing MSDE first and then
attempting an install of MDAC 2.8.
If I understand you correctly after I remove everything I should start with
MDAC and then go on to installing MSDE.
I will try this, but it will have to wait for a day or two. The pressure of
work interfers with all the fun stuff ;-)
Thanks... I'll post results in a few days.
BartC
"Jim Young" wrote:
> snip...
> It seem to me that although MSDE is apparently running, the installation is
> in an inconsistent state. What I would recommend is completely unistalling
> MSDE. The following link is to a KB article for manually removing MSDE from
> your system.
|||It wasn't an error to install MDAC after MSDE; I just thought it would be a
good test to make sure that your system is in good order first. All windows
versions since Windows 2000 come with MDAC preinstalled, but it is best to
upgrade to 2.8 before you start the MSDE installation.
Jim
"BartC" <BartC@.discussions.microsoft.com> wrote in message
news:075F0748-C889-4FA2-8E80-EE7482B059EE@.microsoft.com...
> Hi Jim,
> Well I see one error of my ways. I was installing MSDE first and then
> attempting an install of MDAC 2.8.
> If I understand you correctly after I remove everything I should start
> with
> MDAC and then go on to installing MSDE.
> I will try this, but it will have to wait for a day or two. The pressure
> of
> work interfers with all the fun stuff ;-)
> Thanks... I'll post results in a few days.
> BartC
>
>
>
> "Jim Young" wrote:
>
|||Jim,
OK, here is the latest:
re: KB 320873 - the Msizap.exe failed to find the SQL server to uninstall.
There was no SQL server in Add/Remove.
This in spite of the fact the icon was in the system tray, and I could call
up the control panel to start and stop the SQL server.
Soooooo... I stepped through the manual removal. And took out lots of SQL
keys that were in the registry, plus all the stuff that the KB article
suggested. Removed the temp files and the entire branch of SQL server in the
directory structure.
I also ran Registry First Aid and did a general clean up of the registry.
I then ran the MDACsetup and received the following:
MDAC 2.8 RTM is incompatible with this version of Windows. All of its
features are currently part of Windows.
There is a Details button that brought up nothing.
OK, so which is it... Incompatible with WinXP pro or already installed?
Hard to know from that error mess.
Forging ahead I ran the SQL setup with your (Jim’s) command line switches.
(See previous message.) That resulted in the same error as before... to wit:
Setup failed to configure the server. Refer to the error logs.
With the verbose log switched turned on the resultant log is 3.6 MB. I am
not going to post that (don’t think I could anyway.) There is a lot of note
1: 2360- stuff near the top, and then tons of opening and adding RegValues.
But here is the middle part. This is near the end of the install and a bit
into the rollback. It seems to vomit at (24!1C) at the config server
execution.
I am at a total loss as how to proceed.
Starting custom action CallSQLAdHlp
c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
MSI (s) (24:B8) [06:36:45:799]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (24:B8) [06:36:45:799]: Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (24:B8) [06:36:45:809]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (24:B8) [06:36:45:809]: Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
MSI (s) (24:E8) [06:36:45:819]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI45.tmp, Entrypoint: InstallSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity succeeded
MSI (s) (24:B8) [06:36:46:070]: Executing op:
ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
MSI (s) (24:B8) [06:36:46:070]: Executing op:
CustomActionSchedule(Action=SkuIt.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,ActionType=1025,Source=Binary Data,Target=SkuIt,)
MSI (s) (24:1C) [06:36:46:070]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI46.tmp, Entrypoint: SkuIt
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
MSI (s) (24:B8) [06:36:46:320]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (24:B8) [06:36:46:330]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (24:84) [06:36:46:330]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI47.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "c:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
MSI (c) (20:88) [06:37:12:798]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
MSI (s) (24!1C) [06:37:50:753]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 6:37:50: InstallFinalize. Return value 3.
MSI (s) (24:B8) [06:37:50:783]: User policy value 'DisableRollback' is 0
MSI (s) (24:B8) [06:37:50:783]: Machine policy value 'DisableRollback' is 0
MSI (s) (24:B8) [06:37:50:823]: Executing op:
Header(Signature=1397708873,Version=300,Timestamp= 844313717,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (24:B8) [06:37:50:823]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (24:B8) [06:37:50:823]: Executing op:
DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
MSI (s) (24:B8) [06:37:50:823]: Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing backup files,CleanupTemplate=File: [1])
MSI (s) (24:B8) [06:37:50:823]: Executing op:
RegisterBackupFile(File=c:\Config.Msi\3cca84.rbf)
MSI (s) (24:B8) [06:37:50:823]: Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
MSI (s) (24:B8) [06:37:50:823]: Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Microsoft
SQL Server Desktop
Engine,PackageName=SqlRun01.msi,Language=1033,Vers ion=134218489,Assignment=1,ObsoleteArg=0,,,Package Code={D29DCF7A-8199-4373-BA0D-2F3635EC940C},,,InstanceType=0,LUASetting=0)
MSI (s) (24:B8) [06:37:50:833]: Executing op:
ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
MSI (s) (24:B8) [06:37:50:833]: Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (24:B8) [06:37:50:833]: Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (24:B8) [06:37:50:833]: Executing op:
CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
MSI (s) (24:F8) [06:37:50:833]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI48.tmp, Entrypoint: UnInstSQLAgentSecurity
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
MSI (s) (24:B8) [06:37:51:003]: Executing op:
ActionStart(Name=InstallSQLAdHlp.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (24:B8) [06:37:51:003]: Executing op:
ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
MSI (s) (24:B8) [06:37:51:003]: Executing op:
ActionStart(Name=InstallServices,Description=Insta lling new
services,Template=Service: [2])
MSI (s) (24:B8) [06:37:51:003]: Executing op:
ServiceControl(,Name=MSSQLSERVER,Action=8,,)
MSI (s) (24:B8) [06:37:51:003]: Executing op:
ServiceControl(,Name=SQLSERVERAGENT,Action=8,,)
MSI (s) (24:B8) [06:37:51:193]: Executing op:
ActionStart(Name=RegisterTypeLibraries,Description =Registering type
libraries,Template=LibID: [1])
MSI (s) (24:B8) [06:37:51:193]: Executing op:
TypeLibraryUnregister(,,FilePath=c:\WINDOWS\system 32\atl.dll,LibID={44EC0535-400F-11D0-9DCD-00A0C90391D3},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (24:B8) [06:37:51:193]: CMsiServices::ProcessTypeLibrary runs in
local context, not impersonated.
MSI (s) (24:B8) [06:37:51:203]: ProcessTypeLibraryCore returns: 0. (0 means
OK)
MSI (s) (24:B8) [06:37:51:213]: Executing op:
TypeLibraryUnregister(,,FilePath=c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\dtspump.DLL,LibID={10010200-740B-11D0-AE7B-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (24:B8) [06:37:51:213]: CMsiServices::ProcessTypeLibrary runs in
local context, not impersonated.
MSI (s) (24:B8) [06:37:51:223]: ProcessTypeLibraryCore returns: 0. (0 means
OK)
MSI (s) (24:B8) [06:37:51:233]: Executing op:
TypeLibraryUnregister(,,FilePath=c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\dtspkg.DLL,LibID={10010001-EB1C-11CF-AE6E-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
MSI (s) (24:B8) [06:37:51:233]: CMsiServices::ProcessTypeLibrary runs in
local context, not impersonated.
MSI (s) (24:B8) [06:37:51:304]: ProcessTypeLibraryCore returns: 0. (0 means
OK)
|||This may be a long shot, but is the Server service running on your machine?
Go to Control Panel | Adminstrative Tools | Services. If it is not running
then bring up the properties for the service, set the startup to automatic
and start the service. Then try re-installing MSDE.
Jim
"BartC" <BartC@.discussions.microsoft.com> wrote in message
news:B7EE12E7-D84E-4D83-96E6-70229C1F445C@.microsoft.com...
> Jim,
> OK, here is the latest:
> re: KB 320873 - the Msizap.exe failed to find the SQL server to uninstall.
> There was no SQL server in Add/Remove.
> This in spite of the fact the icon was in the system tray, and I could
> call
> up the control panel to start and stop the SQL server.
> Soooooo... I stepped through the manual removal. And took out lots of
> SQL
> keys that were in the registry, plus all the stuff that the KB article
> suggested. Removed the temp files and the entire branch of SQL server in
> the
> directory structure.
> I also ran Registry First Aid and did a general clean up of the registry.
> I then ran the MDACsetup and received the following:
> MDAC 2.8 RTM is incompatible with this version of Windows. All of its
> features are currently part of Windows.
> There is a Details button that brought up nothing.
> OK, so which is it... Incompatible with WinXP pro or already installed?
> Hard to know from that error mess.
> Forging ahead I ran the SQL setup with your (Jim's) command line switches.
> (See previous message.) That resulted in the same error as before... to
> wit:
> Setup failed to configure the server. Refer to the error logs.
> With the verbose log switched turned on the resultant log is 3.6 MB. I am
> not going to post that (don't think I could anyway.) There is a lot of
> note
> 1: 2360- stuff near the top, and then tons of opening and adding
> RegValues.
> But here is the middle part. This is near the end of the install and a
> bit
> into the rollback. It seems to vomit at (24!1C) at the config server
> execution.
> I am at a total loss as how to proceed.
> Starting custom action CallSQLAdHlp
> c:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
> MSI (s) (24:B8) [06:36:45:799]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (24:B8) [06:36:45:799]: Executing op:
> CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (24:B8) [06:36:45:809]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (24:B8) [06:36:45:809]: Executing op:
> CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=102 5,Source=BinaryData,Target=InstallSQLAgentSecurity ,)
> MSI (s) (24:E8) [06:36:45:819]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI45.tmp, Entrypoint: InstallSQLAgentSecurity
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity succeeded
> MSI (s) (24:B8) [06:36:46:070]: Executing op:
> ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
> MSI (s) (24:B8) [06:36:46:070]: Executing op:
> CustomActionSchedule(Action=SkuIt.2D02443E_7002_4C 0B_ABC9_EAB2C064397B,ActionType=1025,Source=Binary Data,Target=SkuIt,)
> MSI (s) (24:1C) [06:36:46:070]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI46.tmp, Entrypoint: SkuIt
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> MSI (s) (24:B8) [06:36:46:320]: Executing op:
> ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
> MSI (s) (24:B8) [06:36:46:330]: Executing op:
> CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
> MSI (s) (24:84) [06:36:46:330]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI47.tmp, Entrypoint: ConfigServer
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action ConfigServer
> Executing "c:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
> -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
> MSI (c) (20:88) [06:37:12:798]: Font created. Charset: Req=0, Ret=0,
> Font:
> Req=MS Shell Dlg, Ret=MS Shell Dlg
> MSI (s) (24!1C) [06:37:50:753]: Product: Microsoft SQL Server Desktop
> Engine
> -- Setup failed to configure the server. Refer to the server error logs
> and
> setup error logs for more information.
> Action ended 6:37:50: InstallFinalize. Return value 3.
> MSI (s) (24:B8) [06:37:50:783]: User policy value 'DisableRollback' is 0
> MSI (s) (24:B8) [06:37:50:783]: Machine policy value 'DisableRollback' is
> 0
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> Header(Signature=1397708873,Version=300,Timestamp= 844313717,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> DialogInfo(Type=0,Argument=1033)
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> DialogInfo(Type=1,Argument=Microsoft SQL Server Desktop Engine)
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
> action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription= Removing
> backup files,CleanupTemplate=File: [1])
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> RegisterBackupFile(File=c:\Config.Msi\3cca84.rbf)
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
> MSI (s) (24:B8) [06:37:50:823]: Executing op:
> ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Microsoft
> SQL Server Desktop
> Engine,PackageName=SqlRun01.msi,Language=1033,Vers ion=134218489,Assignment=1,ObsoleteArg=0,,,Package Code={D29DCF7A-8199-4373-BA0D-2F3635EC940C},,,InstanceType=0,LUASetting=0)
> MSI (s) (24:B8) [06:37:50:833]: Executing op:
> ActionStart(Name=SkuIt.2D02443E_7002_4C0B_ABC9_EAB 2C064397B,,)
> MSI (s) (24:B8) [06:37:50:833]: Executing op:
> ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (24:B8) [06:37:50:833]: Executing op:
> ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,,)
> MSI (s) (24:B8) [06:37:50:833]: Executing op:
> CustomActionRollback(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType=12 81,Source=BinaryData,Target=UnInstSQLAgentSecurity ,)
> MSI (s) (24:F8) [06:37:50:833]: Invoking remote custom action. DLL:
> C:\WINDOWS\Installer\MSI48.tmp, Entrypoint: UnInstSQLAgentSecurity
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Bart\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action UnInstSQLAgentSecurity
> Starting custom action UnInstSQLAgentSecurity
> MSI (s) (24:B8) [06:37:51:003]: Executing op:
> ActionStart(Name=InstallSQLAdHlp.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
> MSI (s) (24:B8) [06:37:51:003]: Executing op:
> ActionStart(Name=InstallPerfMon.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
> MSI (s) (24:B8) [06:37:51:003]: Executing op:
> ActionStart(Name=InstallServices,Description=Insta lling new
> services,Template=Service: [2])
> MSI (s) (24:B8) [06:37:51:003]: Executing op:
> ServiceControl(,Name=MSSQLSERVER,Action=8,,)
> MSI (s) (24:B8) [06:37:51:003]: Executing op:
> ServiceControl(,Name=SQLSERVERAGENT,Action=8,,)
> MSI (s) (24:B8) [06:37:51:193]: Executing op:
> ActionStart(Name=RegisterTypeLibraries,Description =Registering type
> libraries,Template=LibID: [1])
> MSI (s) (24:B8) [06:37:51:193]: Executing op:
> TypeLibraryUnregister(,,FilePath=c:\WINDOWS\system 32\atl.dll,LibID={44EC0535-400F-11D0-9DCD-00A0C90391D3},Version=-2147483648,,Language=0,,BinaryType=0)
> MSI (s) (24:B8) [06:37:51:193]: CMsiServices::ProcessTypeLibrary runs in
> local context, not impersonated.
> MSI (s) (24:B8) [06:37:51:203]: ProcessTypeLibraryCore returns: 0. (0
> means
> OK)
> MSI (s) (24:B8) [06:37:51:213]: Executing op:
> TypeLibraryUnregister(,,FilePath=c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\dtspump.DLL,LibID={10010200-740B-11D0-AE7B-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
> MSI (s) (24:B8) [06:37:51:213]: CMsiServices::ProcessTypeLibrary runs in
> local context, not impersonated.
> MSI (s) (24:B8) [06:37:51:223]: ProcessTypeLibraryCore returns: 0. (0
> means
> OK)
> MSI (s) (24:B8) [06:37:51:233]: Executing op:
> TypeLibraryUnregister(,,FilePath=c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\dtspkg.DLL,LibID={10010001-EB1C-11CF-AE6E-00AA004A34D5},Version=-2147483648,,Language=0,,BinaryType=0)
> MSI (s) (24:B8) [06:37:51:233]: CMsiServices::ProcessTypeLibrary runs in
> local context, not impersonated.
> MSI (s) (24:B8) [06:37:51:304]: ProcessTypeLibraryCore returns: 0. (0
> means
> OK)
>
Showing posts with label file. Show all posts
Showing posts with label file. Show all posts
Thursday, March 29, 2012
Thursday, March 22, 2012
Can not connect to a flat file
Hi all....
With Visual Studio, I have created a new "Integration Services Project".
As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"
When I do so, I get this error:
The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)
Thanks!
Forch
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)
.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.
I have tried to remove and re-install Integrated services, but I have had no luck.
Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||
Hi Scott,
Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help
Any refernce would be helpful.
Thanks in Advance
Phani Kiran K
|||Hi Forch,
I too have exact problem. Can you remember the solution you had for this problem?
Any reference would be helpful.
Thanks in Advance,
Phani Kiran K.
|||Sorry.... I have not visited this in a while. I just changed everything I need to do to script.
Cheers,
Forch
|||Hi
This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine
Regards,
Phani.
Can not connect to a flat file
Hi all....
With Visual Studio, I have created a new "Integration Services Project".
As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"
When I do so, I get this error:
The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)
Thanks!
Forch
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)
.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.
I have tried to remove and re-install Integrated services, but I have had no luck.
Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||
Hi Scott,
Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help
Any refernce would be helpful.
Thanks in Advance
Phani Kiran K
|||Hi Forch,
I too have exact problem. Can you remember the solution you had for this problem?
Any reference would be helpful.
Thanks in Advance,
Phani Kiran K.
|||Sorry.... I have not visited this in a while. I just changed everything I need to do to script.
Cheers,
Forch
|||Hi
This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine
Regards,
Phani.
Can not connect to a flat file
Hi all....
With Visual Studio, I have created a new "Integration Services Project".
As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"
When I do so, I get this error:
The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)
Thanks!
Forch
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)
.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.
I have tried to remove and re-install Integrated services, but I have had no luck.
Forch|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.|||
Hi Scott,
Its too late to ask this question. Can you remember what makes this problem fixed? We too have exact problem and unable to get any help
Any refernce would be helpful.
Thanks in Advance
Phani Kiran K
|||Hi Forch,
I too have exact problem. Can you remember the solution you had for this problem?
Any reference would be helpful.
Thanks in Advance,
Phani Kiran K.
|||Sorry.... I have not visited this in a while. I just changed everything I need to do to script.
Cheers,
Forch
|||Hi
This issues is realted to 64 bit environment. Once we register the necessary dlls in the 64 bit environmen, everything is working fine
Regards,
Phani.
Can not connect to a flat file
Hi all....
With Visual Studio, I have created a new "Integration Services Project".
As per the tutorial instructions, I right-click in the "Connection Managers" box, and I select "New Flat File Connection"
When I do so, I get this error:
The new connection manager could not be created.
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
Any suggestions? (BTW, I'm using 64-Bit Enterprise edition for x64)
Thanks!
Forch
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerUtils.GetLocaleID(ConnectionManager connectionManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.LoadState(ConnectionManager connManager)
at Microsoft.DataTransformationServices.Controls.FlatFileManagerGeneralPage.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Controls.FlatFileConnectionManagerControl.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerForm.set_ConnectionManager(ConnectionManager value)
at Microsoft.DataTransformationServices.Design.FlatFileConnectionManagerUI.New(IWin32Window parentWindow, Connections connections, ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)
.... To continue, I am not able to make ANY data connections at all.... SQL Server, Oracle, FTP, Text file, nothing.
I have tried to remove and re-install Integrated services, but I have had no luck.
Forch
|||I have this exact same problem and can't seem to be able to find any information about it. I too have uninstalled and reinstalled everything with no success. Any help greatly appreciated.Tuesday, March 20, 2012
Can not attach MDF from HDS LUN
Hi..
We are trying to attach a database (MDF File without LDF File) in SQL2K SP4
MDF File is in HDS (Hitachi Data Storage) Lun or SAN Storage.
When we try attach the MDF File, we are getting an error. The error message is :
" Error 1813: Could not open new database 'Test'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'F:\SQLData\Test_log.ldf' maybe incorrect "
When We try attach the MDF File, but We move the MDF File into Local Hard Drive (Drive C:), then We success to attached the MDF File and the LDF File is automaticlly generated without error.
i'm waiting for the solution
Thank's.
Brgds,
Dwiharto
How did you attach it? Try using sp_attach_single_file_db stored procedure instead.Whether the data file resides on the SAN or not should not matter here.|||
I had try it before, but it is still doesn't working and still had same error message.
btw thanks for ur advice.
maybe u can tell me another way?
Thank's a lot Friend ...
|||Can you post the exact attach statement.|||the statement :
sp_attach_single_file_db @.dbname = 'test',
@.physname = 'F:\SQLData\Test.mdf'
Thank's..
|||The statement looks valid. (F:\) is a locally attached SAN, right? If this is a network attached san, you need to turn on trace flag (1807). Also, does the account used to start sqlserver service has full right to the SAN?
Can not attach mdf 2005 file into sqlserver 2000
hello all.
I have a database file in sqlserver 2005 mode, i set it's compatiblity to sqlserver 2000 (80) but i cant attach it in sqlserver 2000.
My host only support sqlserver 2000!
I have a database file in sqlserver 2005 mode, i set it's compatiblity to sqlserver 2000 (80) but i cant attach it in sqlserver 2000.
My host only support sqlserver 2000!
I need any help to convert or attach it!
Thank all!
Sadly to say: you can not attach a SQL2005 database to a SQL2000 instance even you set the compatiblity to sqlserver 2000 (80). I'm afraid you have create a new database with exact the same schema in SQL2000, and transfer data from the original database to the new one. You can get the scripts for creating the objects of the same schemas by right clicking the objects in Management Studio.
|||Thank!
Sql 2005 is so bad! No server is using it now!
Can not attach database,
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.
It appears that you have a corrupted database file (.MDF), and have been attempting to use a 3rd-party data recovery tool to extract as much data as possible from the damaged database. Is this correct?
It also appears that your disk is likely damaged. Can I assume that you've replaced it?
The primary response in this situation would always be to restore the database from backup. When is your most recent database backup from? Without a valid backup, there's unfortunately not much you can do.
sqlCan Not add new data file to the primary File group- SQL Server 20
Hi All
I am trying to add a new data file (7th one) to a database on SQL Server
2005
The existing 6th file has autogowth set to grow by 100 MB
When I try to add 7th file to make it autogow by 100 MB on a drive which
more than 300 GB I get the following error
Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in database
'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
deleting unneeded files, dropping objects in the filegroup, adding additional
files to the filegroup, or setting autogrowth on for existing files in the
filegroup.
I tried using T-SQL and also management studio I get the same error
Any advises will be appreciated.
Thanks
KiranAutogrowth is set to 100MB but how about Restricted File Growth?
I think it is set to Restricted File Growth = some_value
Please check out your Database's Properties and Files from options and check
if above mentioned value is set correctly or not.
--
Ekrem Ã?nsoy
"Kiran" <Kiran@.discussions.microsoft.com> wrote in message
news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> Hi All
> I am trying to add a new data file (7th one) to a database on SQL
> Server
> 2005
> The existing 6th file has autogowth set to grow by 100 MB
> When I try to add 7th file to make it autogow by 100 MB on a drive which
> more than 300 GB I get the following error
> Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> database
> 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> deleting unneeded files, dropping objects in the filegroup, adding
> additional
> files to the filegroup, or setting autogrowth on for existing files in the
> filegroup.
> I tried using T-SQL and also management studio I get the same error
> Any advises will be appreciated.
> Thanks
> Kiran|||Thanks Ekrem for the reply
I have checked autogowth for the 6th file it is "Unrestricted" and grow by
100 MB
Thanks
Kiran
"Ekrem Ã?nsoy" wrote:
> Autogrowth is set to 100MB but how about Restricted File Growth?
> I think it is set to Restricted File Growth = some_value
> Please check out your Database's Properties and Files from options and check
> if above mentioned value is set correctly or not.
> --
> Ekrem Ã?nsoy
>
> "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> > Hi All
> > I am trying to add a new data file (7th one) to a database on SQL
> > Server
> > 2005
> > The existing 6th file has autogowth set to grow by 100 MB
> > When I try to add 7th file to make it autogow by 100 MB on a drive which
> > more than 300 GB I get the following error
> >
> > Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> > database
> > 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> > deleting unneeded files, dropping objects in the filegroup, adding
> > additional
> > files to the filegroup, or setting autogrowth on for existing files in the
> > filegroup.
> >
> > I tried using T-SQL and also management studio I get the same error
> >
> > Any advises will be appreciated.
> >
> > Thanks
> > Kiran
>|||Hi All
FYI, I see space available under database properties when viewed from
management studio is 0 bytes
Is this preventing addition of new files ? ( Just a guess?)
Thanks
Kiran
"Kiran" wrote:
> Thanks Ekrem for the reply
> I have checked autogowth for the 6th file it is "Unrestricted" and grow by
> 100 MB
> Thanks
> Kiran
>
> "Ekrem Ã?nsoy" wrote:
> > Autogrowth is set to 100MB but how about Restricted File Growth?
> >
> > I think it is set to Restricted File Growth = some_value
> >
> > Please check out your Database's Properties and Files from options and check
> > if above mentioned value is set correctly or not.
> >
> > --
> > Ekrem Ã?nsoy
> >
> >
> >
> > "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> > news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> > > Hi All
> > > I am trying to add a new data file (7th one) to a database on SQL
> > > Server
> > > 2005
> > > The existing 6th file has autogowth set to grow by 100 MB
> > > When I try to add 7th file to make it autogow by 100 MB on a drive which
> > > more than 300 GB I get the following error
> > >
> > > Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> > > database
> > > 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> > > deleting unneeded files, dropping objects in the filegroup, adding
> > > additional
> > > files to the filegroup, or setting autogrowth on for existing files in the
> > > filegroup.
> > >
> > > I tried using T-SQL and also management studio I get the same error
> > >
> > > Any advises will be appreciated.
> > >
> > > Thanks
> > > Kiran
> >
I am trying to add a new data file (7th one) to a database on SQL Server
2005
The existing 6th file has autogowth set to grow by 100 MB
When I try to add 7th file to make it autogow by 100 MB on a drive which
more than 300 GB I get the following error
Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in database
'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
deleting unneeded files, dropping objects in the filegroup, adding additional
files to the filegroup, or setting autogrowth on for existing files in the
filegroup.
I tried using T-SQL and also management studio I get the same error
Any advises will be appreciated.
Thanks
KiranAutogrowth is set to 100MB but how about Restricted File Growth?
I think it is set to Restricted File Growth = some_value
Please check out your Database's Properties and Files from options and check
if above mentioned value is set correctly or not.
--
Ekrem Ã?nsoy
"Kiran" <Kiran@.discussions.microsoft.com> wrote in message
news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> Hi All
> I am trying to add a new data file (7th one) to a database on SQL
> Server
> 2005
> The existing 6th file has autogowth set to grow by 100 MB
> When I try to add 7th file to make it autogow by 100 MB on a drive which
> more than 300 GB I get the following error
> Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> database
> 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> deleting unneeded files, dropping objects in the filegroup, adding
> additional
> files to the filegroup, or setting autogrowth on for existing files in the
> filegroup.
> I tried using T-SQL and also management studio I get the same error
> Any advises will be appreciated.
> Thanks
> Kiran|||Thanks Ekrem for the reply
I have checked autogowth for the 6th file it is "Unrestricted" and grow by
100 MB
Thanks
Kiran
"Ekrem Ã?nsoy" wrote:
> Autogrowth is set to 100MB but how about Restricted File Growth?
> I think it is set to Restricted File Growth = some_value
> Please check out your Database's Properties and Files from options and check
> if above mentioned value is set correctly or not.
> --
> Ekrem Ã?nsoy
>
> "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> > Hi All
> > I am trying to add a new data file (7th one) to a database on SQL
> > Server
> > 2005
> > The existing 6th file has autogowth set to grow by 100 MB
> > When I try to add 7th file to make it autogow by 100 MB on a drive which
> > more than 300 GB I get the following error
> >
> > Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> > database
> > 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> > deleting unneeded files, dropping objects in the filegroup, adding
> > additional
> > files to the filegroup, or setting autogrowth on for existing files in the
> > filegroup.
> >
> > I tried using T-SQL and also management studio I get the same error
> >
> > Any advises will be appreciated.
> >
> > Thanks
> > Kiran
>|||Hi All
FYI, I see space available under database properties when viewed from
management studio is 0 bytes
Is this preventing addition of new files ? ( Just a guess?)
Thanks
Kiran
"Kiran" wrote:
> Thanks Ekrem for the reply
> I have checked autogowth for the 6th file it is "Unrestricted" and grow by
> 100 MB
> Thanks
> Kiran
>
> "Ekrem Ã?nsoy" wrote:
> > Autogrowth is set to 100MB but how about Restricted File Growth?
> >
> > I think it is set to Restricted File Growth = some_value
> >
> > Please check out your Database's Properties and Files from options and check
> > if above mentioned value is set correctly or not.
> >
> > --
> > Ekrem Ã?nsoy
> >
> >
> >
> > "Kiran" <Kiran@.discussions.microsoft.com> wrote in message
> > news:63E763B8-6677-4F7C-8DC4-194A84344170@.microsoft.com...
> > > Hi All
> > > I am trying to add a new data file (7th one) to a database on SQL
> > > Server
> > > 2005
> > > The existing 6th file has autogowth set to grow by 100 MB
> > > When I try to add 7th file to make it autogow by 100 MB on a drive which
> > > more than 300 GB I get the following error
> > >
> > > Could not allocate space for object 'sys.sysfiles1'.'sysfiles1' in
> > > database
> > > 'SomeDb' because the 'PRIMARY' filegroup is full. Create disk space by
> > > deleting unneeded files, dropping objects in the filegroup, adding
> > > additional
> > > files to the filegroup, or setting autogrowth on for existing files in the
> > > filegroup.
> > >
> > > I tried using T-SQL and also management studio I get the same error
> > >
> > > Any advises will be appreciated.
> > >
> > > Thanks
> > > Kiran
> >
Can not access Excel file using OpenRowset
I am using SQLServer 2005 SP2. I enabled the Ad Hoc Distributed Queries and DisallowAdhocAccess registry option is explicitly set to 0. Query is working fine when I remote desk to the server and execute when I run same query from my workstation I am getting following error
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
Any help is appreciated.
Thanks
--
Farhan
Can you post the text of your query?|||
Here you go ...
Select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\inventory.xls;Extended Properties=Excel 8.0')...[Laptop$]
|||Can we clarify your original statement?You wrote that when you execute the statement from the server itself it works.
In that case how do you exactly execute the query? And how do you do it from your workstation?|||
Hello Anton,
I ran the query using SQLServer Management Studio both on Server and Workstation.
Thanks.
|||Connecting to the same server with the same credentials?|||I think this is a point of view issue. Remember that when you perform OpenRowset, it is looking for that location from the server's point of view. If you create a file on the client at C:\file and try to link to it from the server, it will naturally not find C:\file. You have to specify where the server would find that file, not where it is on the client. This is the same kind of issue that would come up if you try to load a CLR assembly on the server that is built on the client. The file is not within the scope of the server's view and definitely not in the same place so it fails to find it and fails to load, but if you perform the exact same operation on the server, it succeeds. This is because, when performing this operation on the server, the client and server are the same machine and have the same filesystem view. You can work around this issue in a few ways if you need to dynamically link the server to a client file. I suggest either: 1.) upload the file through TCP or an extended stored procedure and link to it from the directory path in the server's view, 2.) create a share and place files on the share that you want to push over to the server, specifying the share should give you a uniform location across client and server and effectively abstract out this detail.
Hope that helps,
John
sqlCan not access Excel file using OpenRowset
I am using SQLServer 2005 SP2. I enabled the Ad Hoc Distributed Queries and DisallowAdhocAccess registry option is explicitly set to 0. Query is working fine when I remote desk to the server and execute when I run same query from my workstation I am getting following error
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
Any help is appreciated.
Thanks
--
Farhan
Can you post the text of your query?|||
Here you go ...
Select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\inventory.xls;Extended Properties=Excel 8.0')...[Laptop$]
|||Can we clarify your original statement?You wrote that when you execute the statement from the server itself it works.
In that case how do you exactly execute the query? And how do you do it from your workstation?|||
Hello Anton,
I ran the query using SQLServer Management Studio both on Server and Workstation.
Thanks.
|||Connecting to the same server with the same credentials?|||I think this is a point of view issue. Remember that when you perform OpenRowset, it is looking for that location from the server's point of view. If you create a file on the client at C:\file and try to link to it from the server, it will naturally not find C:\file. You have to specify where the server would find that file, not where it is on the client. This is the same kind of issue that would come up if you try to load a CLR assembly on the server that is built on the client. The file is not within the scope of the server's view and definitely not in the same place so it fails to find it and fails to load, but if you perform the exact same operation on the server, it succeeds. This is because, when performing this operation on the server, the client and server are the same machine and have the same filesystem view. You can work around this issue in a few ways if you need to dynamically link the server to a client file. I suggest either: 1.) upload the file through TCP or an extended stored procedure and link to it from the directory path in the server's view, 2.) create a share and place files on the share that you want to push over to the server, specifying the share should give you a uniform location across client and server and effectively abstract out this detail.
Hope that helps,
John
Can not access Excel file using OpenRowset
I am using SQLServer 2005 SP2. I enabled the Ad Hoc Distributed Queries and DisallowAdhocAccess registry option is explicitly set to 0. Query is working fine when I remote desk to the server and execute when I run same query from my workstation I am getting following error
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
Any help is appreciated.
Thanks
--
Farhan
Can you post the text of your query?|||
Here you go ...
Select * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\inventory.xls;Extended Properties=Excel 8.0')...[Laptop$]
|||Can we clarify your original statement?You wrote that when you execute the statement from the server itself it works.
In that case how do you exactly execute the query? And how do you do it from your workstation?|||
Hello Anton,
I ran the query using SQLServer Management Studio both on Server and Workstation.
Thanks.
|||Connecting to the same server with the same credentials?|||I think this is a point of view issue. Remember that when you perform OpenRowset, it is looking for that location from the server's point of view. If you create a file on the client at C:\file and try to link to it from the server, it will naturally not find C:\file. You have to specify where the server would find that file, not where it is on the client. This is the same kind of issue that would come up if you try to load a CLR assembly on the server that is built on the client. The file is not within the scope of the server's view and definitely not in the same place so it fails to find it and fails to load, but if you perform the exact same operation on the server, it succeeds. This is because, when performing this operation on the server, the client and server are the same machine and have the same filesystem view. You can work around this issue in a few ways if you need to dynamically link the server to a client file. I suggest either: 1.) upload the file through TCP or an extended stored procedure and link to it from the directory path in the server's view, 2.) create a share and place files on the share that you want to push over to the server, specifying the share should give you a uniform location across client and server and effectively abstract out this detail.
Hope that helps,
John
Monday, March 19, 2012
Can MSSQL load a tab delimited text file?
Hi all...
I would like to know if SQL SERVER can load a tab delimited text file.
If yes, how?
A search on the web did not return me the "load data" command as mysql
or other.
Thank you all.BULK INSERT|||Oh my god...
Why you say it is a bulk insert man?? Come on...
I am a MySQL user and wants to know if i can load my data on MSSQL
without a need of a converter.|||<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> Oh my god...
> Why you say it is a bulk insert man?? Come on...
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.
I'm not sure what you don't like about his answer. Did you even bother to
look up the command he gave you?
|||Don't you have Books Online available? I expect Q. John Chen assumed you
would lookup the command:
http://msdn.microsoft.com/library/d...asp?frame=true
--
David Portas
SQL Server MVP
--
<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> Oh my god...
> Why you say it is a bulk insert man?? Come on...
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.|||Oh...
So Bulk Insert is the command...
Thank you all...
Can move a file outside of PRIMARY to a new file group?
So I messed up and didn't create file groups for my scheme
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
Erik
No, that is because SQL Server don't place objects on a certain file, it places objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects, shrink the original file
using (EMPTYFILE) and then drop that file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegr oups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
Erik
No, that is because SQL Server don't place objects on a certain file, it places objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects, shrink the original file
using (EMPTYFILE) and then drop that file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegr oups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>
Can move a file outside of PRIMARY to a new file group?
So I messed up and didn't create file groups for my scheme
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
ErikNo, that is because SQL Server don't place objects on a certain file, it pla
ces objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects,
shrink the original file
using (EMPTYFILE) and then drop that file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegroups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
ErikNo, that is because SQL Server don't place objects on a certain file, it pla
ces objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects,
shrink the original file
using (EMPTYFILE) and then drop that file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegroups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>
Can move a file outside of PRIMARY to a new file group?
So I messed up and didn't create file groups for my scheme
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
ErikNo, that is because SQL Server don't place objects on a certain file, it places objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects, shrink the original file
using (EMPTYFILE) and then drop that file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegroups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>
partitioning strategy... can I create a file group and then take a
file out of PRIMARY and move it to SAN1_FILEGROUP for example?
I'm thinking take the database OFFLINE
and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
Thanks
ErikNo, that is because SQL Server don't place objects on a certain file, it places objects on a
filegroup. So, create a new filegroup, add file(s) to it, move the objects, shrink the original file
using (EMPTYFILE) and then drop that file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Erik G" <info@.fdaregulatory.com> wrote in message
news:1174936993.128302.101110@.l75g2000hse.googlegroups.com...
> So I messed up and didn't create file groups for my scheme
> partitioning strategy... can I create a file group and then take a
> file out of PRIMARY and move it to SAN1_FILEGROUP for example?
> I'm thinking take the database OFFLINE
> and ALTER DATABASE to move the file to the SAN1_FILEGROUP?
> Thanks
> Erik
>
Sunday, March 11, 2012
Can Indexes LIve on another server?
I know I can split up data and indexes onto different file groups, but can I
then move the index file group to another server? if so, what are the pros &
cons?
thanks in advance!!Yes, you can certainly have a filegroup which lives on another physical
resource. There are two very strong di
vantages to this:
(a) network latency unless you are on gig+ ethernet...
(b) reliance on multiple machines to be up for one server to be considered
"available." How do you plan to recycle machines after applying a service
pack or hotfix?
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:E7BF3CB9-6974-4BBD-AD9F-94D81D04EC4C@.microsoft.com...
>I know I can split up data and indexes onto different file groups, but can
>I
> then move the index file group to another server? if so, what are the pros
> &
> cons?
> thanks in advance!!|||what are the performance gains/issues?
I am looking at splitting up a 1 tb data file into a 300gb data file and a
700gb index file. I have a gb network, but I am worried about administrating
mutiple machines.
"Aaron Bertrand [SQL Server MVP]" wrote:
> Yes, you can certainly have a filegroup which lives on another physical
> resource. There are two very strong divantages to this:
> (a) network latency unless you are on gig+ ethernet...
> (b) reliance on multiple machines to be up for one server to be considered
> "available." How do you plan to recycle machines after applying a service
> pack or hotfix?
>
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:E7BF3CB9-6974-4BBD-AD9F-94D81D04EC4C@.microsoft.com...
>
>|||Why not just additional drive(s) to the same server?
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:29753642-4A9E-4DC3-975B-578EBFD963AC@.microsoft.com...
> what are the performance gains/issues?
> I am looking at splitting up a 1 tb data file into a 300gb data file and a
> 700gb index file. I have a gb network, but I am worried about
> administrating
> mutiple machines.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>|||Incorrect. olny local drives can be used for this purpose or special SAN
that you probably don't have.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uMTRslkrFHA.1028@.TK2MSFTNGP12.phx.gbl...
> Yes, you can certainly have a filegroup which lives on another physical
> resource. There are two very strong divantages to this:
> (a) network latency unless you are on gig+ ethernet...
> (b) reliance on multiple machines to be up for one server to be considered
> "available." How do you plan to recycle machines after applying a service
> pack or hotfix?
>
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:E7BF3CB9-6974-4BBD-AD9F-94D81D04EC4C@.microsoft.com...
>|||And only enterprize edition supports VIA SANs. others will work if a SAN
drive is presented by SAN driver as local.
however another tip here is:
BOL
Note When running on Windows NT, SQL Server performance can be improved
further if the databases are created on disks formatted using NTFS and,
specifically, 64-KB extent sizes. In Windows 2000, setting the file system
cluster size to 64-KB extent size using the /A format option will also
improve performance. For more information about formatting an NTFS disk, see
the Windows NT or Windows 2000 documentation.
"Farmer" <someone@.somewhere.com> wrote in message
news:ez99%23ilrFHA.3068@.TK2MSFTNGP14.phx.gbl...
> Incorrect. olny local drives can be used for this purpose or special SAN
> that you probably don't have.
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:uMTRslkrFHA.1028@.TK2MSFTNGP12.phx.gbl...
>|||Am I reading that you have 700gb of indexing on 300gb of tables?
Consider if you are indexing on too many columns:
http://msdn.microsoft.com/library/d.../>
indexes.asp
Also, look into the extent of index fragmentation:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:29753642-4A9E-4DC3-975B-578EBFD963AC@.microsoft.com...
> what are the performance gains/issues?
> I am looking at splitting up a 1 tb data file into a 300gb data file and a
> 700gb index file. I have a gb network, but I am worried about
> administrating
> mutiple machines.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>|||> Incorrect. olny local drives can be used for this purpose or special SAN
> that you probably don't have.
Uh, we have multiple Clariions. But thanks for the tip.|||And here's the full story on creating database files on network drives.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Farmer" <someone@.somewhere.com> wrote in message news:ez99%23ilrFHA.3068@.TK2MSFTNGP14.phx.
gbl...
> Incorrect. olny local drives can be used for this purpose or special SAN
> that you probably don't have.
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in messag
e
> news:uMTRslkrFHA.1028@.TK2MSFTNGP12.phx.gbl...
>|||Well, we are currently delivering on Del 2650's with a powervault loaded wit
h
16 - 15k 73gb hard drives configured into one raid-5 drive. The search times
on this 1tb table are very fast, but I am looking to scale it out. I would
like to seperate the indexes and the data onto different disks, but then
started wondering if I could store the data on one server, and say store the
indexes on 3-4 other servers that point to the data servers.
My research has found that 70-80% of query times is caught up in the indexes
looking for the right keys to use to go get the data with. I have 26 indexes
built on my table that covers 95% of the queries uses according to our log
files. I would like to spread out the work done in the index search to a fe
w
specialized servers if possible. I dont think that MS can do this, but I can
probably build something myself that could.
thanks!!
"Aaron Bertrand [SQL Server MVP]" wrote:
> Uh, we have multiple Clariions. But thanks for the tip.
>
>
then move the index file group to another server? if so, what are the pros &
cons?
thanks in advance!!Yes, you can certainly have a filegroup which lives on another physical
resource. There are two very strong di
vantages to this:(a) network latency unless you are on gig+ ethernet...
(b) reliance on multiple machines to be up for one server to be considered
"available." How do you plan to recycle machines after applying a service
pack or hotfix?
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:E7BF3CB9-6974-4BBD-AD9F-94D81D04EC4C@.microsoft.com...
>I know I can split up data and indexes onto different file groups, but can
>I
> then move the index file group to another server? if so, what are the pros
> &
> cons?
> thanks in advance!!|||what are the performance gains/issues?
I am looking at splitting up a 1 tb data file into a 300gb data file and a
700gb index file. I have a gb network, but I am worried about administrating
mutiple machines.
"Aaron Bertrand [SQL Server MVP]" wrote:
> Yes, you can certainly have a filegroup which lives on another physical
> resource. There are two very strong di
vantages to this:> (a) network latency unless you are on gig+ ethernet...
> (b) reliance on multiple machines to be up for one server to be considered
> "available." How do you plan to recycle machines after applying a service
> pack or hotfix?
>
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:E7BF3CB9-6974-4BBD-AD9F-94D81D04EC4C@.microsoft.com...
>
>|||Why not just additional drive(s) to the same server?
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:29753642-4A9E-4DC3-975B-578EBFD963AC@.microsoft.com...
> what are the performance gains/issues?
> I am looking at splitting up a 1 tb data file into a 300gb data file and a
> 700gb index file. I have a gb network, but I am worried about
> administrating
> mutiple machines.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>|||Incorrect. olny local drives can be used for this purpose or special SAN
that you probably don't have.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uMTRslkrFHA.1028@.TK2MSFTNGP12.phx.gbl...
> Yes, you can certainly have a filegroup which lives on another physical
> resource. There are two very strong di
vantages to this:> (a) network latency unless you are on gig+ ethernet...
> (b) reliance on multiple machines to be up for one server to be considered
> "available." How do you plan to recycle machines after applying a service
> pack or hotfix?
>
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:E7BF3CB9-6974-4BBD-AD9F-94D81D04EC4C@.microsoft.com...
>|||And only enterprize edition supports VIA SANs. others will work if a SAN
drive is presented by SAN driver as local.
however another tip here is:
BOL
Note When running on Windows NT, SQL Server performance can be improved
further if the databases are created on disks formatted using NTFS and,
specifically, 64-KB extent sizes. In Windows 2000, setting the file system
cluster size to 64-KB extent size using the /A format option will also
improve performance. For more information about formatting an NTFS disk, see
the Windows NT or Windows 2000 documentation.
"Farmer" <someone@.somewhere.com> wrote in message
news:ez99%23ilrFHA.3068@.TK2MSFTNGP14.phx.gbl...
> Incorrect. olny local drives can be used for this purpose or special SAN
> that you probably don't have.
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:uMTRslkrFHA.1028@.TK2MSFTNGP12.phx.gbl...
>|||Am I reading that you have 700gb of indexing on 300gb of tables?
Consider if you are indexing on too many columns:
http://msdn.microsoft.com/library/d.../>
indexes.asp
Also, look into the extent of index fragmentation:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:29753642-4A9E-4DC3-975B-578EBFD963AC@.microsoft.com...
> what are the performance gains/issues?
> I am looking at splitting up a 1 tb data file into a 300gb data file and a
> 700gb index file. I have a gb network, but I am worried about
> administrating
> mutiple machines.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>|||> Incorrect. olny local drives can be used for this purpose or special SAN
> that you probably don't have.
Uh, we have multiple Clariions. But thanks for the tip.|||And here's the full story on creating database files on network drives.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Farmer" <someone@.somewhere.com> wrote in message news:ez99%23ilrFHA.3068@.TK2MSFTNGP14.phx.
gbl...
> Incorrect. olny local drives can be used for this purpose or special SAN
> that you probably don't have.
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in messag
e
> news:uMTRslkrFHA.1028@.TK2MSFTNGP12.phx.gbl...
>|||Well, we are currently delivering on Del 2650's with a powervault loaded wit
h
16 - 15k 73gb hard drives configured into one raid-5 drive. The search times
on this 1tb table are very fast, but I am looking to scale it out. I would
like to seperate the indexes and the data onto different disks, but then
started wondering if I could store the data on one server, and say store the
indexes on 3-4 other servers that point to the data servers.
My research has found that 70-80% of query times is caught up in the indexes
looking for the right keys to use to go get the data with. I have 26 indexes
built on my table that covers 95% of the queries uses according to our log
files. I would like to spread out the work done in the index search to a fe
w
specialized servers if possible. I dont think that MS can do this, but I can
probably build something myself that could.
thanks!!
"Aaron Bertrand [SQL Server MVP]" wrote:
> Uh, we have multiple Clariions. But thanks for the tip.
>
>
Can import from xls but what about csv??
Below is the query I use to import from an xls file. What about importing
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extend ed Properties=Excel
8.0')...ChallengeResponse$
Thanks in advance,
Eric
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extend ed Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
|||You can use the OLEDB provider for JET, which provides support for ISAM
sources; however, you will need to specify the type by using the Extended
Properties=TEXT instead of EXCEL and then the file name as the original with
the .CSV extension.
Sincerely,
Anthony Thomas
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:eXSJT6GCFHA.2460@.TK2MSFTNGP14.phx.gbl...
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extend ed Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extend ed Properties=Excel
8.0')...ChallengeResponse$
Thanks in advance,
Eric
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extend ed Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
|||You can use the OLEDB provider for JET, which provides support for ISAM
sources; however, you will need to specify the type by using the Extended
Properties=TEXT instead of EXCEL and then the file name as the original with
the .CSV extension.
Sincerely,
Anthony Thomas
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:eXSJT6GCFHA.2460@.TK2MSFTNGP14.phx.gbl...
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extend ed Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
Can import from xls but what about csv??
Below is the query I use to import from an xls file. What about importing
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
8.0')...ChallengeResponse$
Thanks in advance,
Eric"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA|||You can use the OLEDB provider for JET, which provides support for ISAM
sources; however, you will need to specify the type by using the Extended
Properties=TEXT instead of EXCEL and then the file name as the original with
the .CSV extension.
Sincerely,
Anthony Thomas
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:eXSJT6GCFHA.2460@.TK2MSFTNGP14.phx.gbl...
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
8.0')...ChallengeResponse$
Thanks in advance,
Eric"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA|||You can use the OLEDB provider for JET, which provides support for ISAM
sources; however, you will need to specify the type by using the Extended
Properties=TEXT instead of EXCEL and then the file name as the original with
the .CSV extension.
Sincerely,
Anthony Thomas
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:eXSJT6GCFHA.2460@.TK2MSFTNGP14.phx.gbl...
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
Thursday, March 8, 2012
Can import from xls but what about csv??
Below is the query I use to import from an xls file. What about importing
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
8.0')...ChallengeResponse$
Thanks in advance,
Eric"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA|||You can use the OLEDB provider for JET, which provides support for ISAM
sources; however, you will need to specify the type by using the Extended
Properties=TEXT instead of EXCEL and then the file name as the original with
the .CSV extension.
Sincerely,
Anthony Thomas
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:eXSJT6GCFHA.2460@.TK2MSFTNGP14.phx.gbl...
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
from a csv file. I change the name from ChallengeResponse.xls to
ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
Select *
FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
8.0')...ChallengeResponse$
Thanks in advance,
Eric"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA|||You can use the OLEDB provider for JET, which provides support for ISAM
sources; however, you will need to specify the type by using the Extended
Properties=TEXT instead of EXCEL and then the file name as the original with
the .CSV extension.
Sincerely,
Anthony Thomas
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:eXSJT6GCFHA.2460@.TK2MSFTNGP14.phx.gbl...
"Eric Lovelace" <EricLovelace@.discussions.microsoft.com> wrote in message
news:50366645-7708-4956-9C49-48C585236E06@.microsoft.com...
> Below is the query I use to import from an xls file. What about importing
> from a csv file. I change the name from ChallengeResponse.xls to
> ChallengeResponse.csv but I get an error. Anyone know any tricks to this?
> Select *
> FROM OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Data
> Source=C:\cr\dataload\ChallengeResponse.xls;Extended Properties=Excel
> 8.0')...ChallengeResponse$
>
> Thanks in advance,
> Eric
I'm not sure about using OPENDATASOURCE for a CSV, but you can definitely
use bcp as well as DTS.
Rick Sawtell
MCT, MCSD, MCDBA
Subscribe to:
Posts (Atom)