ok here goes. The DSN is the what you set the name of the datasource so that you can use that name when you are in Coldfusion and you need to reference that datasource.
Example. You make a datasource called Plants to store your plant database. Then in cf you can use <cfquery name="qGetmyplants" datasource="plants"> throughout CF you use datasources and it has to matchup to whatever the name in the CF administrator. For access you probably dont have to set a username and password so you should just be able to select the file and walla. Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 > I am really new to CF, about 1hr, and am having a bit of trouble ... I am > using a CFMX stand-alone server with windows 98 (were just testing some > development stuff). I am trying to add a new data source, more specifically > a MS access 97 database. I am using the JDBC-ODBC Bridge driver, but I > don't understand what the ODBC DSN field is for and how to make it all > connect together ... if any one out there can help it would be greatly > appreciated! > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
