x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 6 replies
  • Subscribers 138 subscribers
  • Views 1131 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
Nic

Error with printing and fixed assets in v12 after migration

Posted By

Good day

I'm hoping someone has come across this issue before, we have completed a test migration from v11 to v12 and after the migration has completed we are unable to print in the new environment due to an error: Unable to connect: incorrect log on parameters [database vendor code: 18456], additionally when accessing any fixed assets option, the system will generate an SQL error file containing a similar message that the SQL login failed, all other access works perfectly.

Both these issues seem to be related to the adxodbc file, I have rebuilt this file from the command line as we as changing the folder password from the Sage console which forces a rebuild of this file, these actions have not helped.

Lastly, it's important to note that printing and fixed assets both work perfectly in the SEED folder on the exact same environment.

Parents Reply
  • 0 in reply to Mike Shaw

    Hi Mike, I went through your blog as suggested and learned that it was passing the ~1 from the first line of adxodbc as the database name, and passing the database name from line 2 of adxodbc as the username, but while browsing through the folder structure I thought maybe I should check the TRT folder for scripts that shouldn't be there, it turns out there was a copy of ORAPASSE.adx in the child folder, by deleting this file my problem is resolved, hopefully this helps someone Slight smile

Children

*Community Hub is the new name for Sage City