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.

Rare behavior

Hi!
My SQL Server has a rare behavior ... some times I can't find database objects like sp's, relations, etc (objects missing). So, I think in scenes:
* security
* virus (like slammer)
* SQLServer becomes "crazy"
Dou you have been in this problem? How did you solve it?
Thanks so much in advance
Note: The SQL server has not installed any service pack. It exists a firewall too.
What does "can't find" mean? Can you show an example, including syntax used
to create objects, syntax used to "find" objects, and what error messages
you receive?
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:B97DD589-BE7E-4BB6-8824-C7FE40399BC0@.microsoft.com...
> Hi!
> My SQL Server has a rare behavior ... some times I can't find database
objects like sp's, relations, etc (objects missing). So, I think in scenes:
> * security
> * virus (like slammer)
> * SQLServer becomes "crazy"
> Dou you have been in this problem? How did you solve it?
> Thanks so much in advance
> Note: The SQL server has not installed any service pack. It exists a
firewall too.
>
|||Sorry! I meant when a check my db I notice disappearance of objects (some relations, sp's etc.). Usually I use SQL Server Entreprise Manager.

Rare behavior

Hi!
My SQL Server has a rare behavior ... some times I can't find database objec
ts like sp's, relations, etc (objects missing). So, I think in scenes:
* security
* virus (like slammer)
* SQLServer becomes "crazy"
Dou you have been in this problem? How did you solve it?
Thanks so much in advance
Note: The SQL server has not installed any service pack. It exists a firewal
l too.What does "can't find" mean? Can you show an example, including syntax used
to create objects, syntax used to "find" objects, and what error messages
you receive?
"Han" <anonymous@.discussions.microsoft.com> wrote in message
news:B97DD589-BE7E-4BB6-8824-C7FE40399BC0@.microsoft.com...
> Hi!
> My SQL Server has a rare behavior ... some times I can't find database
objects like sp's, relations, etc (objects missing). So, I think in scenes:
> * security
> * virus (like slammer)
> * SQLServer becomes "crazy"
> Dou you have been in this problem? How did you solve it?
> Thanks so much in advance
> Note: The SQL server has not installed any service pack. It exists a
firewall too.
>|||Sorry! I meant when a check my db I notice disappearance of objects (some re
lations, sp's etc.). Usually I use SQL Server Entreprise Manager.