Data access failure error

[Nansat]

I am using BUSINESS OBJECTS ENTERPRISE XI and I am having a strange problem.

using crystal reports XI, I have designed a report that generate report out of a CSV file which is present internal harddrive and the report is coming well. I am using a ODBC connection ( Microsoft Text driver) to connect to the data folder.

When I try to schedule the report on the Enterprise XI, it gives a strange error


Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\Bingo.reportjobserver\~tmp11584a209c87821a.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: -1023 ]

I dont know how to fix this..Can somebody help me please.. ?

 

[synapsevampire]

It doesn't have access to your CSV file,and it certainly isn't in the same location.

Move the CSV file to a common drive, and use UNC mapping in the ODBC connection (you also need to have the ODBC set up on Crystal Enterprise), as in:

\\machine\path...

as opposed to

C:\path...

-k

 

[Nansat]

The windows server on which crystal enterprise is installed I went to Administrative tools -> ODBC connections and added the System DSN to access this CSV file. Does this suffice?

 

[Nansat]

Move the CSV file to a common drive, and use UNC mapping in the ODBC connection "

>>> I have placed the file on a common drive and mapped it on my computer.. However I couldnt understand completely the following statement. Can you please help me by explaining this?

"" you also need to have the ODBC set up on Crystal Enterprise), as in: \\machine\path... as opposed to :\path...

 

[synapsevampire]

How did you map it on your machine, using UNC as in:

\\machine\path...

or did you map to a drive letter:

C:\path...

Use UNC, not a drive letter, and make sure that the CE server has access to the common drive,and that it has it's ODBC set up properly.

-k

 

[Nansat]

I have mapped the drive as \\servename\folder1\folder2 to a letter X on the CRYSTAL ENTEPRISE XI server.

and I could browse through the file, by clicking the folder from the server.

I added the report to Crystal enterprise and then in PROCESS->DATABASE->

the defaults came like this

*Use original database logon information from the report
server: System DSN name I have created using ODBC DS
administrator

Database field- blank

user: network user id
pwd: the one I hv specified

When I run this report, I am getting this error

Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\fwcrystal.reportjobserver\~tmp11584a20d0083320.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: -1023 ]

 

[synapsevampire]

I think that you need to use UNC mapping. Mapping to a drive letter is NOT UNC mapping...

This is the 3rd time I've mentioned this, not wure what else to say about it.

-k

 

[Nansat]

This is what I did under UNC mapping

On My computer The network driver looks like this (without any letter associated to it)

Exports on '\\server\Drive1\folder1\folder2'

is this what you mean? After doing this should I create a ODBC system DSN??