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
>> >>
>>