I don’t know how I would do this because our Access is within a Citrix Environment.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, March 09, 2017 9:15 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: connection string for passthrough query
Liz - Open Access as an Administrator. Right-click the Access icon to get that choice. Then build your DSN file. See if that makes a difference.
Also, you can open a DSN in NotePad and see if it needs editing.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP! 2006-2016
That'll do IT http://thatlldoit.com
My Nothing-to-do-with-Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, March 09, 2017 7:13 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: connection string for passthrough query
And I failed… I was able to pull one field down and once the query got more complicated, I got the same error messages.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, March 08, 2017 3:41 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Cc: Pat Martino
Subject: [MS_AccessPros] RE: connection string for passthrough query
Hold it. I knew after hours of sweat and then finally posting here I would get it.
I think I’m on something. I was looking at a table that simply is NOT on that particular server.
HEE HEE!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, March 08, 2017 3:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] connection string for passthrough query
Pros, I have been successful running numerous queries with a certain sql server and its respective connection string.
However, ! I need to point to a different server, and have odbc table links to it. When I click on the ellipsis in the connection string property field, and the wizard prompts me though the dsn to select the server, it does build a connection string and asks me to save the credentials, and to test it for this time, I do.
Then I try to run it, and it still prompts me for a user/pass and then gives me an ODBZC – call failed. Bla db2 for i5/os sql0104 – token ; was not valid valid tokens <end-of-statement> but there isn’t even a semi colon at the end of the connection string anyway.
Ideas?
Respectfully,
Liz Ravenwood
Software Engineer
B/E Aerospace | Super First Class Enviro! nments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This em! ail (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar