OkiMike's Q&A profile
SQL Server "Replication" between two servers which do not have connection at all
Hello, Heros of The Programming World! How it is possible to perform "replication" between two databases using technological means of MS SQL Server 2005 if two servers do not have a connection at all. The only thing is possible - is transfer of data for the replication on a CD. What is the best way to do it if central database has a hundreds of such "subscribers" I'm not quite sure I understood why I need to manipulate with master database... As far as I understood from the book about a replication, I need to use schema with one publisher, one distributor and several subscribers. Some of subscribers wil ...Show All
Visual Studio Team System False positive CA1004:GenericMethodsShouldProvideTypeParameter
The following code produces CA1004: public class Class1 { public static void PopulateList<TAccessor>( Collection <TAccessor> list) { } } Alex, This is a known bug and has been fixed in the latest internal build of Visual Studio and FxCop 1.35 Beta 1. Thanks David ...Show All
Software Development for Windows Vista Problem when install Vista 5308 under WinXP
I am running WinXP and want to install Vista 5308 in another partition to make a dual-boot. I have 4 IDE harddisks, IDE0:0 C(20G) D(120G) IDE0:1 E(60G) IDE1:0 F(20G) G(120G) IDE1:1 H(40G) All are primary partitions, all are NTFS partitions. WinXP I running is in C:, and I want to install Vista in F:. When I came to the screen to choose a partition to install, the "next" button is active when I click on C:/D:/E:/H: partitions, but grey if I chose F: or G:. And a message on the bottom of dialog said:"Please reboot your computer and verify that the disk is enabled in your computer's BIOS". Anybody can tell me why and how to ...Show All
Visual Studio Express Editions Order Tables Ascending in DataSet
Hey there, I have a problem cause I don't know how to order tables ascending within a dataset, so I need to know how can I do that, I have for example these tablenames within a dataset in this order: "0050Colors" "0021Cars" "0120Symbols" "1008Field" "0215Country" that's the order in what the tables are added into the dataset, and I need them in the next order: "0021Cars" "0050Colors" "0120Symbols" "0215Country" "1008Field" So what would be the code, to order the tables in that way, please help, thanks!!!. ...Show All
Visual Basic Deleting all records in access
Hello All, I am working on a project for a former neighbor. I originally wanted to build a program for him to distribute. He is doing a Geneology research. I wanted to create a database with the family name but realized I could not. So, I want to be able to let him put in the data, export it to text or HTML, then delete ALL the records and start the next family. I have seen many examples but cannot get them to work on VB 2005 Express. Here is the code I have been messing with: Dim db as Database dim strSQL as String strSQL="Delete * from Husband" conn.execute strSQL The Dim db and the conn says they are not defin ...Show All
Visual Basic It's slow!!!
Hello After I turn on my computer and when I launch first program (which programed by VB2005), it's take a long time to show main form. VB6 was faster. CPU speed: 2600 MHz Memory: 1024 MB Is there a solution for that Thanks & Regards What do you mean by 'long time' It's possible that, even though windows appears to have finished booting up, it hasn't - it's still loading and starting various services (e.g.SQLServer). Additionally, it may be that the .NET framework needs to load prior to your application loading. Did you try using a splash screen to see if t ...Show All
Visual Studio Express Editions Registration is somewhat confusing
I think I registered successfully but I haven't received a key, only a thank-you email. Does anyone understand exactly what is supposed to happen when registering Thanks. i'm having the same problem and i need to sort the key out as using the package for my studies just received 5 thank you emails and no product keys at all can anyone from microsoft shed any light on this issue ...Show All
Visual C# Multiprocessor builds
I'm looking into buying new machines for my developers and was looking at the new dual core processors from Intel as an option to get faster compiles as compared to a "normal" single core processor. So my question is, does the C# compiler in VisualStudio 2005 take advantage of the dual execution cores or would I just be better off with a faster clocked P4 Thanks in advance for any info. Tom. There is nothing wrong with buying a 64-bit processor, such as the Athlon x64. They run 32-bit code as well as 64-bit. The output of a compiler is dependent on the compiler, not the processor it is run o ...Show All
SQL Server Report Parameter error
Hi , This is vishal vidhale. when i pass parameter in reporting services that time it gives me an error "Foward dependancies are not allowed". How can i overcome this error. Any one who know or having knowledge of SQL reporting services can help me.. Thanks...................... Hi Vishal. May be your parameter(child) is depending on another parameter(Parent) in the Report and that parameter(parent) is declared later this parameter(child). so, if this is the situation, in the parameters form(Report->Parameters) move your paramter(child) to below the parent parameter and check it out. ...Show All
Visual Studio Connecting Crystal Report 4 and MS-Access 2000 Database File
Dear Guys, I am a new programmer. I have develope a simple database application. My database is of MS-Access 2000 File format. I used ADO Connection for data connection. My application runs fine. Now I want to show reports to the users. So for reporting I was suggested to use Crystal Report. I also bought Crystal Report 9.0 but I find it some what uneasy 2 me. I searched many sites for working with it. Later I found some code posting for CR4. I used CR4 to connect and report the MS-Access 97 Files using DAO connection. Now when I use same stuff for my new MS-Access 2000 file format it generates error. So I would like to kn ...Show All
.NET Development Thoughts, Opinions, and Experiences of the Enterprise Library under .NET 2.0?
Anyone willing to share their thoughts, opinions, and experience (positive, negative or otherwise) on the Enterprise Library for the .NET Framework 2.0 Is it heading in the wrong direction Are there better things out there Is it still worth using when .NET 2.0 replaces some of the old functionality in the Enterprise Library 1.0 Are there other alternatives Any comments would be appreciated. Thanks. ...Show All
SQL Server Which system tables hold SSIS pkg information
Hello Everyone, I need to know which system tables hold the pkg information when you import a pkg into SQL Server 2005. Thanks Shabnam The SSIS Packages are stored in MSDB..SysDTSPackages90 table. Thanks, Loonysan http://mystutter.blogspot.com/ ...Show All
Visual Basic Very slow speed on displaying controls in a form
How to improve the display performance on dynamics create controls on form load event The following code is very slow. Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Me .Location = New Point(0, 300) Me .Size = New Size(800, 300) Me .Refresh() Dim but As Button Dim x As Integer Dim y As Integer Dim bHeight As Integer Dim bWidth As Integer bHeight = 48 bWidth = 48 Me .SuspendLayout() For y = 0 To 4 For x = 0 To 14 but = New Button but.Location = New Poin ...Show All
Windows Forms Control Box
Hi Stefano, Thanks for the trick about backGround image I will try to use this trick in my work. I have a question: How can I disable only the C loseBox of a ControlBox of windows form and keep the MinimizeBox and MaximizeBox enabled Previously thanks. Here is the code that will help you achievw what you want to do- public class FormCloseButtonDisabler { private const int MF_BYPOSITION = 0x400; private const int MF_REMOVE = 0x1000; private const int MF_DISABLED = 0x2; [ DllImport ( "user32.dll" , EntryPoint = "DrawMenuBar" )] static extern Int32 DrawMenuBar( Int32 ...Show All
Visual Studio Express Editions Cannot register Visual Web Dev Express 2005
I have the same problem as others have posted. When I click on either of the *register* links from within the app, nothing happens. When I try to go to the site directly (browse there from the Visual Studio/Express pages) I can never find a link that says "click here to register". Please help. To Whom It May Concern, I installed the VWD 2005 Express Edition Betta 2, used it couple times without register. Now i pass 30 days and want to use it again. It asks for register. I tried to register by clicking on "Register now" link at the startup page but the browser showed "The page cannot be displ ...Show All
