Groups | Blog | Home
all groups > sql server reporting services > may 2005 >

sql server reporting services : NotesSQL ODBC


James
5/19/2005 11:20:07 AM
Created a DSN use notessql.
Created a datasource and a report in VS .net.
The report can be previewed but can't be displayed on the reportserver.
The error read like below:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'DataSource1'.
(rsErrorOpeningConnection) Get Online Help
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified.

Does any one know what causes the problem?
Thx in advance.
Robert Bruckner [MSFT]
5/19/2005 4:31:06 PM
Are report designer and report server on the same machine?
Is the DSN also created on the report server machine?

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

James
5/20/2005 6:40:00 AM
Yes. They are all on one machine.
Connection string: DSN=NotesSQL1
Prompt for credentials option is selected.

Will it be different if they are on different machine?

Thx

[quoted text, click to view]
James
5/20/2005 6:44:02 AM
Yes. They are all on one machine. Will it be different if they are on
different machines?
Connection String: DSN=NotesSQL1
Prompt Credential option is selected.

Thx for you great help!

[quoted text, click to view]
AddThis Social Bookmark Button