Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
macgeg
Starting Member
2 Posts |
 Posted - 2004-11-30 : 11:19:25
|
| If i run a report that have a data source ODBCthat connects to a access database from visual studio I have no problem, but if I run the same report from report manager, I have this error:"Errore durante l'elaborazione del report. (rsProcessingAborted) Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) Visualizza la Guida in lineaERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-30 : 12:20:09
|
| Is Report Server installed on the same machine where you are running Visual Studio?Tara |
 |
|
|
macgeg
Starting Member
2 Posts |
Posted - 2004-12-01 : 03:13:42
|
quote:
Originally posted by tduggan
Is Report Server installed on the same machine where you are running Visual Studio?Tara
Yes, is in the same machine. Database is Accesss 97. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-01 : 13:15:31
|
| Check the data source inside Report Manager. Sometimes it gets orphaned upon deployment. So not in VS, but in Report Manager. Once you check that, make sure your report is connected to it in Report Manager.Tara |
|
|
|
|
|
|
Connect to Access database from Report manager