Jimbo44's Q&A profile

• Visual Studio Express Editions remote database

  Hi People! Please, HELP ME! I use Visaul Basic express edition and I want to connect to remote microsoft access database. 192.168.54.106 with computer about this IP I want to connect Data Source=C:\software\software.mdb strConString = "Provider=MS Remote;" & _ "Remote Server=http://192.168.54.106;" & _ "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\software\software.mdb;Persist Security Info=False" This code doesn't work I' am waiting for answer I will be very grateful   nobugz wrote: It is not restricted from accessing files over a network share as the thread poster want ...Show All

• Visual Studio Express Editions Help with "Concentration" Game

  I am a student studying VB for the first time and I've run into a snag programming as assignment. It's a matching game consisting of 8 pairs of matching words randomly assigned to 16 labels. When a label is clicked, the word currently assigned to it will display. If two labels are clicked and the words match, the labels are disabled and change their color. This is done until all 8 pairs of words are found, after which a message box is displayed indicating the game is over. I am confused as to how I can randomize the list of words and assign them to the labels, as well as how to check for matching. Any help would be appreciated. So here's the array I've got with the words to be used: Dim sItems(15) As ...Show All

• Software Development for Windows Vista StateMachine invoke SequentialWorkflow

  Hi together, I am using a state machine workflow which invokes another sequential workflow. The sequential workflow gets called but after the sequential workflow has finished, the parent workflow (which is a state machine) switches to the completion state. Example: Sequential Workflow ^ | State A ---> State B ----> State C ----> Completion State As you can see in the sample "State B" invokes "Sequential Workflow". And now when the sequential workflow gets finished, the parent state machine switches to the completion state instead of "State C". Any ideas what's wrong here Cheers, Franz HI, I have done the same scenario like yours a ...Show All

• SQL Server sql 2005 downgrade to sql 7.0

  Hello people, I'm experiencing problem here that we need to downgrade our sql 2005 back to version 7.0. Apparently, all the mdf files from 2005 are recognized as "corrupted" by the 7.0 server. All my dbs are created within 2005 and i'd like to move these to the older 7.0 server. I wonder whether there are any procedure to convert 2005 mdf files so that is is compatible with sql server 7.0 or what is the most common way of solving this Any pointer would be appreciated. thx! No, you will have to export / import the data to / from the SQL Servers. There are internal changes within the database that cam’t be read by SQL Server 7.0 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Forms ClickOnce - CrystalDecisions.CrystalReports.Engine.ReportDocument

  Hi, I developed a large scale win form application that uses Crystal Reports (vs2003 cr version ) in .NET 1.1 and recently converted it to .NET 2.0. The problem is when ever a user opens a form that uses crystal reports I get the follow exception: ************** Exception Text ************** System.TypeInitializationException: The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception. ---> System.Runtime.InteropServices.COMException (0x800736B1): Retrieving the COM class factory for component with CLSID {11BD5260-15B6-412D-80DB-12BB60B8FE50} failed due to the following error: 800736b1. at CrystalDecisions.CrystalReports.Engine.ReportDocument..cctor() --- End of inner exception stack trace --- ...Show All

• SQL Server Creatng Charts Using scripts in sql server 2005 express

  Hi all, I want to Create charts for database table entries in sql server 2005 express edition, by using the scripts only not through wizards... Plz help me for the above topic Thanks & Regards, Srinivas T-SQL only returns data, you will need to use some other program to generate the charts from the data. You could use the Reporting controls in VS but I believe the report designer for VS is only available in VS Pro and as a download for VWD Express. (The other Express products don't have report design as a feature.) You can also consider Report Server, which is part of SQL Express Advanced. You will additionally need the SQL Express Toolkit to get the report design projects as part of BIDS. ...Show All

• Microsoft ISV Community Center Forums How do connect an Excel file from Remote Server

  Hi All, I am creating one application in Excel. In this application One Excel file will be in the Remote Server.When one persone get log in then the file immediately has to link with this excel file which in the remote server. Now my question is - Is it possible to connect the Excel file from the remote server using VBA. Please any one help me to do this. i am searching this in lots of way. if not is it possible Access file. Kalidas It is ok blackmamba, Please blackmamba i am seraching this very urgently. please help me. i can't understant. The remote server will be in singapore and the user will be in india. in this case how can we map the singapore server in india pc. There are mult ...Show All

• Visual Studio Express Editions Reading spreadsheet data

  This seems very basic, but couldnt find anything yet. I need to just read a column of data, and store it in an array. I am trying to do it with out having to open an instance of Excel. It is a space deliminted file. Any tips I am a total newb, thanks! If its a space delimited text file Then use the TextFieldParser Class http://msdn2.microsoft.com/en-us/library/4cwxw7dx(VS.80).aspx ...Show All

• Visual Basic How do I set delay between code?

  Hello all. I would like to enquire how I can set a delay in between chunks of code. For example, after some code which interacts with a server, I am supposed to get a corresponding information from the server before it is appropriate to proceed on to the next part of the code. As the server response is not immediate, therefore an arbitrary delay is needed. What is the proper code format that I need to add  I can't seem to find the documentation in the help file. Thanks in advance. The easiest way is often to simply do a sleep: System.Threading.Thread.Sleep(1000) ...Show All

• SQL Server SQL Server Agent could not access replication agent

  We just moved source server to newer, bigger box ... Windows 2003 and Active Directory ... Snapshot agent worked but distribution failed ... Same login as on older machine, login is sysadm, used DCOMCNFG to allow ability to launch process ... What are we missing Thanks Raymond. It is SQL 2000 and the process failed immediately. It's running with the owner of sa and since I deleted old replication, I can't verify if that is the same. ...Show All

• SQL Server Need help in copying a temp tables contents to a existing table

  I have a real table with an identity column and a trigger to populate this column. I need to import / massage data for data loads from a different format, so I have a temp table defined that contains only the columns that are represented in the data file so I can bulk insert. I then alter this table to add all the other columns so that it reflects all the columns in the real table. I then populate all the values so that this contains the data I need. I then want to insert into the real table pushing the data from the temp table, however this gives me errors stating that the query returned multiple rows. I specified all the columns in the insert grouping as well as on the select from the temp table. ANY thoughts / comments ar ...Show All

• Visual Studio Express Editions Creating Icons

  I have been trying to create an icon and saving it with paint as "icon.ico" but it isnt accepting it other icons will be accepted does anyone know why this is happening Polarbear541 i was using the properties window not code (in the visual basic express program) It says "the argument 'picture' must be a picture that can be used as an icon." ...Show All

• SQL Server How to query data from Cube

  Could you instruct me the way to query data from cube Thank you very much. You can query AS cubes using the MDX language ( http://msdn2.microsoft.com/en-us/library/ms145506.aspx ). You can also various client applications to visually query cube data, including the PivotTable component in Excel and Office Web Components. ...Show All

• SQL Server How to add reference to SSIS script task

  Hi ALL I cannot add the reference to the following: "Imports Microsoft.AnalysisServices.AdomdClient" in SSIS script task. All the objects that i declared become underlined because there is no reference to the above library. When i go in SSIS script task and open the code to add the reference it does not the list the above library. I am able to add reference in Visualstudio but not in SSIS. Please adivse, it is very critical and urgent for my task Thanks. Does this help http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/07/16018.aspx Ed ...Show All

• Visual Studio 2008 (Pre-release) Background AddIn - Program not responding?

  Hi! For this code: using System; using System.Collections.Generic; using System.Text; using Microsoft.MediaCenter; using Microsoft.MediaCenter.Hosting; namespace addInMCE { public class Class1 : IAddInModule , IAddInEntryPoint { void IAddInEntryPoint .Launch( AddInHost host) { host.MediaCenterEnvironment.Dialog( "Boom" , "Bam" , DialogButtons .Ok, 10, true ); } void IAddInModule .Initialize( Dictionary < string , object > appInfo, Dictionary < string , object > entryPointInfo) { //throw new Exception("The method or operation is not implemented."); } void IAddInModule .Uninitialize() { //throw new Exception("The method or operation is not implemented." ...Show All