Re: Access error on citrix environment only.
- From: "Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx>
- Date: Mon, 19 Nov 2007 17:51:33 GMT
Parthiban s <parthiban.surya@xxxxxxxxx> wrote:
Recently I migrated a MS Access app from mdb data tables to oracle db.
It all works fine when connected locally to server but errors out in
citrix for only two screens with below error.
unable to insert into link table.
ORA- 1745 - invalid host or bind variable name.
Possibly the Citrix server has a different version of the Oracle driver software or
Access than you do? Just guessing.
when i digged into the issue, found possible keyword column issue. Both
the tables have a keyword column(Comment as column name which works fine
when used by noncitrix environment). I had renamed Comment to comments
in the table and forms,queries to avoid possible errors. waiting for the
citrix team to deploy it to the test environment. I am guessing of other
possiblities since its blocking many users daily activities and looking
for your expertise help.
Googling on the message shows a similar error using the keyword desc (likely for
descending) so you're likely on the right track.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.
- References:
- Access error on citrix environment only.
- From: Parthiban s
- Access error on citrix environment only.
- Prev by Date: Re: How do I use one record to describe a table
- Next by Date: Re: How do I use one record to describe a table
- Previous by thread: Re: Access error on citrix environment only.
- Next by thread: ZIP code module without DLL dependencies???
- Index(es):
Relevant Pages
|
