FDSN-returns Server is has not yet been opened.

[olichap]

Hello all,

I have an application that utilizes a File Data Source Name. Recently the password was changed for the SQL Server login (originally there was NOT a password, just used "sa&quot. I've modified my FDSN accordingly but every time I run the report through my VB6/CR8.5 (using Rpt Designer Component) app the "...not yet been opened" message appears as the Viewer tries to open the report and execute my SQL.

All of the DLL's necessary for the app are present. It runs fine when my FDSN uses default NT login but I need to supply a specific ID/Password. The report is a DSR, not an RPT file. When I save it to an RPT file and preview the results in CR directly (FDSN supplying UID/PWD) the report shows up fine.

My reports are based upon stored-procs that are visible when I look under "Set Location" so the report designer is able to see the database structure through the FDSN but not execute the procedure.

Any ideas on what might be happening?

Thanks,

Oliver

 

[Praveenk00]

u need to open database if u r changing login/pwd at runtime

use

.logonserver property of report to give new login/.pwd/server/database

 

[olichap]

I have a DSN that should handle the login as a trusted connection. The File DSN is configured with the UID/PWD when you set it up. I know it does not store the password in the .DSN file itself, but isn't the purpose of a shared DSN to give ODBC access through a file that's been pre-configured to log onto a database?