IceAngel89's Q&A profile

• Visual Studio Express Editions Browser and Player

  Hi! first: i am new to this! so heres the problem: i want to build a browser with a music player! i thought the browser is on one tab and the player is on an other. so i realy would like to know how to do this! thx! your leo but if somebody downloads my application and wants to play his own file(s) and how do i get these play/stop/rewind etc. buttons ...Show All

• SQL Server Connecting to Oracle on 64-bit (x64) machine

  Hi, Has anyone received the following error when trying to create a connection to an Oracle database using SSIS installed on a 64-bit (x64) machine "Test connection failed because of an error in initializing provider. ORA-06413: Connection not open" The reason this is funny to me is because I have the same Oracle/SSIS setup on a 32-bit (x86) machine and I can connect successfully. On both machines I have SSIS RTM, Oracle 9.2 and using the Microsoft Ole Db Provider for Oracle. Thanks, - Joel We are also facing the same problem with Oracle. Btw, if you guys are looking at high speed data loading into Oracle using SSIS, we have built a high speed connector. More details - please visit http://www.p ...Show All

• SQL Server Error after migrating to SQL Server 2005

  I'm trying to migrate MS Access 2003 query into SQL Server 2005 view. I'm getting error for the following query. ERROR: Incorrect syntax near the keyword 'LEFT' MS-Access query: SELECT tbl.*, tblP.ParticipantLastName, tblP.ParticipantFirstName, tblP.ParticipantAmount, tblP.SocialSecurityNumber, tblP.Comment FROM tbl LEFT JOIN tblP ON tbl.AutoNumber = tblP.RecordNumber WHERE ToBeProcessed='YES' and [Cancel]=0; SQL Server View: CREATE VIEW dbo.[qryReport] AS /* * Generated by SQL Server Migration Assistant for Access. * Contact accssma@microsoft.com or visit http://www.microsoft.com/sql/migration for more information. */ SELECT tbl.*, tblP.ParticipantLastName, tblP.ParticipantFirstName, tblP.ParticipantAmount, ...Show All

• Visual Studio Express Editions Prevent Unbound DataGridView From Adding New Rows -- and more

  I've been in VB6 for a LONG time and can do most anything I want with it but I'm just getting started in VB 2005 Express. I want to rewrite my gradebook program using an unbound grid control (thinking maybe DataGridView). When I edit a cell in the last row of my grid, the grid wants to add another row on the bottom. How can I stop this ============================================= Another option I have is to use a 3rd party control like FlexCell. Adding extra components in VB6 was easy but how do I get a new control (beyond the ones included in VB2005) like FlexCell in my VB2005 project I figured out that I have to add a reference in the Project Properties tab, but my FlexCell does not appear in the toolbox. I was able to copy a flexgrid ...Show All

• Visual C++ Try This Code In VS2005

  Here is a very problem i came through while writing a very simple program in VS2005 Professional Edition. Try the following code: #include<iostream> using std::cout; int main(); { int i=0; cout<<(i+1)<<" "<<i++; return 0; } The expected output is:1 0 However,the output comes out to be: 2 0. When i tried the same code on dev-cpp compiler the output is as expected i.e 1 0. I think the above code is not compiler dependent .So why is this problem with VS2005 compiler Kindly provide a solution to this problem and try to give maximum details. lali.b2   lali.b wrote:        cout<<(i+1)<<"   "<<i+ ...Show All

• SQL Server How to get sql server name with a vb-script?

  Is there anyone who knows how to get sql server name using a vb-script I have tryed this: bKey = WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL") But it cant open it for read. Someone who knows a better way Regards SW-engineer I am not looking for the machine name! I am looking for the name of the sql-server (mssqlserver or sqlexpress) I need the name when my script creating a database. What is the "SSIS system varaiable MachineName " How work this script in vb.net versus usual vb-script Imports Microsoft.SqlServer.Management.Smo Dim dt As DataTable dt = SmoApplication.EnumAvailableSql ...Show All

• Visual Studio Team System Setting up users

  Hello, I am trying to set up our user accounts and everything is going well. I am however running into a problem because we need to do the following: When a bug is created, or fixed we usually assign it a department instead of a specific person (i.e. QA, Applications, etc) Is there any way to add a team like that to the user's list (I know I could just create a user called the same name as the team I want), or does anyone have a better way of assigning cases You can achieve that by modifying the Task work item type definition (you can export it using witexport.exe). Here you can specify users/groups/values you want to see in the list: <FIELD refname="System.AssignedTo" name="Assigned T ...Show All

• Visual Basic Which set of code is more efficient?

  Hi, I'm trying to optimize my code for a VB.NET/Microsoft Access Project and I'm wondering if someone could confirm for me which snippet of code is more efficient. Both snippets successfully do the same thing. Stored Procedures would probably be better if I was using SQL, but I don't think I can really use those in Access (although I could create a query, but would that be better ) A) counter4 = 0 For counter1 = 0 To DsPredicted.Predicted.Count If cboPredictedBloomName.Text = DsPredicted.Predicted.Item(counter1).BloomID And cboActualStartDate.Text = DsPredicted.Predicted.Item(counter1).StartDate Then strgotme(counter4) = DsPredicted.Predicted.Item(counter1).Location End If Next B) 'Connectio ...Show All

• Visual Basic Regarding object Application

  Dear folks, This topic is related with VB6. According MSDN method logEvent of the object application writes to NT Event Viewer. So that I wonder what happen when you are doing the same against XP Pro Sp2 I am not be able to all to see there. Thanks in advance and best regards, T hese forums are for VB.NET and there are better places to find answers for older versions of VB. Maybe the VB6 newgroups - http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vb.general.discussion&lang=en&cr=US Or perhaps the VB6 resource center http://msdn.microsoft.com/vbrun/ or perhaps www.vbcity.com may be useful places to search for answers on VB6 related questions. ...Show All

• Microsoft ISV Community Center Forums When sending a worksheet to the USB port …

  Hey, When sending a worksheet to the USB port … (memory stick). How do I detect if the memory device is not in the USB port …. and how do I handle the error if its not there Best Regards Cathrine Hi The USB will be a removeable drive (drivetype =1), beware if you have a floppy drive this is also type 1. The below modified help text example lists the removeable drives. If A: is your only other removeable drive any, other drive letter that shows up will be your USB. Sub ShowDriveList() Dim fs, d, dc, s, n Set fs = CreateObject("Scripting.FileSystemObject") Set dc = fs.Drives For Each d In dc If d.drivetype = 1 Then ...Show All

• Visual Basic Lines in the body of an email

  I am trying to do what I thought would be simple (especialloy since it worked like a charm in VB 6 with the mapi control: The program populates a multi-line text box with information based on user selections The user hits a button and it pulls up his email client with the subject and body filled in so that he can select a recepient and send off the information. The problem. The text always comes out as a single line run together How can I get line breaks back into the body The code that doesn't work is: Dim sendthis As String = "" sendthis = sendthis & "mailto:" sendthis = sendthis & "&subject=New Loss for client " & frmMain.Clt & " Number: " & ...Show All

• Visual Studio Image or picture in crystal report vb.net

  I have a vb.net program that can be used to browse picture or image and then save the path of that particular picture or image file into database. But the problem that i have encountered is that when i try to load the crystal report in vb.net, i cannot load the image or picture file as well according to the path saved in the database. Is there any way to load any image or picture file according to the path that i have been set into crystal report in vb.net For e.g. i saved the path of a picture or image file into database (C:\test.jpg), now i am going to load the crystal report and the picture or image file will also be loaded as well accrording the above path (C:\test.jpg). This is way that i want it to be, is there any way to do so ...Show All

• Visual C# C# Creating a derived class from a base class.

  I creating a source code generator that code generates the entire data tier and business tier for any SQL Server database (For each table I create a stored procedure, the data object, the business object, the data object reader and writer, etc.). The business objects are inherited from the data objects as shown: public class AddressBusinessObject : AddressDataObject The way the generator works is it creates the data object every time, but it only creates the business object if it has not been created, thus you may customize the business object and any changes to the data object (new fields) can be re-code generated without affecting the customizations to the business object. All of the private variables and properties for th ...Show All

• SQL Server Need ID after OLEDB command (insert)

  Hi, I'm stuck on the following thing: After a slowly changing dimension task I replaced the OLE DB Destination task by an OLE DB Command and created the insert manually. This because I need to work further on the dataset. So I do a union all between the output of the two OLE DB Commands (insert and update). Untill here no problem. But than, because I need an ID further on, I do a lookup in the table in which I just inserted and updated my data for the right ID's. When I run this project I get the error message " row yielded no match during lookup ". I don't understand this beacause I just inserted the data and I've checked, it's there. I could resolve this by splitting up in two control flows (reselect all the needed d ...Show All

• Gadgets Sidebar gadgets outside the sidebar?

  Hi guys, I'm interested on building some gadgets and I'd like to know a couple of info about this specific type. 1) Can they exist outside the sidebar In this case, can they know their position in the stage 2) Can they communicate to each other I had a look to the API and I couldn't find so much information about these topics. Any info will be very appreciated. Thanks, chr gabon wrote: Well, this could work only partially, the problem is to make a gadget reacting based on an event in another gadget. And of course reading a file every 100 m/s to check changes is not an option, and I don't think you integrated listeners to trigger eventual modification to a file without a contin ...Show All