Er, all of the optional arguments. Try just the new datasource name and the
path to the file.
On Mon, Jun 1, 2009 at 8:43 PM, David McGuigan <davidmcgui...@gmail.com>wrote:
> Try omitting the driver and the port.
>
>
>
>
>
> On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart
> <sstwebwo...@bellsouth.net>wrote:
>
>>
>> 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:davidmcgui...@gmail.com]
>> 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 <bboisv...@gmail.com>
>> 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 <mkru...@cfwebtools.com>
>> > 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:sstwebwo...@bellsouth.net]
>> > > 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:323062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
