Database connections

[Guest_imported]

Please Help!
I have a report that connects to a SQL Server. Until today all has worked fine. This morning it stopped. I have found out that the SQL Server password has since changed. How can I change the password my report is using to log onto the server, instead of prompting the user?

Thx

 

[SteveFairclough]

You may need to change it in the ODBC Connection on the user's machine rather than the Crystal Report Design. Steve Fairclough
I.T. Manager

 

[Hattusas]

Well I suggest just the reverse.If I were you, as a first step I'd selct "verify database" option and type the appropriate username and password there.

 

[Guest_imported]

Thanks for the responses....

I have verified the database and although it does prompt me for the password, after saving it back on my web server, my users are still prompted for database userid and password...

Is there something I can place in my ASP that will log onto the database server first then call ther report? Or can I redirect to the rpt file with parameters attached to the end of the call?

Thanks in advance...

 

[Guest_imported]

Further to the above I amn using a direct MS SQL DLL and not via the odbc settings...

 

[Hattusas]

Mail your reports to my e-mail if you like.I will try to change into my database.If I succeed I will tell the steps I have made.
Here is my email = openyourmind77@yahoo.com

 

[Hattusas]

Hi again .I managed to change your passwords.I hope those steps I performed will help you.First I must say that I connected your database to IBM DB2 and created a table with the same properties and insert sample data into it.
Level 1 --> Convert database driver...
Level 2 --> It prompted me the user name and password.I typed them.
Level 3 --> Set Location...I chose your table and clicked on "set" and found the table name from my DB2 database and said OK.
Level 4 --> Verify database...
Level 5 --> save and exit...
Level 6 --> That's it.I called your report from Internet explorer succesfully.Without prompting any user info...

Now...Somehow SCR doesn't forget the database info.So I suggest you these levels...
Level1 --> Convert database driver into ODBC...
Level2 --> If password requires.Type in the new password.
Level3 --> Set Location...
At this moment SCR forgets the old password.So return to your SQLServer again )
Level4 --> Save and quit...
Level5 --> Convert database driver into SQLServer...
Level6 --> If password requires.Type in the same password.
Level7 --> Set Location...
Level8 --> Verify database...
Level9 -->Save,exit and restart...
Level10 --> I HOPE IT WORKS! )
If you problems call me again.