User (Legacy) Posted August 6, 2002 Report Share Posted August 6, 2002 Has any ColdFusion users successfully connected ChartFX to SQL Server? If so, I would really appreciate a copy of your complete connection string. There aren't any examples on the ChartFX site, and the documentation is no help. My attempts have thus far failed, mainly with "invalid username/password; logon denied". Thanks, Leonce Link to comment Share on other sites More sharing options...
Software FX Posted August 6, 2002 Report Share Posted August 6, 2002 How are you connecting to SQL in the pages that do not have any charts ? Are you using ADO ? -- Regards, JC Software FX Support "Leonce" <leonce.lionnet@ramstein.af.mil> wrote in message news:MIuSd0TPCHA.1280@webserver1.softwarefx.com... > Has any ColdFusion users successfully connected ChartFX to SQL Server? If > so, I would really appreciate a copy of your complete connection string. > There aren't any examples on the ChartFX site, and the documentation is no > help. My attempts have thus far failed, mainly with "invalid > username/password; logon denied". > > Thanks, Leonce > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 7, 2002 Author Report Share Posted August 7, 2002 For all webpages, I use ColdFusion's native ODBC connection. I never use dynamic connection strings since CF is already connected to the databases as specified in the CF administrator. It would be nice if ChartFX would use the CF connection to the databases, but if it can't, I'll use whatever works. I just can't get it to work. Working examples are the greatest productivity tools. The ones on theChartFX website are great, but there are fewer examples of CF than ASP. Thanks, Leonce "Software FX Support" <support@softwarefx.com> wrote in message news:OI#nmkYPCHA.1276@webserver1.softwarefx.com... > How are you connecting to SQL in the pages that do not have any charts ? Are > you using ADO ? > > -- > Regards, > > JC > Software FX Support > "Leonce" <leonce.lionnet@ramstein.af.mil> wrote in message > news:MIuSd0TPCHA.1280@webserver1.softwarefx.com... > > Has any ColdFusion users successfully connected ChartFX to SQL Server? If > > so, I would really appreciate a copy of your complete connection string. > > There aren't any examples on the ChartFX site, and the documentation is no > > help. My attempts have thus far failed, mainly with "invalid > > username/password; logon denied". > > > > Thanks, Leonce > > > > > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted August 7, 2002 Author Report Share Posted August 7, 2002 JC, this morning after a good night's sleep, figured it out. Since ColdFusion has already established a connection to all the databases at startup, I simply removed the Logon and Password references from the connection string. However, I still feel that we could use more CF specific examples. In particular, can we pass the results of a CFQUERY to ChartFX, or must we use Conn.Execute and Conn.AdoResultset combination? Thanks, Leonce Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.