C#

FirstPrevNext

Test connection failed on a password protected Access database sebastud20-Oct-05 12:57 sebastud 20-Oct-05 12:57  Hello, I created a database in Access and then protected it (Tools->Securityy->Set Database Password). After that, I created a new WinForm C# application and in the designer I dragged an OleDbConnection to the form, set the connection string to use the previously created database and to use the password (I used Jet 4.0 OleDbProvider). All well, but when I hit "Test Connection" I receive this: "Test connection failed because of an error in intializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user." Access is closed...no one is using the file. Any help is appreciated. Thanks Re: Test connection failed on a password protected Access database sebastud20-Oct-05 23:34 sebastud 20-Oct-05 23:34  Me again...I forgot to mention that I can connect to the database from source code with this connection string: ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+AppPath+"; Jet OLEDB:Database Password=abc"; Is this a bug in .NET IDE? Regards Re: Test connection failed on a password protected Access database mav.northwind21-Oct-05 3:26 mav.northwind 21-Oct-05 3:26  Hi! What's the value of AppPath? This should be the full path to the mdb-file, but if it's really only your application's path that'll be a problem... Regards, mav Re: Test connection failed on a password protected Access database sebastud21-Oct-05 7:14 sebastud 21-Oct-05 7:14  Hi, Yes, it is the full path to .mdb file. I dont have any problems connecting to the database from source code (this works OK)...the problem is I can't do it from the designer (when you set the properties of the connection string of a OleDbConnection and when you press the "Test Connection" button). Thanks GUI using C# celllllllll20-Oct-05 12:48 celllllllll 20-Oct-05 12:48  Hi all, I was wondering if anyone could help me out in writing a gui in C#. I just want to pop up a "Hello world" with a button and when I click on that button, there should come another pop up window "You are welcome to Csharp". PLease help. I appreciate that. Thanks Preeti9 Re: GUI using C# Christian Graus20-Oct-05 12:51 Christian Graus 20-Oct-05 12:51  MessageBox.Show("Hello world"); MessageBox.Show("Welcome to C#"); Of course, you need to import the System.Windows dll and be using System.Windows.Forms. Christian Graus - Microsoft MVP - C++ Re: GUI using C# celllllllll20-Oct-05 12:55 celllllllll 20-Oct-05 12:55  Many Many Thanks, I really appreciate that. So, its the same syntax that we use in C++. Thanks Preeti9 Re: GUI using C# Christian Graus20-Oct-05 12:56 Christian Graus 20-Oct-05 12:56  No, in C++, they are global API calls, MessageBox or AfxMessageBox. Here, there is nothing global, so everything that would be global is now a static method on a class. MessageBox is a class, and it has one static method, called Show. But yeah, the net result is the same Christian Graus - Microsoft MVP - C++ Re: GUI using C# celllllllll20-Oct-05 12:58 celllllllll 20-Oct-05 12:58  ok....I got it.Thanks So, we don't declare anything globally but we use a static method on a class.... Thanks again Preeti9 Re: GUI using C# Christian Graus20-Oct-05 13:09 Christian Graus 20-Oct-05 13:09  Preeti9 wrote: So, we don't declare anything globally but we use a static method on a class.... Yes, we CAN'T declare true globals, because C++ allows OO, C# enforces it. So, a static member is the obvious way around that. Christian Graus - Microsoft MVP - C++ Re: GUI using C# celllllllll20-Oct-05 13:11 celllllllll 20-Oct-05 13:11  Thanks..Appreciate your help Preeti9 How can I get the Ip address list that a dhcp server leased using C#? Member 162442720-Oct-05 12:07 Member 1624427 20-Oct-05 12:07  Hi , Any reply is appriated. Thanks. web browser plug in ? Christian Graus20-Oct-05 12:05 Christian Graus 20-Oct-05 12:05  I have been offered a job writing an image viewer for a web app. Now, I'm not sure yet, but I suspect they will want to be able to click a link in their web app, and have an image viewer come up on the client. Can I do this in C# ( set it up so that when I click a link, my app gets installed if need be, and then run using the image from the web, even though it's not associated with this image type ) ? Christian Graus - Microsoft MVP - C++ Lorge volume ...Can .NET Handle ? dvsr20-Oct-05 11:47 dvsr 20-Oct-05 11:47  Hi, I am writting an application in C#.NET.This application will run daily once. The application has to fetch the data from DB2. The volume may be 15 million records(each record will be having 120 fields). I will be processing that data and the resultent data will be sent to DB2(diff table). Will ".Net"(dataset) can handle that much volume of data? Suppose the data is in some flat file(in some machine) is file handling functions are best way to use. Please Suggest the best possible solution. -- modified at 18:02 Thursday 20th October, 2005 Re: on .net Christian Graus20-Oct-05 12:02 Christian Graus 20-Oct-05 12:02  The best possible solution, assuming you catch batch the data, is to use the ADO.NET stuff that's designed to talk to databases. Flat files on the machine are a terrible idea. If it was me, I'd write the code to create a similar dataset, and stuff it with 20 million dummy records, to see what it does. However, if it was me, I'd never grab that many records anyhow, I'd make all operations on the data happen in the database, and my app would never retrieve more data than it needed to display on one page. Christian Graus - Microsoft MVP - C++ Re: on .net dvsr20-Oct-05 12:10 dvsr 20-Oct-05 12:10  HI Christian Graus, Thanks for the info, Here I had to get all that data. I am not displaying any data in my application(just for testing i am using datagrids)..I just have to process it and put the resultent data in DB2. Thanks and Regards, Subbu Re: on .net Christian Graus20-Oct-05 15:14 Christian Graus 20-Oct-05 15:14  Why do you need to process it all at once ? What's the process, that you can't do it within the database ? Christian Graus - Microsoft MVP - C++ Re: Lorge volume ...Can .NET Handle ? A.A.20-Oct-05 15:07 A.A. 20-Oct-05 15:07  dvsr wrote: Please Suggest the best possible solution. 15 million records might be a lot of records to process at once, its hard to tell without seeing the overall picture(there might be other compelling solutions). Even before looking for specific tech to use, see if you can do the processing in piecemeal and save the result and use it to work with the next batch. Though I think the previous suggestion of doing the processing on the DB side might be an issue if other apps are using it at the same time. Quran Translation Intro Discover Re: Lorge volume ...Can .NET Handle ? Dave Kreskowiak20-Oct-05 22:43 Dave Kreskowiak 20-Oct-05 22:43  It's best to leave the processing in the database itself. Retrieving/Sending 30M records (you have to put them back ater the processing, correct?) will (usually) needlessly beat the crap out of the network your SQL server is attached to. Part of the job of a developer is to evaluate your processes and code and consider their impact on the resources around them. What is this servers SQL load? What about it's NIC? What is the impact of adding 30M transactions to those loads? (I mean either from your processing application or from doing it inside the SQL database!) Will your retrieval, processing, and upload spike the use of these resources so bad that normal traffic is negatively impacted? How long will this processing take using each method? ...?, ...?, ...?, ...? The .NET Framework dataset object can handle as much data as you can fit in memory. Millions of records is not out of the question. The real question is if it's practical. Only you can say. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Lorge volume ...Can .NET Handle ? dvsr21-Oct-05 3:34 dvsr 21-Oct-05 3:34  HI Dave, Thanks for ur suggesition. My Applications is something related to Airlines business. We expect atleast 15M records per day .... We r doing some statistical analysis on that data and the resultent set will be very small which we r going to send back to DB2. BTW ..we r using DB2. ANyway I can rise the issues and discuss this suggesitions in my team meeting. Thanks alot. Subbu Re: Lorge volume ...Can .NET Handle ? Guffa21-Oct-05 3:16 Guffa 21-Oct-05 3:16  How much data is it? If each field contain an average of 10 bytes, it comes to about 16 GB. Plus some overhead. I doubt that you have a machine with that amount of RAM... Do you really need all the data at once in memory to process it? If you need all the data at once, you probably have to copy the data into a temporary table, process it there, then read the result from it. --- b { font-weight: normal; } Default parameters in C# method Yanshof20-Oct-05 11:04 Yanshof 20-Oct-05 11:04  Hi All I want write some method in c# with default parameters. I try to do it like i did in C++ but the compiler does not let me. How can i do it ? Thanks . Re: Default parameters in C# method Christian Graus20-Oct-05 12:03 Christian Graus 20-Oct-05 12:03  Nope, VB.NET has this, and C# doesn't. Funny enough, I raised this at the MVP summit to the guys who design the language, and didn't get a flood of support. The only way to do this is to write two methods, one that takes the extra parameter and one that does not. Make sure they both call the same underlying function. Christian Graus - Microsoft MVP - C++ Re: Default parameters in C# method Yanshof20-Oct-05 12:07 Yanshof 20-Oct-05 12:07  Do it with overload method is not smart way. The default parameters is the best way to do it. Re: Default parameters in C# method Christian Graus20-Oct-05 12:10 Christian Graus 20-Oct-05 12:10  yanshof wrote: The default parameters is the best way to do it. I agree - if C# supported default parameters, it would indeed be the best way to do it. Christian Graus - Microsoft MVP - C++

Last Visit: 31-Dec-99 18:00     Last Update: 11-Jun-24 3:05 Refresh ᐊ Prev1...12191121921219312194121951219612197121981219912200 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.