|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Crystal Reports, ODBC & Access >> ODBC General Issues >> Funky Data With ODBC Connection http://www.istechforum.com/YaBB.pl?num=1197330619 Message started by JNAPIER on 12/10/07 at 16:50:19 |
|
Title: Funky Data With ODBC Connection Post by JNAPIER on 12/10/07 at 16:50:19 After our UPS Worldship forced an update on us, all of our ODBC connections are screwy. Excel will not open a table saying table doesn't exist. Crystal reports opens the tables, but I get this (434352204845414C544820434152452045515549504D454E542020202020) as the customer name. EVO works fine as well as looking at the tables with MDB and all looks good. I tried to recreate the ODBC DDF file and it ran fine but didn't change anything. The UPS link is screwed as well as the Fed-Ex Map. The UPS Install is on a workstation and not the server. The Problem does exist on all workststions. I sure hate UPS....................... :P Any Ideas? |
|
Title: Re: Funky Data With ODBC Connection Post by GasGiant on 12/11/07 at 06:04:57 When I have screwy problems with ODBC (usually after an Evo update) I have to restart the server. Then everything clears up. This does not sound equivalent, but it is all that I have. :-/ |
|
Title: Re: Funky Data With ODBC Connection Post by HB on 12/11/07 at 07:48:44 I noticed after updating the UPS software recently that the export file is in a different directory in the UPS installation. This required a remapping of the drive |
|
Title: Re: Funky Data With ODBC Connection Post by JNAPIER on 12/11/07 at 10:10:42 Keep the ideas coming gang ;) The UPS timing might just be a coincidence. Excel can not see the tables any longer but Crystal can refresh existing reports or change search criteria in them. New crystal reports do not bring in proper characters almost all numbers. Some fields are readable and are numbers. All EVO lookups, grids, MDB, searches or reports are all fine. I have no clue. The server and all workststions have been cold restarted. No errors reporting on any logs. No crashing or hanging. Pervasive 9 upgrade maybe? Reinstall the Server side of 2000I? Shoot the *&%$#@ ? John |
|
Title: Re: Funky Data With ODBC Connection Post by JNAPIER on 12/11/07 at 17:04:41 Still fighting this thing. Reindex the file didn't work. Uninstall and reinstall both Server and Client Pervasive, didn't help. Downloaded and installed Pervasive 9.5x as a demo. No different. Using the DEMODATA file set from pervasive and everything in Excel, Crystal and Pervasive work and look fine? I an SOOOOO out of Ideas at this point. Recap EVO works fine Crystal Reports only works on existing reports. Not newly created ones. Excel will not import at all and existing Queries do not work. MDB sees all data fine. Pervasive utilitie sees garbage in the fields. Pervasive Rebuild works fine with no errors found. John |
|
Title: Re: Funky Data With ODBC Connection Post by GasGiant on 12/12/07 at 06:08:47 Hmmmmmm...... How about remaking the DDF files that ODBC uses (ODBCDDF.RUN?) |
|
Title: Re: Funky Data With ODBC Connection Post by kkmfg on 12/12/07 at 06:11:55 Have you tried deleting the DSN's and recreating them? |
|
Title: Re: Funky Data With ODBC Connection Post by kkmfg on 12/12/07 at 07:00:02 GasGiant wrote:
Seems like his first post in this thread says that he has already tried that though... |
|
Title: Re: Funky Data With ODBC Connection Post by GasGiant on 12/12/07 at 07:44:53 Ah, yes. Did you try smacking it? Might not help, but you'll feel better. |
|
Title: Re: Funky Data With ODBC Connection Post by JNAPIER on 12/12/07 at 16:36:18 kkmfg wrote:
Well, It seams that All 10 workstations had the same thing Jack em up. I deleted all DSN's from the server and recreated them first, no joy. I than deleted all DSN's from all the workstations and recreated them. Suck cess......... :-* It works again. The only remaining issue is redirecting all of the reports to the new DSN location. Which is a pain, but simple pain Thanks Gang, John |
|
Title: Re: Funky Data With ODBC Connection Post by David Waldmann on 12/13/07 at 06:44:50 JNAPIER wrote:
Do you have a mass-change method, or what? |
|
Title: Re: Funky Data With ODBC Connection Post by JNAPIER on 12/13/07 at 10:13:37 David Waldmann wrote:
Do you have a mass-change method, or what?[/quote] Even Better, A very willing young Assistant that likes to :-*kiss A$$. He should be done next year some time ;D ;D ;D John |
|
Title: Re: Funky Data With ODBC Connection Post by David Waldmann on 12/13/07 at 10:33:15 And you are located where? :P |
|
Title: Re: Funky Data With ODBC Connection Post by Tim Goldstein on 12/13/07 at 11:07:30 Why not use the Same DSNs that you deleted? then all your reports will work correctly. Notice that Punctuation counts in DSNs i.e Crystal and crystal are not the same DSN. You can have DSN problems if you change versions of pervasive between the servers and workstations, i.e. 200i on the workstations and 9.5 on the server. they all have to be the same version. Also, I have seen problems when the DSN for the server was created from the workstation. Make sure you create your server DSNs on the server. Hope it helps, Tim |
|
Title: Re: Funky Data With ODBC Connection Post by JNAPIER on 12/13/07 at 11:19:48 Tim Goldstein wrote:
That is good to know, sometimes we tend to make things more complicated in our own heads. I like Simple :o Thanks Everyone... John |
|
Title: Re: Funky Data With ODBC Connection Post by David Waldmann on 12/17/07 at 05:46:02 Tim Goldstein wrote:
What about with a new server with the data on a different drive? That's my situation, and I thought that by using the same DSN it wouldn't know any difference. But apparently it does. |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |