SOT: ASG Safari ODBC and ColdFusion

Has anyone had any experience with ASG's Safari ODBC software?  We are in the midst of a Datatel Colleague migration and now at the point where we need to get data from the new system. Our goal is to install the Safari ODBC software on SQL and web servers to connect directly to our Unidata DB server. If anyone has any experience with this, we would certainly appreciate it. Thanks M!ke

I have been beating my head against thew was with the same problem We are able to sqlize unidata files, set a up a datasource in cf administrator. We're pulling some data but it's pretty ugly multivalued fields and the dates don't come back correctly. The datatel folks on campus just sort of shrug and say hmmm while my boss claims this should all be pretty easy. Hasn't been for me. I'd really like to talk to someone tha thas been or is going down this road. ----- Excess quoted text cut - see Original Post for more -----

Well, I'll start talking and say what I have done/learned so far. First, we are about three versions behind on Safari software.  I'm told that it is cost-prohibitive, at this time, to bring in Datatel support to upgrade the Safari installation on our servers.  This goes for both our server and client versions of Safari. We are able to connect to Safari, using its ODBC driver, to MS Access and MS SQL Server.  I have not yet really been able to connect using ColdFusion and the Safari ODBC driver.  I can get the datasource to validate, but I cannot successfully query a table. For now, I'm not so worried about using CF to connect to the tables since the connection is unbelievably SLOW!  I'm very unimpressed. So, my plan is to use SQL 2005 to extract the Datatel data on a nightly basis. I was told that if you create a view in Safari administrator, it will automatically convert multi-valued fields to separate tables/views in Safari. I have also heard that it is best if you create views/tables in Datatel before using Safari's features since the Datatel views/tables will have much-better performance. I have not yet seen the date problem you are having, but I don't really remember pulling any date fields to see how they would appear. We don't really have that much data in production, other than HR files, so I haven't done that much with it yet.  I hope to start pulling some stuff out in the next week or so. BTW, what version of Safari are you using?  What version of CF are you using? Thanks I have been beating my head against thew was with the same problem We are able to sqlize unidata files, set a up a datasource in cf administrator. We're pulling some data but it's pretty ugly multivalued fields and the dates don't come back correctly. The datatel folks on campus just sort of shrug and say hmmm while my boss claims this should all be pretty easy. Hasn't been for me. I'd really like to talk to someone tha thas been or is going down this road. ----- Excess quoted text cut - see Original Post for more -----