When viewing a report on the web, I can only do so if the data has been saved with the report. Otherwise, I get an error stating 'Server has not yet been opened' or if I specify not to save the data with the report, I get the error "An Error has occured on the server in attempting to access the data source".
In order to avoid DSN's on the server, we usually use an include file which contains the connection information - for example:
set Conn = "Server.CreateObject("ADODB.Connection"
Conn.Open "Driver=SQL Server;Server=database servername;Database=database name;Trusted_Connection=yes;wsid=code server name;application=application name"
To create the report, I just connect to the database as through Crystal Reports but not via a DSN.
Can anyone help?
In order to avoid DSN's on the server, we usually use an include file which contains the connection information - for example:
set Conn = "Server.CreateObject("ADODB.Connection"
Conn.Open "Driver=SQL Server;Server=database servername;Database=database name;Trusted_Connection=yes;wsid=code server name;application=application name"
To create the report, I just connect to the database as through Crystal Reports but not via a DSN.
Can anyone help?