Re: [U2] ODBC Difficulties

2006-01-12 Thread Simon Lewington
Kevin King... I am having some difficulties getting the Unidata ODBC driver to work properly. ... I have verified the registry settings per the ODBC documentation, verified the location and contents of uci.config, and verified the ODBC configuration settings. Still, when trying to connect

RE: [U2] ODBC Difficulties

2006-01-12 Thread Kevin King
BRILLIANT! Thanks Simon (for regmon)! This should be very useful. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] ODBC Difficulties

2006-01-11 Thread Kevin King
I forgot to mention that I'm using the same user ID on both systems, so it would seem that it's not the privilege file. Also, the fact that the errors get returned immediately - as if it doesn't even make an effort to connect - makes me think something is amiss with the driver. There should be

RE: [U2] ODBC Difficulties

2006-01-11 Thread colin.alfke
Rats, that was my best guess - unless it's some kind of domain type issue. (I don't give up easy do I?) Which version of the driver are you using? There were different drivers with the 6.0a and 6.0b client CD's, I might have even gotten a patched one from IBM. I always use the System DSN. I

RE: [U2] ODBC Difficulties

2006-01-11 Thread [EMAIL PROTECTED]
issues were resolved. Just my $.02. Regards, Robert Original Message: - From: Kevin King [EMAIL PROTECTED] Date: Wed, 11 Jan 2006 06:25:17 -0700 To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC Difficulties I forgot to mention that I'm using the same user ID on both

RE: [U2] ODBC Difficulties

2006-01-11 Thread Kevin King
Thanks Robert. The user ID is currently 4 characters and the password is currently 7. -k --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] ODBC Difficulties

2006-01-11 Thread colin.alfke
That's right - I also had a problem with a user that had a password with a symbol in it. I don't recall which - I think it was just the $. Colin -Original Message- From: robert dunnmiller I encountered an issue with ODBC connectivity, very similar to what you are reporting. The

RE: [U2] ODBC Difficulties

2006-01-11 Thread Kevin King
Thanks for the heads up, I do appreciate all the different ideas about this ODBC problem, but the uid and pw are both letters and numbers, no symbols. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] ODBC Difficulties

2006-01-10 Thread Kevin King
I am having some difficulties getting the Unidata ODBC driver to work properly. Here's the setup: I am in Colorado, the client server is in southern California, and the remote site where the ODBC connection is being setup is in Toronto, Ontario (and travel to either the California or Toronto

RE: [U2] ODBC Difficulties

2006-01-10 Thread colin.alfke
I'm running w2kPro SP4 with ODBC driver version 3.01.04.7036 and I can connect to both UD 6.0.12 and 5.1.27 (both on w2k) with it. I just tested with Excel, Access, and the ODBC Query tool from http://gpoulose.home.att.net/. The only problem I had was my user id did not have write access on the

RE: [U2] ODBC Difficulties

2006-01-10 Thread Kevin King
Yeah, Colin... I have the ODBC working here with my XP client (over VPN) with no difficulties whatsoever, which is why the whole thing seems like a version conflict. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] ODBC Difficulties

2006-01-10 Thread colin.alfke
Could be. I've had some strange experiences with some of the ODBC clients. Like it working for Excel but not Access. I'd also check the privilege file. It seems that sometimes VSG (I'm guessing - but it's the only thing that seems remotely reasonable) changes the OS permissions on the file. Not