RDO Connection through VB

Hi,

I am using VB to connect to the database and I am using RDO (Remote Data Objects) for this connectivity.

For security reasons, I am using the userid and password retrieved from a different database to establish the connection to the production server. The password we retrieve is encrypted and the connection program decrypts that and connects.

All is fine so far. But after I connect to the database, in the VB project, in the debug mode, I can see the connection string by accessing the property RdoConnection.Connect.

Is there a way, by which, I could establish the rdoconnection and immediately after that, change the 'Connect' property of that to something else, so that it does not have the actual connection information?

Thanks in advance
RajI don't think so. When you change the connect property, I think you will lose the connection.

You could make the class that holds the RDO object private so that it is not remotely accessible. You should also make the RDO object private to the class, and provide write-only access to the connection string by creating a Let property with no Get property.

RDA with limited connectivity

Apologies for cross posting but I can't figure where to post. Please
feel free to move my message elsewhere (notify
mat<at>oldhallsoftware<.>com) cheers
I have an ASP.net app that mobile service engineers use to exchange
info with our back office systems thru GPRS. Works great but my
company has a national phone contract and in some areas the
connectivity just isn't up to scratch.
I'm now researching a store and forward solution with Vis Studio 2005.
Have read all the help stuff but have a few questions....
I'll be saving data entered by engineers to a SQL modile db and using
RDA to send data back via existing stored procs.
Any ideas on how i test for connectivity and whether a transaction has
completed with RDA.
Any links to useful resources would be very welcomeI suggest a forum such as
http://msdn.microsoft.com/newsgroup...b&lang=en&cr=US
or the asp or c# version of it.
I have never used RDA as it has many flaws as with all mobile or semi-mobile
comms. I have, though, used merge replication from a PPC to a back ofice
using a sqlce .sdf and gprs. Merge replication automatically checks the
connection before it connects. Also, How do you use this app in dev, do you
check the connection using active sync?
"ohs" wrote:

> Apologies for cross posting but I can't figure where to post. Please
> feel free to move my message elsewhere (notify
> mat<at>oldhallsoftware<.>com) cheers
>
> I have an ASP.net app that mobile service engineers use to exchange
> info with our back office systems thru GPRS. Works great but my
> company has a national phone contract and in some areas the
> connectivity just isn't up to scratch.
> I'm now researching a store and forward solution with Vis Studio 2005.
> Have read all the help stuff but have a few questions....
> I'll be saving data entered by engineers to a SQL modile db and using
> RDA to send data back via existing stored procs.
> Any ideas on how i test for connectivity and whether a transaction has
> completed with RDA.
> Any links to useful resources would be very welcome
>