All,
I understand from talking with the GS support staff that this issue has been resolved, but for everyone else’s benefit I thought I’d review the resolution:
Always be sure you are using the correct ODBC driver to connect to your TMS database. For a SQL Server database, it should be the one labeled either SQL Server Native Client 10.0, or SQL Server Native Client 11.0. In Heikki’s case, this was the source of the problem; his external IT staff has installed TMS and configured it to use incorrect drivers.
[cid:image001.png@01CF2654.D516BFE0]
Note that this error message can be the indication of other issues, but here’s at least one issue that can be easily addressed. Please contact me directly if you have other questions about ODBC connectivity.
Best,
Danielle
________________________________
Danielle Uchitelle | Managing Director
[log in to unmask]<mailto:[log in to unmask]> | 646.733.2239 x264
GallerySystems | www.gallerysystems.com<https://urldefense.proofpoint.com/v1/url?u=http://www.gallerysystems.com/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=NtUacqqW%2BzFbOS8WFNOy7KIG3%2B7rURqyTIDYe7Bu0jg%3D%0A&s=7e92e893f49173dbb52e7586fb2be099bcf02cab0eb78c6c73138db2f4081184>
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Heikki Pauts
Sent: Saturday, February 08, 2014 7:34 PM
To: [log in to unmask]
Subject: Re: TMS2012 SP2 | Error : Object variable or With block variable not set
Dear Danielle,
I have received this error message with navigating (or actually doing just about anything) in Loans, after I upgraded to TMS 2012 SP1. I suspected it has smth. to do with the check for anonymity rights that TMS performs at every navigation, or alternatively, that I have a problem with the database collation / SQL client version. I have attached the messages as they appear. After waiting for a while (query time-out), and clicking away these two messages, I can continue using Loans, but as soon as I try to navigate to another record (or attach an object to the loan), the same happens. Needless to say, but I have maximum rights for accessing anonymity information.
Occasionally these messages appear also in Objects, but I can't replicate the reason.
I guess upgrading to SP2 doesn't solve this problem?
Greetings,
Heikki Pauts
National Museum of Antiquities
Leiden, The Netherlands
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
|
