Digital Workshop

I have a database with query actions and script queries. Both use the same DSN, but when published the script query would not connect!

the script query I had

myDB = new Database("FILEDSN=C:\\Program Files\\Common Files\\ODBC\\Data Sources\\EditCert.dsn;").

I didn't think the path was relevant when published since opus writes the DSN internally. I tried relative paths, but after a bit of head scratching, trial and error, I found that changing the database object to

myDB = new Database("FILEDSN=EditCert.dsn;")
so removing all reference to the path for the script query cured the problem. It now works in preview and published.