/
Crystal Reports Can't Create Connection to Database
Crystal Reports Can't Create Connection to Database
Problem
In the Crystal Reports Database Expert the Foray database is not found under Create New Connection
Solution
Create an ODBC x32 Data Source
Windows Start Menu, open ODBC Data Sourcse (32-bit)
Click System DSN
Click Add…
Select the driver for your database. PostgreSQL Unicode or ODBC Driver XX for SQL Server
Click Finish
Enter a name for the data source, the database name (ex: ForayAdams), the server FQDN, username and password.
Test
Save
If the driver for your database doesn’t appear run the installer from the Foray ADAMS prerequisites folder. Crystal’s designer is a 32 application and therefore needs a 32 bit driver such as psqlodbc_x86.msi
Related articles
, multiple selections available,
Related content
Errors with ODBC Data Source and Crystal Reports
Errors with ODBC Data Source and Crystal Reports
More like this
ODBC Data Source for use with Crystal Reports and PostgreSQL
ODBC Data Source for use with Crystal Reports and PostgreSQL
More like this
Crystal Reports "Database logon failed"
Crystal Reports "Database logon failed"
More like this
Cannot find the user 'foraydbadmin', because it does not exist or you do not have permission.
Cannot find the user 'foraydbadmin', because it does not exist or you do not have permission.
More like this
Migrating from Windows XP to Windows 7
Migrating from Windows XP to Windows 7
More like this
Crystal Reports Runtime Fails to Install
Crystal Reports Runtime Fails to Install
More like this
© 2023 Foray, LLC - All Rights Reserved