DLL wanted!

SQLVersionControl.VCS_SQL class. Which dll contains that class? Does anybody
know?|
| SQLVersionControl.VCS_SQL class. Which dll contains that class? Does
anybody
| know?
|
--
The dll you're after is mdt2dbsv.dll. The description for this dll is
Microsoft Design Tools - VID/VSS integration. This dll comes with Visual
Studio.
Hope this helps,
--
Eric Cárdenas
SQL Server support

DLL use In Crystal Reports

Hi K.Babu!

This is Ramesh and i have a qury for u,i have developed a DLL in VB and registered it for usein asp and vb and i aslo want to make use of this DLL in Crystal Reports without VB/ASp as Interface for Reports

Please tell me how to call the functions written in DLL in Crystal Reports directly

i have put my DLL in the directory where other Crystal Reports DLL are and registered but dont know how to call this dll in reports

Waiting for ur reply soonHi,
You need to have your DLL name start with CRUFLxxxx where xxxx is the rest of the DLL name i.e. CRUFLmyStuff.DLL, then copy into Crystal dir and then register from DOS prompt with: -
regsvr32 c:\winnt\crystal\CRUFLmyStuff.DLL)
after this restart CR and you should find your DLL function's from
formula workshop / functions / additional functions / Visual Basic UFL's and there should be your DLL functions.

If this don't work check out Crystals white paper SCR_User_Defined_Functions.pdf

good luck!|||Hello mramesh73,

Just curious to know whether phil's resolution helped. I have plans of creating dll for the same purpose down the road.

Thanks

DLL missing or ??

I have SQL server 2000 and access 2003 adp file always disconnect
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
run-time error 429
ActveX component can't create object
How repair this without reinstall all'Hi
This seems to get asked quite a lot http://tinyurl.com/9aypy
Some suggested solutions may be
http://support.microsoft.com/kb/q189366/
http://tinyurl.com/aofef
http://tinyurl.com/eyt7r
John
"Valentin Albastroiu" wrote:

> I have SQL server 2000 and access 2003 adp file always disconnect
> Dim cnn As ADODB.Connection
> Set cnn = New ADODB.Connection
> run-time error 429
> ActveX component can't create object
> How repair this without reinstall all'
>
>|||The PC on which you install the application must have the same version or
greater of MDAC (Microsoft Data Access Components) that was on the
development PC when the application was compiled. If this error is occurring
on the development PC, then perhaps the MDAC components or configuration got
corrupted somehow. Either way, consider downloading and running the latest
verison of MDAC on both the development and end user PCs.
http://msdn.microsoft.com/library/d...mdacinstall.asp
"Valentin Albastroiu" <vali_albastroiu@.hotmail.com> wrote in message
news:uzl%23tZByFHA.736@.tk2msftngp13.phx.gbl...
>I have SQL server 2000 and access 2003 adp file always disconnect
> Dim cnn As ADODB.Connection
> Set cnn = New ADODB.Connection
> run-time error 429
> ActveX component can't create object
> How repair this without reinstall all'
>

dll locked by VS

Hi,
I'm new to VS-Development an have to write a little assembly for Reporting
Services. Every time a change something in the assembly, I call the
following .bat-file:
copy "D:\rw\Visual Studio
2005\wbiReports\wbiReports\bin\Debug\wbiReports.dll" "C:\Programme\Microsoft
SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\"
copy "D:\rw\Visual Studio
2005\wbiReports\wbiReports\bin\Debug\wbiReports.dll" "\\wbi-lyta\C$\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\"
copy "D:\rw\Visual Studio
2005\wbiReports\wbiReports\bin\Debug\wbiReports.dll" "C:\Programme\Microsoft
Visual Studio 8\Common7\IDE\PrivateAssemblies\"
But the last copy fails, if there is still one VS open. I normally have 3
projects open, 2 reports and the assembly-project. Now having to close not
only every project but even close all VSs is very annoying. Am I doing
anything wrong?
Regards,
RalphI have run into the same problem. The best workaround I found is to
use NUnit to do all of my testing for the assembly. When I'm done I
install it into the appropriate directories and modify and test my
reports. This allows me to avoid the problem for the most part.

DLL issues

Can anybody recall having simmilar messages while running sprocs with trace
turned on:
DBCC TRACEON 260, server process ID (SPID) 52.
2007-10-19 08:41:18.72 spid52 Extended stored procedure DLL
'aegxprocs.dll' does not export __GetXpVersion(). Refer to the topic
"Backward Compatibility Details (Level 1) - Open Data Services" in the
documentation for more information.
2007-10-19 08:41:23.87 spid52 Extended stored procedure DLL
'aegxprocs.dll' does not export __GetXpVersion(). Refer to the topic
"Backward Compatibility Details (Level 1) - Open Data Services" in the
documentation for more information.
2007-10-19 08:41:33.75 spid52 DBCC TRACEOFF 260, server process ID (SPID)
52.
ThanksHi
From: http://msdn2.microsoft.com/en-us/library/ms164627.aspx
When SQL Server is started with the trace flag -T260 or if a user with
system administrator privileges runs DBCC TRACEON (260), and if the extended
stored procedure DLL does not support __GetXpVersion(), a warning message
(Error 8131: Extended stored procedure DLL '%' does not export
__GetXpVersion().) is printed to the error log. (Note that __GetXpVersion()
begins with two underscores.)
As I don't seem to have this DLL I would assume it is a third party product
which may need updating?
John
"dk" wrote:
> Can anybody recall having simmilar messages while running sprocs with trace
> turned on:
> DBCC TRACEON 260, server process ID (SPID) 52.
> 2007-10-19 08:41:18.72 spid52 Extended stored procedure DLL
> 'aegxprocs.dll' does not export __GetXpVersion(). Refer to the topic
> "Backward Compatibility Details (Level 1) - Open Data Services" in the
> documentation for more information.
> 2007-10-19 08:41:23.87 spid52 Extended stored procedure DLL
> 'aegxprocs.dll' does not export __GetXpVersion(). Refer to the topic
> "Backward Compatibility Details (Level 1) - Open Data Services" in the
> documentation for more information.
> 2007-10-19 08:41:33.75 spid52 DBCC TRACEOFF 260, server process ID (SPID)
> 52.
> Thanks
>|||Hi John,
Thanks for your reply. Yes, it's third party dll (epicor financials).
THanks again
Dk
"John Bell" wrote:
> Hi
> From: http://msdn2.microsoft.com/en-us/library/ms164627.aspx
> When SQL Server is started with the trace flag -T260 or if a user with
> system administrator privileges runs DBCC TRACEON (260), and if the extended
> stored procedure DLL does not support __GetXpVersion(), a warning message
> (Error 8131: Extended stored procedure DLL '%' does not export
> __GetXpVersion().) is printed to the error log. (Note that __GetXpVersion()
> begins with two underscores.)
> As I don't seem to have this DLL I would assume it is a third party product
> which may need updating?
> John
>
> "dk" wrote:
> > Can anybody recall having simmilar messages while running sprocs with trace
> > turned on:
> > DBCC TRACEON 260, server process ID (SPID) 52.
> > 2007-10-19 08:41:18.72 spid52 Extended stored procedure DLL
> > 'aegxprocs.dll' does not export __GetXpVersion(). Refer to the topic
> > "Backward Compatibility Details (Level 1) - Open Data Services" in the
> > documentation for more information.
> > 2007-10-19 08:41:23.87 spid52 Extended stored procedure DLL
> > 'aegxprocs.dll' does not export __GetXpVersion(). Refer to the topic
> > "Backward Compatibility Details (Level 1) - Open Data Services" in the
> > documentation for more information.
> > 2007-10-19 08:41:33.75 spid52 DBCC TRACEOFF 260, server process ID (SPID)
> > 52.
> > Thanks
> >
> >

DLL issue when installing SS05 64bit

I uninstalled a 32-bit eval Std Ed SQL Server 2005. I then attempted to install 64bit licensed Std Ed. The database engine and other components install fine, but SSIS is throwing a DLL error (first error following). How can I solve this issue? I have attempted to IGNORE the error, but when I try to run SSIS - I get a DLL error (second error following). All assistance is appreciated.

TITLE: Microsoft SQL Server 2005 Setup

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server
\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: -2146233087
Error message: Unknown error 0x80131501
Error description: One or more of the components being installed are already registered as 32 bit components in the target application. You must install the 64 bit versions of the components being installed in a different COM+ application, or delete the existing 32 bit versions of the components being installed from the target COM+ application prior to attempting install of the 64 bit versions. COM+ applications cannot contain bit neutral components.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80131501

TITLE: Connect to Server

Cannot connect to SERVERNAME.

ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "SERVERNAME" failed:
Error loading type library/DLL.

I've seen this issue in the forums a couple times, but haven't been able to repro it on my box. Here is a thread regarding this issue with a few suggestions. Feel free to take a look to see if it pertains to your situation. The people on the thread seem to have a handle on the issue, so they may be able to help out if you get stuck.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136467&SiteID=1

Thanks,
Sam Lester (MSFT)|||The is in the Component Services in com+ called Microsoft.Sqlserver.MSMQTask. You need to delete that one. After that the install will run just fine.

Theo Ekelmans

DLL initialization failure using CDOSYS mail

We have a SQL 2000 stored procedure to send notification emails using CDOSYS and OLE Automation. It has been happily sending out emails for quite a while now from both of our dev and prod machines.

The other day I added a line of code to format the message body variable. I tested the change in a T-SQL script in dev, then added the line into the procedure and recompiled it in dev using an ALTER PROC script. I then called the dev proc and everything is still good. The change has no impact to the sp_OA* commands.

So then I used the same ALTER PROC script and pointed it to production. There is no difference between the dev and prod procs so this was OK. The script ran OK and the proc was updated with the change. However, now only the prod proc doesn't work. Further, the same code in a T-SQL script also fails. But everything remains fine in the dev environment.

We restored the database that had the email SP to a point prior to the change, but the problem persists. It is as if recompiling the proc has disabled the CDOSYS capability from SQL server. CDOSYS still works from VBscript on the server.

The error message:

Msg 50000, Level 18, State 3, Procedure usp_SendEmail, Line 154

Error in Email Object: Source: CDO.Configuration.1 . Description: A dynamic link library (DLL) initialization routine failed.

(EOLIAN.Tools.dbo.usp_SendEmail)

Here's a bit of the code:

DECLARE @.iMsg int,

@.hr int

EXEC @.hr = sp_OACreate 'CDO.Message', @.iMsg OUT

IF @.HR <> 0 GOTO Error_Handling

EXEC @.hr = sp_OASetProperty @.iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2'

IF @.HR <> 0 GOTO Error_Handling

I encountered a similar problem a few months ago when we collocated our DB server (Win2K, SQL 2005) and changed the domain it was in. At the time, granting the login that runs the SQL Server service access to the System32/InetSrv directory fixed the problem (seemed to be a metabase access issue). The one difference is that we use the Pickup directory (SendUsing=1).

A few weeks later, things stopped working again. Like you, I've tested using a VBScript logged in as the same account that's running the SQL Server service and the emails gets generated without difficulty. But using the stored proc or a pared-down SQL script generates the same DLL initialization error in CDO.Configuration.1.

This proc has been in use since we converted to SQL 2000 and has not been altered for some time (>12mo). The only change is the domain change which clearly introduced a number of security implications. However, that doesn't explain why it worked and then just stopped working.

If I figure out the problem, I'll post again. If you figure out hte problem, please post as well as we may be chasing the same issue.

|||Moving to the T-SQl group.|||The problem is resolved, although not understood. We rebooted the server and restarted SQL and all is well again. Not sure what caused the problem, or what the problem was.|||The solution was short lived. The DLL initialization failure message is back. :-(

dll in c# sql 2005

I wrote a class in C# with one method that returns a string. I built the dll and deployed it into sql 2005 and everything works just fine.

I am now in a situation where I need to use this function in SQL 2000. Is there any way that I can use the existing dll and create a sql 2000 function, and if so how do I go about doing this?

Here is the c# code from the deployed dll.

using System;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

using System.Text.RegularExpressions;

public partial class GECBI

{

[Microsoft.SqlServer.Server.SqlFunction(IsDeterministic = true, IsPrecise = true)]

public static string RegExMatch(string pattern, string matchString)

{

Regex r1 = new Regex(pattern);

if (r1.Match(matchString.TrimEnd(null)).Success)

{

Regex testReg = new Regex(pattern);

Match regMatch = testReg.Match(matchString);

string runnumber = regMatch.ToString();

return runnumber;

}

else

{

return null;

}

}

};

Accesing CLR Function is only possible in SQL2k5. Wrapping the .NET object in a COM object or calling the function on a SQL2k5 Server would be very slow during execution time.

HTH, JEns K. Suessmeyer.

http://www.sqlserver2005.de|||So what would be an alternative for me to achieve the above? Can someone give me an example of how to create the above function in something that I can use with sql 2k please?|||There is actually no alternativ for that. have a look in the internet, there have been some samples implemented to mimic the functionality.

http://www.google.de/search?hl=de&q=regular+expressions+sql+server+2000&meta= http://www.codeproject.com/managedcpp/xpregex.asp

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

DLL files for crystal reports

Dear Friends,
Which DLL (i.e. *.dll) files are important inorder the crystal reports v10 to be displayed in the vb.net 2003 program?
Can I have the names of these dll files please?Visit http://support.businessobjects.com

DLL Error & Legend Question

I'm using version 8.5.
Is there a way to limit the legend to only show elements that are shown on the chart (i.e have a value)?

Also I'm recieving the following error when I attempt to generate a report into PDF:

"ERROR IN DATABASE DLL, CHECK REPORT'S SQL"

The report sql works fine in Query Analzyer, the database is up to and it is verified.

Any advice is greatly appreciated,

Thanks,
GalahadHi,
Change your database driver and try once again.

Regards

Deepak|||Yes i had tried that. But whenever i try to change to any other driver than pdsodbc.dll (ODBC), i get errors that are the same as before.

I'm accessing SQL Server data so I have changed to every driver that i know that would work w/ sql server. But no luck.

Other reports that I run have no issues using the same driver.

FYI, The reports are run locally on my machine for testing and migrated over to a dev server. A java client converts the Crystal into PDF files.

Any suggestions?

Thanks,
Galahad|||Open the report and Do verify Database
Set the Database Location path also|||Dear all in this discussion
i am also stuck with this problem , for an immediate solution , the DNS connection , along with a set location works , but the report speed is slow

The senario, the rpt files are in the local machine , the server has the database , when the report is requested it gives the error "Physical database not found"
please let me know the solution

Dll error

Hello,
I have developed an vb.net windows application, which uses SQLXMLBulkload3class. For this, I added references to Microsoft SQLXMLBulkload 3.0 Type library. This works fine through sourcecode and exe in my development pc. While building windows installer
(package and deployment) through setupwizard, says "cannot automatically detect dependencies for "c:\commonfiles\system\oledb\xblkld3.dll". Ignored that, went ahead and built the WindowsInstaller i.e. msi file. In the target pc, I installed .net framew
ork first and while installing the application package got an error "xblkld3.dll failed to register. HRESULT-2147023782." still went ahead and installed the application. Says "COM object with CLSID{.....} is either not valid or not registered" when it c
omes to SQLXMLBulkload module. Anything should I add in the references? Or Install any components or missing any dlls? Pls. Help me.
Thanks for all your help.
Rgds,
Padmaja.
Suggested way to redistribute SQLXML is to ask the user install SQLXML
themselves. The installer is available from MSDN.
FYI, these are the dependencies for SQLXML
a.. This release is installed using the Microsoft Windows Installer 2.0. You
might need to upgrade your installer to Windows Installer 2.0 prior to
installing SQLXML 3.0.
a.. SQLXML requires Microsoft SOAP Toolkit 2.0 to be installed to run Web
Services. Users not using Microsoft Windows XP must download the toolkit to
use Web Services.
a.. MDAC 2.6 or later must be installed before the installation can be run.
a.. This release also has a dependency on MSXML version 4.0 SP2. This
version of MSXML is included with the download.
Soap toolkit is not needed for SQLXML Bulkload (xblkld3.dll)
Chandra
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Padmaja" <anonymous@.discussions.microsoft.com> wrote in message
news:796EAED4-E157-44B7-BE52-8B0F6A73F2EC@.microsoft.com...
> Hello,
> I have developed an vb.net windows application, which uses
SQLXMLBulkload3class. For this, I added references to Microsoft
SQLXMLBulkload 3.0 Type library. This works fine through sourcecode and exe
in my development pc. While building windows installer (package and
deployment) through setupwizard, says "cannot automatically detect
dependencies for "c:\commonfiles\system\oledb\xblkld3.dll". Ignored that,
went ahead and built the WindowsInstaller i.e. msi file. In the target pc,
I installed .net framework first and while installing the application
package got an error "xblkld3.dll failed to register. HRESULT-2147023782."
still went ahead and installed the application. Says "COM object with
CLSID{.....} is either not valid or not registered" when it comes to
SQLXMLBulkload module. Anything should I add in the references? Or Install
any components or missing any dlls? Pls. Help me.
> Thanks for all your help.
> Rgds,
> Padmaja.
>
|||I checked for SQLXML SP3 & MDAC 2.7. They are already installed. I am getting the error of 'not detecting the dependencies' while building the windows installer. Any help is appreciated.
|||I checked for SQLXML and MDAC2.7. They are already installed. I am getting the error of 'cannot automatically detect dependencies xblkld3.dll' while creating windows installer. Any help is appreciated.
Thanks,
Padmaja.

DLL and Xtended Proc...

Hello,
I've created my own sendmail in VB6 SP5 as a DLL and put it on my SQL server
2K SP3. I've a class module with only one public funtion in it.
I want to use the function in this dll so I decalred my DLL as an extended
proc in SQL . apprently SQL doesn't recognize the function in my dll. How
can I use it? What's the best way to do it?
Best regards,I'm not sure if a VB6 DLL can be registered as an extended stored procedure
this way.
If you want to use the functionality of your DLL from SQL Server, you could
use the sp_OA* set of procedures for the same. Refer to
http://www32.brinkster.com/srisamp/sqlarchives.asp for articles on COM
accessibility. You can refer to the articles titled "Using COM Objects in
SQL Server" and "Extending SQL Server with COM Objects".
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Philippe RUELLO" <pruello@.tibco.fr> wrote in message
news:OMjpLlYuDHA.2712@.tk2msftngp13.phx.gbl...
> Hello,
> I've created my own sendmail in VB6 SP5 as a DLL and put it on my SQL
server
> 2K SP3. I've a class module with only one public funtion in it.
> I want to use the function in this dll so I decalred my DLL as an extended
> proc in SQL . apprently SQL doesn't recognize the function in my dll. How
> can I use it? What's the best way to do it?
> Best regards,
>|||Just to confirm - VB only produces COM type .dlls, not call level type which
are required for extended stored procedures. So you cannot register VB .dlls
for use as extended stored procedures in SQL Server.
The other method that SriSamp has suggested (sp_OACreate) is the only way to
access your VB .dll directly from T-SQL.
Regards,
Greg Linwood
SQL Server MVP
"SriSamp" <ssampath@.sct.co.in> wrote in message
news:#j7#xrYuDHA.1576@.TK2MSFTNGP11.phx.gbl...
> I'm not sure if a VB6 DLL can be registered as an extended stored
procedure
> this way.
> If you want to use the functionality of your DLL from SQL Server, you
could
> use the sp_OA* set of procedures for the same. Refer to
> http://www32.brinkster.com/srisamp/sqlarchives.asp for articles on COM
> accessibility. You can refer to the articles titled "Using COM Objects in
> SQL Server" and "Extending SQL Server with COM Objects".
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
> "Philippe RUELLO" <pruello@.tibco.fr> wrote in message
> news:OMjpLlYuDHA.2712@.tk2msftngp13.phx.gbl...
> > Hello,
> > I've created my own sendmail in VB6 SP5 as a DLL and put it on my SQL
> server
> > 2K SP3. I've a class module with only one public funtion in it.
> > I want to use the function in this dll so I decalred my DLL as an
extended
> > proc in SQL . apprently SQL doesn't recognize the function in my dll.
How
> > can I use it? What's the best way to do it?
> > Best regards,
> >
> >
>|||Thanks for the answer.
I tried to use that methos but i've some troubles using the attachements
with CDONT.Newmail
I could use Xp_sendmail, but I want to modify the parameter From.
Have some clues?
"SriSamp" <ssampath@.sct.co.in> a écrit dans le message de
news:%23j7%23xrYuDHA.1576@.TK2MSFTNGP11.phx.gbl...
> I'm not sure if a VB6 DLL can be registered as an extended stored
procedure
> this way.
> If you want to use the functionality of your DLL from SQL Server, you
could
> use the sp_OA* set of procedures for the same. Refer to
> http://www32.brinkster.com/srisamp/sqlarchives.asp for articles on COM
> accessibility. You can refer to the articles titled "Using COM Objects in
> SQL Server" and "Extending SQL Server with COM Objects".
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
> "Philippe RUELLO" <pruello@.tibco.fr> wrote in message
> news:OMjpLlYuDHA.2712@.tk2msftngp13.phx.gbl...
> > Hello,
> > I've created my own sendmail in VB6 SP5 as a DLL and put it on my SQL
> server
> > 2K SP3. I've a class module with only one public funtion in it.
> > I want to use the function in this dll so I decalred my DLL as an
extended
> > proc in SQL . apprently SQL doesn't recognize the function in my dll.
How
> > can I use it? What's the best way to do it?
> > Best regards,
> >
> >
>|||How about xp_smtp_sendmail from www.SQLDev.Net?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Philippe RUELLO" <pruello@.tibco.fr> wrote in message news:uXn1yUZuDHA.2408@.tk2msftngp13.phx.gbl...
> Thanks for the answer.
> I tried to use that methos but i've some troubles using the attachements
> with CDONT.Newmail
> I could use Xp_sendmail, but I want to modify the parameter From.
> Have some clues?
> "SriSamp" <ssampath@.sct.co.in> a écrit dans le message de
> news:%23j7%23xrYuDHA.1576@.TK2MSFTNGP11.phx.gbl...
> > I'm not sure if a VB6 DLL can be registered as an extended stored
> procedure
> > this way.
> > If you want to use the functionality of your DLL from SQL Server, you
> could
> > use the sp_OA* set of procedures for the same. Refer to
> > http://www32.brinkster.com/srisamp/sqlarchives.asp for articles on COM
> > accessibility. You can refer to the articles titled "Using COM Objects in
> > SQL Server" and "Extending SQL Server with COM Objects".
> > --
> > HTH,
> > SriSamp
> > Please reply to the whole group only!
> > http://www32.brinkster.com/srisamp
> >
> > "Philippe RUELLO" <pruello@.tibco.fr> wrote in message
> > news:OMjpLlYuDHA.2712@.tk2msftngp13.phx.gbl...
> > > Hello,
> > > I've created my own sendmail in VB6 SP5 as a DLL and put it on my SQL
> > server
> > > 2K SP3. I've a class module with only one public funtion in it.
> > > I want to use the function in this dll so I decalred my DLL as an
> extended
> > > proc in SQL . apprently SQL doesn't recognize the function in my dll.
> How
> > > can I use it? What's the best way to do it?
> > > Best regards,
> > >
> > >
> >
> >
>

dll & Web Service in VB.Net 2005 Stored Procedure

Hi,
I am writing a vb.net2005 program that needs to create a stored procedure
with SqlServerProject Template.
Now, I have two questions for this stored procedure.
1) How can I import and execute the .dll in this Stored Procedures?
2) How can I connect the Web Service and get the result in this Stored
Procedures?
---
Partial Public Class StoredProcedures1
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub GetTable()
Dim strSQL As String = "SELECT * FROM Table1"
Using conn As New SqlConnection("context connection=true")
Using cmd As New SqlCommand
With cmd
.Connection = conn
.CommandText = strSQL
.CommandType = CommandType.Text
conn.Open()
SqlContext.Pipe.ExecuteAndSend(cmd)
.Connection.Close()
End With
End Using
End Using
End Sub
End Class
---
Thanks!"James Wong" <cphk_msdn@.nospam.nospam> wrote in message
news:u155F84iGHA.1260@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I am writing a vb.net2005 program that needs to create a stored procedure
> with SqlServerProject Template.
> Now, I have two questions for this stored procedure.
> 1) How can I import and execute the .dll in this Stored Procedures?
You need to deploy the assembly into your database (CREATE ASSEMBLY) and
then add a stored procedure referencing the method in the assembly (CREATE
PROCEDURE). Visual Studio will do this for you if you right-click on the
project and select Deploy.
Here's how you would do it by hand:
CREATE ASSEMBLY [SqlServerProject2]
FROM 'c:\SqlServerProject2.dll'
WITH PERMISSION_SET = SAFE
GO
CREATE PROCEDURE [GetTable]
AS
EXTERNAL NAME
[SqlServerProject2].[SqlServerProject2.StoredProcedures].[GetTable]

> 2) How can I connect the Web Service and get the result in this Stored
> Procedures?
>
From the web service just connect to the database and execute it with a
SqlCommand.
David|||Hi David,
sorry, i think that u were misunderstood my problem.
My Stored Procedure "StoredProcedures1.GetTable()" is need to call another
.dll & web service to get some value.
Thanks
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> glsD:O3xF9H5iGHA.45
04@.TK2MSFTNGP05.phx.gbl...
> "James Wong" <cphk_msdn@.nospam.nospam> wrote in message
> news:u155F84iGHA.1260@.TK2MSFTNGP05.phx.gbl...
> You need to deploy the assembly into your database (CREATE ASSEMBLY) and
> then add a stored procedure referencing the method in the assembly (CREATE
> PROCEDURE). Visual Studio will do this for you if you right-click on the
> project and select Deploy.
> Here's how you would do it by hand:
> CREATE ASSEMBLY [SqlServerProject2]
> FROM 'c:\SqlServerProject2.dll'
> WITH PERMISSION_SET = SAFE
> GO
> CREATE PROCEDURE [GetTable]
> AS
> EXTERNAL NAME
> [SqlServerProject2].[SqlServerProject2.StoredProcedures].[GetTable]
>
> From the web service just connect to the database and execute it with a
> SqlCommand.
> David
>|||"James Wong" <cphk_msdn@.nospam.nospam> wrote in message
news:eWXrxU5iGHA.412@.TK2MSFTNGP05.phx.gbl...
> Hi David,
> sorry, i think that u were misunderstood my problem.
> My Stored Procedure "StoredProcedures1.GetTable()" is need to call another
> .dll & web service to get some value.
>
To use another .dll add a reference to your database project. To use a web
service add a web reference.
David|||Hi David,
1) For DLL, VS.Net 2005 is not allow me to import a new References in
SqlServerProject Template.
2) For Web Service, it will occur error when running.
----
--
Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _
Public Shared Sub SPWithWebService()
Dim WebService As New SqlServerProject1.localhost.Service
Dim msg As String = CStr(WebService.HelloWorld())
SqlContext.Pipe.Send(msg)
End Sub
End Class
----
--
Thanks
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> glsD:OqYxDh5iGHA.34
96@.TK2MSFTNGP04.phx.gbl...
> "James Wong" <cphk_msdn@.nospam.nospam> wrote in message
> news:eWXrxU5iGHA.412@.TK2MSFTNGP05.phx.gbl...
> To use another .dll add a reference to your database project. To use a
> web service add a web reference.
> David
>|||Hello James,
When you are using the VS SQL Server Project you are restricted to what
assemblies you can reference. This behavior is by design. However, you
could create a normal class library project, add references as per usual
and then manually create your assembly through CREATE ASSEMBLY. Make sure
your referenced
assemblies are in the same directory as your user assembly.
If you want to use the VS SQL Server Project you can create the assembly
you want to reference in the database before you try to reference it. You
need do a manual CREATE ASSEMBLY against the DLL you want.
As for Web service , you will also need to use the CLR SDK tool SGEN.EXE to
create and register a helper assembly for the assembly generated by WSDL,
as described in:
http://blogs.msdn.com/sqlclr/archiv.../25/Vineet.aspx
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

DLL

I have a report that need to use a decrypting dll. I can save the DLL on my
locat drive and run the report locally in the report designer. Ho do I get
it to work with a published report. I have put the dll on the local drive of
the server but it does not work when I run the report in report manager.There should be detailed instructions in RS books under "custom assemblies"
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"johnE" <johnE@.discussions.microsoft.com> wrote in message
news:535467D0-6489-4944-BB1C-7C445B36FAE5@.microsoft.com...
> I have a report that need to use a decrypting dll. I can save the DLL on
my
> locat drive and run the report locally in the report designer. Ho do I
get
> it to work with a published report. I have put the dll on the local drive
of
> the server but it does not work when I run the report in report manager.

Distributing ntwdblib.dll

Given these facts:
- There are some legacy applications that use DB-Library (ntwdblib.dll)
to connect to SQL Server
- There are now free SQL Server editions like MSDE and SQL Server
Express, and both are supposed to work with the DB-Library
- There is a need to use those legacy applications to connect to SQL
Server Express and/or MSDE 2000.
So here are my questions:
Is it possible to freely distribute ntwdblib.dll for the customers?
What is the correct/legal way to distribute such file, if a simple copy
is not allowed?
Thanks in advance!Hello Wagner,

> - There are some legacy applications that use DB-Library
> (ntwdblib.dll)
> to connect to SQL Server
> - There are now free SQL Server editions like MSDE and SQL Server
> Express, and both are supposed to work with the DB-Library
> - There is a need to use those legacy applications to connect to SQL
> Server Express and/or MSDE 2000.
SQL Server 2005 Express Edition does NOT support DBLIB. For more information
on this topic, please see:
http://url123.com/wn3x7
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Well, it seems to be not true. The link you sent says only that 64-bit
version of SQL Server 2005 does not support DB-Library.
It actually says that x86 version DOES support it, it only alerts that
future versions of SQL Server might not support it.
So my question remains.
Wagner
Kent Tegels wrote:
> Hello Wagner,
>
> SQL Server 2005 Express Edition does NOT support DBLIB. For more informati
on
> on this topic, please see:
> http://url123.com/wn3x7
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/|||You are correct that DB-Library is supported for use against SQL Server
2005, but will not be in some future release. Just to clarify one point in
my other posting, I just said that I don't know how much DB-Library was
tested with 64-bit instances of SQL Server 2005, not that the configuration
is officially not supported. I queried the dev team get a more clear answer.
In terms of your original question on this thread, redistributing
ntwdblib.dll is generally allowed. It would be controlled by the licensing
terms of the version of SQL Server from which you got your copy of
ntwdblib.dll. For SQL Server 2000 this is defined in two files on the
installation CD: license.txt and redist.txt. The SQL Server 2000 license.txt
says you can redist the files listed in redist.txt provided you meet some
general conditions, such as only distributing it in object code form with
your application. ntwdblib.dll is one of the files listed as redistributable
in the SQL Server 2000 redist.txt file.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
Download the latest Books Online update:
http://www.microsoft.com/technet/pr...oads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.

Distributing ntwdblib.dll

Given these facts:
- There are some legacy applications that use DB-Library (ntwdblib.dll)
to connect to SQL Server
- There are now free SQL Server editions like MSDE and SQL Server
Express, and both are supposed to work with the DB-Library
- There is a need to use those legacy applications to connect to SQL
Server Express and/or MSDE 2000.
So here are my questions:
Is it possible to freely distribute ntwdblib.dll for the customers?
What is the correct/legal way to distribute such file, if a simple copy
is not allowed?
Thanks in advance!Hello Wagner,
> - There are some legacy applications that use DB-Library
> (ntwdblib.dll)
> to connect to SQL Server
> - There are now free SQL Server editions like MSDE and SQL Server
> Express, and both are supposed to work with the DB-Library
> - There is a need to use those legacy applications to connect to SQL
> Server Express and/or MSDE 2000.
SQL Server 2005 Express Edition does NOT support DBLIB. For more information
on this topic, please see:
http://url123.com/wn3x7
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Well, it seems to be not true. The link you sent says only that 64-bit
version of SQL Server 2005 does not support DB-Library.
It actually says that x86 version DOES support it, it only alerts that
future versions of SQL Server might not support it.
So my question remains.
Wagner
Kent Tegels wrote:
> Hello Wagner,
> > - There are some legacy applications that use DB-Library
> > (ntwdblib.dll)
> > to connect to SQL Server
> > - There are now free SQL Server editions like MSDE and SQL Server
> > Express, and both are supposed to work with the DB-Library
> > - There is a need to use those legacy applications to connect to SQL
> > Server Express and/or MSDE 2000.
> SQL Server 2005 Express Edition does NOT support DBLIB. For more information
> on this topic, please see:
> http://url123.com/wn3x7
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/|||You are correct that DB-Library is supported for use against SQL Server
2005, but will not be in some future release. Just to clarify one point in
my other posting, I just said that I don't know how much DB-Library was
tested with 64-bit instances of SQL Server 2005, not that the configuration
is officially not supported. I queried the dev team get a more clear answer.
In terms of your original question on this thread, redistributing
ntwdblib.dll is generally allowed. It would be controlled by the licensing
terms of the version of SQL Server from which you got your copy of
ntwdblib.dll. For SQL Server 2000 this is defined in two files on the
installation CD: license.txt and redist.txt. The SQL Server 2000 license.txt
says you can redist the files listed in redist.txt provided you meet some
general conditions, such as only distributing it in object code form with
your application. ntwdblib.dll is one of the files listed as redistributable
in the SQL Server 2000 redist.txt file.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.