So I went the API route...
<cffunction name="dbMerge" access="public" description="I move the data into
the user database" returntype="any">
<cfargument name="dbFileName">
<cfset dbfile =
"D:\Sites\stlouislandscape-v1\clarity\dbStore\"&#arguments.dbFileName#>
<cfset adminLogin =
createObject("component","cfide.adminapi.administrator").login("pil0t")>
<cfset dbCreate =
createObject("component","cfide.adminapi.datasource")>
<cfset tempAccessDBDSN =
dbCreate.setMSAccess("tempADSN", "#dbfile#", "MSAccess",
"macromedia.jdbc.MacromediaDriver", "19998")>
<cfquery name="getData"
datasource="tempAccessDBDSN">
SELECT *
FROM MEMBERSHIP
</cfquery>
<cfreturn getData>
</cffunction>
I'm getting this error
Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of
type class coldfusion.server.ConfigMap.
The error occurred on line 1385.
Any ideas?
--
Scott Stewart
ColdFusion Developer
4405 Oakshyre Way
Raleigh, NC 27616
(h) 919.874.6229 (c) 703.220.2835
-----Original Message-----
From: David McGuigan [mailto:[email protected]]
Sent: Monday, June 01, 2009 5:04 PM
To: cf-talk
Subject: Re: DSN-Less connections in CF8
Second that. The Admin API makes it easy.
On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert <[email protected]> wrote:
>
> You can also use the Admin API to create DSNs on the fly.
>
> cheers,
> barneyb
>
> On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger <[email protected]>
> wrote:
> >
> > Scott,
> >
> > Here's the approach we usually use (it works pretty well).
> >
> > http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx
> >
> > -Mark
> >
> >
> >
> > Mark A. Kruger, CFG, MCSE
> > (402) 408-3733 ext 105
> > www.cfwebtools.com
> > www.coldfusionmuse.com
> > www.necfug.com
> >
> > -----Original Message-----
> > From: Scott Stewart [mailto:[email protected]]
> > Sent: Monday, June 01, 2009 3:23 PM
> > To: cf-talk
> > Subject: DSN-Less connections in CF8
> >
> >
> > Yeah, this one's been beaten to death but.
> >
> > I need a process where a user can upload an Access db, certain tables
can
> be
> > read and the data inserted into a MySQL DB.
> >
> >
> >
> > The user has to be able to upload a new db once or twice a month, and
the
> > name may not always be the same.
> >
> >
> >
> > I know you used to be able to do this pre-MX, but google searches come
> back
> > with conflicting results.
> >
> >
> >
> > Has anyone gotten this to work successfully\?
> >
> >
> >
> > --
> > Scott Stewart
> > ColdFusion Developer
> > 4405 Oakshyre Way
> > Raleigh, NC 27616
> > (h) 919.874.6229 (c) 703.220.2835
> >
> >
> >
> >
> >
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323059
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
