<cffunction name="createDemobuilder_DataSources" hint="Creates a new datasource" returntype="boolean">
<cfargument name="DSN" required="yes" type="string">
<cfargument name="DBPATH" required="yes" type="string">
<cfscript>
factory = CreateObject("java", "coldfusion.server.ServiceFactory");
datasources = factory.datasourceservice.getDataSources();
</cfscript>
<cfset datasourcecopy = Duplicate(datasources['DemoBuilderDefaultDB'])>
<cfset datasourcecopy.name = "#DSN#">
<cfset path="#DBPATH#\#DSN#.mdb">
<cffile action="" source="#Request.Source.dbpath#" destination="#path#">
<cfset datasourcecopy.urlmap.databasefile = "#path#">
<cfset datasourcecopy.url = ""> <cfset datasourcecopy.urlmap.connectionprops.datasource = "#DSN#">
<cfdump var="#datasourcecopy#">
<cfset datasources['#DSN#'] = Duplicate(datasourcecopy)>
<cfdump var="#datasources#">
<cftry>
<cfset valid = factory.datasourceservice.verifydatasource(arguments.DSN)>
<cfcatch type="any">
<cfset valid="false">
</cfcatch>
</cftry>
<cfreturn valid>
</cffunction>
I tried adding the store and restart methods but I still got the same error. I also tried the method you used (with a minor change for ms access) but sadly, the same error.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

