leclerc9's Q&A profile

• SQL Server Looking for suggestion of how to manage a DB file when it getting too big.

  Hi all, At our facility, we have a > 350 gigs database and the DB is breaking into 2 files. One file is our Image table with the size of 300 gigs. The other file contains all of the other tables. The image file is getting bigger and bigger everyday, I am worry that eventually when a data file getting too big it could lead into problem. - DB fragmentatio, hard to manage etc My question is anyone has run into this problem, and how do you solve it I am open for any suggestion. BTW: I am using SQL 2000. Thanks in advance. Thanks all for your suggestions. The main problem we are having is we have one huge table (300 gigs) reside in one file group and spliting a table across multiple files is not an option for us since we ...Show All

• Windows Forms Autocomplete: Same two names, different objects

  I'm currently using AutoComplete on a combobox in my project. The combobox is bound to a list of Employee objects, and displays the employee's full name (last name, firstname). Everything works great, except when I encountered two employees with the same name. AutoComplete displayed only one instance of the name and would only allow me to select the first instance of the name (Employee object) on the bindingsource. No matter how hard I tried I can not select the second employee object with the same name. I've tried to use the dropdown list of the combobox to manually select the 2nd employee object, but Autocomplete overrules my selection and returns me to the first object. Is there anyway I can get AutoComplete to allow me to select the s ...Show All

• Visual Basic my first DLL: Class is visible but not Functions

  I'm learning how to write a DLL in VB Express 2005. It compiles fine: Public Class Common Public Function FourTimes( ByVal x As Long ) As Long FourTimes = x * 4 End Function Public Sub SayHello() MsgBox( "Hello from Pearl4.dll" ) End Sub End Class Then I create a TLB library file, which also appears to work fine: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm.exe C:\Windows\System32\Pearl4.dll /tlb I want to access the functions in VBA, so in Access I added a Reference to the TLB, and now I can see the class named Common, but neither of the two procedures. How do I make them visible Thanks for your help. Henry You'll need to either c ...Show All

• Software Development for Windows Vista Windows Vista Network Crash Under Heavy Load

  I am currently using build 5744 When i have a large amount of network trafic such as torrents or when i am on a windows XP pro system and i try to copy relatively large files from the vista machine it seems that the nforce network controler shuts down i dont get past the default gateway. the only way to fix it is by rebooting....but it keeps hapening. any help would realy be nice! thanks, Tom Hello Tom, This seems like a third party driver issue, I would get in contact with NVIDIA regarding the issue you are experiencing. Also, you might want to try posting this question into the Windows Vista Beta Networking forums at http://forums.microsoft.com/TechNet/ShowForum.aspx ForumID=716&SiteID=17 as this forum is geared mor ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. other operating systems?

  will XNA ever be available for linux, mac, or other c'mon at least mac! Microsoft hasn't said anything about it by now but historically, DirectX has never been deployed for any other OS than Windows. Now DirectX will be accessible also for XBOX 360 through XNA but I don't have any hope to have DirectX for Mac, Linux or solaris. However very recently Microsoft signed a contract with Novell (the developer of Suse Linux, Mono technologies, Openoffice and others) in which for a period of five years both are to work together. The reason is that like you or me, developers want Xplatform solutions and that means developing a program once and being able to run it in all systems. Mono has long been the alternative ...Show All

• Visual Studio Express Editions I would like to make a dynamic memory seach engine for my database

  I would like to make an application that is a dynamic search engine for my database the textbox must be dynamic and have a search engine that invokes the list of words inside a listbox one letter at a time, without pressing an [event action (a button)] so for instance. I type 'a', and I get a list of all the words in the listbox beginning with 'a' inside my database, then I type another letter 'an', and I get a list of all the words in the listbox begining with 'an', Then I type 'ang' and I get the list of words inside the listbox beginning with 'ang'.......until I have typed 'angiospermae' and a matching word appears inside a listbox of words... The point is that the seach engine is dynamic because it finds each matching characte ...Show All

• SQL Server Same DB, Different Performance on Different Servers

  Hi, We are doing response time testing on our application with SQL Server 2000 SP4. But it is found that a query have different performance on the same DB (restore from the same backup) in different servers. The execution plans are different on the 2 servers. Server A: the execution plan use parallelism with varying response time (from 3 sec to 64 sec). Server B: it is a single thread execution plan with faster response time (about 1 sec). Here is the server configuration: Server A Dell 750, you can access Dell homepage for more detail. CPU – P4 2.8 GHz CPU Memory – 2G Disk – RAID 1 SCSI OS – Windows 2003 Enterprise Edition SP1 Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18: ...Show All

• .NET Development MD5CryptoServiceProvider behavior changed on Vista?

  This is my code to protect my password : private static string EncryptPassword(string password) { if (password != null && password.Length > 0) { MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider(); byte[] bytes = md5.ComputeHash(Encoding.UTF8.GetBytes(password)); return Encoding.UTF8.GetString(bytes); } return string.Empty; } On Windows XP and Windows 2003, the password has been encrypted and saved in database. However, when the program runs on Vista, and read the password from database, the password compare failed. This means the behavior of the MD5CryptoServiceProvider changed Thanks! You are making an invalid assumption that all byte arrays are valid UTF-8 strings: return Enc ...Show All

• Windows Forms How to share an object instance through all forms just like vs6.0's global variables?

  Now I am doing a c#.net 2005 database project.At the begining, I want to design a login form and after user successfully logon, I will store its account and something else such as Sales Month selected. But I found that c# is purely object oriented language and there is no gloabl varialbe. I wonder how to do this. I have been used to web design and this is my first real winform project(Before only some simple projects). So there are many questions during my design. Another problems: After I new a child window in its Mdi parent, I want to transfer some information to the child, how can I do Now I am trying to define some members and methods to manipulate them in the child form, and so I can invoke the mothods to transf ...Show All

• SQL Server Inserting existing Data from one Server to another Server FOR MS-SQL Server

  hi guys! i have this task to do, well lets say i have a DB in a Server lets say Server1 and i want to copy or insert this data to the Server2. Is there any easy way to do this copying the Keys automaticly What is the best way to copy the data Thanks a lot. novelle hi there! well the problem is i dont need all the data in that Database only some of it and i dont want it all on the second server, copying and deleting the data that i dont need in the server2 will take a long time, im speaking here in a very huge amount of data so i think its not the best way to do that... what i want to do is copy the tables from the database in server1 to server2 and then make a insert statement to server2 bu ...Show All

• Visual C++ linking error LNK2019

  hi all i want to use windows services API in project.i had written generic class for this purpose.i had included winsvc.h and lib Advapi32.lib throgh pragma statement like #pragma comment(lib,"Advapi32.lib") but when i build the project errors,where that is the function of that class that i m calling for windows service. error LNK2019: unresolved external symbol __imp__CloseServiceHandle@4 referenced in function "public: __thiscall CWindowsService::~CWindowsService(void)" ( 1CWindowsService@@QAE@XZ) the class to which this function belongs is the generic class.and code used to make the object of this class is CWindowsService o_obj; o_obj.Test(); When you use #pragma comment(linker) or #pragma comment(lib) you get ...Show All

• Visual Studio Express Editions How can I know when someone push the SCAN button on the scanner?

  Hi, I have a scanner with SCAN button . How can I know when someone push the SCAN button on the scanner P.S I have Lexmark scanner and when you push the scan button on the scanner  it scan the picture and create file. Regards, Yaniv You would have to talk to the scanner manufacturers interface (driver). They may have an API (Application Programming Interface), but I would doubt there's a publicly available API. This would be the only way to 'talk' to the hardware. ...Show All

• Visual Studio 2008 (Pre-release) KevinButton Source

  Does anyone know where the source code for the KevinButton demo can be found I was hoping to use it for a demo. -- Bryant Sorry for the delay: http://blogs.msdn.com/okoboji/archive/2006/09/20/764019.aspx ...Show All

• SQL Server Read CSV file - Save Columns into Rows

  I want to import CSV file and convert columns into rows depending on Customer count(2nd record in each row of CSV file) and save to SQL table --CSV file format State, Customer_Count, Name_1, Total_1,Name_2, Total_2,Name_3, Total_3..can go upto 600 GA,2,'John Doe',14.00,'Roger Smith',15.00 FL,3,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00 SC,5,'John Doe',14.00,'Roger Smith',15.00,'Sally Cox',16.00,'James Brown',17.00,'Rick Davis',18.00 Data in SQL table from csv file should look like this State,Name,Total GA,John Doe,14.00 GA,Roger Smith,15.00 FL,John Doe,14.00, FL,Roger Smith,15.00 FL,Sally Cox,16.00 I have multiple CSV files with millions of records. How can i achieve this using Integration Services or Bulk Data ...Show All

• Software Development for Windows Vista Trap last browsed URL

  I would like to be able to create something in Vista that "listens" for when a page is opened in IE (I would liek it to listen for any browser..but just IE will be fine).. Does anybody know where I should look for documentation on how to accomplish this Thanks! Looks good, except that it doesn't work when built under Visual Studio 2005. I couldn't get it to recognize a single thing that my Internet Explorer browser did. Is there anything else available that might work ...Show All