enric vives's Q&A profile

• SQL Server How to use SQL Svr 2005 Express in Excel 2003 VBA code?

  Hello, how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003 I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express Thanks a lot. Christian This means VBA only supports ADO 1.0 and not ADO 2.0 Do you have a code snippet for creating a connection, creating a table and selecting data from sql server express Thanks a lot. Christian ...Show All

• SQL Server Foreach endless loop

  I'm having a problem where I'm using a Execute SQL Task to retrieve a dataset and storing that in an object variable. Then on success of that execute sql task I use a foreach loop task to go through the dataset and do 2 tasks inside the foreach loop. When I execute this package I have ~12 records in the dataset however when I get to the foreach loop in the 2nd iteration it keeps repeating it. It acts like it is stuck on the second record (tuple) and never goes on. I'm using an ForEach ADO Enumerator in the foreach. I've even set a breakpoint on each iteration and no task fails in side the foreach loop. I'm completely perplexed why it will iterate to the 2nd record but get stuck there in an endless loop. I've tried this on 2 different compu ...Show All

• Windows Forms Windows installer problem

  Hello! I install my aplication as administrator and I choose "Everyone" during installation. I install it in c:\Program Files\myApp. When I try to run this aplication as ordinary user then it appeared error message that access to the path c:\Program Files\myApp\somefile is denied. It is caused because I try modify config file which is created automatically by exe file (and it is placed in Program Files where ordinary user  doesn't  have permission to modify  any files). How can I solve this problem Thanks for help. Sebastian If users (or the application running in user context) needs to write to this file you shouldn't put it in the Program Files Folder in the first place. If you really ...Show All

• SQL Server Send email and Post to DB using Notification Services

  Can you send out an email and also post the same data that is in the email to a database using notification services I want to be able to send out the emails using notifications services, but I also want to be able to track the emails that went out. Any ideas Thanks, S Because the NS architecture, all data you send are saved on NS database (also you have some views to take it). The service do not mind if you send if via email or you use another protocol like filechannel, all the data are collect in your notificationclass and stored in DB. Hope this help ;) ...Show All

• Visual C++ Memory leak identifier tool for Dot Net

  Hi all, Can anyone please tell me which is the best tool (free) for identifying memory leaks in dot net application Thanks in advance Kishaloy wrote: Hi all, Can anyone please tell me which is the best tool (free) for identifying memory leaks in dot net application Thanks in advance Have a look for AQTIme on Google Thanx ...Show All

• Software Development for Windows Vista Project Templates misssing

  Hi, I installed the Visual Studio Extensions for .NET Framework 3.0 (WWF) RTM (English). After installation, all other project templates for Visual Basic and Visual C# are missing. I tried devenv /installvstemplates and also devenv /setup. It didn't work to get the templates back. Project/ItemTemplates and Project/ItemTemplatesCache folders inside Microsoft Visual Studio 8\Common7\IDE seem to be ok, cause all the templates are still there. I uninstalled the WWF Extensions again and all project templates are back in the New Project Wizard. When I reinstall WWF Extensions they are gone again. Is this a bug of WWF Extensions My configuration: Windows XP SP 2 (German) (Visual Studio 2005 Security patch installed) .Net Framework 3.0 ...Show All

• Visual Studio Express Editions IDE Question about braces

  In Beginning Visual C# 2005 Express Edition by Peter Wright it states that Visual Studio will automatically insert closing braces. When you enter a { followed by Enter , the VS editior will automatically drop in a closing } as well. This does not seem to work this way for me and I have been unable to locate an option that would turn this feature on. What am I missing Hi all, I have posted this as a surgestion to Microsoft at https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=211340 If you think that this would make a difference please support it. Also have a look at some of the other ideas, there are some good ones!! Scott ...Show All

• SQL Server Predict Probability in Decision Trees

  Hello, I installed the bike buyer example and i am learning the DMX language. Now i wrote the following query (using MS decision trees): SELECT T.[Last Name], [Bike Buyer], PredictProbability ( Predict ([Bike Buyer])) AS [Probability] From [v Target Mail] PREDICTION JOIN OPENQUERY (....... And so on..) Now the result is surprising to me. In the resulttabel all the probabilities are equal. Bike Buyer Probability 1 0.99994590500919611 0 0.99994590500919611 0 0.99994590500919611 0 0.99994590500919611 0 0.99994590500919611 1 0.99994590500919611 and so on. Now i am wondering what predictProbability means. I thought that PredictProbability meant the probability that the prediction is correct. Now all the probabi ...Show All

• Visual Studio 2008 (Pre-release) Function Memoization

  I am playing with Wes Dyers' excellent Memoization Function applied on Fibonacci function and I think the Memoize extension function is not correctly executed on a method argument. More precisely the following code: using System; using System.Collections.Generic; using System.Linq; namespace Fibonacci { static class Program { public static Func <A, R> Memoize<A, R>( this Func <A, R> f) { var map = new Dictionary <A, R>(); return a => { R value; if (map.TryGetValue(a, out value)) return value; value = f(a); map.Add(a, value); return value; }; } static void Test( Func < int , int > f, int i, str ...Show All

• Software Development for Windows Vista CoCreateInstance Problem

  Hello there ! I am creating an application which contains multiple graphs. Also I have a Directshow Filter which I intend to use in many graphs simultaneously. I am using CoCreateInstance() to create instance of my filter. In second instance (ie. my other graph with same filter is still running.) CoCreateInstance eighter does not return or it returns 0x8000ffff error. Can anybody please tell me what is happening here and corrective action I can take Thank you, There isn't anything inherent in DS that would prevent you from creating multiple instances of a filter. It would have to be something the filter is doing itself. Other than the obvious (set breakpoints inside your filter and trace), I' ...Show All

• Visual Studio 2008 (Pre-release) ChannelFactory.Close() throws CommunicationException error

  Hi, I've created an intermediate service that accepts a message on a one-way contract from a client and then forwards the message onto a server based on a message header entry. The service contract for the intermediate service requires sessions and the binding uses wsHttpBinding with reliableSession set to true. When I receive a message from the client and then create a channel factory to forward the message to the server, when I close the channel factory I get the error: 'The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.'. void IOneWaySessionRelayService.RelayMessage(Message message) { // Find ultimate receiver endpoint Ulti ...Show All

• SQL Server Package fails but single Task ends with success

  Hi I've created a simple package that contains only one task that is an execute sql task. When I run only this single task from Business Intelligence development studio it runs successfully. But when I run the whole package (also from Business intlligence studio), the package fails. The data source I access is ODBC. I'm sure the real reason for the error is the bad ODBC driver of the data source but this can't be changed. So I need to know what is different from running only a task in a package to running the whole package. If I knew that I might be able to adjust some setting and make it work. Any help welcome. I've checked the package in package explorer but there's only the one executable that ...Show All

• Visual C# why my try/catch statement "loops"

  hi! i have three succeeding try-catch-finally statements but it sort of "loops" when i run the program. this is basically the code.. . try { insert1.Connection.Open(); insert1.ExecuteNonQuery(); } catch ( OracleException ex) { MessageBox .Show(ex.ToString()); } finally { MessageBox .Show( "insert1 done!" ); insert1.Connection.Close(); } try { insert2Connection.Open(); insert2.ExecuteNonQuery(); } catch ( OracleException ex) { MessageBox .Show(ex.ToString()); } finally { MessageBox .Show( "insert2 done!" ); insert2.Connection.Close(); } try { insert3.Connection.Open(); insert3.ExecuteNo ...Show All

• SQL Server Setting Global Variables in a Script Task, HOW?

  I'm playing (and trying to learn)... I have an FTP task in a for each containter and am setting the RemotePath using an expression (works great). Thought I could use this to start learning some of the scripting funtionality in SSIS (in a script task) so found some code in this forum (thanks Original Posters!) and tried my hand at some coding... Intent was to create a variable and then dynamically overwrite the Expression in the FTP Task from the script (I know I don't need to do this, I just wanted to use it for learning purposes).... I have a variable named varFTPDestPathFileName (string) and want to set it to the value of varFTPDestPath (string) + varFTPFileName (string). Note: all variables are scoped at the package level (could ...Show All

• Visual C# How do I rename the administrator on a given machine via c#(System.Management?)

  I've found a few bread crumbs, but i have not as of yet figured this out.. here's what i know. You're supposed to be able to do it using WMI via win32_useraccount.Rename, You can call WMI stuff in c# via System.Management. What I need is how to tie those two pieces of information togther to allow me to make the changes. Can anyone help Give me a few more breadcrumbs to follow Thanks,  Eric-   I was trying to look for this for you earlier but couldnt find one. the technet scripting guy article(s) did state that there was no way to rename an account in WMI since the Rename method does not exist in W2K. I also remember a previous colleague who I was with (who is a guru of infra ...Show All