Showing posts with label management. Show all posts
Showing posts with label management. Show all posts

Monday, March 12, 2012

QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)

I am getting the following message when I attempt to Export data in SQL Management Studio from my workstation. The error occurs as soon as I click Next to go to the Source Data Sources page of the Export wizzard. I am using SQL Server 2005 Management Studio. I get a similar error in Visual Studio 2005 when I attempt to open a SSIS project. When I click on the link in the error message the page at Micorsoft Help says there is no explanation. Any ideas on what might be wrong or what settings I am missing?

The error text is:

This wizard will close because it encountered the following error: (Microsoft SQL Server)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

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

QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)


Program Location:

at System.Runtime.InteropServices.CustomMarshalers.EnumeratorToEnumVariantMarshaler.MarshalNativeToManaged(IntPtr pNativeData)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSDBProviderInfos90.GetEnumerator()
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean fSources, WizardInputs wizardInputs)
at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)

Review this thread http://groups-beta.google.com/group/microsoft.public.dotnet.framework.setup/browse_thread/thread/a2ed96d68cb349f3/db810a1bcf8f66e4?q=qi+ienumvariant&_done=%2Fgroups%3Fhl%3Den%26lr%3Dlang_en%26safe%3Doff%26c2coff%3D1%26q%3Dqi+ienumvariant%26qt_s%3DSearch+Groups%26&_doneTitle=Back+to+Search&&d#db810a1bcf8f66e4 in other groups that might help to resolve the issue.

HTH

|||This may be due to InstallShield. Here is their solution: http://support.installshield.com/kb/view.asp?articleid=q106194

QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)

I am getting the following message when I attempt to Export data in SQL Management Studio from my workstation. The error occurs as soon as I click Next to go to the Source Data Sources page of the Export wizzard. I am using SQL Server 2005 Management Studio. I get a similar error in Visual Studio 2005 when I attempt to open a SSIS project. When I click on the link in the error message the page at Micorsoft Help says there is no explanation. Any ideas on what might be wrong or what settings I am missing?

The error text is:

This wizard will close because it encountered the following error: (Microsoft SQL Server)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

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

QI for IEnumVARIANT failed on the unmanaged server. (CustomMarshalers)


Program Location:

at System.Runtime.InteropServices.CustomMarshalers.EnumeratorToEnumVariantMarshaler.MarshalNativeToManaged(IntPtr pNativeData)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSDBProviderInfos90.GetEnumerator()
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean fSources, WizardInputs wizardInputs)
at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)

Review this thread http://groups-beta.google.com/group/microsoft.public.dotnet.framework.setup/browse_thread/thread/a2ed96d68cb349f3/db810a1bcf8f66e4?q=qi+ienumvariant&_done=%2Fgroups%3Fhl%3Den%26lr%3Dlang_en%26safe%3Doff%26c2coff%3D1%26q%3Dqi+ienumvariant%26qt_s%3DSearch+Groups%26&_doneTitle=Back+to+Search&&d#db810a1bcf8f66e4 in other groups that might help to resolve the issue.

HTH

|||This may be due to InstallShield. Here is their solution: http://support.installshield.com/kb/view.asp?articleid=q106194

Wednesday, March 7, 2012

q; Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
SQL2000 server in SQL Server Management Studio?You can register a SQL 2000 instance in SSMS but not a SQL 2005 instance in
EM. However, the subject of your message indicates an 'access denied'
error, which is different than a version incompatibility. Try to connecting
with SSMS and post the full error message.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:03DDAA79-2041-44F7-8FF2-ABA2BB9D2BCA@.microsoft.com...
> Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
> SQL2000 server in SQL Server Management Studio?|||EM will not be able to register SQL 2005 servers, AND SSMS will be able to
register SQL 2000 servers.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:03DDAA79-2041-44F7-8FF2-ABA2BB9D2BCA@.microsoft.com...
> Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
> SQL2000 server in SQL Server Management Studio?

q; Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
SQL2000 server in SQL Server Management Studio?You can register a SQL 2000 instance in SSMS but not a SQL 2005 instance in
EM. However, the subject of your message indicates an 'access denied'
error, which is different than a version incompatibility. Try to connecting
with SSMS and post the full error message.
Hope this helps.
Dan Guzman
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:03DDAA79-2041-44F7-8FF2-ABA2BB9D2BCA@.microsoft.com...
> Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
> SQL2000 server in SQL Server Management Studio?|||EM will not be able to register SQL 2005 servers, AND SSMS will be able to
register SQL 2000 servers.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:03DDAA79-2041-44F7-8FF2-ABA2BB9D2BCA@.microsoft.com...
> Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
> SQL2000 server in SQL Server Management Studio?

q; Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
SQL2000 server in SQL Server Management Studio?
You can register a SQL 2000 instance in SSMS but not a SQL 2005 instance in
EM. However, the subject of your message indicates an 'access denied'
error, which is different than a version incompatibility. Try to connecting
with SSMS and post the full error message.
Hope this helps.
Dan Guzman
SQL Server MVP
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:03DDAA79-2041-44F7-8FF2-ABA2BB9D2BCA@.microsoft.com...
> Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
> SQL2000 server in SQL Server Management Studio?
|||EM will not be able to register SQL 2005 servers, AND SSMS will be able to
register SQL 2000 servers.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:03DDAA79-2041-44F7-8FF2-ABA2BB9D2BCA@.microsoft.com...
> Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or
> SQL2000 server in SQL Server Management Studio?

Monday, February 20, 2012

Q: report statements

Hello,
We have a dental practice that uses SQL server as a database and a practice
management system. I need develop a report by using Reporting Services to be
able to print statements per patient. Is there any reports already developed
for healthcare companies so that I can check and see what exactly I need to
include and how to do that?
Thanks,doesn't have specific health care reports, but maybe you might get some ideas.
http://www.microsoft.com/sql/reporting/downloads/default.asp
"JIM.H." wrote:
> Hello,
> We have a dental practice that uses SQL server as a database and a practice
> management system. I need develop a report by using Reporting Services to be
> able to print statements per patient. Is there any reports already developed
> for healthcare companies so that I can check and see what exactly I need to
> include and how to do that?
> Thanks,
>