RE: [U2] UniData 7.1 and ODBC

2007-08-07 Thread Bob Wyatt
Jeff,

This is an indication that the connection isn't defined correctly...
Have you tried the IP address of quicksilver.hampshire.edu instead of the
fully resolved host name? Have you verified that there is VOC file in the
defined PATH to the account? Have you verified that the destination account
is set up for ODBC?

Regards, 

Bob Wyatt 
Ashwood Computer, Inc. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera
Sent: Monday, August 06, 2007 08:59
To: u2-users@listserver.u2ug.org
Subject: [U2] UniData 7.1 and ODBC

I'm having some basic trouble getting ODBC setup with Unidata.  In
Developing 
UniData ODBC Applications under Before You Begin it says:

* Make sure the files you want to access in UniData are ODBC/SQL accesible.

See Using VSG and the Schema API

Yet in Using VSG and the Schema API under Before You Begin it says:

* Setup your ODBC server and database information so that the files are 
accesible to VSG.


Here's what I tried and isn't working too well.  I edited uci.config file
and 
added the entry

testr18
DBMSTYPE = UNIDATA
network = TCP/IP
service = udserver
host = quicksilver.hampshire.edu
account = /datatel/coll18/test/apphome

When I attempt to run VSG, I see my testr18 definition in the server 
drop-down, and then enter:

Database Name: testr18
User: my_username
Password: my_password

and get:

Died in UCI::SQLConnect() with SQLSTATE 08001, Native error: 0 [IBM][SQL 
Client][UNIDATA] Database testr18 doesn't exist.

Any pointers appreciated.
-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

Daddy - did you lose your mind?
Catherine Butera
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniData 7.1 and ODBC

2007-08-04 Thread John Jenkins
From the symptom you have I was expecting it to be set and set wrongly -
(*surprised*).

(type set or echo %CLASSPATH%)

Otherwise please check the shortcut properties for VSG - is the path or
directory misspelled?

If not obvious the de-install VSG - reboot - install. But take a look for
your misspelt JVM path in the registry first.

Regards

JayJay

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Butera
Sent: 04 August 2007 02:50
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata 7.1 and ODBC

 What's your *system* (not user please) CLASSPATH environment variable set
 to?

Not set - what would you like it to be?

Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

Daddy - did you lose your mind?
 Catherine Butera
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unidata 7.1 and ODBC

2007-08-03 Thread John Jenkins
What's your *system* (not user please) CLASSPATH environment variable set
to?

Regards

JayJay
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unidata 7.1 and ODBC

2007-08-03 Thread Jeff Butera

What's your *system* (not user please) CLASSPATH environment variable set
to?


Not set - what would you like it to be?

Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

Daddy - did you lose your mind?
Catherine Butera
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/