[U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
I have a customer setting up a Win7/64 box for UPS Worldship. Previously they had a XP/32 box in that same place running an earlier version of the WS solution. They've installed the Unidata ODBC driver (which is 32-bit) and have configured it, and have tested it successfully using Excel. (By tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
It is possible that this is a permissions problem. Try the following: - Disable UAC and rerun the app. - Disable UAC and run the app as Administrator. If that still doesn't work, then I'm out of rabbits, or need a closer look at the hat. If either one works, then you have hit a UAC problem. Note that a normal user cannot write to the Program Files directory (plus other places) under Windows 7/2008 server environment. Lots of older apps required you to do this, and will break when ported, unless you run with elevated privileges. You may wish to check if UPS has an updated version of their app for Windows 7/x64. I have a number of things I do on my Win7/x64 system that require me to run as Administrator with UAC turned off. It simply won't work otherwise. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, January 26, 2011 9:50 AM To: U2 Users List Subject: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64 I have a customer setting up a Win7/64 box for UPS Worldship. Previously they had a XP/32 box in that same place running an earlier version of the WS solution. They've installed the Unidata ODBC driver (which is 32-bit) and have configured it, and have tested it successfully using Excel. (By tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
I'll pass that along, thanks! On Wed, Jan 26, 2011 at 11:15 AM, Robert Houben robert.hou...@fwic.netwrote: It is possible that this is a permissions problem. Try the following: - Disable UAC and rerun the app. - Disable UAC and run the app as Administrator. If that still doesn't work, then I'm out of rabbits, or need a closer look at the hat. If either one works, then you have hit a UAC problem. Note that a normal user cannot write to the Program Files directory (plus other places) under Windows 7/2008 server environment. Lots of older apps required you to do this, and will break when ported, unless you run with elevated privileges. You may wish to check if UPS has an updated version of their app for Windows 7/x64. I have a number of things I do on my Win7/x64 system that require me to run as Administrator with UAC turned off. It simply won't work otherwise. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, January 26, 2011 9:50 AM To: U2 Users List Subject: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64 I have a customer setting up a Win7/64 box for UPS Worldship. Previously they had a XP/32 box in that same place running an earlier version of the WS solution. They've installed the Unidata ODBC driver (which is 32-bit) and have configured it, and have tested it successfully using Excel. (By tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
Is there anything in the EventLog for windows? The DSN has a Trace option that can save output to a text file. May be helpful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
One of our recent WS machines came from UPS with Vista installed (IIRC, I was not onsite). If they are shipping them this way, they should be UAC aware. On Wed, Jan 26, 2011 at 1:15 PM, Robert Houben robert.hou...@fwic.net wrote: It is possible that this is a permissions problem. Try the following: - Disable UAC and rerun the app. - Disable UAC and run the app as Administrator. If that still doesn't work, then I'm out of rabbits, or need a closer look at the hat. If either one works, then you have hit a UAC problem. Note that a normal user cannot write to the Program Files directory (plus other places) under Windows 7/2008 server environment. Lots of older apps required you to do this, and will break when ported, unless you run with elevated privileges. You may wish to check if UPS has an updated version of their app for Windows 7/x64. I have a number of things I do on my Win7/x64 system that require me to run as Administrator with UAC turned off. It simply won't work otherwise. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, January 26, 2011 9:50 AM To: U2 Users List Subject: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64 I have a customer setting up a Win7/64 box for UPS Worldship. Previously they had a XP/32 box in that same place running an earlier version of the WS solution. They've installed the Unidata ODBC driver (which is 32-bit) and have configured it, and have tested it successfully using Excel. (By tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
Nothing in the event log. Not sure how to enable a DSN trace within the Fedex app. Input? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
turn it on in the configuration tab of the data source, bottom right Kevin King wrote: Nothing in the event log. Not sure how to enable a DSN trace within the Fedex app. Input? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
Where will the log be written? On Wed, Jan 26, 2011 at 2:18 PM, Jeff Schasny jscha...@gmail.com wrote: turn it on in the configuration tab of the data source, bottom right Kevin King wrote: Nothing in the event log. Not sure how to enable a DSN trace within the Fedex app. Input? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
Ah, I see it now. It's in the Tracing tab here. On Wed, Jan 26, 2011 at 2:18 PM, Jeff Schasny jscha...@gmail.com wrote: turn it on in the configuration tab of the data source, bottom right Kevin King wrote: Nothing in the event log. Not sure how to enable a DSN trace within the Fedex app. Input? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users