I'm having a real tough time getting an Access DSN less connection to
work. Here's the scenario:
I have a form on one site, which when submitted, should connect to an
Access db on another physical server and site name, and then insert the
data into tables. Pretty straigtforward. On the server/site name that
has the receiving Access db, I have a DSN created, called WEW, and a new
user with UID (work1) and PWD (work2) set, with file permissions given
to this _db1 folder for that new user.
Here's the connection string I put in the CFQUERY Tag:
<CFSET REQUEST.PurchaseDataConnectString="Driver={Microsoft Access
Driver(*.mdb)};Dbq=c:\inetpub\mysite\_db1\wew.mdb;Uid=work1;Pwd=work2;">
I have this scenario working correctly using SQL 2000 (with its
corresponding connection string - not shown here), but I can't get it to
work with Access.
What am I doing wrong?
Thanks,
Mark
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
