Re: Exception trying to import data from Excel .


Hello,

An attempt to install Microsoft SQL Server 2005 this week has not gone
well. This situation bears some resemblance to the issue reported in
the base note. Sure hope you can provide some pointers to help clean
up this install.

^^^^^^^^^^^^^^^^^^^^^^
***************************

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

OS is XP that has been updated with SP2

^^^^^^^^^^^^^^^^^^^^^^
***************************

The message reported in the base note pops up when trying to import an
Excel spread***

TITLE: SQL Server Import and Export Wizard
------------------------------

An error occurred which the SQL Server Integration Services Wizard was
not prepared to handle.

------------------------------
ADDITIONAL INFORMATION:

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

The connection type "EXCEL" specified for connection manager
"{DEF6D1FB-B267-4876-BD71-21EED20BFCC0}" is not recognized as a valid
connection manager type. This error is returned when an attempt is made
to create a connection manager for an unknown connection type. Check the
spelling in the connection type name.
({35A5EB2F-5F49-4C69-908C-910B76CB3B8D})

------------------------------

The connection type "EXCEL" specified for connection manager
"{DEF6D1FB-B267-4876-BD71-21EED20BFCC0}" is not recognized as a valid
connection manager type. This error is returned when an attempt is made
to create a connection manager for an unknown connection type. Check the
spelling in the connection type name.
({35A5EB2F-5F49-4C69-908C-910B76CB3B8D})

------------------------------
BUTTONS:

OK
------------------------------


^^^^^^^^^^^^^^^^^^^^^^
***************************

The following was reported when I clicked on show technical details.


An error occurred which the SQL Server Integration Services Wizard was
not prepared to handle. (SQL Server Import and Export Wizard)

===================================

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------
Program Location:

at System.RuntimeMethodHandle._InvokeConstructor(Object[] args,
SignatureStruct& signature, IntPtr declaringType)
at System.RuntimeMethodHandle.InvokeConstructor(Object[] args,
SignatureStruct signature, RuntimeTypeHandle declaringType)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags
bindingAttr, Binder binder, Object[] args, CultureInfo culture,
Object[] activationAttributes)
at
Microsoft.SqlServer.Dts.DtsWizard.Step1.DataSourceComboBox_SelectedIndexChanged(Object
sender, EventArgs e)
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs
e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)

===================================

The connection type "EXCEL" specified for connection manager
"{64F34933-F4E6-464B-9F14-B271C7A92065}" is not recognized as a valid
connection manager type. This error is returned when an attempt is made
to create a connection manager for an unknown connection type. Check the
spelling in the connection type name.
({7D105397-41F6-4A2F-ADF2-87CF59C3FB94})

------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Connections.Add(String
connectionType)
at
Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOrCreateConnectionManager(String
name, String connectionType, WizardInputs wizardInputs)
at Microsoft.SqlServer.Dts.DtsWizard.ExcelForm..ctor(DataSourceInfo
info, Boolean bDest, WizardInputs inputs, WizardPage page)

===================================

The connection type "EXCEL" specified for connection manager
"{64F34933-F4E6-464B-9F14-B271C7A92065}" is not recognized as a valid
connection manager type. This error is returned when an attempt is made
to create a connection manager for an unknown connection type. Check the
spelling in the connection type name.
({7D105397-41F6-4A2F-ADF2-87CF59C3FB94})

------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnections90.Add(String
bstrConnectionType)
at Microsoft.SqlServer.Dts.Runtime.Connections.Add(String
connectionType)


^^^^^^^^^^^^^^^^^^^^^^
***************************

I was not able to re-register dtsconn.

?cmd> regsvr32.exe ?u dtsconn.dll? returns the RegSvr32 popup,
DLLUnregisterServer in dtsconn.dll failed. Return code was: 0x80070005


?cmd> regsvr32.exe dtsconn.dll? returns the RegSvr32 popup,
DLLRegisterServer in dtsconn.dll failed. Return code was: 0x80070005

^^^^^^^^^^^^^^^^^^^^^^
***************************

I was not sure where I was supposed to confirm the registry
permissions. A registry search for
{DEF6D1FB-B267-4876-BD71-21EED20BFCC0} and
{35A5EB2F-5F49-4C69-908C-910B76CB3B8D} did not find any entries.


I re-installed MDAC.

I confirmed the version of Msjet40.dll but did NOT re-install Jet SP8.
The Microsoft article indicated that 4.0.8618.0 is a newer version that
was expected due to the XP SP2 MS04-014 combination.


I also noticed that the import option for flat files is missing from
the drop down list where Excel was selected.

Backing up a little further, the installation did not proceed cleanly.
The following failure was reported during installation.

^^^^^^^^^^^^^^^^^^^^^^
***************************

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

Failed to install and configure assemblies C:\Program Files\Microsoft
SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+
catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: You must have administrative credentials to perform
this task. Contact your system administrator for assistance.

For help, click: http://tinyurl.com/zekv9

------------------------------
BUTTONS:

&Abort
&Retry
&Ignore
------------------------------

^^^^^^^^^^^^^^^^^^^^^^
***************************

The details from the link for this failure are as follows.

^^^^^^^^^^^^^^^^^^^^^^
***************************

Details
Product: SQL Server
Event ID: 29549
Source: setup.rll
Version: 9.00.1291.00
Component: SQL Server Setup
Message: Failed to install and configure assemblies [2] in the COM+
catalog. Error: [3]{Error message: [4]}{Error description: [5]}

Explanation
Microsoft SQL Server Setup could not verify that Microsoft Distributed
Transaction Coordinator (MS DTC) is running.


User Action
In the Services snap-in, verify that Distributed Transaction
Coordinator is started as a Network Service account. Use the Services
snap-in to configure MS DTC to run as a Network Service account, and
start MS DTC. Click Retry.



--------------------------------------------------------------------------------


Currently there are no Microsoft Knowledge Base articles available for
this specific error or event message. For information about other
support options you can use to find answers online, see
http://support.microsoft.com/default.aspx.

^^^^^^^^^^^^^^^^^^^^^^
***************************

I confirmed that DTC was running and tried the install several more
times with the same result. I elected to ignore the error and the
install then completed ?successfully?.

I do not have domain administrator privilege but my account does have
administrator privileges on my machine.

I am currently using Microsoft Access but find it awkward to manage
around the 2GB mdb limit. Thanks very much.

Cheers &c.
-Brian


--
SQL Server Newbie
------------------------------------------------------------------------
SQL Server Newbie's Profile: http://www.dbtalk.net/m167
View this thread: http://www.dbtalk.net/t288815

.