AcrossThePond's Q&A profile

• SQL Server Error Log shows message regarding I/O Requests taking longer than 15 seconds. Why?

  I noticed the following message in the error log last week: "SQL Server has encountered 50 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\mssql\dataDB1_Data2_Data.NDF] in database [DB1] (7). The OS file handle is 0x000003F4. The offset of the latest long IO is: 0x00000c71fec000" I get the feeling that this is not a database issue per se, but perhaps the engine informing me that it's I/O requests to the O/S are taking too long. Is that correct Can you point me to a document which discusses this topic Could this be a disk/controller issue Could this be caused by a poor distribution of database files across disk volumes Thanks SQL Server ...Show All

• .NET Development Access Excel File On Different Server ** Help Urgently Needed Plz **

  Hi all, I am trying to link to an excel file on a web directory on a different server but can't seem to get access to the file, This is the code i'm using: Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=\\fse1web563\fsetrain$\public\Equiv\FSE_PAS.xls;" _ & "Extended Properties=Excel 8.0;" Any ideas, help appreciated what happens when you try it how do you normally access the file in Windows try pasting that path from the data source into Windows Explorer and see if you can access it, if not, then that is your problem and you need to find the correct path to the file ...Show All

• Software Development for Windows Vista SNMP pdu agent address is 0.0.0.0 when trap sent from Vista

  When I generate a trap from a Vista machine using the WinSNMP APIs the agent address is 0.0.0.0 instead of the IPv4 address of the machine. If I run the same code on an XP SP2 machine the agent address is as expected. The code I am using to generate the trap is below. I am new to SNMP and the WinSNMP API so it is possible I am omitting some important step, such as explicitly setting the agent address. I have searched the WinSNMP documentation and googled for inspiration but I have not found a way to set the agent address. Where am I going wrong The source address on the IP packet appears to be correct, so I guess I could use that. However, and I may be demonstrating my ignorance of SNMP here, could the packet have been relayed so that th ...Show All

• Visual FoxPro sharing connections between applications

  Pehaps I better wrote: sharing databases between applications . This is the thing. I have a VFP application which is 99% complete. Occasionally I add some embelishments or premium features. I am also in the process of developing a C# app of Winsock style. It is a console app in Visual Studio 2005. It is supposed to use some of the same ODBC VFP9 databases. I've read that VFP databases are much superiod to SQLServer databases in terms of speed. I spent a day trying to figure out why I could not open a connection while my VFP app was open all the time and those databases were linked to it. Finally, even superstupid get their break and I realized that there was nothing wrong with my connection string. I shut the VFP app down. This brings m ...Show All

• SQL Server SQL 2005 Express and Visual Studio 2003 - Connecting

  I have Visual Studio 2003 and had used it successfully with MSDE. I recently upgraded to SQL 2005 Express and cannot seem to connect to the SQL server. it appears in the list of servers on localhost, but when I try to create a new database it tells me that it "cannot create databases on this server." It will not even open up any existing databases. I have .NET 2.0 installed. I uninstalled SQL and reinstalled it, but nothing seems to help. I feel I must be missing something, but do not know what. I no longer have the MSDE installation files, so I hope I can get Studio to talk to SQL Express. Any help is appreciated. Further checking in the services list showed that SQLEXPRESS was fro ...Show All

• Visual Studio Migrating From Crystal 9.0 to Crystal XI

  Facing Difficulties while migrating to Crystal XI. Advice would be appreciated. I have installed the evaluation version of Crystal XI but when am running the applications am getting errors such as load report failed and Unable to connect: invalid log on parameters and so on. Help is needed urgently... hi kentish, this is suresh, from chennai, india. this is ur question which was posted on 01-13-2006. Facing Difficulties while migrating to Crystal XI. Advice would be appreciated. I have installed the evaluation version of Crystal XI but when am running the applications am getting errors such as load report failed and Unable to connect: invalid log on parameters and so on. i hope you had the solution for ur doub ...Show All

• SQL Server "dangerous MSI" Microsoft SQL Server 2000 DTS Designer Components

  Microsoft SQL Server 2000 DTS Designer Components has cause a total destruction of my Enterprise Manager. In my workstation I've got Sql Server 2000 client and Sql Server 2005 client. Everything goes fine up to here. But when I've installed that MSI I have not been able to open my Enterprise Manager. From MMC appears: Error initializing component CLSID: {xxx.xxx} My goal was be able to open 2000 stuff from Sql Management Studio. By the moment, I'm forget of that. Does anyone have ever faced this issue QA is working. Thanks in advance for any suggestion First, if you had 2000 client tools and 2005 client tools installed you did not need to install the "DTS designer tools&quo ...Show All

• Visual Basic releasing resources

  having created a user control (which contains a few buttons and text boxes ) and added several of them to a panel...how do i release their resources/memory when i want to clear the screen and start over do i need to create a dipose or finailize method in the user control class do i just need to iterate throught all the controls and call their dipose methods or something else how do i release all the variables associated with the class Thanks, Dan I suspect something else is going on - for one thing, you mention opening files. Yes, a lot of controls will use a lot of memory, but is unlikely to cause an out of memory exception (the garbage collector is quite smart). Try populating w ...Show All

• Visual C++ VS2k5 .Net - Recompling previous versions Problem

  Hi all, I wrote a program in VS2k3 .Net a couple of years ago, and recently I wrote a program in VS2k5 using the ver. v2.0.50727. of .Net. The thing is when install the program complied in VS2k5 .Net on a computer that is running the program complied in VS2k3 .Net, I receive an error: Different version of .Net required. So I install the newest version of .Net, but then the program compied in VS2k3 .Net doesn't want to work So my question is, everytime Microsoft releases a new .Net framework, does the whole program have to be re-complied / re-written Thank you Regards Programm3r Program written in VS2003 can run under .NET Framework 1.1 or later. Install .NEt Framework 2.0, both programs can run under it. .NET Framew ...Show All

• Windows Forms check whether form is already opened

  I want to check whether form is already opened, if yes, bring it to front, otherwise, create the new form and open it: frmRegistration frmRegistration1 = new frmRegistration(); frmRegistration1.Show(); please help. It's a C#.net 2005 winform application thx nobugz, thats exactly what i was looking for. i did a little change, this is my code: if ( Properties.Settings.Default.frmReg == null ) { Properties.Settings.Default.frmReg = new frmRegistration(); Properties.Settings.Default.frmReg.Show( this ); } else if ( Properties.Settings.Default.frmReg != null && Properties.Settings.Default.frmReg.WindowState == FormWindowState.Minimized) { Properties.Settings.Default.frmReg ...Show All

• SQL Server Sub-select "NOT IN" performance in SQL Server 2005 Vs 2000?

  I have a suituation that I have inherited where extensive use of "NOT IN" has been used in a system. We all know that this is bad form but that is what I have to deal with and changing every query would be a major undertaking. Certainly way beyond the end of my contract! Here is the situation: The database has been restored from a backup taken on a SQL Server 2000 box. The collation has been changed from SQL_LATIN1_CP1_CI_AS to the SQL Server 2005 default, LATIN1_General_CI_AS using a script to change all objects. Statistics have been rebuilt for every table. I have a bunch of DTS packages with this type of SQL statement with "NOT IN" statements. In some cases, these are nested three deep! Even though ...Show All

• Visual C# report path

  how can I set the Report Path in ReportViewer please give me an example. ReportServerUrl = http://localhost/reportserver ReportPath = .... You would set the report path to the folder and filename (do not include the RDL extension) of the report. Thus if you had a report located in the sales/2006/Q4 folder of RS and the report you wanted to run was called CorpSales.rdl you'd do the following. ReportPath = "sales/2006/Q4/CorpSales"; Michael Taylor - 9/11/06 ...Show All

• SQL Server Reporting Services - credentials error.

  Hi everyone. I have created a report in RS and it works fine (am invoking from VB.Net - windows forms). However, I have copied the report into a new one as I need a very similar looking report to be called from the same application, but if I attempt to invoke it in the same way as the first I get the following error: "An attempt was made to set credentials for a data source '<name>' associated with thre report. Report data source settings are specified in a way that prevens credentials from being submitted to the report server." I am passing the credentials like so: Dim cc As New DataSourceCredentials Dim cred() As DataSourceCredentials = {cc} cred(0).Password = "*****" cred(0).UserName = "*** ...Show All

• Visual Studio Express Editions Textbox Display web browser's URL

  I would like to know how to make my ToolStripTextBox1 display the URL of WebBrowser1. I want it to display the URL of each new page WebBrowser1 loads. Thank You. For your webrowser make a webrowser.documentcomplete event In that event put this code: ToolStripTextBoxq.text = webBrowser1.URL And you'll have it. ...Show All

• SQL Server Slow Report

  As I sit here waiting for a test run of the report to complete, I'm forced to wonder why it's taking over 10 minutes... so far. The query itself, when run through Management Studio takes about 50 seconds, so why would it take over 10 minutes to generate the report   It's the only query being run, and it's not doing anything especially tricky with the data.  It's all actually being processed in the query, returning some counts and displaying them in a simple list. Any thoughts EDIT:  I should mention that the query itself isn't very simple, so I can understand the query itself being slow... just not the report being 10 times slower than the query in management studio. Could you be more specific please Is it an ...Show All