>>That�s great, but how can I get info into Excel > spreadsheets using JDBC?
I've no idea - but as a work around all I can suggest is that you could use Fergal's download to excel thing (available on the witango.com component zone). I used it to set up a cron job which pulled data from a database and another file - pushed the entire result out to an excel sheet which I then mailed out to a list of people... This is a way to get info in anyway. --- Trevor Green <[EMAIL PROTECTED]> wrote: > That�s great, but how can I get info into Excel > spreadsheets using JDBC? > > T. > > On 1/29/04 4:17 PM, "witango man" > <[EMAIL PROTECTED]> wrote: > > > Since you're using the 5.5 dev studio you could > use > > JDBC - from archives check out: > > > > http://www.apocm.de/witango/ > > > > > > --- Trevor Green <[EMAIL PROTECTED]> > wrote: > >> Hi Chris > >> > >> I am actually asking for authentication every > time, > >> but for some reason it > >> will not accept the authentication (I have not > been > >> able to authenticate > >> successfully once). I am thinking that when Dev > >> Studio tries to access the > >> odbc source it is using a different ODBC config > file > >> somewhere. I have > >> double checked all the configs and they seem OK > but > >> there is obviously > >> something wrong somewhere. > >> > >> Trevor > >> > >> On 1/29/04 3:24 PM, "Chris Millet" > >> <[EMAIL PROTECTED]> wrote: > >> > >>> > >>> In step 3) "Check" (not uncheck) the box that > says > >> "Ask each time" > >>> > >>> Chris > >>> > >>> On Jan 29, 2004, at 5:18 PM, Chris Millet wrote: > >>> > >>>> Not sure if this is the same issue, but I have > >> seen this behavior > >>>> before when login has been set to be automatic > >> and something is out of > >>>> whack with the username and password. In that > >> case: > >>>> > >>>> 1) Open the "Properties" menu palette under the > >> "Window" menu bar > >>>> 2) Open the "Workspace" menu palette (if not > >> already open) and > >>>> highlight the datasource > >>>> 3) In the "Properties" palette, click the > >> "Development" tab, then > >>>> uncheck the box that says "Ask each time" > >>>> 4) try again > >>>> > >>>> if this doesn't work, check your username and > >> password in the DSN > >>>> > >>>> I hope this helps. > >>>> Chris > >>>> > >>>> On Jan 29, 2004, at 4:26 PM, Trevor Green > wrote: > >>>> > >>>>> Hi > >>>>> > >>>>> Is there some neat little document somewhere > >> that explains how to use > >>>>> ODBC with MacOSX properly? I am running > Panther > >> with Dev Studio 5.5 > >>>>> and mySQL. I have created the DSN?s and when I > >> test them using > >>>>> odbctest they work fine. When I go into the > Dev > >> Studio I can see the > >>>>> DSN?s but when I try and expand them I get an > >> error saying that a > >>>>> connection could not be made. > >>>>> > >>>>> Please help!!! > >>>>> ? > >>>>> Trevor Green > >>>>> > >>>>> > >> > > > ______________________________________________________________________ > >>>>> __ > >>>>> TO UNSUBSCRIBE: Go to > >> http://www.witango.com/developer/maillist.taf > >>>>> > >>> > >>> > >> > > > ________________________________________________________________________ > >>> TO UNSUBSCRIBE: Go to > >> http://www.witango.com/developer/maillist.taf > >> > >> > >> Trevor Green > >> IT Director > >> > >> TBWA\Chiat\Day > >> Telephone: 310-305-5269 > >> Fax: 310-305-6269 > >> Mobile: 310-925-4158 > >> > >> > > > ________________________________________________________________________ > >> TO UNSUBSCRIBE: Go to > > http://www.witango.com/developer/maillist.taf > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! SiteBuilder - Free web site building tool. > Try it! > > http://webhosting.yahoo.com/ps/sb/ > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > > > > Trevor Green > IT Director > > TBWA\Chiat\Day > Telephone: 310-305-5269 > Fax: 310-305-6269 > Mobile: 310-925-4158 > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
