Tried that. Same error. I'm also getting the same error on the Sales & Service demo accounts which are installed activated and updated.
The truly strange part is that the ODBC configuration test in ODBC setup insists that the configuration is OK. I just downloaded the free WinSQL client program and it connects just fine so this may be an Office 2003/old UV PE/old ODBC client issue. My other computer which connects just fine is running Office 2000. I suppose I should get the latest UV PE version and associated clients and try that. Sounds like a plan. Anthony Youngman wrote: > If you did that, in that order, then the answer's simple. You need to update > the cache AFTER updating HS_FILE_INFO. Can't remember the name of the > command, but it's something like you need to run HS.UPDATE in the same > account as HS_FILE_INFO in order to publish the changes. > > Cheers, > Wol > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny > Sent: 23 October 2007 14:54 > To: [email protected] > Subject: Re: [U2] ODBC error > > The connectivity tests in Universe ODBC setup work fine for all data > sources. This is a new installation of both Universe and the ODBC > clients on a new PC. I have installed these same UV PE version and ODBC > clients on another PC and they work just fine. These were my install steps: > New PC, Windows XP Pro, Windows firewall disabled > Universe PE with matching ODBC client rev installed. > Created new account and a couple files > Created @ & @SELECT items in the dictionaries of the new files > Logto HS.ADMIN: > Enabled ODBC access for the new account. > Updated file information cache for the new account. > Created new ODBC data source which tests clean. > Tested Sales and Service demo data sources and they test clean. > Added entries to HS_FILE_INFO with READ rights for the new files in the > new accounts. > > Hona, David S wrote: > >> Are you able to successfully complete the ODBC connectivity tests to the >> demo accounts on your server? >> >> If not, fix that first and then if that's not the problem it's probably >> related to a UV configuration problem. Check your unirpcservices config >> file and check there is no conflict with any other service on your >> server. BTW...has it ever worked? >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny >> Sent: Monday, 22 October 2007 11:32 PM >> To: [email protected] >> Subject: Re: [U2] ODBC error >> >> UV 10.0.10 and ODBC driver 3.07.02.7013 >> >> This same combination of UV and ODBC driver are working just fine on my >> personal laptop also under XP Pro >> >> I get the same error from HS.SALES, HS.SERVICE and my newly created >> account. >> >> >> >> Hona, David S wrote: >> >> >>> What are UV server and client releases? >>> >>> Can you get a list of files from the built-in "demo" accounts: UV/ODBC >>> Sales sample (HS.SALES) and UV/ODBC Service Sample (HS.SERVICE)? >>> >>> >> ------- >> u2-users mailing list >> [email protected] >> To unsubscribe please visit http://listserver.u2ug.org/ >> >> >> > > -- > ------------------------------------------------------------------------ > Jeff Schasny - Denver, Co, USA > jeff at schasny dot com > ------------------------------------------------------------------------ > ------- > 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/ > > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jeff at schasny dot com ------------------------------------------------------------------------ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
