TOPIC: Logging Into Multiple Dabases

Logging Into Multiple Dabases 13 May 2011 13:37 #798

  • ddale@teksolutions.com
  • ddale@teksolutions.com's Avatar
  • Offline
I have a Crystal report that gets data from a Pervasive database and Logicity worked very well in running that report on a scheduled basis. I have since needed to add an MS Access database to the report (there is no password/userid required for login to the Access databse). The report will run within the Crystal programming environment, but Logicity cannot seem to run it even with a DSN setup for the Access database. Any ideas?
The administrator has disabled public write access.

Re:Logging Into Multiple Dabases 13 May 2011 19:51 #799

  • mholbrook
  • mholbrook's Avatar
Hello,

The reason this is happening is because you have 2 data sources. A work around for this that we have found is to use a file dsn. Let me know if this helps. Thanks!

Matt
The administrator has disabled public write access.

Re:Logging Into Multiple Dabases 16 May 2011 16:27 #800

  • ddale@teksolutions.com
  • ddale@teksolutions.com's Avatar
  • Offline
Matt,

I created a file DSN for the Access DB and still have a login error when the report tries to run. Perhaps my file DSN isn't setup correctly?
The administrator has disabled public write access.