el_Fede's Q&A profile
Microsoft ISV Community Center Forums Problem with Connection Strings
Hi All, I have an excel spreadsheet, which I want to use like a database table and access using ADO from another spreadsheet, but whenever I attempt to assign my connection string to the ActiveConnection property of my ADODB Recordset, I get the following error: Could not find installable ISAM. Below is the connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Le09\kpl_biskra\personal_biskra\ksmith\Reporting\Weekly\Christmas Analysis\DataFile.xls;Extended Properties=Excel 8.0;HDR=Yes; Can anyone help Many thanks! Keith Keith, I ran into this exact issue a couple weeks ago. Unfortunately I don't remember off the top of my head what I did to fix it. Let me dig through some ...Show All
Windows Live Developer Forums 3D Map not displayed.
Hi, I am trying to view 3D maps from my IE 7 browser. My hardware configuration is P4 2.8 GHz; 1 GB RAM; inbuild graphics card with 64 MB of memory. When I switches to 3D mode the 3D control gets loaded successfully but when I zoom in; I can't see any 3D structure; only thing I can see is green land. How can I view 3D objects like buildings & all on Virtual Earth On the VE website, the options link is in the upper right corner of the page. The 3D settings button is near the bottom of the list of settings. Once set, it will be used for any site you visit. ...Show All
Visual Basic Help! I can't save data changes to an MDB file in Visual Basic 2005 Express
Hi all. I've created an application that will read data from an MDB table (linked to an Excel spreadsheet), but I during debugging I cannot actually save any changes made to the table. I've gone through all the walkthroughs but I just end up with an error message. Is it actually possible to write to an MDB file If not, how do I create an MDF file (which I know is writable) from an existing Excel spreadsheet Although I have created a version of this spreadsheet on my local server, VB2005E won't let me connect to my local server when choosing a data source. Clearly I'm a complete newbie at this, so all advice is very gratefully appreciated. Make sure that a primary key has been set on the table in ...Show All
Smart Device Development Plug-in code issue with CF 2.0
I'm trying load a plug-in and I'm using CF 2.0 The path is: C:\NewIntel\MCU\Plugin1\bin\Debug Interfaces.dll which does load Interfaces.dll but not Plugin1.dll which is in the same path for the Storage Card running the emulator. Look at FindPlugins function for the code that does Assembly.LoadFrom("Plugin1.dll"). This code works fine for for the Desktop framework 2.0. What can I do to fix it Error... System.IO.IOException was unhandled Message="File or assembly name 'Plugin1.dll', or one of its dependencies, was not found." StackTrace: at System.Reflection.Assembly.LoadFrom() at PluginServices.FindPlugins() at WCEMCU.frmMCU.frmMCU_Load() at System.Windows.Forms.Form.OnLoad() at System.Windows.Forms. ...Show All
Visual Studio 2008 (Pre-release) Extracting DataTable from query expression
Hello, I would like to be able to "extract" the DataTable used in a query expression. Sepose I have the following code var query = from c in Customers select c; I would like to "walk" the query expression and to receive Customers as base table in that query. If I have the following query: var query = from c in Customers join o in Orders on c.ID equals o.CustID select new { c, o } I would like to receive Customers and Orders as base tables in that query. Is it possible Dear Matt, Thanks for the answer. I understand what you are saying. Let me try to explain why I want this kind of behivour: I'm writing a 3-tier application. ...Show All
Windows Forms ClickOnce Deployment
Hi I tried the Clickonce deployement example with publish wizard. It works good on my machine but when i try to access that web page from some other machine using local intranet it is not displaying publish.htm page. Any suggestion please. Thanks Shailesh Sounds like an IIS issue if the htm page isn't even displaying. Are other pages working fine from another computer What type of authentication do you have enabled on IIS ...Show All
Visual FoxPro the no server server?
ok my client now wants the application i made to run on multiple computers. i am not a network wiz but i know a few things. will this work: 1. right click mynetwork places and do map network drive. ill make drive Z:\ and find a folder.... ok now i have drive Z:\.... now i do the same thing with the 2 other computers. So i now have 3 computers with drive z:\. on drive z:\ im going to have all the files. my questions are is this a good setup will it work out More or less but not so simple. You have to make sure any new installation has a map to drive Z: Better yet, don't use mappings and use \\Servername\SharedFolder\ notation instead. Your program has to be multiuse ...Show All
Visual C# Delegate quandary
In my Class Form1 a delegate DoMyWork object is declared as follows: public delegate void DoMyWork ( Cdelegate cDelegate, string sss); Cdelegate is a Class. It looks like this: public class Cdelegate { public void openCSVfileAndDumpToSQL ( string symbol ) { Class2 class2 = new Class2 ( ); string csvFile = ""; DataSet dataSet = new DataSet ( ); DataTable dataTable = new DataTable ( "temp_" + symbol ); // etc., etc., etc. } } Then in Class Form1 I have a Click method: private void pushCSVtoSQLserver_Click ( object sender, System.EventArgs e ) { Cdelegate cDelegate = new Cdelegate ( ); char[] delim = { ',' }; string[] symbols = Globals.cumSy ...Show All
Visual C# Do Loops in C#
Im new to C#, just busy moving from Visual Basic. I find the language nice, and have been coming on well so far, however at the minute i wish to use a loop; I was wondering, does C# not support the 'until' specifier when 'do looping' If possible I would greatly appreciate anyones help, maybe you could explain a little to me about loops in this language Common mistakes maybe ... Also when using a 'while' I have and error explaining something within the function cannot be void, however I am not at my own PC right now and do not have the exact error message to hand. Thanks for any help. JWH John Wesley Harding wrote: This reply is a great help, however one last question would be...Does a ' ...Show All
Visual FoxPro the no server server?
ok my client now wants the application i made to run on multiple computers. i am not a network wiz but i know a few things. will this work: 1. right click mynetwork places and do map network drive. ill make drive Z:\ and find a folder.... ok now i have drive Z:\.... now i do the same thing with the 2 other computers. So i now have 3 computers with drive z:\. on drive z:\ im going to have all the files. my questions are is this a good setup will it work out what i do is i have a text file on all the computers and inside the text file is the path.. "z:\" so before my application starts i just create a temp cursor and append the csv value from that text file. i ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Post 2D whole screen 'filters'?
Hi there, I want to be able to do a 'blur' or a 'fade to black' of the whole screen after I've done all the individual Draw()s. Imagine this is an end of game, and I want to do a nice blur of the whole game screen, then display 'game over' or whatever. Is there a way to do this 'filter' Thanks! LH I am sorry. Silly me, I thought these forums were just for xna questions. Doh. It's the beta release of the XNA studio, C#. Using this so far with a 2D game. thanks! LH ...Show All
Visual Studio 2008 (Pre-release) Exceptions and WCF
Hey! I have read the msdn documentation on handling faults in WSF but can’t get it to work. I have the fallowing Interface fore the service: [ServiceContract(SessionMode = SessionMode.Required, CallbackContract = typeof(IChatChangeHandler))] public interface IChatChangePub { [OperationContract(IsOneWay = false, IsInitiating = true)] bool subscribe(string inNickName); [OperationContract(IsOneWay = false, IsInitiating = true)] void unsubscribe(); [OperationContract] [FaultContract(typeof(userListFault))] List<string> getUserList(string inNickName); [OperationContract(IsOneWay = true)] void publishChatMessage(chatMessage inMessage); } As you can see i am using a costum faultExcetion(userListFault) that lo ...Show All
SQL Server NoRows SubReport
Greetings, I have a report which contains three subreports. Each subreport is contained within a rectangle in the main report so I can force a page break after each subreport. In each of the subreports, there is a graphic and a text box on one line, then another text box below those two items, then a table below all that. My problem is that if one of the subreports returns no data, it is resulting in a NoRows sort of situation and not even the graphic and the two text boxes are shown. I understand that you can set a NoRows message, but ideally, I want my NoRows message to be the graphic and the two text boxes, not a plain text message. I'm not sure if this is even possible or at the very least if I could conditionally force a page br ...Show All
Visual Basic Access database + BLOB?
Hopefully someone can help me with a few questions: 1) Can you manipulate Access fields to manually (using the Access interface) add images translated into binary (have a text field instead of a OLE Object field) Or does this have to be done through a memorystream/streamwriter in a seperate program 2) I don't like using BLOB to read binary text streams from a database because it causes crashes when I scroll through the entries too fast or how it requires you to read the binary from the database to a physical file then read the file using system.drawing.image.fromfile(). Can I use image.fromstream() to do the same thing without having to write to the harddrive (I would like a short example please) Maybe memorystream 3)Can you strip the OL ...Show All
Visual C# parameterless arguments ... parameter count missmatch
I have a delegate that has a parameterless arguments delegate void MyDelegate(params object[] args) I have a function : void ShowBox(params object[] args) When i try to invoke it like this Invoke(new MyDelegate(Showbox), "hi", "hello"); it doesn't work .. it gives a parameter count missmatch But if i do something like this it works ... object[] param = new object[2] {"hi","hello"}; Invoke(new MyDelegate(Showbox), new object[] {param}); i thought i could do something like the string.format (format, "hi", "hello"); how come it doesn't work the same Hi, the actual Invoke method takes a delegate and an array of parameters, it is not using a ...Show All
