"Server has not yet been opened" error accessing SQL Server

[jbradley]

I'm trying to migrate to SQL from Access. I got my data moved and started changing the database location of my reports to the new database on the SQL server.

The reports are viewed from a VB application that passes the selected report to the CR Viewer. When I try to view the reports that point to the SQL server I get the "Server has not yet been opened" error.

Can I store the logon information in my report, or how do I pass it in from VB (I want to use "Trusted Connection&quot?

 

[chandhureddy]

Hi,

i encounterd the same error. when i set the logon info it is working fine.
try something like this

crviwer.SetLogonInfo "(ServerName)", DBNAME, cstr(UID), cstr(PWD)

Hope it may helps you.

chandhureddy