I'd remove all of the lines except under the localud section: DBMSTYPE = UNIDATA ACCOUNT = path to the demo account on the Unix server network = TCP/IP service = udserver host = the ipaddress of the machine
Please also make sure there is a blank line after the last item (the UCI config will make sure it is there automatically). Make sure the full path to the demo account is there (case sensitive). When you start VSG put the same full path - case sensitive - in the Database Name that you used for ACCOUNT in the config file. See if that helps. I'm not sure why you've put the rest of the options in there - we've always just left them blank to use the defaults.... -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles >-----Original Message----- >From: Lynn Fernando [mailto:[EMAIL PROTECTED] >Sent: Monday, June 28, 2004 3:27 PM >To: [EMAIL PROTECTED] >Subject: [U2] Error when connecting to the host using VSG > > >We want to be able to retrieve data from Unidata files. I have >installed >the Unidata client on my PC and I am trying to start VSG. >Whenever I use >the connect dialog box to connect to Unidata(on the Unix Server), I get >the following errormessage: >Died in UCI::SQLConnect[] with SQLSTATE IM997,Native error:0[IBM][SQL >Client] An illegal configuration option was found. >Would anyone know what the reason may be for getting this error. In >the UCI Editor I created a database name that points to the demo >database on the Unix platform. >Below show the parameters: >[ODBC DATA SOURCES] > ><localuv> >DBMSTYPE = UNIVERSE >network = TCP/IP >service = uvserver >host = localhost > ><localud> >DBMSTYPE = UNIDATA >ACCOUNT = path to the demo account on the Unix server >USERNAME = testname >MAXFETCHBUFF = 8192 >MAXFETCHCOLS = 400 >network = TCP/IP >service = udserver >host = the ipaddress of the machine >AUTOINC = no >CASE = yes >DESCB4EXEC = yes >DSPSIZE = yes >MAPERROR = list >MARKERNAME = no >NLSLCALL = none >NLSLCCOLLATE = none >NLSLCCTYPE = none >NLSLCMONETARY = none >NLSLCNUMERIC = none >NLSLCTIME = none >NLSLOCALE = none >NLSMAP = none >NULLABLE = yes >SEARCH = yes >TXBEHAVIOR = 1 >TXCOMMIT = no >TXROLL = no >TXSTART = no >TYPENAME = yes >UNSIGNED = no >UPDATE = no >New Items = no >Any help is greatly appreciated. >Thanks in advance >Lynn >------- >u2-users mailing list >[EMAIL PROTECTED] >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
