Publishing report in 8.5

[oshlonger]

I have designed a report in the Crystal Report Designer that gets data via an ODBC connection to a MS Access 2000 table. It runs fine when I'm in the designer.

When I publish it in through the Crystal Management Console, it fails with the error message "Cannot open SQL Server"

I do not know why I am getting this error? When I build reports that get data from my SQL Server Databases, I can publish them successfully. Its only when I am connecting to my Access table, however, I do not have a user name or password for the Access database.

Any thoughts would be appreciated.

 

[cbrittain533]

Is the ODBC connection set up on the CE server?

Do you use ODBC connections to connect to the SQL Server tables in the other reports?

Is the Access database local to the server or on another network machine?

 

[oshlonger]

The ODBC connection to my Access table is not set up on the CE Server.

I do use ODBC connections to connect to SQL server tables for other reports.

The access database is not local to the server. It is on another machine.

 

[cbrittain533]

I would try setting up the ODBC connection on the CE machine. When I use ODBC, I create the same connection on the CE machine and have not had any problems.

The only thing that is making me wonder is the other reports. If you are using ODBC to make those connections as well and are not creating the ODBC connection on the CE box, you should have the same problem. It might be due to being able to identify a SQL Server by computer name and having to map to a specific filename with path for Access in the report itself.

 

[oshlonger]

Setting up an ODBC connection on the CE machine did not help. (unless I am setting up the connection incorrectly)

I'm not sure if the ODBC connections for my SQL Server databases are on the CE machine, I'll have to check.

Any more suggestions?

 

[JohnTcolo]

From the CE machine, I would browse out to the access database and try to open it thru explorer using Access. This will server to prove you have rights and can actually hit the access database. If you CAN open the database this way, you need to look closely at how you have the odbc datasource set up. You are aware that you can hit this database using the Database Files option rather than an ODBC datasource. This is what I would probably use to locate the database. (rather than a datasource)

 

[cutiger93]

I am having this same problem. I do not have Access installed on the CE machine. Could this cause an issue?

oshLonger do you have Access on your CE machine.

 

[JohnTcolo]

You should not need access on the CE machine. What happens when try using the Database/Files option in Crystal? This should bypass the ODBC datasource alltogether.

 

[cutiger93]

I was able to solve my issue by removing the startup screen in my access database.

Now I will test moving the database to another network drive.

 

[oshlonger]

JohnTcolo-
I am able to browse out to the Access database and open it. I understand I can hit it using the Database Files option rather than an ODBC datasource, however, i need to be able to make changes to the database regularly. It would not be convienent for me to place the database on the CE machine itself

 

[synapsevampire]

If you can browse to it via ODBC, you can browse directly to it on whatever machine it's residing on.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[oshlonger]

I was able to browse out to the machine the access table is residing on. I was able to view it in desinger but still not able to publish...ready to give up!