RE: Data source error
Hmmm, are you using the system user as the user CF service operates under? Or have you created a new user? Ensure that the user has permissions on the database folder, it is also a good idea to ensure the db is not in a folder that is accessible to the web (ie: your inetpub/wwwroot or whatever dir structure you use). Yes it should be a system dsn. ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Eric Vacin [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 4:28 PM To: CF-Talk Subject: Re: Data source error Stephanie, I got it from the CF Admin...when I tried to do an ODBC socket to the data source I created in the ODBC panel. Below is the exact output: * Connection verification failed for data source: ss []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink Server]Could not create a trace file.. I've added a system DSN...this is right, right? I'm starting to think its some kind of permissions thing as I have the server locked down, very locked down. Singed, Eternally Confused. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data source error
Eric, I experienced this problem a few days ago, not sure if it was because I applied the CFMX Updater 3 patch. I ended up having to re-install CFMX Server and that fixed the problem. Hope that helps... Ben -Original Message- From: Eric Vacin [mailto:[EMAIL PROTECTED] Sent: April 3, 2003 2:28 PM To: CF-Talk Subject: Re: Data source error Stephanie, I got it from the CF Admin...when I tried to do an ODBC socket to the data source I created in the ODBC panel. Below is the exact output: * Connection verification failed for data source: ss []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink Server]Could not create a trace file.. I've added a system DSN...this is right, right? I'm starting to think its some kind of permissions thing as I have the server locked down, very locked down. Singed, Eternally Confused. On 4/3/03 1:07 PM, "Stephenie Hamilton" <[EMAIL PROTECTED]> wrote: > Did you get that from the windows odbc control panel? Are you adding > it as a system DSN or a file DSN? > > > ~~ > Stephenie Hamilton > Macromedia Certified ColdFusion Professional > CFXHosting > > > > > > -Original Message- > From: Eric Vacin [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 2:21 PM > To: CF-Talk > Subject: Re: Data source error > > > Thanks Stephanie! > > > When I tried that I got, "Could not create trace file"... > > H Any ideas? > > e > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Data source error
Stephanie, I got it from the CF Admin...when I tried to do an ODBC socket to the data source I created in the ODBC panel. Below is the exact output: * Connection verification failed for data source: ss []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink Server]Could not create a trace file.. I've added a system DSN...this is right, right? I'm starting to think its some kind of permissions thing as I have the server locked down, very locked down. Singed, Eternally Confused. On 4/3/03 1:07 PM, "Stephenie Hamilton" <[EMAIL PROTECTED]> wrote: > Did you get that from the windows odbc control panel? Are you adding it > as a system DSN or a file DSN? > > > ~~ > Stephenie Hamilton > Macromedia Certified ColdFusion Professional > CFXHosting > > > > > > -Original Message- > From: Eric Vacin [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 2:21 PM > To: CF-Talk > Subject: Re: Data source error > > > Thanks Stephanie! > > > When I tried that I got, "Could not create trace file"... > > H Any ideas? > > e > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data source error
Did you get that from the windows odbc control panel? Are you adding it as a system DSN or a file DSN? ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Eric Vacin [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 2:21 PM To: CF-Talk Subject: Re: Data source error Thanks Stephanie! When I tried that I got, "Could not create trace file"... H Any ideas? e --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Data source error
Thanks Stephanie! When I tried that I got, "Could not create trace file"... H Any ideas? e On 4/2/03 7:47 AM, "Stephenie Hamilton" <[EMAIL PROTECTED]> wrote: > To add to that, if you create the DSN in windows odbc control panel, it > does not show up in CF Administrator, but you can create it also in CF > Admin by adding it as an ODBC Socket datasource type (driver drop down). > When you enter the Data Source name, then choose ODBC Socket as the > driver type, then on the next screen it will give you a drop down named > ODBC DSN where you can select the DSN you created in the windows odbc > control panel. > > HTH > > > ~~ > Stephenie Hamilton > Macromedia Certified ColdFusion Professional > CFXHosting > > > > > > -Original Message- > From: Dan Phillips [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 02, 2003 9:30 AM > To: CF-Talk > Subject: RE: Data source error > > >>> How would I reset (sp?) the DSN? > > Just delete it and recreate it > > >>> when I at a data source via the control panel, it doesn't show up in > the CF Admin. However the reverse is true. When I add it in the CF > Admin, it does in fact show up in the control panel. > > This is normal. Not sure why it happens but nothing to worry about > > > Dan Phillips > www.CFXHosting.com > 1-866-239-4678 x105 > [EMAIL PROTECTED] > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data source error
To add to that, if you create the DSN in windows odbc control panel, it does not show up in CF Administrator, but you can create it also in CF Admin by adding it as an ODBC Socket datasource type (driver drop down). When you enter the Data Source name, then choose ODBC Socket as the driver type, then on the next screen it will give you a drop down named ODBC DSN where you can select the DSN you created in the windows odbc control panel. HTH ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 9:30 AM To: CF-Talk Subject: RE: Data source error >> How would I reset (sp?) the DSN? Just delete it and recreate it >>when I at a data source via the control panel, it doesn't show up in the CF Admin. However the reverse is true. When I add it in the CF Admin, it does in fact show up in the control panel. This is normal. Not sure why it happens but nothing to worry about Dan Phillips www.CFXHosting.com 1-866-239-4678 x105 [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
RE: Data source error
>> How would I reset (sp?) the DSN? Just delete it and recreate it >>when I at a data source via the control panel, it doesn't show up in the CF Admin. However the reverse is true. When I add it in the CF Admin, it does in fact show up in the control panel. This is normal. Not sure why it happens but nothing to worry about Dan Phillips www.CFXHosting.com 1-866-239-4678 x105 [EMAIL PROTECTED] -Original Message- From: Eric Vacin [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 5:53 PM To: CF-Talk Subject: Re: Data source error Hey Thanks for your quick reply Dan! How would I reset (sp?) the DSN? The mdb file is in fact good. Also (and perhaps this is telling) when I at a data source via the control panel, it doesn't show up in the CF Admin. However the reverse is true. When I add it in the CF Admin, it does in fact show up in the control panel. Again, this is all happening when I first submit the data source. Thanks in advance, e On 4/1/03 2:28 PM, "Dan Phillips" <[EMAIL PROTECTED]> wrote: > It's lost the connection. Try to rest the DSN And see what happens. > Also, open the mdb and make sure the data is ok and not corrupt. Run > Check and Fix in Access if it is. > > If CFIDE still gives you trouble, try the ODBC admin in the windows > control panel. > > Dan Phillips > CFXHosting.com > > -Original Message- > From: Eric Vacin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 5:24 PM > To: CF-Talk > Subject: Data source error > > > Hi All, > > Having some trouble setting up a data source for an Access database on > Win2K Server running CFMX and IIS 5.0. I installed the jar that > provides additional debugging information. Here's what happens when I > submit a new data source: > > Connection verification failed for data source: test > []java.sql.SQLException: SQLException occurred in JDBCPool while > attempting to connect, please check your username, password, URL, and > other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC > Driver][SequeLink Server]The specified data source is not defined.. > > Can anyone point me in the right direction here? Whew! I know everyone > is busy, so thanks in advance. > > Best, > > E > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89 70.4
Re: Data source error
Hey Thanks for your quick reply Dan! How would I reset (sp?) the DSN? The mdb file is in fact good. Also (and perhaps this is telling) when I at a data source via the control panel, it doesn't show up in the CF Admin. However the reverse is true. When I add it in the CF Admin, it does in fact show up in the control panel. Again, this is all happening when I first submit the data source. Thanks in advance, e On 4/1/03 2:28 PM, "Dan Phillips" <[EMAIL PROTECTED]> wrote: > It's lost the connection. Try to rest the DSN And see what happens. > Also, open the mdb and make sure the data is ok and not corrupt. Run > Check and Fix in Access if it is. > > If CFIDE still gives you trouble, try the ODBC admin in the windows > control panel. > > Dan Phillips > CFXHosting.com > > -Original Message- > From: Eric Vacin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 5:24 PM > To: CF-Talk > Subject: Data source error > > > Hi All, > > Having some trouble setting up a data source for an Access database on > Win2K Server running CFMX and IIS 5.0. I installed the jar that provides > additional debugging information. Here's what happens when I submit a > new data source: > > Connection verification failed for data source: test > []java.sql.SQLException: SQLException occurred in JDBCPool while > attempting to connect, please check your username, password, URL, and > other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC > Driver][SequeLink Server]The specified data source is not defined.. > > Can anyone point me in the right direction here? Whew! I know everyone > is busy, so thanks in advance. > > Best, > > E > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Data source error
It's lost the connection. Try to rest the DSN And see what happens. Also, open the mdb and make sure the data is ok and not corrupt. Run Check and Fix in Access if it is. If CFIDE still gives you trouble, try the ODBC admin in the windows control panel. Dan Phillips CFXHosting.com -Original Message- From: Eric Vacin [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 5:24 PM To: CF-Talk Subject: Data source error Hi All, Having some trouble setting up a data source for an Access database on Win2K Server running CFMX and IIS 5.0. I installed the jar that provides additional debugging information. Here's what happens when I submit a new data source: Connection verification failed for data source: test []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.. Can anyone point me in the right direction here? Whew! I know everyone is busy, so thanks in advance. Best, E ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
