mmc.exe-Entry point not found in Enterprise Manager

I recently installed SQL 2000 on my machine and it was running fine till I i
nstalled SQL7 on the same machine. Now the SQL7 is running okay but I can't
use SQL2000 anymore. I received the following while try to open Enterprise
Manager:
mmc-entry point not found
The procedure entry point ? loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PB
G@.Z could
not be located in the dynamic link library SEMCOMN.dll
Can anyone provide me with some advise? Thanks in advance.Ling,
I agree with Tom.Though not officially stated(or is it?), its a good
practice to install SQL7 first and then proceed with the SQL2000 one.In your
case, instead of trying to play around with (un)registering the dlls, go
ahead and uninstall SQL7.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ling" <anonymous@.discussions.microsoft.com> wrote in message
news:CDFD0161-D3A2-4717-88BD-52ADF1C56322@.microsoft.com...
> I recently installed SQL 2000 on my machine and it was running fine till I
installed SQL7 on the same machine. Now the SQL7 is running okay but I
can't use SQL2000 anymore. I received the following while try to open
Enterprise Manager:
> mmc-entry point not found
> The procedure entry point ? loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PB
G@.Z
could not be located in the dynamic link library SEMCOMN.dll
> Can anyone provide me with some advise? Thanks in advance.|||Thank you guys. I will give it a try.

mmc.exe-Entry point not found in Enterprise Manager

I recently installed SQL 2000 on my machine and it was running fine till I installed SQL7 on the same machine. Now the SQL7 is running okay but I can't use SQL2000 anymore. I received the following while try to open Enterprise Manager:
mmc-entry point not found
The procedure entry point ?loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PBG@.Z could not be located in the dynamic link library SEMCOMN.dll
Can anyone provide me with some advise? Thanks in advance.
Ling,
I agree with Tom.Though not officially stated(or is it?), its a good
practice to install SQL7 first and then proceed with the SQL2000 one.In your
case, instead of trying to play around with (un)registering the dlls, go
ahead and uninstall SQL7.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ling" <anonymous@.discussions.microsoft.com> wrote in message
news:CDFD0161-D3A2-4717-88BD-52ADF1C56322@.microsoft.com...
> I recently installed SQL 2000 on my machine and it was running fine till I
installed SQL7 on the same machine. Now the SQL7 is running okay but I
can't use SQL2000 anymore. I received the following while try to open
Enterprise Manager:
> mmc-entry point not found
> The procedure entry point ?loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PBG@.Z
could not be located in the dynamic link library SEMCOMN.dll
> Can anyone provide me with some advise? Thanks in advance.
|||Thank you guys. I will give it a try.

mmc.exe-Entry point not found in Enterprise Manager

I recently installed SQL 2000 on my machine and it was running fine till I installed SQL7 on the same machine. Now the SQL7 is running okay but I can't use SQL2000 anymore. I received the following while try to open Enterprise Manager
mmc-entry point not foun
The procedure entry point ?loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PBG@.Z could not be located in the dynamic link library SEMCOMN.dll
Can anyone provide me with some advise? Thanks in advance.Uninstall SQL Server 7.0 and 2000. If you still have to
use SQL Server 7.0 First, Install SQL Server 7.0 as the
default then, Install SQL Server 2000 as the named
instance.
>--Original Message--
>I recently installed SQL 2000 on my machine and it was
running fine till I installed SQL7 on the same machine.
Now the SQL7 is running okay but I can't use SQL2000
anymore. I received the following while try to open
Enterprise Manager:
>mmc-entry point not found
>The procedure entry point ?
loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PBG@.Z could not be
located in the dynamic link library SEMCOMN.dll
>Can anyone provide me with some advise? Thanks in
advance.
>.
>|||Ling,
I agree with Tom.Though not officially stated(or is it?), its a good
practice to install SQL7 first and then proceed with the SQL2000 one.In your
case, instead of trying to play around with (un)registering the dlls, go
ahead and uninstall SQL7.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ling" <anonymous@.discussions.microsoft.com> wrote in message
news:CDFD0161-D3A2-4717-88BD-52ADF1C56322@.microsoft.com...
> I recently installed SQL 2000 on my machine and it was running fine till I
installed SQL7 on the same machine. Now the SQL7 is running okay but I
can't use SQL2000 anymore. I received the following while try to open
Enterprise Manager:
> mmc-entry point not found
> The procedure entry point ?loadSQLToolsLibrary@.@.YAPAUHINSTANCE_@.@.PBG@.Z
could not be located in the dynamic link library SEMCOMN.dll
> Can anyone provide me with some advise? Thanks in advance.|||Thank you guys. I will give it a try.sql

MMC error with Enterprise Manager

When attempting to display a database's property window in Enterprise Manager
an error happens with MMC. On a machine that also has SQL Server 2005 client
tools installed Enterprise manager crashes. On other machines that do not
have SQL Server 2005 client tools installed, MMC throws an error similar to
the one below before Enterprise Manager crashes:
mmc.exe Application error The instruction at "0x7801094 referenced
memory.....
The exact memory address in the above error message is not correct. I copied
it from another reference (on Google) dealing with DTS / MMC errors. I do not
have the exact message because I was forced to reinstall SQL Server 2000 in
order to use the RTM version to get around this error. The bug does not
happen in the RTM version but does with both SP3 and SP4.
The problem started fairly recently and I suspect it has to do with a
Microsoft update. It is happening to every computer computer in our facility
that has service packs applied to SQL Server and affects more than the
ability to display a databases property page.
Does anyone have any knowledge as to what might be causing these errors with
MMC and whether or not there is a work around?
I have now applied SP4 again and can replicate the error again.
When I right click on a Database in Enterprise Manager and select properties
I receive the following message:
mmc.exe - Application Error
The instruction at "0x4247b98b" referenced memory at "0x0000001c". The
memory could not be read.
Click OK to terminate....
I am running SQL Server 2000 on Windows 2000 (SP4).

Missing Sql Server node

I have just installed Visual Studio 2005 team system beta 2 on an XP machine which had a sql server 2000 previously installed. However I do not see the Sql Servers node in Solution explorer. I do have the data connections node and can make conenctions to the server. Does anyone know what I can do to make the Sql Servers node available?

Hi Asim Shah,

You should register again almost one SQL Server there.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

Missing Sql Server node

I have just installed Visual Studio 2005 team system beta 2 on an XP machine which had a sql server 2000 previously installed. However I do not see the Sql Servers node in Solution explorer. I do have the data connections node and can make conenctions to the server. Does anyone know what I can do to make the Sql Servers node available?

Hi Asim Shah,

You should register again almost one SQL Server there.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

Missing SP Parameter?

I've got a completely goofy problem on one development machine running Vista, SQL 2005 sp2, and Orcas Beta 2. I'm calling a stored proc from within my C# and my ExecuteDataReader() command fails saying I'm missing a parameter (which I'm not).

The c# looks like this:

if (SqlContext.IsAvailable)

{

using (System.Data.SqlClient.SqlConnection cnx =

new System.Data.SqlClient.SqlConnection("context connection=true"))

{

cnx.Open();

using (SqlCommand xCmd = new SqlCommand("dbo.TestMe", cnx))

{

xCmd.CommandType = CommandType.StoredProcedure;

xCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("myParam", SqlDbType.Int));

xCmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("myStr",

SqlDbType.VarChar, 150));

xCmd.Parameters["myParam"].Value = 123;

xCmd.Parameters["myStr"].Value = "Hello";

xCmd.ExecuteNonQuery();

}

}

}

My Stored Proc look like this:

CREATE PROCEDURE [dbo].[TestMe]

@.myParam as int,

@.myStr as nvarchar(150)

AS

BEGIN

SELECT 1 as myCol

END

The result is a an exception that looks like this:

A .NET Framework error occurred during execution of user-defined routine or aggregate "StoredProcedure1":

System.Data.SqlClient.SqlException: Procedure or function 'TestMe' expects parameter '@.myParam', which was not supplied.

If I run the SP from the Sql Workbench, it looks fine. Any ideas? I just repaved SQL and Orcas on this machine to see if I can fix the problem -- no luck.

The problem is with how you have created the parameters in your C# code. When you are using the Sql provider and you are clling parameterized queries or stored proc with queries, the parameters are sent in by name. Your T-SQL code has two parameters: @.myParam and @.myStr, in your T-SQL code you create a param called myParam and myStr - you need the @. as well in the parameter name.

Niels
|||

Well that certainly fixed the problem. Thanks!

But has something changed in the SqlClient plumbing? I went back to look at our test machine, which is a Windows Server 2003 R2 / SQL 2005 SP2 (64-bit) system. The C# code works without the "@." in the param names as it does on other similarly configured systems. I even took the little routine from my code sample and deployed it -- sans "@." -- on our test machines and it works. Hmm.

Again thanks for the reply.

-Erik

Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!
Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FA...rCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||See below URLS as well.
http://sql-server-performance.com/fo...p?TOPIC_ID=695
http://sql-server-performance.com/fo...p?TOPIC_ID=308
http://sql-server-performance.com/fo...p?TOPIC_ID=687
http://sql-server-performance.com/fo...p?TOPIC_ID=907
http://sql-server-performance.com/fo...p?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>
|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:

>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>

Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=695
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=308
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=687
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=907
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>

Missing Perf Counters

I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I cannot
find the SQL performance counters when running the NT Performance Monitor,
and the master..sysperfinfo table is empty. I've tried running lodctr
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
Counters for MSSQLServer are already installed.
Any ideas short of reinstalling SQL Server? (The machine is already in
production w/ several client databases up & running).
Thanks!Might try:
How to manually rebuild Performance Counter Library values
http://support.microsoft.com/?kbid=300956
and
Enabling Performance Counters in SQL Server 2000 (non-MS link)
http://www.extremeexperts.com/SQL/F...erCounters.aspx
HTH
Jerry
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||See below URLS as well.
http://sql-server-performance.com/f...sp?TOPIC_ID=695
http://sql-server-performance.com/f...sp?TOPIC_ID=308
http://sql-server-performance.com/f...sp?TOPIC_ID=687
http://sql-server-performance.com/f...sp?TOPIC_ID=907
http://sql-server-performance.com/f...sp?TOPIC_ID=403
Thanks
Hari
SQL Server MVP
"cw" <cwilson@.3mc.com> wrote in message
news:uLLlLhSxFHA.1124@.TK2MSFTNGP12.phx.gbl...
>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I
>cannot find the SQL performance counters when running the NT Performance
>Monitor, and the master..sysperfinfo table is empty. I've tried running
>lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I
>get Counters for MSSQLServer are already installed.
> Any ideas short of reinstalling SQL Server? (The machine is already in
> production w/ several client databases up & running).
> Thanks!
>|||If no records are returned when you query sysperfinfo, then
take a look at the following (I've seen cases where the
error message isn't always logged so that wouldn't
necessarily rule this out as an issue).
http://support.microsoft.com/?id=812915
-Sue
On Thu, 29 Sep 2005 15:04:13 -0400, "cw" <cwilson@.3mc.com>
wrote:

>I built a SQL2000 sp3a w/ hotfix 818 on a Windows2003 sp1 machine. I canno
t
>find the SQL performance counters when running the NT Performance Monitor,
>and the master..sysperfinfo table is empty. I've tried running lodctr
>"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" and I get
>Counters for MSSQLServer are already installed.
>Any ideas short of reinstalling SQL Server? (The machine is already in
>production w/ several client databases up & running).
>Thanks!
>

Missing Log - Suspect Datanbase - HELP!

A customer called me and said they ran the disk out of space, rebooted the
machine and the activity log is complaining about the database log being
already in use, and being out of disk. The database is in suspect mode, and
the database log is MIA!
Any ideas'
Thanks
RichardTry looking into system procs,
sp_add_data_file_recover_suspect_db and sp_add_log_file_recover_suspect_db
in books online
Thanks
"Richard Douglass" wrote:
> A customer called me and said they ran the disk out of space, rebooted the
> machine and the activity log is complaining about the database log being
> already in use, and being out of disk. The database is in suspect mode, and
> the database log is MIA!
> Any ideas'
> Thanks
> Richard
>
>|||Richard
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:OfDesPeVHHA.1000@.TK2MSFTNGP05.phx.gbl...
>A customer called me and said they ran the disk out of space, rebooted the
>machine and the activity log is complaining about the database log being
>already in use, and being out of disk. The database is in suspect mode,
>and the database log is MIA!
> Any ideas'
> Thanks
> Richard
>

missing DTS connections

I am running SQL server 2000 service pack 3 on a windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd Faber
You can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/downl...s/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:

>I am running SQL server 2000 service pack 3 on a windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber
|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:

> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/downl...s/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>

missing DTS connections

I am running SQL server 2000 service pack 3 on a Windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd FaberYou can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/down...ls/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:

>I am running SQL server 2000 service pack 3 on a Windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:

> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/down...ls/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>

Missing dll folder in SQL Server 2005

Hello, I have have some instructions to put a dll file in the folder
"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
do you think I would be the dll.
ThanksHi Don,
Are these instructions from a specific application? Does it mention if it is
compatible with SQL Server 2005?
Ben Nevarez
"Don" wrote:
> Hello, I have have some instructions to put a dll file in the folder
> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
> do you think I would be the dll.
> Thanks
>|||Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
> Hi Don,
> Are these instructions from a specific application? Does it mention if it is
> compatible with SQL Server 2005?
> Ben Nevarez
>
>
> "Don" wrote:
>> Hello, I have have some instructions to put a dll file in the folder
>> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
>> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
>> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
>> do you think I would be the dll.
>> Thanks|||Yes, it's for a extended stored procedure called xp_calendar. And there are
notes about having it work with SQl 2005 just not about were to put the dll.
I had installed it on a SQL Server 2000 as a test and xp_calendar worked
well, but when I went to install it at the client running 2005 I saw that it
does not have the dll folder.
http://www.sqlservercentral.com/articles/Miscellaneous/2985/
http://www.logicom-inc.com/xp_sql2exchange/xp_sql2exchange.html
Thanks
Don
"Tibor Karaszi" wrote:
> Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
> instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
> >
> > Hi Don,
> >
> > Are these instructions from a specific application? Does it mention if it is
> > compatible with SQL Server 2005?
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "Don" wrote:
> >
> >> Hello, I have have some instructions to put a dll file in the folder
> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
> >> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
> >> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
> >> do you think I would be the dll.
> >>
> >> Thanks
> >>
>
>|||I would add the files to the binn folder and then adjust the paths in the file "xp_add.sql"
accordingly. You would need to find what folder (MSSQL.1 etc) corresponds to your instance name,
check the below reg key for that:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Don" <Don@.discussions.microsoft.com> wrote in message
news:0AC640AC-92C5-478F-82EA-6DD80D9BB418@.microsoft.com...
> Yes, it's for a extended stored procedure called xp_calendar. And there are
> notes about having it work with SQl 2005 just not about were to put the dll.
> I had installed it on a SQL Server 2000 as a test and xp_calendar worked
> well, but when I went to install it at the client running 2005 I saw that it
> does not have the dll folder.
> http://www.sqlservercentral.com/articles/Miscellaneous/2985/
> http://www.logicom-inc.com/xp_sql2exchange/xp_sql2exchange.html
> Thanks
> Don
> "Tibor Karaszi" wrote:
>> Exactly my thoughts, Ben. My guess is that it is an extended stored procedure, and if the
>> instructions doesn't say how to install it on 2005, we shouldn't assume it has been tested on
>> 2005.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
>> news:D1FD01B8-51AC-4570-92C7-EB0254257714@.microsoft.com...
>> >
>> > Hi Don,
>> >
>> > Are these instructions from a specific application? Does it mention if it is
>> > compatible with SQL Server 2005?
>> >
>> > Ben Nevarez
>> >
>> >
>> >
>> >
>> > "Don" wrote:
>> >
>> >> Hello, I have have some instructions to put a dll file in the folder
>> >> "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dll" which I see on a
>> >> machine with SQL Server 2000. On machines with SQL Server 2005 you have 3
>> >> folders MSSQL.1, MSSQL.2, MSSQL.3 and none of them have a dll folder. Where
>> >> do you think I would be the dll.
>> >>
>> >> Thanks
>> >>
>>