deAttach database: February 2012

Saturday, February 25, 2012

DCOM Error 10005

I have a setup where in following scenario i get DCOM error
1. Install a 32 bit NT service on x64
2. Install SQL 2005 Server
3. Upgrade the 32bit NT service using msi package.
After step 2 the NT service is running fine.
But after step 3,
Service fails to start with Error,
The MyService service failed to start due to the following error:
The service did not respond to the start or control request in a
timely fashion. (event 7000)
Event viewer also shows the DCOM error 10005.
DCOM got error "The service did not respond to the start or control
request in a timely fashion. " attempting to start the service
MyService with arguments "-Service" in order to run the server.
This problem is seen only on setups where i have SQL 2005 installed.
Is there a way to find out why "Service Control Manager" manager gives
errors 7000 & 7009. '
MyService is created using VC6 ATL wizard. It is run in "Local System"
account and in non-interactive mode.
Any help will be greatly appreciated.
Thanks,
wnHi
"wn123456@.gmail.com" wrote:
> I have a setup where in following scenario i get DCOM error
> 1. Install a 32 bit NT service on x64
> 2. Install SQL 2005 Server
> 3. Upgrade the 32bit NT service using msi package.
> After step 2 the NT service is running fine.
> But after step 3,
> Service fails to start with Error,
> The MyService service failed to start due to the following error:
> The service did not respond to the start or control request in a
> timely fashion. (event 7000)
> Event viewer also shows the DCOM error 10005.
> DCOM got error "The service did not respond to the start or control
> request in a timely fashion. " attempting to start the service
> MyService with arguments "-Service" in order to run the server.
> This problem is seen only on setups where i have SQL 2005 installed.
> Is there a way to find out why "Service Control Manager" manager gives
> errors 7000 & 7009. '
> MyService is created using VC6 ATL wizard. It is run in "Local System"
> account and in non-interactive mode.
> Any help will be greatly appreciated.
> Thanks,
> wn
>
You may want to check http://support.microsoft.com/kb/892500 this shows how
to turn on logging so you may get more information.
John|||On Feb 27, 7:23 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
>
>
> "wn123...@.gmail.com" wrote:
> > I have a setup where in following scenario i get DCOM error
> > 1. Install a 32 bit NT service on x64
> > 2. Install SQL 2005 Server
> > 3. Upgrade the 32bit NT service using msi package.
> > After step 2 the NT service is running fine.
> > But after step 3,
> > Service fails to start with Error,
> > The MyService service failed to start due to the following error:
> > The service did not respond to the start or control request in a
> > timely fashion. (event 7000)
> > Event viewer also shows the DCOM error 10005.
> > DCOM got error "The service did not respond to the start or control
> > request in a timely fashion. " attempting to start the service
> > MyService with arguments "-Service" in order to run the server.
> > This problem is seen only on setups where i have SQL 2005 installed.
> > Is there a way to find out why "Service Control Manager" manager gives
> > errors 7000 & 7009. '
> > MyService is created using VC6 ATL wizard. It is run in "Local System"
> > account and in non-interactive mode.
> > Any help will be greatly appreciated.
> > Thanks,
> > wn
> You may want to checkhttp://support.microsoft.com/kb/892500this shows how
> to turn on logging so you may get more information.
> John- Hide quoted text -
> - Show quoted text -
Thanks John.
I tried by adding registry entries mentioned in the KB article. But i
am not getting any additional error events.
Looks like this is not an DCOM related problem.
I have another NT service which is not a COM service that too shows
the same problem.
Do you have any idea if i can enable some logging for "Service control
Manager" ?
The control do not reach to ServiceMain function of MyService.
Is it that "Service control Manager" is returning error ?|||Hi
> Thanks John.
> I tried by adding registry entries mentioned in the KB article. But i
> am not getting any additional error events.
> Looks like this is not an DCOM related problem.
> I have another NT service which is not a COM service that too shows
> the same problem.
> Do you have any idea if i can enable some logging for "Service control
> Manager" ?
> The control do not reach to ServiceMain function of MyService.
> Is it that "Service control Manager" is returning error ?
>
Have you looked in the event log for any messages?
John

DCOM Error 10005

I have a setup where in following scenario i get DCOM error
1. Install a 32 bit NT service on x64
2. Install SQL 2005 Server
3. Upgrade the 32bit NT service using msi package.
After step 2 the NT service is running fine.
But after step 3,
Service fails to start with Error,
The MyService service failed to start due to the following error:
The service did not respond to the start or control request in a
timely fashion. (event 7000)
Event viewer also shows the DCOM error 10005.
DCOM got error "The service did not respond to the start or control
request in a timely fashion. " attempting to start the service
MyService with arguments "-Service" in order to run the server.
This problem is seen only on setups where i have SQL 2005 installed.
Is there a way to find out why "Service Control Manager" manager gives
errors 7000 & 7009. '
MyService is created using VC6 ATL wizard. It is run in "Local System"
account and in non-interactive mode.
Any help will be greatly appreciated.
Thanks,
wnHi
"wn123456@.gmail.com" wrote:

> I have a setup where in following scenario i get DCOM error
> 1. Install a 32 bit NT service on x64
> 2. Install SQL 2005 Server
> 3. Upgrade the 32bit NT service using msi package.
> After step 2 the NT service is running fine.
> But after step 3,
> Service fails to start with Error,
> The MyService service failed to start due to the following error:
> The service did not respond to the start or control request in a
> timely fashion. (event 7000)
> Event viewer also shows the DCOM error 10005.
> DCOM got error "The service did not respond to the start or control
> request in a timely fashion. " attempting to start the service
> MyService with arguments "-Service" in order to run the server.
> This problem is seen only on setups where i have SQL 2005 installed.
> Is there a way to find out why "Service Control Manager" manager gives
> errors 7000 & 7009. '
> MyService is created using VC6 ATL wizard. It is run in "Local System"
> account and in non-interactive mode.
> Any help will be greatly appreciated.
> Thanks,
> wn
>
You may want to check http://support.microsoft.com/kb/892500 this shows how
to turn on logging so you may get more information.
John|||On Feb 27, 7:23 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
>
>
> "wn123...@.gmail.com" wrote:
>
>
>
>
>
>
>
> You may want to checkhttp://support.microsoft.com/kb/892500this shows how
> to turn on logging so you may get more information.
> John- Hide quoted text -
> - Show quoted text -
Thanks John.
I tried by adding registry entries mentioned in the KB article. But i
am not getting any additional error events.
Looks like this is not an DCOM related problem.
I have another NT service which is not a COM service that too shows
the same problem.
Do you have any idea if i can enable some logging for "Service control
Manager" ?
The control do not reach to ServiceMain function of MyService.
Is it that "Service control Manager" is returning error ?|||Hi

> Thanks John.
> I tried by adding registry entries mentioned in the KB article. But i
> am not getting any additional error events.
> Looks like this is not an DCOM related problem.
> I have another NT service which is not a COM service that too shows
> the same problem.
> Do you have any idea if i can enable some logging for "Service control
> Manager" ?
> The control do not reach to ServiceMain function of MyService.
> Is it that "Service control Manager" is returning error ?
>
Have you looked in the event log for any messages?
John

DCOM error

I just installed sql server 2005 on a windows 2003 server. I chose the option to install but do not configure. After restarting, I used the Reporting SErvices Configuration Manager and it all looks ok. When I browse to //localhost/reports I get a rs page with the message of:

The request failed with HTTP status 400: Bad Request.

One slightly unusual thing is SQL Server 2005 was installed as a named instance ("(local)\SQL2K5") - the server's default instance is a sql 2000 installation, which had RS installed and running. Before configuring RS for 2k5, I deleted the VDs for Reports and ReportServer from IIS, so that I could recreate them to use 2K5.

The new ReportServer VD appears to work (although no reports are installed to test).

Thanks for any help getting this issue resolved!

I have a bunch of these in Application Log... I have a feeling it's related.. I don't know what it means though
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

Anyone?

|||

I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't):

1. Click Start | Run and run dcomcnfg.exe

2. In MMC, open Component Services | My Computer

3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area

4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions)

If that doesn't do the trick:

1. Start DCOMCNFG

2. Under Component Services -> My Computer -> Dcom Config -> Netman click
Properties, then Security tab

3. In Launch and Activation Permissions box click Edit.

4. Add Network Service with Local Launch and Local Activation permissions

Good luck!|||Nope... you were right - neither worked.

I have since created 2 new VDs - Reports2K5 and ReportServer2k5, which correspond to my instance of SQL SErver 2005. The REportServer2K5 appears to be working OK... Reports2K5 (manager) still gives me the 400 error.
Would this error be logged anywhere?

Thanks for your help.||| Big Smile The site (Default web site) was using a specific IP address.. I changed it to All Unassigned and it works!

|||Good catch!|||Is there a way to configure SQL 2005 Reporting Services using an IIS Website with a specific IP?|||

I'm getting the same event error:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool.

I went into Component Services and Netman has local launch permissions and can find no reference for "Network Connection Manager Class" (the name the ID translates to based upon registry lookup). What in Component Services should I be looking for and where? This is a brand new installation of 2003 Server Professional w/ Exchange 2003 and all the latest service packs/patches. Thanks,

John

|||

Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.

Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.

Report server had previously been working ok until the final site config when the host headers were implemented.

As one site could act as a default then the problem was resolved by adding an additional binding for port 80 with no header specified.

All boxes running fine now.

The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.

|||

I believe this errors can be fixed by the following 899965

http://support.microsoft.com/?kbid=899965

|||

had a similar problem and found out the following:

If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

The result is then
<Configuration>
<UI>
<ReportServerUrl>http://mbs05:8088/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
.....

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

|||Just a blank host header for a site that has an assigned IP. Work on three different boxes for me.|||Same for me. I moved Reporting Services to it's own website (because sharepoint installed it's own ISAPI filter on the default website that was totally screwing up RS), and set a host header for the new site. Every time I turned off the default website, RS would break, even though it should have nothing to do with it.
I switched the host headers around (so the default website has host headers, and the RS website doesn't) now it works perfectly.
|||

Folks,

I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.

If one of you could please set me right it would be much appreciated.

Firstly, the error I'm getting in the event log is as follows:

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool."

So I go to the regedit and look it up.
I search for BA126AD1-2166-11D1-B1D0-00805FC1270E
And Regedit duly comes up with:

HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}

Which identifies this as the "Network Connection Manager Class"

Allright..now the KB article then tells me to :

4. Click Start, click Run, type dcomcnfg in the Open box, and then click OK.

If a Windows Security Alert message prompts you to keep blocking the Microsoft Management Console program, click to unblock the program. 5. In Component Services, double-click Component Services, double-click Computers, double-click My Computer, and then click DCOM Config. 6. In the details pane, locate the program by using the friendly name.

If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.

And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)

So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....

I'd really appreciate a bit of help on this one...

Thanks

|||

Another question on this...just to be sure I'm chasing the right tail....

When I point a browser at the site http://localhost/Reportserver$DeptServer05 I get the following message...

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

DCOM error

The new ReportServer VD appears to work (although no reports are installed to test).

Thanks for any help getting this issue resolved!

Anyone?

|||

I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't):

1. Click Start | Run and run dcomcnfg.exe

2. In MMC, open Component Services | My Computer

3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area

4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions)

If that doesn't do the trick:

1. Start DCOMCNFG

2. Under Component Services -> My Computer -> Dcom Config -> Netman click
Properties, then Security tab

3. In Launch and Activation Permissions box click Edit.

4. Add Network Service with Local Launch and Local Activation permissions

Good luck!

|||Nope... you were right - neither worked.

Thanks for your help.||| Big Smile The site (Default web site) was using a specific IP address.. I changed it to All Unassigned and it works!

|||Good catch!|||Is there a way to configure SQL 2005 Reporting Services using an IIS Website with a specific IP?|||

I'm getting the same event error:

John

|||

Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.

Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.

Report server had previously been working ok until the final site config when the host headers were implemented.

As one site could act as a default then the problem was resolved by adding an additional binding for port 80 with no header specified.

All boxes running fine now.

The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.

|||

I believe this errors can be fixed by the following 899965

http://support.microsoft.com/?kbid=899965

|||

had a similar problem and found out the following:

If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

Folks,

I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.

If one of you could please set me right it would be much appreciated.

Firstly, the error I'm getting in the event log is as follows:

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool."

So I go to the regedit and look it up.
I search for BA126AD1-2166-11D1-B1D0-00805FC1270E
And Regedit duly comes up with:

HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}

Which identifies this as the "Network Connection Manager Class"

Allright..now the KB article then tells me to :

4. Click Start, click Run, type dcomcnfg in the Open box, and then click OK.

If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.

And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)

So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....

I'd really appreciate a bit of help on this one...

Thanks

|||

Another question on this...just to be sure I'm chasing the right tail....

When I point a browser at the site http://localhost/Reportserver$DeptServer05 I get the following message...

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

DCOM error

The new ReportServer VD appears to work (although no reports are installed to test).

Thanks for any help getting this issue resolved!

Anyone?

|||

I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't):

1. Click Start | Run and run dcomcnfg.exe

2. In MMC, open Component Services | My Computer

3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area

4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions)

If that doesn't do the trick:

1. Start DCOMCNFG

2. Under Component Services -> My Computer -> Dcom Config -> Netman click
Properties, then Security tab

3. In Launch and Activation Permissions box click Edit.

4. Add Network Service with Local Launch and Local Activation permissions

Good luck!

|||Nope... you were right - neither worked.

Thanks for your help.||| Big Smile The site (Default web site) was using a specific IP address.. I changed it to All Unassigned and it works!|||Good catch!|||Is there a way to configure SQL 2005 Reporting Services using an IIS Website with a specific IP?|||

I'm getting the same event error:

John

|||

Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.

Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.

Report server had previously been working ok until the final site config when the host headers were implemented.

As one site could act as a default then the problem was resolved by adding an additional binding for port 80 with no header specified.

All boxes running fine now.

The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.

|||

I believe this errors can be fixed by the following 899965

http://support.microsoft.com/?kbid=899965

|||

had a similar problem and found out the following:

If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

Folks,

I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.

If one of you could please set me right it would be much appreciated.

Firstly, the error I'm getting in the event log is as follows:

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool."

So I go to the regedit and look it up.
I search for BA126AD1-2166-11D1-B1D0-00805FC1270E
And Regedit duly comes up with:

HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}

Which identifies this as the "Network Connection Manager Class"

Allright..now the KB article then tells me to :

Click Start, click Run, type dcomcnfg in the Open box, and then click OK.

If a Windows Security Alert message prompts you to keep blocking the Microsoft Management Console program, click to unblock the program.

In Component Services, double-click Component Services, double-click Computers, double-click My Computer, and then click DCOM Config.

In the details pane, locate the program by using the friendly name.

If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.

And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)

So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....

I'd really appreciate a bit of help on this one...

Thanks

|||

Another question on this...just to be sure I'm chasing the right tail....

When I point a browser at the site http://localhost/Reportserver$DeptServer05 I get the following message...

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

DCOM error

The new ReportServer VD appears to work (although no reports are installed to test).

Thanks for any help getting this issue resolved!

Anyone?

|||

I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't):

1. Click Start | Run and run dcomcnfg.exe

2. In MMC, open Component Services | My Computer

3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area

4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions)

If that doesn't do the trick:

1. Start DCOMCNFG

2. Under Component Services -> My Computer -> Dcom Config -> Netman click
Properties, then Security tab

3. In Launch and Activation Permissions box click Edit.

4. Add Network Service with Local Launch and Local Activation permissions

Good luck!|||Nope... you were right - neither worked.

Thanks for your help.||| Big Smile The site (Default web site) was using a specific IP address.. I changed it to All Unassigned and it works!

|||Good catch!|||Is there a way to configure SQL 2005 Reporting Services using an IIS Website with a specific IP?|||

I'm getting the same event error:

John

|||

Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.

Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.

Report server had previously been working ok until the final site config when the host headers were implemented.

As one site could act as a default then the problem was resolved by adding an additional binding for port 80 with no header specified.

All boxes running fine now.

The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.

|||

I believe this errors can be fixed by the following 899965

http://support.microsoft.com/?kbid=899965

|||

had a similar problem and found out the following:

If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

Folks,

I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.

If one of you could please set me right it would be much appreciated.

Firstly, the error I'm getting in the event log is as follows:

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool."

So I go to the regedit and look it up.
I search for BA126AD1-2166-11D1-B1D0-00805FC1270E
And Regedit duly comes up with:

HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}

Which identifies this as the "Network Connection Manager Class"

Allright..now the KB article then tells me to :

4.Click Start, click Run, typedcomcnfg in the Open box, and then click OK.

If a Windows Security Alert message prompts you to keep blocking the Microsoft Management Console program, click to unblock the program.5.In Component Services, double-click Component Services, double-click Computers, double-click My Computer, and then click DCOM Config.6.In the details pane, locate the program by using the friendly name.

If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.

And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)

So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....

I'd really appreciate a bit of help on this one...

Thanks

|||

Another question on this...just to be sure I'm chasing the right tail....

When I point a browser at the site http://localhost/Reportserver$DeptServer05 I get the following message...

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

DCOM error

The new ReportServer VD appears to work (although no reports are installed to test).

Thanks for any help getting this issue resolved!

Anyone?

|||

I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't):

1. Click Start | Run and run dcomcnfg.exe

2. In MMC, open Component Services | My Computer

3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area

4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions)

If that doesn't do the trick:

1. Start DCOMCNFG

2. Under Component Services -> My Computer -> Dcom Config -> Netman click
Properties, then Security tab

3. In Launch and Activation Permissions box click Edit.

4. Add Network Service with Local Launch and Local Activation permissions

Good luck!|||Nope... you were right - neither worked.

Thanks for your help.||| Big Smile The site (Default web site) was using a specific IP address.. I changed it to All Unassigned and it works!

|||Good catch!|||Is there a way to configure SQL 2005 Reporting Services using an IIS Website with a specific IP?|||

I'm getting the same event error:

John

|||

Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.

Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.

Report server had previously been working ok until the final site config when the host headers were implemented.

As one site could act as a default then the problem was resolved by adding an additional binding for port 80 with no header specified.

All boxes running fine now.

The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.

|||

I believe this errors can be fixed by the following 899965

http://support.microsoft.com/?kbid=899965

|||

had a similar problem and found out the following:

If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

Folks,

I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.

If one of you could please set me right it would be much appreciated.

Firstly, the error I'm getting in the event log is as follows:

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool."

So I go to the regedit and look it up.
I search for BA126AD1-2166-11D1-B1D0-00805FC1270E
And Regedit duly comes up with:

HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}

Which identifies this as the "Network Connection Manager Class"

Allright..now the KB article then tells me to :

4.Click Start, click Run, typedcomcnfg in the Open box, and then click OK.

If a Windows Security Alert message prompts you to keep blocking the Microsoft Management Console program, click to unblock the program.5.In Component Services, double-click Component Services, double-click Computers, double-click My Computer, and then click DCOM Config.6.In the details pane, locate the program by using the friendly name.

If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.

And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)

So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....

I'd really appreciate a bit of help on this one...

Thanks

|||

Another question on this...just to be sure I'm chasing the right tail....

When I point a browser at the site http://localhost/Reportserver$DeptServer05 I get the following message...

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

DCOM error

The new ReportServer VD appears to work (although no reports are installed to test).

Thanks for any help getting this issue resolved!

Anyone?

|||

I'm not sure the applog error that you're catching is related, so let's try to fix it and then see if the original problem goes away (I suspect it won't):

1. Click Start | Run and run dcomcnfg.exe

2. In MMC, open Component Services | My Computer

3. Right-click My Computer, choose Properties, select the COM Security tab. Click on the edit default button in Launch permissions options area

4. Add network service and give it appropriate perms (Local Launch and Local Activation permissions)

If that doesn't do the trick:

1. Start DCOMCNFG

2. Under Component Services -> My Computer -> Dcom Config -> Netman click
Properties, then Security tab

3. In Launch and Activation Permissions box click Edit.

4. Add Network Service with Local Launch and Local Activation permissions

Good luck!

|||Nope... you were right - neither worked.

I'm getting the same event error:

John

|||

Had very similar on 4 servers, all using unassigned , but they all had host headers specified. Short summary below to explain.

Each server had three web sites all bound to unassigned ip address, using host headers and diffrent ssl ports to separate ou the traffic.

Report server had previously been working ok until the final site config when the host headers were implemented.

As one site could act as a default then the problem was resolved by adding an additional binding for port 80 with no header specified.

All boxes running fine now.

The origonal posting pointed me in the right direction and as I was also implmenting http endpoints in SQL , I could have spent awhile on red herings. Much thanks.

|||

I believe this errors can be fixed by the following 899965

http://support.microsoft.com/?kbid=899965

|||

had a similar problem and found out the following:

If you want to run Reporting Services under a different port than normal, you have to change these two config files:
rsreportserver.config
and
RSWebApplication.config

Enter the full path (like http://servername:port/ReportServer) to <ReportServerUrl> (delete <ReportServerVirtualDirectory> then!) or resp. <UrlRoot>

and

<Configuration>
... <Service>
....
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://mbs05:8088/reportserver</UrlRoot>
<UnattendedExecutionAccount>
...

Hope this helps,
Martin

PS: see also http://msdn2.microsoft.com/en-us/library/ms159261(SQL.90).aspx

Folks,

I'm trying to resolve the same error but having a bit of trouble following through the instructions in the KB.

If one of you could please set me right it would be much appreciated.

Firstly, the error I'm getting in the event log is as follows:

"The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool."

So I go to the regedit and look it up.
I search for BA126AD1-2166-11D1-B1D0-00805FC1270E
And Regedit duly comes up with:

HKEY_CLASSES_ROOT\CLSID\{BA126AD1-2166-11D1-B1D0-00805FC1270E}

Which identifies this as the "Network Connection Manager Class"

Allright..now the KB article then tells me to :

Click Start, click Run, type dcomcnfg in the Open box, and then click OK.

If a Windows Security Alert message prompts you to keep blocking the Microsoft Management Console program, click to unblock the program.

In Component Services, double-click Component Services, double-click Computers, double-click My Computer, and then click DCOM Config.

In the details pane, locate the program by using the friendly name.

If the AppGUID identifier is listed instead of the friendly name, locate the program by using this identifier.

And this is where I'm stuck.. cos there is nothing there that corresponds to a Network Connection Manager Class or to the CLSID... (is that what they mean in the doc when they refere to AppGUID ?)

So, I can't continue on with the fix.. because I can't find the right app to fix the launch and activation permissions for....

I'd really appreciate a bit of help on this one...

Thanks

|||

Another question on this...just to be sure I'm chasing the right tail....

When I point a browser at the site http://localhost/Reportserver$DeptServer05 I get the following message...

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

dcdiag error

Hi all,
This morning my dcdiag command show this error
Starting test: systemlog
An Error Event occured. EventID: 0x00000457
Time Generated: 08/24/2007 08:41:46
(Event String could not be retrieved)
An Error Event occured. EventID: 0x00000457
Time Generated: 08/24/2007 08:41:48
(Event String could not be retrieved)
................... myDC failed test systemlog
Anybody can help me with this? or explain to me the error.
Tks
JFBHi
This is not a SQL Server issue, you may want to post in a more appropriate
newsgroup.
John
"JFB" wrote:
> Hi all,
> This morning my dcdiag command show this error
> Starting test: systemlog
> An Error Event occured. EventID: 0x00000457
> Time Generated: 08/24/2007 08:41:46
> (Event String could not be retrieved)
> An Error Event occured. EventID: 0x00000457
> Time Generated: 08/24/2007 08:41:48
> (Event String could not be retrieved)
> ................... myDC failed test systemlog
> Anybody can help me with this? or explain to me the error.
> Tks
> JFB
>
>|||Ups... sorry...
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5A1ADB7C-D22F-4A9B-A1A3-0DA7A68F5437@.microsoft.com...
> Hi
> This is not a SQL Server issue, you may want to post in a more appropriate
> newsgroup.
> John
> "JFB" wrote:
>> Hi all,
>> This morning my dcdiag command show this error
>> Starting test: systemlog
>> An Error Event occured. EventID: 0x00000457
>> Time Generated: 08/24/2007 08:41:46
>> (Event String could not be retrieved)
>> An Error Event occured. EventID: 0x00000457
>> Time Generated: 08/24/2007 08:41:48
>> (Event String could not be retrieved)
>> ................... myDC failed test systemlog
>> Anybody can help me with this? or explain to me the error.
>> Tks
>> JFB
>>

DBxtra Data explorer

DBxtra Data explorer
DBxtra version 1 is ready.
You can connect to unlimited MS Access, MS SQL Server, Paradox, PDF and Excel tables and queries.
Get the sense out of your data!1
1. Connect to your data
2. Explore your data
3. Design and deploy your reports
4. Export your data
5. Send your data by E-mail
6. Schedule reports and alerts
Try the free Download!
http://www.dbxtra.comADVERTISING

I think i am going to post ads for commercial items that i believe in

"hey you got you chocolate in my peanut butter"
"You got your peanut butter on my chocolate"
"two great tastes that taste great together"
reeses peanut butter cups :eek:|||Hey...whats with the dead chick on the couch?

http://www.dbxtra.com/images/p1.jpg|||I've got another idea for a great commercial venture.

Gasoline powered "adult" toys!

What a marketing opportunity! We can all get rich, very quickly... Live lives of leisure, travel the world, sample the best of everything. We can be rich I tell you, just rich if we all work together to tap this as yet unexplored marketing opportunity!!!

On a (very slightly) more serious note, will an admin please move this thread to the Marketplace (http://www.dbforums.com/f188) where it belongs?

-PatP|||But if will have to marketed for outdoor use only...

Maybe the chick on the couch was using one of your products and passed out from the exhaust...|||pat i hate to tell you this but we already have gasoline powered adult toys.

porsche
ferrari
jaguar
lamborghini
etc.|||pat i hate to tell you this but we already have gasoline powered adult toys... and look at the money that people will spend on them! I tell you, there is a fortune to be made here if we can just find the right products and advertising medium!!!

Somebody, PLEASE move this to the MarketPlace (http://www.dbforums.com/f188)!

-PatP

dbuse function, and spaces

Hi,
We have a problem when using the dbuse function, with a database that
include a space in its name.
Any suggestions ?
I try to wrape it with 'db name' - got 000170 015 Line 1: Incorrect
syntax near

And with "db name" and got the same.

Thanks
EyalHi

You may be able to use the square brackets around the name, otherwise check
out setting quoted identifiers.

To do this you will need to set the DB Library Option DBQUOTEDIDENT see
Books Online:

mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dbl
ibc.chm::/dbc_pdcapa_6vhv.htm

John

"Eyal Goren" <eyal_goren@.bmc.com> wrote in message
news:88eabf1e.0401040029.238db349@.posting.google.c om...
> Hi,
> We have a problem when using the dbuse function, with a database that
> include a space in its name.
> Any suggestions ?
> I try to wrape it with 'db name' - got 000170 015 Line 1: Incorrect
> syntax near
> And with "db name" and got the same.
> Thanks
> Eyal

DBTYPE_DBTIMESTAMP OLE DB question

Folks,
I am trying to use ole db to read a date field created as a DATETIME in C#.
It only seems to work if I set the binding type (wType) to
DBTYPE_DBTIMESTAMP. When I do this, 16 bytes of data are written to my
buffer. The question then is what to do with this raw data. What should I
cast it to, so that I can make use of it? I can't think of date/time types
that are 16 bytes long.
Thank you,
Matthew FlemingHi
The SQL Server data type "Timestamp" has nothing to do with date or time. It
is a binary number that is sequential and is generally used for concurrency
control in applications.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"dermite" <dermite@.discussions.microsoft.com> wrote in message
news:614ADA8C-E424-4419-9FBC-B86C93646E80@.microsoft.com...
> Folks,
> I am trying to use ole db to read a date field created as a DATETIME in
> C#.
> It only seems to work if I set the binding type (wType) to
> DBTYPE_DBTIMESTAMP. When I do this, 16 bytes of data are written to my
> buffer. The question then is what to do with this raw data. What should I
> cast it to, so that I can make use of it? I can't think of date/time types
> that are 16 bytes long.
> Thank you,
> Matthew Fleming|||If this is so, then why is the field (which was created as type DATETIME),
readable only with a binding type of DBTYPE_DBTIMESTAMP? I tried
DBTYPE_DATE and it did not work (0 bytes were written to the buffer).
Matthew Fleming
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> The SQL Server data type "Timestamp" has nothing to do with date or time.
It
> is a binary number that is sequential and is generally used for concurrenc
y
> control in applications.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "dermite" <dermite@.discussions.microsoft.com> wrote in message
> news:614ADA8C-E424-4419-9FBC-B86C93646E80@.microsoft.com...
>
>|||Mike Epprecht (SQL MVP) (mike@.epprecht.net) writes:
> The SQL Server data type "Timestamp" has nothing to do with date or
> time. It is a binary number that is sequential and is generally used for
> concurrency control in applications.
Yes, but the OLE DB data type DBTYPE_DBTIMESTAMP has everything to do
with date and time. That is in fact how you get back the datetime data type
from SQL Server.
Anyway, the actual question have been sorted out in
microsoft.public.olddb.data. Please to do not post the same question to
different newsgroups independently!
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

DBTYPE of 130 at compile time and 5 at run time

If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

www.databasetimes.net

See this: http://support.microsoft.com/kb/251238/

DBTYPE of 130 at compile time and 5 at run time

If any one can help

Thanks

www.databasetimes.net

What were you trying to do when you encountered this error?|||

Faiz Farazi wrote:
If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

I have got the same error trying to populate a table on SQL 2005 for datawarehousing purposes from a view in Oracle 9i.

I found that the problem is usually in the data type of the columns defined in the Oracle view: for example SQL 2005 doesn't like a oracle INTEGER, but if you convert the integer columns in a NUMBER the error will disappear.
The same with the Oracle VARCHAR2.

I tryed also to set the 'lazy schema validation' option using sp_serveroption as suggested here
http://www.dbforums.com/archive/index.php/t-815652.html
but it says that this option is not available in this version of SQL...|||

Hi,

I encountered the same problem.

It occured with Oracle >= 9.2.6 (w. Sql2000 and Sql2005)

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".

When I alter the oracle-number-fields to a more precise type of e.g. number(10), the problem is solved. So, I altered all "number" to "number(38)" (the maximal allowed number format) and the problem was bypassed.

regards

Hans

|||

Hans G. wrote:

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

This is may be because the OPENQUERY does not perform a validation of the query you submit before execution time.

Hans G. wrote:

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".
When I alter the oracle-number-fields to a more precise type of e.g. number(10), the problem is solved. So, I altered all "number" to "number(38)" (the maximal allowed number format) and the problem was bypassed.

This probably has to do with the implicit conversion that the OLE DB provider performs importing data from Oracle.
I wasn't able to translate the codes provided in the error to the corresponding datatype, but looking at "Data Type Mapping with Distributed Queries" in BOL it looks like that the NUMBER type in Oracle does not correspond to any of the DBTYPE implicitly converted to numeric(p,s)...

HTH
IgorB|||

Faiz Farazi wrote:

If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

www.databasetimes.net

MR Alam (Lascomp)

Thanks Mr Alam for your support . the link you have send to me it help my problem . Thanks gain http://www.lascomp.com

Faiz Farazi

www.databasetimes.net

|||

Thanks For all the answer-

Faiz Farazi

MCDBA,OCA,A+

www.databasetimes.net

|||

this is an pain of an error

we have it too, when converting data from Oracle 9.2 running financials across to SQL 2000 tables

"openquery" seems to work best - also we found that upgrading OLE/DB and MDAC drivers had no effect !!

also pulling the data from Visual Basic seems to work better than from SQL Server directly - which is odd ?

It appears, from reading forums, that a field defined as "TEST NUMBER" is typeless

whereas a field defined as TEST NUMBER(10,2) is not - hence ODBC or OLEDB drivers get confused as they dont know what to convert these things to.

any further comments welcome

regards

|||

Thaks that′s the solution I was traying for two hours really thanks!!!!

DBTYPE of 130 at compile time and 5 at run time

If any one can help

Thanks

www.databasetimes.net

What were you trying to do when you encountered this error?|||

Faiz Farazi wrote:
If any one can help
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

I have got the same error trying to populate a table on SQL 2005 for datawarehousing purposes from a view in Oracle 9i.

Hi,

I encountered the same problem.

It occured with Oracle >= 9.2.6 (w. Sql2000 and Sql2005)

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".

regards

Hans

|||

Hans G. wrote:

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

This is may be because the OPENQUERY does not perform a validation of the query you submit before execution time.

Hans G. wrote:

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".
When I alter the oracle-number-fields to a more precise type of e.g. number(10), the problem is solved. So, I altered all "number" to "number(38)" (the maximal allowed number format) and the problem was bypassed.

HTH
IgorB|||

Faiz Farazi wrote:

If any one can help
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks
www.databasetimes.net

MR Alam (Lascomp)

Thanks Mr Alam for your support . the link you have send to me it help my problem . Thanks gain http://www.lascomp.com

Faiz Farazi

www.databasetimes.net

|||

Thanks For all the answer-

Faiz Farazi

MCDBA,OCA,A+

www.databasetimes.net

|||

this is an pain of an error

we have it too, when converting data from Oracle 9.2 running financials across to SQL 2000 tables

"openquery" seems to work best - also we found that upgrading OLE/DB and MDAC drivers had no effect !!

also pulling the data from Visual Basic seems to work better than from SQL Server directly - which is odd ?

It appears, from reading forums, that a field defined as "TEST NUMBER" is typeless

whereas a field defined as TEST NUMBER(10,2) is not - hence ODBC or OLEDB drivers get confused as they dont know what to convert these things to.

any further comments welcome

regards

|||

Thaks that′s the solution I was traying for two hours really thanks!!!!

DBTYPE of 130 at compile time and 5 at run time

If any one can help

Thanks

www.databasetimes.net

What were you trying to do when you encountered this error?|||

Faiz Farazi wrote:
If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

I have got the same error trying to populate a table on SQL 2005 for datawarehousing purposes from a view in Oracle 9i.

Hi,

I encountered the same problem.

It occured with Oracle >= 9.2.6 (w. Sql2000 and Sql2005)

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".

regards

Hans

|||

Hans G. wrote:

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

This is may be because the OPENQUERY does not perform a validation of the query you submit before execution time.

Hans G. wrote:

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".
When I alter the oracle-number-fields to a more precise type of e.g. number(10), the problem is solved. So, I altered all "number" to "number(38)" (the maximal allowed number format) and the problem was bypassed.

HTH
IgorB|||

Faiz Farazi wrote:

If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

www.databasetimes.net

MR Alam (Lascomp)

Thanks Mr Alam for your support . the link you have send to me it help my problem . Thanks gain http://www.lascomp.com

Faiz Farazi

www.databasetimes.net

|||

Thanks For all the answer-

Faiz Farazi

MCDBA,OCA,A+

www.databasetimes.net

|||

this is an pain of an error

we have it too, when converting data from Oracle 9.2 running financials across to SQL 2000 tables

"openquery" seems to work best - also we found that upgrading OLE/DB and MDAC drivers had no effect !!

also pulling the data from Visual Basic seems to work better than from SQL Server directly - which is odd ?

It appears, from reading forums, that a field defined as "TEST NUMBER" is typeless

whereas a field defined as TEST NUMBER(10,2) is not - hence ODBC or OLEDB drivers get confused as they dont know what to convert these things to.

any further comments welcome

regards

|||

Thaks that′s the solution I was traying for two hours really thanks!!!!

DBTYPE of 130 at compile time and 5 at run time

If any one can help

Thanks

www.databasetimes.net

What were you trying to do when you encountered this error?|||

Faiz Farazi wrote:
If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

I have got the same error trying to populate a table on SQL 2005 for datawarehousing purposes from a view in Oracle 9i.

Hi,

I encountered the same problem.

It occured with Oracle >= 9.2.6 (w. Sql2000 and Sql2005)

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".

regards

Hans

|||

Hans G. wrote:

In my situation, the SQL-error 7356 does not happen using the OPENQUERY-format. (select * from OPENQUERY(ORASRV, "ora-select-stmnt.....")

This is may be because the OPENQUERY does not perform a validation of the query you submit before execution time.

Hans G. wrote:

It only occurs on Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby only; if the oracle-table has fields of type "number".
When I alter the oracle-number-fields to a more precise type of e.g. number(10), the problem is solved. So, I altered all "number" to "number(38)" (the maximal allowed number format) and the problem was bypassed.

HTH
IgorB|||

Faiz Farazi wrote:

If any one can help

OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed.

Thanks

www.databasetimes.net

MR Alam (Lascomp)

Thanks Mr Alam for your support . the link you have send to me it help my problem . Thanks gain http://www.lascomp.com

Faiz Farazi

www.databasetimes.net

|||

Thanks For all the answer-

Faiz Farazi

MCDBA,OCA,A+

www.databasetimes.net

|||

this is an pain of an error

we have it too, when converting data from Oracle 9.2 running financials across to SQL 2000 tables

"openquery" seems to work best - also we found that upgrading OLE/DB and MDAC drivers had no effect !!

also pulling the data from Visual Basic seems to work better than from SQL Server directly - which is odd ?

It appears, from reading forums, that a field defined as "TEST NUMBER" is typeless

whereas a field defined as TEST NUMBER(10,2) is not - hence ODBC or OLEDB drivers get confused as they dont know what to convert these things to.

any further comments welcome

regards

|||Thaks that′s the solution I was traying for two hours really thanks!!!!

Saturday, February 25, 2012

DCOM Error 10005

DCOM Error 10005

DCOM error

DCOM error

DCOM error

DCOM error

DCOM error

DCOM error

dcdiag error

DBxtra Data explorer

dbuse function, and spaces

DBTYPE_DBTIMESTAMP OLE DB question

DBTYPE of 130 at compile time and 5 at run time

DBTYPE of 130 at compile time and 5 at run time

DBTYPE of 130 at compile time and 5 at run time

DBTYPE of 130 at compile time and 5 at run time

DBTYPE of 130 at compile time and 5 at run time

deAttach database

Blog Archive

About Me