>>Hi, maybe I am kind of rusty, and I am missing something, here is my situation
>>
>>I have an application for reporting against a MSSQL server database, since the application is multicompany, there are several databases
>>
>>I am building the reports criteria screens so i set some remote views for the user to select the criterias. My problem now is, since i am working on a test environment, How do I change the connection to work with the actual data based on the company
>>
>>I know i can create several dbc and connections ponting to the right databases, that could be asolution, but on the side of security, I do not want to store the user and password with the connection, but if i remove the user and password and create a connection at the beggining of my app it seems not to be working even though i have the RV set as shared connection.
>>
>>any ideas to fix this would be apreciated
>
>That would not address your problem, but if you would be using CursorAdapters then it would not be a problem for you.


Thnks, i have never used cusrsor adapters, could you be so kind and elaborate for me your idea?