hmm not sure if i get either of you ... please find screen shots at http://www.ualberta.ca/~sdoherty/help.bmp
.. i defined my dsn as perd (my access database) driver as JDBC-ODBC Bridge .. then clicked add. on the next screen i don't know what to put for ODBC DSN, my database isn't lsited ... so i am confused sean =) |-----Original Message----- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] |Sent: Thursday, July 25, 2002 3:50 PM |To: CF-Talk |Subject: Re: new to CF | | |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
