Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: GS Newsgroups: comp.lang.basic.visual.misc,microsoft.public.vb.general.discussion Subject: Re: Accessing website db - ADO or DAO? Date: Tue, 08 May 2012 00:28:44 -0400 Organization: A noiseless patient Spider Lines: 44 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15"; format=flowed Content-Transfer-Encoding: 8bit Injection-Date: Tue, 8 May 2012 04:28:47 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="UVJBuiIZprDyxzUkJsiwfw"; logging-data="24472"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18tI4E6A2TuOFKMHh1T/RrM" X-Antivirus-Status: Clean X-Newsreader: MesNews/1.08.03.00-gb X-Antivirus: avast! (VPS 120507-1, 05/07/2012), Outbound message X-Face: G"ln~:.wBqHZznO'(lJjjprxGYAjIF7#^u)lx,@"H'F#uXm%j`T6kxat5rq092aW;K*#m4jZ(2aW$34N&B&E@ j~tjGV-aC18j1y>zi.\[ZGXsd Cancel-Lock: sha1:rsPdfSpno7oLPVx1SxrPl9I8k4I= X-ICQ: 543516788 Xref: csiph.com comp.lang.basic.visual.misc:1069 ralph explained : > On Mon, 07 May 2012 20:43:04 -0400, GS wrote: > >> Hi folks, >> >> I'm looking to use a website db from a VB6 app but seem to not be able >> to figure out how. I'm okay with local db files, Excel files, and text >> files but totally clueless how to pull data from a website. I really >> want to stick with classic VB (and/or VBA)! >> >> Any advice/pointers will be most appreciated. Thanks in advance... > > Farnsworth is correct we need more information. > > But the platform or the internal Database used by the web site is > probably of no interest - rather we need to know what kind of data Web > Service it is providing, if any - Perhaps, you only need to strip an > exposed/rendered HTML table of its data? > > In other words what mechanism/s are available - Likely to be either > SOAP, WDI, or even UDDI. Add HTTP, HTML, and XML to the mix, and if > any of those acronyms are unfamiliar - then you need to start doing > your homework. > > At this point ADO or DAO is of no interest. Those libraries might > enter the picture once the type of service is known, or just as likely > you might write your own access routines since you are using VB. > > -ralph Thanks, Ralph. I think you're right and I hope I can get the needed info. I was able to google and find some classic VB to pull from a remote MySQL db using ADODB and an IP address. The idea of writing my own routine in VB is where I'd like to go, ultimately! -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion