On my laptop, I go to cfide/administrator... and add the data source. It is then accessible to dreamweaver and I can use it. When I publish the file at localhost, it works. But when I upload to IX, it errors
Thanks, Jon On 4/22/06 9:00 AM, "Mike Chytracek" <[EMAIL PROTECTED]> wrote: > So you are not actually having the datasource added to coldfusion through > the admin? This is the problem. > > You likely have to contact your host to set up a datasource for you. > > Mike > > -----Original Message----- > From: Jonathan Gravois [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 22, 2006 8:59 AM > To: CF-Newbie > Subject: Re: Connecting to MySQL > > All of our sites are hosted at IXWebHosting. > > In the control panel, there is a "mySQL Server" tab. I created the database > there. > > A second tab on the control panel is labeled "ODBC." In there I created a > DSN following the instructions. > > In DreamWeaver, the database is shown and the tables are accessible. But > when I upload the files to the server (on IX) -- boom! > > Thanks Again, > Jon > > > On 4/22/06 8:53 AM, "Adrian Lynch" <[EMAIL PROTECTED]> wrote: > >> 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:1785 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
