I'm no expert on drivers or DSN settings, but it looks like you have set up an ODBC DSN. Is that right? How did you go about setting up the DSNs?
-----Original Message----- From: Jonathan Gravois [mailto:[EMAIL PROTECTED] Sent: 22 April 2006 14:43 To: CF-Newbie Subject: Re: Connecting to MySQL Error Diagnostic Information ODBC Error Code = IM002 (Data source not found and no default driver specified) [Microsoft][ODBC Driver Manager] Data source 'CFIXSUPPORT' not found and no default driver specified Thanks Jon On 4/22/06 8:35 AM, "Adrian Lynch" <[EMAIL PROTECTED]> wrote: > What errors are you getting? > > -----Original Message----- > From: Jonathan Gravois [mailto:[EMAIL PROTECTED] > Sent: 22 April 2006 14:31 > To: CF-Newbie > Subject: Re: Connecting to MySQL > > > yes > > On 4/22/06 8:28 AM, "Adrian Lynch" <[EMAIL PROTECTED]> wrote: > >> Have you set up a DSN on the production server? >> >> -----Original Message----- >> From: JONATHAN GRAVOIS [mailto:[EMAIL PROTECTED] >> Sent: 22 April 2006 14:23 >> To: CF-Newbie >> Subject: Connecting to MySQL >> >> >> I am very new to CF_MX7 but am beginning a project of migrating asp sites > to >> CF. >> >> I am trying to connect to a mySQL database on a host. I connect fine on > the >> development server on my laptop but when I upload the files to the >> production server, the connection is lost and errors are generated. >> >> I think the problem is that on my laptop - a MAC - I have a dsn to the > mysql >> server on the laptop that is identical to the mysql on the production > server >> - Windows 2003. I don't know how to tell the application - be it > DreamWeaver >> or ColdFusion - which mySQL server to use. >> >> Am I lost or what? >> >> Jon >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1782 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
