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/
