MrJP's Q&A profile

• SQL Server How to make a File Share Subscription running on Vista?

  I recently migrate to Vista.   I had a bunch of reports with file share subscriptions that were running fine on XP.   After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager.   As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’.   I thought that this was the signature of a successfully configured subscription.   But surprisingly, there is nothing in the file share. The directory is empty.   Anybody has an idea why   Anybody knows how I could possibly find information on my ...Show All

• Visual Studio Express Editions Cannot install VC# Express

  I have tried unsuccessfully to install VC# Express several times over the last few days both from the download now link and from the .ISO image. Here is the install log from my latest attempt. [11/14/06,18:47:50] Setup.exe: [11/14/06,18:47:50] Setup.exe: ========== Logging started ========== [11/14/06,18:47:50] Setup.exe: ===================================== [11/14/06,18:47:50] Setup.exe: GetGlobalCustomProperty({481CEF9F-033A-11D3-ACE2-00C04F8EEBA1}) [11/14/06,18:47:50] Setup.exe: GetGlobalCustomProperty(B51015E7-26A5-4c8f-B871-26ABA9BEFB65) [11/14/06,18:47:50] Setup.exe: Command line parameters: [11/14/06,18:47:50] Setup.exe: entering ISetupManager::RunIntro() [11/14/06,18:47:50] Setup.exe: LoadSetupDatabase() [11/14/06,18:47:50] Setup ...Show All

• Visual Studio Team System Change request

  Hi, I have some question, I want to know how can I manage my all change request in my Team System, I have to modify my Template or what you recommend, I want to have control in my change request because I have to apply on CMMI process, any idea about this   Thanks! Hi, I found my file ChangeRequest.xml from my Template, I have some problem with this, because if I want to add more fields to my change request form, for example I want to add at my form the Cost field, first my data type is decimal because we talk about money but the field need some reference, you know in where can I consult all refname="" that I can use there.   This is my field code:    ...Show All

• SQL Server How do I schedule JOB in sql 2005

  Can anyone please help me for scheduling JOB in sql 2005. Thanks in advance. Raviraj you could emulate the agent by writing a batch script that calls some sql commands using sqlcmd , then use windows "scheduled tasks" to give it a daily job... though scheduled tasks isnt super reliable IMO it can pretty much get the job done ...Show All

• SQL Server Aborting a thread CRASHES Sql Server 2000!

  Hi, I'm creating a new thread and executing a database import operation using a transaction. I have had several problems that I cannot explain, the most serious of them being that aborting this thread sometimes crashes the instance of Sql Server to which I was connected! The application is a Windows Forms app, and when I launch the import operation I display a form that allows me to abort the import while it is in progress. If the user decides to abort the import in the middle of things, I call the Abort() method of the thread executing the import. I'm catching any exceptions in the method on the bottom of the call stack (the ThreadStart delegate) and logging the information, and from the stack trace I can see that the ThreadAbort ...Show All

• .NET Development Custom Collections and Custom Events in Web Services

  Hi, I have a Web Service that returns a Custom Collection. So my Web Services client proxy class that was autogenerated has a array of objects that correspond to my custom collection on the server. This is working fine for me. My question is: I have a requirement that when some specific changes occur in the object array on the client side, I should be able to catch that change. Suppose I have a CustomCollection on server called 'EmployeeCollection' (Collection of Employee). Employee has only two attributes EmployeeID and Salary. So when I generate a client proxy, I get a Employee class on the client and an Employee[] that corresponds to EmployeeCollection. Now at runtime, when Employee[] on the client is populated and if ...Show All

• Visual C++ 24Bits Bit-field Alignment error under VC++

  Hi, I wrote code to interact with some netrork device. One of the network structures contains a 24-bits field. Everything is packed to "1" (byte). struct test { char bob0; char bob1; short bob2; char bob3; unsigned long bob4 : 24; unsigned long bob5; }; int main() { test tt; tt.bob0 = 0; tt.bob1 = 1; tt.bob2 = 2; tt.bob3 = 3; tt.bob4 = 4; tt.bob5 = 5; unsigned long * ptr; ptr = (unsigned long *)&tt; printf("%08X\n", ptr[0]); printf("%08X\n", ptr[1]); printf("%08X\n", ptr[2]); printf("%08X\n", ptr[3]); printf("%08X\n", ptr[4]); return 0; } Under Visual Studio (2003 and 2005), the result is: 00020100 00000403 000005CC <-- CC Packing is at 1, there s ...Show All

• Visual Basic Recording sound from microfphone in VB 2005 EE

  Please, could you  tell me how to record sound from microphone in VB 2005 EE . If you would be so kind anything simply. Thanks. Thank you very much! I I tried it but this program for Visual Basic 4.0. It doesn't work in Visual Basic 2005 Express Edition. I am much obliged. Bubo ...Show All

• Visual Studio Express Editions Openin files

  Hi i am extremly new in VB, so please treat me like a baby (!). I am trying to open a .txt file, and a book im reading is telling me to do it like this: Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim FileName As String FileName = App.Path & "c:\NamesAndAges.txt" End Sub Now this isnt working its sayin "App not declared" can you please tell me how to solve this. any help is apreciated! Thanks, Fire_alive I see you are a VB6 user. in order to open/write files in .NET, you read/write from a Stream or File classes. to open a file: ...Show All

• SQL Server Encryption - Protect from attacks by programmers?

  I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up. What are your ideas on this matter TIA, barkingdog >>it should just be passed to the OPEN SYMMETRIC KEY statement Exactly, but my open symmetric statement is inside an SP. There can be more than 100 SPs that have to access this password. In ...Show All

• Visual C++ change letter in an array

  How do you change an letter in an array for example string[10] = hello; how do you change 'h' in array to a 'b' Some optimization :) you can directly write as str[0] ='a'; ...Show All

• Software Development for Windows Vista data execution prevention

  hi, data excution prevention is not allowing me to use windows live messenger, i have tried to disable it for windows messenger but it wont allow me to, anyone know how i can disable data excution prevention on windows vista thanks for any help. I am having the same problem with my Windows Live Messenger. I just bought a new Acer Aspire 9410 laptop and tried to run Messenger only to get the data execution prevention error. Please let me know how to fix this issue. I cannot believe that Microsoft would have an error with one of their key programs like this. Thanks, Dave ...Show All

• SQL Server Drop Database

  Hi all, I try to restore a DB on MS SQL 2000 but something was wrog because restored DB compare on tree view of SQL Enterprise Manager commented with "(Loading/Suspect)". I can't access to DB and I cant delete it. I obtain this : "Error 3724: Cannot drop the database 'XXXX' bacause it is being used for replication. How can I delete or solve this problem Thank's a lot bye HID Well, thank's for your rapid suggest and sorry for may long break. So the problem persist because I can't access to DB for restore..., what do you think if I try to shutdown DBMRS and I delete file_data.mdf Do you think a link on tree of SQL Manager go away Thanks hid ...Show All

• SQL Server Cannot create DSN to SQL Express

  I installed SQL Express and was able to create a new DB using Management Studio. I was able to copy over tables from another DB using DTS, but strangely the Native Client would not work I had to use OLE for SQL Server. But I am unable to create a DSN to the database using ODBC Administrator. I keep getting Login Timeout expired error message, using both Native Client and SQL Server drivers. What am I missing Thanks Mark Finallly I managed to get it to work, when I realized the ODBC Administrator does not display the full name of the server. It displayed MARK_LAP, which is the name of my computer. I realized I needed to type in MARK_LAP\SQLEXPRESS which is the name of the server, and it works now. ...Show All

• SQL Server Need some help with DTexec execution

  Hi! When i excute in the sql server this works fine xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx "' but when i excute throught the C# code jobCommand = new SqlCommand(@"xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"'", cconn); It shows up red lines near the " and ' qoutes. I know that quotation marks are wrong but don't know how to solve it. some help please Thanks jas one more guidance needed with regard to the Quotation marks path = @"D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"; jobCommand = new SqlCommand(@& ...Show All