I just select a data source and then pick the tables I want to query from. It should prompt you for selection and sorting criteria as well. If it's not doing that then maybe you don't have a file dns setup for the U2 odbc service.
------------------------------------------- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] ------------------------------------------- www.allspec.com ------------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Charlie Rubeor > Sent: Friday, July 21, 2006 1:48 PM > To: [email protected] > Subject: RE: [U2] Client SQL prompt for Unidata > > I use MSQuery all the time to verify the connection, but I have not > figured out how to get the results of an sql statement to appear on the > screen. We would really like to simply type SELECT > VENDOR_NAME,VENDOR_ADDRESS FROM VENDOR_MASTER; and have the results on the > screen, just like it does from the Unidata sql prompt. If MSQuery can do > so, that would be ideal. > > -------------------------------------------------- > Charlie Rubeor > Senior Database Administrator > Wiremold/Legrand > 60 Woodlawn Street > West Hartford, CT 06110 > Tel: 800-233-6251 x3498 > Fax: 860-523-3690 > Email: [EMAIL PROTECTED] > -------------------------------------------------- > > > > > "Glen Batchelor" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/21/2006 12:30 PM > Please respond to > [email protected] > > > To > <[email protected]> > cc > > Subject > RE: [U2] Client SQL prompt for Unidata > > > > > > > Use Microsoft Query? > > Office XP: > C:\Program Files\Microsoft Office\OFFICE11\MSQRY32.EXE > > ------------------------------------------- > Glen Batchelor > IT Director > All-Spec Industries > phone: (910) 332-0424 > fax: (910) 763-5664 > e-mail: [EMAIL PROTECTED] > ------------------------------------------- > www.allspec.com > ------------------------------------------- > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:owner-u2- > > [EMAIL PROTECTED] On Behalf Of Charlie Rubeor > > Sent: Friday, July 21, 2006 10:57 AM > > To: [email protected] > > Subject: [U2] Client SQL prompt for Unidata > > > > We have odbc all set up, works fine, we load data into Access, Excel, as > > well as a couple of other applications. What I do not have is a way to > > execute sql statements from the client. Some of our users would like to > > be able to simply type their own select statements from an sql prompt, > > without having to log into Unidata or opening up Excel. > > > > -------------------------------------------------- > > Charlie Rubeor > > Senior Database Administrator > > Wiremold/Legrand > > 60 Woodlawn Street > > West Hartford, CT 06110 > > Tel: 800-233-6251 x3498 > > Fax: 860-523-3690 > > Email: [EMAIL PROTECTED] > > -------------------------------------------------- > > ------- > > 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/ > ------- > 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/
