i have 32 and 64 bit System DSN setup on the server using the 2005 drivers. 4.0 was installed with 2008 Express. i'm not sure if that has anything to do with it? dumb question, should it be set to the db or cms db?
i don't remember configuration being this confusing.
here's what it shows in CMC settings:
setting up new connection, i'm trying to use the credentials for the boe140 db. someone tried connecting to the SQL 2005 db and that makes a connection but i get errors.
created a new connection using IDT and the test worked:
imported and used the new connection for the universe i need. the test worked:
error in crystal reports: