Hi, Although I'm an old hand at Unidata and UniBasic, I'm a newbie to ODBC.
I am trying to set up an ODBC link to my Unidata 6.0 database, using the Unidata ODBC driver that came with 6.0, to use in a VB.net application I'm writing. All seems to be set properly, but if I try to do a test of my connection by going to Excel and doing Data/Get External Data/New Database Query from the menu, I always get an error saying "Non-numeric found when numeric required." Here's what I've done to this point: I've modified the uni.config file on the AIX 5.1.server. I'm creating a schema for the file using the VSG program included with Unidata 6.0. I'm picking the file from the list of files, assigning ALL permissions to PUBLIC. I'm creating a view and schema using all fields (I have tried with only the text fields). My test file (1NF format) has fields of Name (25L Text), Town (25L Text) & Code (8R Number Conv=MR0). My @ID is a number (3 records: 1, 2 & 3). Valid data in each field. I've tried the @ID field with and without a Conv of MR0. With the MR0, VSG calls it an integer. Without the MR0, VSG calls it a VARCHAR. I get no errors while creating the schema in VSG, and I do see all the 'D' type dictionary fields in VSG, so it appears that it's not a network related error. I'm creating a link to the database in Windows XP Pro (and Win2000 Pro) - Administration Tools - Data Sources. There isn't much to configure here, and I think it's all set up ok. I'm trying to use Excel (have tried Access, too), to see if I can pull in the data, and I always get the message "Non-numeric found when numeric required". Any ideas? Thanks, - Dave -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
