Well, I use a hosting company, so stuff like that is out of something I can do. :) I'll forward your suggestion along though. :) Thanks.
On Wed, Mar 24, 2010 at 1:57 PM, Won Lee <[email protected]> wrote: > > I'm really trying hard to remember...but I think the connector is part of > the db string. Open up each datasource in cfadmin. It also might be > installed to your JDK_Path/lib/ext. I might be off, both in pointing you > towards the JDBC connector and how to check which version you have. I have > no experience actually handling the connector. I just know that when my > data sets started to yield unexpected data I would have the server admins > check the connectors and often it was the cause. > > > > On Wed, Mar 24, 2010 at 4:17 PM, Phillip Vector > <[email protected]>wrote: > >> >> Datasource is correct and the application datasource is correct. >> >> I have no way to confirm the JDBC connectors. >> >> On Wed, Mar 24, 2010 at 12:37 PM, Won Lee <[email protected]> wrote: >> > >> > 1) check the datasource in cf admin. >> > 2) make sure the JDBC connectors are the same. In your case it doesn't >> seem >> > like it will be the issue but I would eliminate it as a possibility. >> > 3) check the application.dsn (or whatever you named it). Make sure it is >> > correct by cfdumping it. >> > >> > W >> > >> > On Wed, Mar 24, 2010 at 3:02 PM, Phillip Vector >> > <[email protected]>wrote: >> > >> >> >> >> When I run this on my server.. >> >> >> >> SELECT * FROM Accounting Where PromoCode = 'CNJ0009001' >> >> >> >> I get 6 results... >> >> >> >> This is a local Dev server I have set up. >> >> >> >> When i run it at my hosting company, I get 0 results for the same >> >> exact query. I go in and my external database program confirms the >> >> records are in there. The page works fine locally, but on the live >> >> site, it doesn't. >> >> >> >> Before I make a ticket, can anyone confirm perhaps a setting they >> >> heard of or some such that might be responsible or does anyone have >> >> any additional troubleshooting steps I may be missing? >> >> >> >> >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
