.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How do I access a network share from a CLR function

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :



I wrote a CLR TVF for SQL Sever to retrieve the filenames in a directory. It contains the following code to retrieve the filenames:


Sub New(ByVal PathName As

View Complete Post

More Related Resource Links

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

Error "The process cannot access the file ....." occurs while using function "ExportToStream"


Dear all,

   I sometimes get the following error while printing crystal report to pdf:

   System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because
it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export
(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream
(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
 at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at
 CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at
 CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382

  The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?

Thank you very much.


Merge Replication: How to give read access on snapshot share to a sql account

Hello All, I want to give read access to an sql account(not windows account). Can it be given or not. Someone please tell. Thanks saandii777

Access Public Function in MasterPage

Hi,I need help in accessing the function in my masterpage.I have a.master and b.aspx with the content page.Now in the page load of my content page, I want to execute the an sql query which is in a function in my master page.How can I access the function in my master page??code in my master page:public function info () as string'SQL Queryend function

Access UserControl Control from a JavaScript Function

I have a requirement to launch a Modal Javascript dialog box from within my usercontrol,I have done this by <code> function browseControlAction(ProjID,ControlID) { strPrompt = 'Select a Previous control action..'; strOptions = 'dialogWidth:25;dialogHeight:30;status:no;resizable:yes'; selectedAction = window.showModalDialog('browseControlActions.aspx?ProjID=' + ProjID + '&Control=' + ControlID, strPrompt, strOptions); var sControl = ' + ControlID + '; if (selectedAction != null) { alert(ControlID.toString()); alert(selectedAction); var sTest = ControlID + '_txtControlAction'; alert(sTest); var sTest2 = 'txtSummary'; alert(sTest2); document.getElementById('txtCurrentControls').innerText=selectedAction;   //this works as this a control on the page itself document.getElementById(sTest2).innerText=selectedAction;      //Ditto document.getElementById(sTest).innerText=selectedAction;    //This Fails as this is the control in the USercontrol I am trying to Access //__doPostBack('',''); }</code>can anybody tell me why I can't access the Textbox control on the USercontrol?

Map a network share to a virtual directory path @ runtime

Hi Guys Have run into an interesting issue. We have an asp.net web application - we can deploy it over the internet, the secure intranet, local offline user laptops. On of the teams in our organization has a product by which they develop static html reports from the main database. Originally we developed a module in our app which is nothing more than an iframe. Since the html files were pushed under our application virtual directory we used to use java script to set the source of iframe to http://server/app/module/fileXXX.html   Now due to some deployment procedure changes and some security issues the html reports will be deployed on another network server and exposed through a share. Also the share will not have IIS so not virtual directory. So we can no longer set the iframe source through java script to a web file.   Is there any way i can @ runtime map a folder in my application virtual to the network share so that we can browse to these web files like before (Copying the files over from the share to my Virtual Directory is not a very elegant soln.)   Thanks Regards Siddharth

how can i connect to Access DB in another PC in network

Hello all ,  i want to make 2 separated programs that share database in network the Access DB is on PC and the program is on another one how can i make the connection between them ?Kareem Naguib

Unable to access VM network drive in SQL during backup generated by stored procedure

I get the following error in a log file created in the osql command: Msg 3201, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150Cannot open backup device 'x:\Servername_master_sqlbu_200703101930.bkf'.Device error or device off-line. See the SQL Server error log for moredetails.Msg 3013, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150BACKUP DATABASE is terminating abnormally. The device is established in a CMD file right before the osql command is started that starts my stored procedure.  The CMD in this file is: for /f "tokens=15 delims=." %%i in ('ipconfig^|find "IP Address"^|find "192.168"') do set SUBNET=%%i :loopif exist x:\ net use x: /delnet use x: \\192.168.%SUBNET%.1\backup if not ERRORLEVEL 1 ( goto continue) else ( echo FAILED TO CONNECT TO BACKUP SERVER >> "%SystemDrive%\LogFiles\%Computername%.log" sleep 60 goto loop) :continue echo IP ADDRESS OBTAINED Echo delete old log file if it exists if exist %3\%computername%_kaman_full_sqldb_backup_old.log del /Q %3\%computername%_kaman_full_sqldb_backup_old.log Echo Rename log file to old.log rename %3\%computername%_kaman_full_sqldb_backup.log %computername%_kaman_full_sqldb_backup_old.log echo backup SQL Databases on server will start now osql -E -n -d %1 -i %2\kaman_full_sqldb_backup.sql -h-1 -o %3\%Co

How to access server/share resources from an internal/intranet Web Part?

We are a team of native-client/webforms developers who have been tasked with developing an internal intranet SharePoint system for our team. We want a WebPart that displays sets of files on internal shares, allows selection of subset(s), and then downloads the files to the local machine. Basically it's a builds/test-artifacts/documents "getter" scenario. We created less elaborate web sites that do somethihng like this (as proof of concept.) However, no matter what we do with our WebPart, it will not allow access to non-local(host) shares, files, etc. The WebPart CAN access said shares/files when the entire thing - client (IE session) and debug[ger/gee] etc - are run on a single dev box. However, when we attempt to run the client on a different machine accessing the dev box (in a server role), the code cannot access the network resources (for example, File.Exists() and Directory.Exists() fail.) How can we make this work?

Equivalent C# function for this random access read for this VB6 function?

I'm having a problem reading a block of bytes into an array from a file read (random access).  Instead, in C#, it seems I can only read byte by byte and not a block of byte.  I want to create a string array that is 500 cells in capacity but each cell is 10 bytes wide.  how do i do this?I have  written the function in Vb6 and maybe someone can tell me the fs.Read (code) for the C# equivalent.In Vb6, I declaredPrvate Type WFM  points(500) as String * 10   // This will create an string array of 500 cells but the KEY here is each cell is 10 bytes wide fixed!End type

SQL Equivalent to the First Function in MS Access

Is there a sol'n?  I have looked all over the net and have not been able to find a thing.Here is copy Access code..SELECT ID, [Academic Year], Term, Location, [Student Section], [Creation Date], First(Date) AS FirstOfDate, First(Status) AS FirstOfStatus, First([Reg Status]) AS [FirstOfReg Status], First([Status Date]) AS [FirstOfStatus date] INTO [TEMPDB]FROM [StudentRecord]GROUP BY ID, [Academic Year], Term, Location, [Student Section], [Creation Date]ORDER BY ID, [Academic Year], Term, Location, [Student Section], [Creation Date], First(Date) DESC , First(Status) DESC;I hope this helps.

Cannot Access Reports from Computers Within Network




I am able to access reports from my computer that has the SQL Server (2008) installed, but can't seem to access from other computers in the network. All I get is

"The permissions granted to user 'MyComputerName\Guest' are insufficient for performing this operation. (rsAccessDenied)"

Can someone please help?

I tried creating user "MyComputerName\Guest" and assign permission to view reports, but still cannot get it to work. Am I doing something wrong?

Here are some details from my Report Services Configuration Manager

Service Account is set up to Use built-in account : Network Service

Current Report Server Database

SQL Server Name : MyComputerName\ServerName

Database Name : ReportServer$ServerName

Report Server Mode : Native

Current Report Server Database Credential

Credential : SQL Account

Login : sa

Password : **********



Loading Static Files in a website from a network share


Hi everyone

Hopefully someone can give me some input on this problem

I have a secured network share which has folders arranged by user Identifiers. These folders consists of HTML files (and their content which is spread across sub folders). The content can be any static file (image,css) etc. All i know (through a config file) is the HTML file i need to load. Then i am blind to its content.

I cannot unfortunately import this folder/files under my web application due to certain security concerns.

Is there any way through my web application(Asp.net 2 and IIS 6) that i can load this file when the request comes through.



Claims Based Authentication - Access Denied for NTLM - Network Related



We have setup a test SharePoint environment on a single box. If we create a new classic authentication web application using NTLM the site works fine, and recognizes AD users correctly. Users can then login successfully. If we create a new claims based authentication web application using NTLM all users receive an Access Denied error when trying to view the site. The application will recognize AD users when applying permissions in Central Admin's User Policy section, but none of those users are able to access the site.

If I turn on Fiddler Capture, the sites will work fine. Once I turn it off the sites no longer work and we are again presented with an Access Denied exception (or sometimes 403 Forbidden in Firefox and Chrome). I know that Fiddler create a local proxy so I'm curious what that proxy is doing that allows claims based to work correctly.

Has anyone seen this before? Does this sound Firewall/Antivirus related? Client or server?

Thank you,



allowing remote users access to a specific site but not to any other network servers



I've been checking previous postings.  We are opening up a sharepoint site for partner companies. Once they get to their site we don't want them on any other servers on the network. 

I followed the info in previous postings and created a group called Computer_Deny, created a user and added them to that group.  I created a GPO and linked it to the default domain with the user right deny access to this computer from the network enabled and the Computer_Deny group added.  Removed authenticated users from the filtering and added the Computer_Deny group.

did gpupdate /force

restarted an internal machine for testing.  Logged on as the user I created, the user can't get to any server except the domain controller.  What I'm not sure about....they need to authenticate with the DC, I believe, once they finish their HTTPS entry and then need to get to the sharepoint server.  If that is true, the authentication process has to happen on the DC.  I would think the authentication process is different that a user trying to access a computer from the network.  Am I correct?  Am I least moving in the right direction?

The user can still access the DC various ways i.e. run command, entire network but NOT via RDP since that right has not been granted.  Some further research indicates that if

Passing variable into function in SQL Server from Access



I am trying to call a function in SQL Server 2005 from Access 2003.  It works fine with the constant value, but fails with a variable of the same value.  This works:

strSQL = "SELECT * FROM functionName (constantValue)"
rs.Open strSQL, cn 

But when I use variable in the parameter, I get error.  I have tried creating parameter objects in Access, but couldn't execute it and don't know if this is a way to go anyway.

Would appreciate for any help or suggestion.


Thank you

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend