|
I have a standalone application written in VB.NET that uses an access DB. The application is portable and used by several users on differnet machines. I want to be able to sync the portable DB's with a master DB. Is Replication the only way? The DB's are password protected at present. I can think of a way using replication with JRO, but that seems a bit old hat now. Please help
|
|
|
|
|
Yes, replication is about the only way your going to accomplish this. You can either use the Replication facilities built into Access or use a 3rd party utility to do it, or come up with your own scheme and code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Is anyone else having problems with logon boxes when trying to show a Crystal report?
We have an application which stores data internally as a set of collections. When we need to print the data on a report, the application loads the data into a set of tables within a dataset, applies the logon information, writes the data to each table, assigns the relevant report to the Crystal report viewer and .Shows the report.
All of this works and has been working for months. Yet a recent deployment on a Win XP Home (SP2) machine invokes the logon box for a single table at the reportviewer.Show statement. I.E. the table has already been logged on to - and data has been written to it. Other tables in the dataset do not suffer the problem.
Other reports suffer the same problem - a single table, not always the same one, requires a logon at .Show time.
And all other machines continue to work OK.
I can see from searches on the net that this logon issue for datatables and Crystal is problematic - so what gives? Is there a known issue here?
Any ideas/info gratefully received ...
|
|
|
|
|
Greetings Alan!
I too have suffered from the dreaded log on window appearing when it is not expected to  . What *sometimes* helped me was to "verify database" to force Crystal to look at the data source again and clear up any issues that may exist. Hope that helps!
Joel Parmer 
|
|
|
|
|
Hi Joel
And thanks for your reply. The problem is, as you say, maddening. I have now reported the issue to Microsoft Support - who seem to agree that I'm not the first to suffer it. Watch this space and I'll report what happens.
I'll try the 'verify database' you mention but I must admit that I'm not exactly sure what you mean. How would I do this?
Many thanks
Alan
|
|
|
|
|
Problem solved. I reported the whole thing to Microsoft Support and, after a lot of trying this and that, it appeared that the merge modules shipped with VS.NET 2003 had problems. Crystal have made available a fixed set of modules available at
http://support.businessobjects.com/fix/merge_modules.asp
Installing these (on the development machine) solved the problem.
|
|
|
|
|
Hi,
I have a program that looks at a folder for a specific type of file and if its there it adds it to a list box. I then have the list box contents output to a text file. Everytime a file is added to the list box its added to the text file. Only problem is that when the file is removed from the folder its removed from the list box and textfile also. I am trying to find out a way to write the contents to the text file but when the files are being removed it will not remove them from the text file. Can anyone help with this
Thanks
|
|
|
|
|
Then change the code that write the data out to the text file to compare the data in the listbox with the data loaded from the text file. If there are delete records in the listbox, just don't delete them from the text file. If there are existing records in both, don't add it again. If there is new data in the listbox, add it. Why is this so hard?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hy everyone!
I do have the following situation
<br />
DIM myint as Integer<br />
DIM myreal1 as VARIANT<br />
DIM myreal2 as VARIANT<br />
<br />
myint = myreal1 / myreal2<br />
VBA in Excel does the following:
If myreal1/myreal2 < xx.5 then round to next LOWER integer
if myreal1/myreal2 >= xx.5 then round to next HIGHER integer
But I do want the result to be round to next LOWER integer EVERYTIME!
meaning 0,95 should be 0 and 0,45 aswell
In C there is a function name floor() which does this, but I could not find a similar function in VBA. If anyone knows the relevant function in VBA please let me know.
Thanks!
Stephan.
|
|
|
|
|
I just found out myself.
it's the int() function in VBA
Stephan.
|
|
|
|
|
Public Function Ceiling(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double
' X is the value you want to round
' is the multiple to which you want to round
Ceiling = (Int(X / Factor) - (X / Factor - Int(X / Factor) > 0)) * Factor
End Function
Public Function Floor(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double
' X is the value you want to round
' is the multiple to which you want to round
Floor = Int(X / Factor) * Factor
End Function
|
|
|
|
|
Hello there,
I'm having problems reading a DLL Version number. I used the System.Reflection in order to load the assembly, and then read the version number. No problem, it works fine! But since we cannot unload, the dll is locked untile my app shuts down. My app is a WebService, so won't shut down every second  Is there another way to get the version number of a dll/exe, or to unload an assembly so that it's overwritable again?
Thnx
I love it when a plan comes together
|
|
|
|
|
You can check into creating a new AppDomain and loading your .DLL into that. I don't have any example code, because frankly, I've never done it. But, I have seen it discussed in the c# Forum about 6 months ago.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi.. how can i determine the active node on a clustered server on a vb.net project?
each cluster has 2 nodes
for example:
server1a
server1b
server2a
server2b
server3a
server3b
and the active nodes are server1a, server2a, server3b
i'm trying to develop a project that will list just the active nodes .. any idea would be greatly appreciated.
msn: cute_leny@hotmail.com
|
|
|
|
|
Are we talking about a Microsoft cluster, Novell, Linux, ...?
For a Microsoft cluster, the easiest way is to use the Cluster Automation objects. You can start by reading the documentation on them here[^]. Microsoft clusters also don't have an "active" node. Nodes are either up and available or down for some failure or administratively down. You can find out which nodes are "available" and which are "down".
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi there.. thanks for replying... yeah we're using Microsoft Cluster. i'll try that and see what i can do from there..
thanks for the help...really appreciated by a newbie like me..
|
|
|
|
|
Hi there.. I’ve seen the link on the documentation of server cluster API’s from msdn but it seems that it was just applicable for windows server 2003 and codes for C++. We only have windows 2000 advanced server. I’m developing remotely from the servers and I really have no idea how to access and manipulate these APIs using asp/vb.net.. Can you give me an idea how to do this in asp/vb.net? I’m really a newbie with this technology.. hope you can help me.. thanks.. more power..
|
|
|
|
|
The API calls work on any Windows Server 2003, Windows 2000 Datacenter or Advanced Servers, or NT4 Enterprise SP# or better. I think your looking at the WMI objects. Those are Windows Server 2003 only.
You can call the cluster API's from VB.NET just as you can call any of the Win32 API functions. There is very little information on using the Cluster API's in VB/VB.NET, so it's definately going to be a research project, trial-and-error kind of thing. There is no known example code either.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
yeah.. i've also done some research and so far i have not seen any codes/project like this before..got really no idea how to do this and i'm stuck with this project for 2 months now..
anyway, thanks a lot for your time  and goodluck to me..
|
|
|
|
|
Hi guys, can anyone help me to get Active Window, I want its properties like Height x Width and its position. like Corel Capture. can anyone help me for this
Heeren
hiren_Sb@yahoo.com
|
|
|
|
|
You can call the Win32 API function GetForegroundWindow[^] to get that windows handle. You can then pass that handle and the appropriate structures to the GetWindowRect Function[^] or the GetWindowInfo Function[^] to get the information you want.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank ya Dave, I'll try this Win32 api functions. And can you tell me is there any other functions in .Net to do is instead of using Win32 Apis.
Thank ya again
Heeren Bhanushali
hiren_sb@yahoo.com
|
|
|
|
|
No there isn't. The .NET Framework BCL doesn't wrap the entire Win32 API.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank ya.. Dave, Thanx for your reply.. Well, can we chat .. or may i have your email ID
Heeren Bhanushali
heeren@fissionvector.com
|
|
|
|
|
Nope. I only chat with people here at CodeProject. I do this in my spare time, which is rare nowadays.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
