ReneeC's Q&A profile

• SQL Server Neither Exist or Not Exist seem to be working... help!

  the follow SQL returns the following error. select companyintid from company where [dbo] . [exist] ( select companyname from companies where companyintid = 'CM00006070' ); ------------------------ERROR--------------- Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'select'. Msg 102, Level 15, State 1, Line 4 Incorrect syntax near ')'. This query probably doesn't make any sense.  If the EXISTS predicate returns true (i.e., there is a row in the 'companies' table with that 'companyintid'), you'll get back every row from the 'company' table.  If it returns false, you'll get back no rows.   I'm betting what you really want ...Show All

• SQL Server Perfomance tuning

  Dear friends We have one problem in our existing system.We are expecting some expert comment on this.We have one corebanking system back end as MS SQL server with IIS server.Our system is always very slow in the peak times of tranasactions.We are planning to optimize this with a short time plan .So pls give some suggestions that our DBA team can implement in a short time with SQL SERVER 2000 Thanks in Advance Filson A possible course of action is this: Try to check your IIS's and SQL's processor during the peak times to see if the problem is with your SQL or IIS If your problem is not in IIS: Try to see if your sql server's processor is 100% or near. If it is, then your queries are probab ...Show All

• SQL Server Scheduling multiple reports at one time

  Hi, I need my reports to run at the 4rth day of every month. I have packs of reports, and typically upto 18 reports in a pack and these packs have to run on the 4rth of every month. How can i schedule the 18 reports to run at the same time. I don't want to schedule a time for every report ,this is very laborious.Is there any option in SSRS for simulataneously scheduling of these reports Thanks Hi, You can achieve this functionality by using a Shared Schedule. In the case the question is if you can assign the schedule to all reports at once, the answer is not by using the web interface, but you can create an script to do so. In the case you're asking to chain the report pr ...Show All

• SQL Server Update query runs very slow in SQL 2005 than SQL 2000

  Earlier I posted this query in SQL Server Database Engine forum. I am reposting it here. We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query and insert query run faster. Query is called from ASP (active server page) page. Changing of fill factor option from 0 to 70 also did not work. I also have set the competible leve to 90. OLD Sever Config: dual xeon 1GHz, 512MB RAM, window 2000, MS SQL 2000 New server Config: Dual Core Xeon with 2 CPU, 10 GB RA ...Show All

• Visual Basic how to implement the "Add new" button

  hi all, I am using the DataBinding to bind a couple of controls on my form to an Access db. i managed to do an update on the modified rows. I just cant program the button that is behind the "add new" button. I am using VS2005 Pro. please download the solution from here and make sure u change the path of the DB to wherever u put it . http://www.wegraphics.com/dotNet/addnew.rar this is the code in case u dont have the IDE ... thanks alot for any help. Public Class Form1 Public WithEvents dt As New DataTable Public WithEvents da As New OleDb.OleDbDataAdapter Public WithEvents conn As New OleDb.OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Se ...Show All

• Visual Studio Express Editions Get Access Point Information

  how can I get MAC address and signal sitrenght of all Access point in network... which method do I have to use.......... I read javawrapi doc but I can't make ..... can you show it in a sample code... I have Javawrapi package JavaWrapi jWrapi = JavaWrapi.getInstance(); // locate a 802.11 device NDISDevice dot11NIC = jWrapi.getDOT11Device(); jWrapi.openNDISDevice( dot11NIC ); // get the dot 11 api DOT11API dot11API = jWrapi.getDOT11API(); // list all Access Points // this line have to get all AP in networks, isn't it Enumeration aps = dot11API.getAPDataVector().elements(); while( aps.hasMoreElements() ) { APData apData = (APData)aps.nextElement();// text1.append( apData.toString() ); // shows information about AP } ...Show All

• Gadgets file is .gadget but IE downloads as .zip

  I have packed my gadget files in a zip file. I then changed the name to *.gadget. The icon changed to a gadget icon and double-clicking it installs it. I then uploaded the file to my webserver and it is there are a gadget file. I then linked to it as a gadget file. When I click that link it downloads a .zip file and asks where to save it rather than downloading as a gadget file and installing. What am i doing wrong What do you mean by "automatic install" When you download a file, you should be given the option to save or run. If you run a .gadget file, it'll run you through a few prompts and then install. It's not possible for you to make a .gadget automatically install with no u ...Show All

• SQL Server SQL EXPRESS TIMEOUT

  The default is sest to 15 seconds that of course is no good because it takes more than that to attact the damm database though is very small. Does any one know how to modify the connection timeout I'd try including it on the Connection String but no luck. it looks like it detaches the database after a period of inactivity. If anyone knows anything about please let me know THANKS You are connecting to a User Instance which is a special type of SQL instance designed for use with single user, local data applications. User Instances are not designed for use with deployed ASP.NET applications. The fact that the VS development tools use this type of connection is not really the fault of SQL Express. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Color based collision detection?

  Sorry if this question is laughable, I'm new to this stuff. Is there any way to do collision detection based on color. For example, a plane sprite intersects a segment of screen that is green and triggers an event independent of vector intersection math. You don't want to try something like that. Every model or sprite you use should have one or more bounds objects that you can use for collision detection. There are some collision comparison operations already built into the xna primitives. BoundingSphere, BoundingBox, Ray, Plane and the others all have the ability to compare against most of the other shapes. "Screen space" is only for rendering and getting mouse input coordinates. All coll ...Show All

• SQL Server sql server on xp??

  hi all.... i am new to sql server 2000....i want to install it locally on my machine...can i set it on windows xp or it must be set on NT windows if i can set it on xp...how can i make the connection success to the server locally(at one machine) Jojo, are you trying to install SQL 2000 or SQL 2005 They have a slightly different OS support matrix and both are available from www.microsoft.com/sql . Thanks, Sam Lester (MSFT) ...Show All

• Visual Studio Several DataSet as the report DataSource runtime problem

  I have Crystal Report document based on several DataSets (DataSets are connected trough their XSD-schema). There are no subreports - only the main report with fields from 3 different DataSets. So at the run time I want to set the DataSource for this report, and I don't know how I can do it. Notice that DataSets are not persisted at the database. I have only DataSet objects. So, do you know how can I set these DataSets as DataSource Thanks. For absolute beginners using designer, this worked for me in VB create blank form create dataset drag datatable onto form to create datagridview (this makes form aware of dataset) delete datagridview and navigation strip drag crystalreportview ...Show All

• Software Development for Windows Vista Can't install windows vista beta RC1 in my PC.

  Hello, I'm spanish and my english don't very good... I'm download windows vista beta RC1 because microsoft send me one mail. I have two images isos of 32 and 64 bit's burned into dvd's but I can't install anyone!!!! While instaling windows vista 32 or 64 bit's generate one error!!! Exactly once I introduce my code licence and the program installation start copy into my hard disk. Please visit this url for see the error: http://keopsito.googlepages.com/DSCN2569.JPG And my PC hang. My PC: Processor: Intel Pentium D 930. Maindboard: Gigabyte GA-8I945P-G-RH Memory: 2x512Mb DDR2 Graphics: Ati Sapphire Radeon x1600Pro 512Mb DDR2 Sound: Sound Blaster Audigy 2. Hard Disk: Raid 0 Maxtor 2x160Gb 7200Rpm. IDE. Actualy works into windows home 32 bit's ...Show All

• Visual Studio Exporting to Word

  Hi, I know that exporting into Word is not supported, but is it possible for me as a Developer to extend the report viewer functionality myself in order to do that I also read that it may be possible to export to Word if using the Report Server. Is that true Our current report is local. Also, does anyone know if a new version of the ReportViewer is planned and the timing of that release Thx. You can export in rtf format which will be displayed in all versions of MS WORD. Currently i dnt have CR installed on my pc but as far as i remember crystal reports allows export to WORD. Try add/remove export options from the Crystal Report Setup CD. ...Show All

• SQL Server naives bayes prediction

  Hi, I am trying to deploy a Naives bayes network.But in spite of I am getting an dependecy network that relates 3 variables, I've got an classification Matrix where all the predicted values are the same. Counts for nai 1 on [Cod Conceito] Predicted Missing (Actual) 0 (Actual) 1 (Actual) 2 (Actual) 3 (Actual) 4 (Actual) 5 (Actual) 6 (Actual) 7 (Actual) 8 (Actual) 9 (Actual) Missing 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 0 57578 2499 11292 102 2374 317 80 271 989 2 0 0 0 0 0 0 0 0 0 0 0 3 0 ...Show All

• Visual Basic Simple login Query Problem

  Howdy all, I'll start off by saying that I am a complete newbie when it comes to VB. I've dabbled in VBA for a many a year and am finally making the switch to VB and VS2005, but I must say that I'm having some issues. The scenario: I have the following elements in a VB project: A form called LOGIN A DataSet called 'DataSet1' that has the following tables: NameTable, ProjectTable, TaskTable The issue: Never really having to work with datasets before, I have a small problem trying to execute a simple query to authenticate a user. Let me explain as simply as i can. On the LOGIN form I have 2 textboxes called LOGIN_TB_Username and LOGIN_TB_Password, also a LinkLabel control that is being used as the 'enter' button. Now a ...Show All