> I realize that this isn't the list for this question but > I'm not sure where else to post it... I apologize for the > off-topic post.
No need to apologize, but you'd be better off posting it to cf-server or cf-talk than cf-linux, I suspect. > The older versions of CF would use my system DSNs as CF > DSNs but CF MX doesn't seem to do that. The CF DSNs which > were automatically registered during installation appear > in the system DSNs control panel but none of the DSNs I > have added appear in the CF Data Sources page. > > When I try to register my DSNs via CF Administrator I always > get strange errors such as: > []java.sql.SQLException: SQLException occurred in JDBCPool > while attempting to connect, please check your username, > password, URL, and other connectivity info. > The root cause was that: java.sql.SQLException: SQLException > occurred in JDBCPool while attempting to connect, please > check your username, password, URL, and other connectivity > info. 1. What type of databases are you trying to connect to? 2. Are your two CF ODBC services running? I ran into a problem where I couldn't connect to MS Access databases, because I couldn't start these two services. The solution in that case was to uninstall CF MX, delete the CFusionMX directory, and reinstall CF MX - some software I'd subsequently installed had apparently killed these services. > And there are no drivers available for some DB types that I > need to use as DSNs, such as FoxPro. That's what the "ODBC Socket" option is for. It's a generic ODBC connector. You'd need to create an ODBC datasource, then create an ODBC Socket datasource in CF MX that points to the actual ODBC datasource, I think. > Any advice on this issue or do I need to go back to CF 4.5? I'd recommend dumping Foxpro first, myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
