Afternoon,
I am trying to install Analysis Services on Win2k, and I am getting an error I don't know what to do with...
msmdsrv.exe - Ordinal not found
The ordinal 801 could not be located in the dynamic link library msjet40.dll.
I have tried:
uninstalling and re-installing Analysis Services
updating MDAC
deleting msjet40.dll and then updating MDAC
I'm at a loss... Can any suggest anything?
Thanks in advance!!Howdy
You may have to remove entries from the Registry to clean it up.
Cheers
SG
Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
Msg 7320
Hi,
I've successfully created a connection (linked server) in
SQL Server 2000 to an Oracle database (9i). I'm running
SQL Server on a WIN2K machine.
Now, I know that the connection is made because I can see
the list of tables and views under my Linked Server.
With that said, if I try ANY kind of query on these tables
I get a Msg 7320 error. The name of my Linked Server is
OracleSource. Here are some examples of queries that fail:
select * from openquery(OracleSource, 'select * from
ETA_USER.ABBR_DEVICE')
Select * From OracleSource..ETA_USER.ABBR_DEVICE
ETA_USER is the Schema and ABBR_DEVICE is the table name.
They are the same except one is using OpenQuery and not
the other. I know that this query works because I tried
it successfully in SQL Plus.
I have no idea what to try next and there doesn't seem to
be any help on the net (I've already consulted KB articles
270119, 251238, 248156 and 280106)
Any ideas, please!
Thanks, Skip.You might be encountering a limitation as described in :
244661 INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider
http://support.microsoft.com/?id=244661
You can also try dbcc trace (7300,3604) to see if you can get the provider
to return more information on why it is failing.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
I've successfully created a connection (linked server) in
SQL Server 2000 to an Oracle database (9i). I'm running
SQL Server on a WIN2K machine.
Now, I know that the connection is made because I can see
the list of tables and views under my Linked Server.
With that said, if I try ANY kind of query on these tables
I get a Msg 7320 error. The name of my Linked Server is
OracleSource. Here are some examples of queries that fail:
select * from openquery(OracleSource, 'select * from
ETA_USER.ABBR_DEVICE')
Select * From OracleSource..ETA_USER.ABBR_DEVICE
ETA_USER is the Schema and ABBR_DEVICE is the table name.
They are the same except one is using OpenQuery and not
the other. I know that this query works because I tried
it successfully in SQL Plus.
I have no idea what to try next and there doesn't seem to
be any help on the net (I've already consulted KB articles
270119, 251238, 248156 and 280106)
Any ideas, please!
Thanks, Skip.You might be encountering a limitation as described in :
244661 INFO: Limitations of Microsoft Oracle ODBC Driver and OLEDB Provider
http://support.microsoft.com/?id=244661
You can also try dbcc trace (7300,3604) to see if you can get the provider
to return more information on why it is failing.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Msg 7320
Hi,
I've successfully created a connection (linked server) in SQL Server 2000 to an Oracle database (9i). I'm running SQL Server on a WIN2K machine.
Now, I know that the connection is made because I can see the list of tables and views under my Linked Server.
With that said, if I try ANY kind of query on these tables I get a Msg 7320 error. The name of my Linked Server is OracleSource. Here are some examples of queries that fail:
select * from openquery(OracleSource, 'select * from ETA_USER.ABBR_DEVICE')
Select * From OracleSource..ETA_USER.ABBR_DEVICE
ETA_USER is the Schema and ABBR_DEVICE is the table name.
They are the same except one is using OpenQuery and not the other. I know that this query works because I tried it successfully in SQL Plus.
I have no idea what to try next and there doesn't seem to be any help on the net (I've already consulted KB articles 270119, 251238, 248156 and 280106)
Any ideas, please!
Thanks, Skip.Have you tried it with the 4 part name?|||Originally posted by Brett Kaiser
Have you tried it with the 4 part name?
The second select is using four-part naming, no? I know I'm missing the catalog (between the server name and the schema) but I don't think there's one because sp_table_ex returned NULL for this table's catalog.
Is there a way in SQL Plus to view a table's catalog if there's one?
Thanks,
Skip.|||What do you have selected under Security Tab int the linked server option in EM. I have had a problem where the Linked server to oracle did not work until i had the radio button
Be made with this security context selected.
Another Miracle .... brett|||Thanks Brett but I do need a security context because authentication is required to login to the remote server (a special user has been created for this purpose).
Plus, the EXACT same query works under SQL Plus!
Anyway, any other ideas?
Skip|||Yup ..
Thats what I am talking about ... The problem i faced a long time ago was ...
I was able to run the query from SQL plus ... also from QA but not from a stored procedure ... and using the security context helped me out ... am not sure in your case what is the problem until you elaborate what all you have tried out
I've successfully created a connection (linked server) in SQL Server 2000 to an Oracle database (9i). I'm running SQL Server on a WIN2K machine.
Now, I know that the connection is made because I can see the list of tables and views under my Linked Server.
With that said, if I try ANY kind of query on these tables I get a Msg 7320 error. The name of my Linked Server is OracleSource. Here are some examples of queries that fail:
select * from openquery(OracleSource, 'select * from ETA_USER.ABBR_DEVICE')
Select * From OracleSource..ETA_USER.ABBR_DEVICE
ETA_USER is the Schema and ABBR_DEVICE is the table name.
They are the same except one is using OpenQuery and not the other. I know that this query works because I tried it successfully in SQL Plus.
I have no idea what to try next and there doesn't seem to be any help on the net (I've already consulted KB articles 270119, 251238, 248156 and 280106)
Any ideas, please!
Thanks, Skip.Have you tried it with the 4 part name?|||Originally posted by Brett Kaiser
Have you tried it with the 4 part name?
The second select is using four-part naming, no? I know I'm missing the catalog (between the server name and the schema) but I don't think there's one because sp_table_ex returned NULL for this table's catalog.
Is there a way in SQL Plus to view a table's catalog if there's one?
Thanks,
Skip.|||What do you have selected under Security Tab int the linked server option in EM. I have had a problem where the Linked server to oracle did not work until i had the radio button
Be made with this security context selected.
Another Miracle .... brett|||Thanks Brett but I do need a security context because authentication is required to login to the remote server (a special user has been created for this purpose).
Plus, the EXACT same query works under SQL Plus!
Anyway, any other ideas?
Skip|||Yup ..
Thats what I am talking about ... The problem i faced a long time ago was ...
I was able to run the query from SQL plus ... also from QA but not from a stored procedure ... and using the security context helped me out ... am not sure in your case what is the problem until you elaborate what all you have tried out
Friday, March 9, 2012
MSDTC!
I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
Arpan
There isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
Arpan
There isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
MSDTC!
I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
MSDTC!
I have SQL Server 7.0 installed in my Win2K Pro machine. When I
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
navigate to Start-->SQL Server 7.0-->MSDTC Administrative Console, I
get the "Missing Shortcut" error. Even a search on 'dac.exe' doesn't
yield any result. Does this mean that the DTC console didn't get
installed while SQL Server 7.0 was installed? How do I install it
directly from the SQL Server Setup CD or do I have to uninstall & then
reinstall SQL Server 7.0 to make use of DTC? Or is there an altogether
different Setup CD for DTC?
This is the first time I am trying to use DTC.
Thanks,
ArpanThere isn't a seperate CD/setup for DTC. I would un-install and
re-install.
ALI
Saturday, February 25, 2012
MSDTC Error
Setup: Win2K Server, SQL server 2000 sp4
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/defaul...332&Product=sql)Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> ([url]http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql[/url
])
>
>
>|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
[vbcol=seagreen]
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
>|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPin
g?
John
"Labhesh Shrimali - Bangalore" wrote:
[vbcol=seagreen]
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
>
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/defaul...332&Product=sql)Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> ([url]http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql[/url
])
>
>
>|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
[vbcol=seagreen]
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
>|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPin
g?
John
"Labhesh Shrimali - Bangalore" wrote:
[vbcol=seagreen]
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
>
MSDTC Error
Setup: Win2K Server, SQL server 2000 sp4
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/default...32&Product=sql)
Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> (http://support.microsoft.com/default...32&Product=sql)
>
>
>
|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
[vbcol=seagreen]
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPing?
John
"Labhesh Shrimali - Bangalore" wrote:
[vbcol=seagreen]
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/default...32&Product=sql)
Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> (http://support.microsoft.com/default...32&Product=sql)
>
>
>
|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
[vbcol=seagreen]
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPing?
John
"Labhesh Shrimali - Bangalore" wrote:
[vbcol=seagreen]
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
MSDTC Error
Setup: Win2K Server, SQL server 2000 sp4
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
>
>
>|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
> > Setup: Win2K Server, SQL server 2000 sp4
> >
> > "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> > New transaction cannot enlist in the specified transaction coordinator. "
> >
> > I've seen the KB atricles if you have this problem on server 2003 but the
> > items in the steps don't exist in win 2k server.
> > (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
> >
> >
> >
> >
> >|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPing?
John
"Labhesh Shrimali - Bangalore" wrote:
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
> > Hi Ben
> >
> > Did you check out the information on the related article
> > http://support.microsoft.com/kb/306843/ ?
> >
> > Is this using a linked server?
> >
> > John
> >
> > "Ben" wrote:
> >
> > > Setup: Win2K Server, SQL server 2000 sp4
> > >
> > > "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> > > New transaction cannot enlist in the specified transaction coordinator. "
> > >
> > > I've seen the KB atricles if you have this problem on server 2003 but the
> > > items in the steps don't exist in win 2k server.
> > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
> > >
> > >
> > >
> > >
> > >
"Microsoft OLE DB Provider for SQL Server error '8004d00a'
New transaction cannot enlist in the specified transaction coordinator. "
I've seen the KB atricles if you have this problem on server 2003 but the
items in the steps don't exist in win 2k server.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)Hi Ben
Did you check out the information on the related article
http://support.microsoft.com/kb/306843/ ?
Is this using a linked server?
John
"Ben" wrote:
> Setup: Win2K Server, SQL server 2000 sp4
> "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> New transaction cannot enlist in the specified transaction coordinator. "
> I've seen the KB atricles if you have this problem on server 2003 but the
> items in the steps don't exist in win 2k server.
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
>
>
>|||I am also having Linked Server.
but not able to get out of this problem
"John Bell" wrote:
> Hi Ben
> Did you check out the information on the related article
> http://support.microsoft.com/kb/306843/ ?
> Is this using a linked server?
> John
> "Ben" wrote:
> > Setup: Win2K Server, SQL server 2000 sp4
> >
> > "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> > New transaction cannot enlist in the specified transaction coordinator. "
> >
> > I've seen the KB atricles if you have this problem on server 2003 but the
> > items in the steps don't exist in win 2k server.
> > (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
> >
> >
> >
> >
> >|||Hi
Have you verified that DTC is working correctly? Have you tried using DTCPing?
John
"Labhesh Shrimali - Bangalore" wrote:
> I am also having Linked Server.
> but not able to get out of this problem
> "John Bell" wrote:
> > Hi Ben
> >
> > Did you check out the information on the related article
> > http://support.microsoft.com/kb/306843/ ?
> >
> > Is this using a linked server?
> >
> > John
> >
> > "Ben" wrote:
> >
> > > Setup: Win2K Server, SQL server 2000 sp4
> > >
> > > "Microsoft OLE DB Provider for SQL Server error '8004d00a'
> > > New transaction cannot enlist in the specified transaction coordinator. "
> > >
> > > I've seen the KB atricles if you have this problem on server 2003 but the
> > > items in the steps don't exist in win 2k server.
> > > (http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql)
> > >
> > >
> > >
> > >
> > >
Monday, February 20, 2012
MSDTC and Full Text Indexing
Happy Christmas everyone,
I have just visited an active/active win2K(sp2) and SQL 2000(sp3a) cluster
that is not too happy. The virtual servers will not fail over between the
nodes as the MSDTC will not restart if moved. Full text indexing exists
only in one virtual server and needs to be on both instances.
I suspect that comclust wasn't run at installation but has been subsequently
run on one node only. Is there a safe way of now recreating the MSDTC or
reinstalling somehow without reinstalling SQL?
Thanks in advance.
Tim
I never wish I was not what I was not when I didn't wish what I was not was
not what I am not.
Hi Tim!
Yes, you can remove and reinstall MSDTC 'underneath' SQL.
However, the health of this cluster sounds pretty suspect!
I would caution you to BACK EVERYTHING UP before you do anything to this
cluster.
:-)
All system db's...everything.
If it's not moving, back it up!
Ok, with that said, you can follow this KB article on moving and rebuilding
the MSDTC resource:
294209 How to rebuild or move MSDTC used with a SQL failover cluster
There is also this article:
Microsoft Distributed Transaction Coordinator (MSDTC) Recovery Techniques
in Windows 2000 Cluster Server (243204)
Which is not really SQL specific.
As for the FTSearch issue...that is a little more complicated.
Generally there are two reasons FTS doesn't work in a cluster.
1. Search setup was not successful
2. You have missing registry keys.
For number 1, you will need to do some detective work.
First collect the most recent sqlstp#.log from both nodes.
Look for the searchsetup.exe section.
Any errors? If there is an error number, go to a cmd prompt, type net
helpmsg <errornumber>
What's the error? This will be important. At that point you should engage
PSS to rebuild FTS, as it's tricky at best.
For number 2, follow this article to confirm you have the correct registry
entries for FTS:
http://support.microsoft.com/default...B;EN-US;810056
INF: You Must Use Resource-Specific Registry Keys for SQL Server Cluster
Resources (810056)
If missing, put them in there. If that doesn't fix it, again, call PSS,
you probably have more at play than just missing registry keys.
Hope your sickly cluster recovers!
Thanks!
Donna Lambert
SQL Server Product Support
I have just visited an active/active win2K(sp2) and SQL 2000(sp3a) cluster
that is not too happy. The virtual servers will not fail over between the
nodes as the MSDTC will not restart if moved. Full text indexing exists
only in one virtual server and needs to be on both instances.
I suspect that comclust wasn't run at installation but has been subsequently
run on one node only. Is there a safe way of now recreating the MSDTC or
reinstalling somehow without reinstalling SQL?
Thanks in advance.
Tim
I never wish I was not what I was not when I didn't wish what I was not was
not what I am not.
Hi Tim!
Yes, you can remove and reinstall MSDTC 'underneath' SQL.
However, the health of this cluster sounds pretty suspect!
I would caution you to BACK EVERYTHING UP before you do anything to this
cluster.
:-)
All system db's...everything.
If it's not moving, back it up!
Ok, with that said, you can follow this KB article on moving and rebuilding
the MSDTC resource:
294209 How to rebuild or move MSDTC used with a SQL failover cluster
There is also this article:
Microsoft Distributed Transaction Coordinator (MSDTC) Recovery Techniques
in Windows 2000 Cluster Server (243204)
Which is not really SQL specific.
As for the FTSearch issue...that is a little more complicated.
Generally there are two reasons FTS doesn't work in a cluster.
1. Search setup was not successful
2. You have missing registry keys.
For number 1, you will need to do some detective work.
First collect the most recent sqlstp#.log from both nodes.
Look for the searchsetup.exe section.
Any errors? If there is an error number, go to a cmd prompt, type net
helpmsg <errornumber>
What's the error? This will be important. At that point you should engage
PSS to rebuild FTS, as it's tricky at best.
For number 2, follow this article to confirm you have the correct registry
entries for FTS:
http://support.microsoft.com/default...B;EN-US;810056
INF: You Must Use Resource-Specific Registry Keys for SQL Server Cluster
Resources (810056)
If missing, put them in there. If that doesn't fix it, again, call PSS,
you probably have more at play than just missing registry keys.
Hope your sickly cluster recovers!
Thanks!
Donna Lambert
SQL Server Product Support
MSDTC
Hello Everyone,
Has anyone had any experience with the following error
message on a win2k standard edition, running on a win 2003
server?
"The XA Transaction Manager cannot load the requested XA
Dll since a registry entry is required for this operation.
Please create a string value in the registry under
HKLM\Software\Microsoft\MSDTC\XADLL where the value name
is the name of the dll in the format dllname.dll and the
value is the full path of the Dll. If you are not sure
about the name or path of your XA Dll then please check
the documentation for your XA provider. If this machine is
part of a cluster please note that this registry entry
needs to be made for each node in the cluster. cwbodbc.dll"
ANy help would be greatly appreciated.
TIA
Chris
Which data access API are you using, ODBC?
Which resource manager (database)?
The ODBC driver exposes the XA Switch entrypoints, that is the DLL you need
to register. If you are running on a cluster you need to repeat this on
every node of the cluster.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Chris Bellizzi" <anonymous@.discussions.microsoft.com> wrote in message
news:082101c49a54$be0956f0$a601280a@.phx.gbl...
> Hello Everyone,
> Has anyone had any experience with the following error
> message on a win2k standard edition, running on a win 2003
> server?
> "The XA Transaction Manager cannot load the requested XA
> Dll since a registry entry is required for this operation.
> Please create a string value in the registry under
> HKLM\Software\Microsoft\MSDTC\XADLL where the value name
> is the name of the dll in the format dllname.dll and the
> value is the full path of the Dll. If you are not sure
> about the name or path of your XA Dll then please check
> the documentation for your XA provider. If this machine is
> part of a cluster please note that this registry entry
> needs to be made for each node in the cluster. cwbodbc.dll"
> ANy help would be greatly appreciated.
> TIA
> Chris
>
Has anyone had any experience with the following error
message on a win2k standard edition, running on a win 2003
server?
"The XA Transaction Manager cannot load the requested XA
Dll since a registry entry is required for this operation.
Please create a string value in the registry under
HKLM\Software\Microsoft\MSDTC\XADLL where the value name
is the name of the dll in the format dllname.dll and the
value is the full path of the Dll. If you are not sure
about the name or path of your XA Dll then please check
the documentation for your XA provider. If this machine is
part of a cluster please note that this registry entry
needs to be made for each node in the cluster. cwbodbc.dll"
ANy help would be greatly appreciated.
TIA
Chris
Which data access API are you using, ODBC?
Which resource manager (database)?
The ODBC driver exposes the XA Switch entrypoints, that is the DLL you need
to register. If you are running on a cluster you need to repeat this on
every node of the cluster.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Chris Bellizzi" <anonymous@.discussions.microsoft.com> wrote in message
news:082101c49a54$be0956f0$a601280a@.phx.gbl...
> Hello Everyone,
> Has anyone had any experience with the following error
> message on a win2k standard edition, running on a win 2003
> server?
> "The XA Transaction Manager cannot load the requested XA
> Dll since a registry entry is required for this operation.
> Please create a string value in the registry under
> HKLM\Software\Microsoft\MSDTC\XADLL where the value name
> is the name of the dll in the format dllname.dll and the
> value is the full path of the Dll. If you are not sure
> about the name or path of your XA Dll then please check
> the documentation for your XA provider. If this machine is
> part of a cluster please note that this registry entry
> needs to be made for each node in the cluster. cwbodbc.dll"
> ANy help would be greatly appreciated.
> TIA
> Chris
>
MSDTC
Hello Everyone,
Has anyone had any experience with the following error
message on a win2k standard edition, running on a win 2003
server?
"The XA Transaction Manager cannot load the requested XA
Dll since a registry entry is required for this operation.
Please create a string value in the registry under
HKLM\Software\Microsoft\MSDTC\XADLL where the value name
is the name of the dll in the format dllname.dll and the
value is the full path of the Dll. If you are not sure
about the name or path of your XA Dll then please check
the documentation for your XA provider. If this machine is
part of a cluster please note that this registry entry
needs to be made for each node in the cluster. cwbodbc.dll"
ANy help would be greatly appreciated.
TIA
ChrisWhich data access API are you using, ODBC?
Which resource manager (database)?
The ODBC driver exposes the XA Switch entrypoints, that is the DLL you need
to register. If you are running on a cluster you need to repeat this on
every node of the cluster.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Chris Bellizzi" <anonymous@.discussions.microsoft.com> wrote in message
news:082101c49a54$be0956f0$a601280a@.phx.gbl...
> Hello Everyone,
> Has anyone had any experience with the following error
> message on a win2k standard edition, running on a win 2003
> server?
> "The XA Transaction Manager cannot load the requested XA
> Dll since a registry entry is required for this operation.
> Please create a string value in the registry under
> HKLM\Software\Microsoft\MSDTC\XADLL where the value name
> is the name of the dll in the format dllname.dll and the
> value is the full path of the Dll. If you are not sure
> about the name or path of your XA Dll then please check
> the documentation for your XA provider. If this machine is
> part of a cluster please note that this registry entry
> needs to be made for each node in the cluster. cwbodbc.dll"
> ANy help would be greatly appreciated.
> TIA
> Chris
>
Has anyone had any experience with the following error
message on a win2k standard edition, running on a win 2003
server?
"The XA Transaction Manager cannot load the requested XA
Dll since a registry entry is required for this operation.
Please create a string value in the registry under
HKLM\Software\Microsoft\MSDTC\XADLL where the value name
is the name of the dll in the format dllname.dll and the
value is the full path of the Dll. If you are not sure
about the name or path of your XA Dll then please check
the documentation for your XA provider. If this machine is
part of a cluster please note that this registry entry
needs to be made for each node in the cluster. cwbodbc.dll"
ANy help would be greatly appreciated.
TIA
ChrisWhich data access API are you using, ODBC?
Which resource manager (database)?
The ODBC driver exposes the XA Switch entrypoints, that is the DLL you need
to register. If you are running on a cluster you need to repeat this on
every node of the cluster.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Chris Bellizzi" <anonymous@.discussions.microsoft.com> wrote in message
news:082101c49a54$be0956f0$a601280a@.phx.gbl...
> Hello Everyone,
> Has anyone had any experience with the following error
> message on a win2k standard edition, running on a win 2003
> server?
> "The XA Transaction Manager cannot load the requested XA
> Dll since a registry entry is required for this operation.
> Please create a string value in the registry under
> HKLM\Software\Microsoft\MSDTC\XADLL where the value name
> is the name of the dll in the format dllname.dll and the
> value is the full path of the Dll. If you are not sure
> about the name or path of your XA Dll then please check
> the documentation for your XA provider. If this machine is
> part of a cluster please note that this registry entry
> needs to be made for each node in the cluster. cwbodbc.dll"
> ANy help would be greatly appreciated.
> TIA
> Chris
>
Subscribe to:
Posts (Atom)