ISTech Support Forum - Funky Data With ODBC Connection

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Funky Data With ODBC Connection
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....................... Tongue

Any Ideas?

Back to top

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: Funky Data With ODBC Connection Reply #1 - 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.
Back to top	IP Logged

HB Full Member I love DBA Posts: 216 Gender:	Re: Funky Data With ODBC Connection Reply #2 - 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
Back to top	Helmut Bode General Pencil Co. DBA Classic 2004.1 w/IS Tech update 7/25/13 EVO-ERP Pervasive 11 Win2008 Server Terminal Server 12 Users IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: Funky Data With ODBC Connection
Reply #3 - 12/11/07 at 10:10:42

Keep the ideas coming gang Wink

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

Back to top

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: Funky Data With ODBC Connection
Reply #4 - 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

Back to top

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: Funky Data With ODBC Connection Reply #5 - 12/12/07 at 06:08:47 Hmmmmmm...... How about remaking the DDF files that ODBC uses (ODBCDDF.RUN?)
Back to top	IP Logged

kkmfg Senior Member Ghost of the code Posts: 411 Gender:	Re: Funky Data With ODBC Connection Reply #6 - 12/12/07 at 06:11:55 Have you tried deleting the DSN's and recreating them?
Back to top	Collin K & K Manufacturing, Inc EvoERP Version 1-22-10 SP3 5 User Workgroup Pervasive 10 IP Logged

kkmfg Senior Member Ghost of the code Posts: 411 Gender:	Re: Funky Data With ODBC Connection Reply #7 - 12/12/07 at 07:00:02 Quote from GasGiant on 12/12/07 at 06:08:47: Hmmmmmm...... How about remaking the DDF files that ODBC uses (ODBCDDF.RUN?) Seems like his first post in this thread says that he has already tried that though...
Back to top	Collin K & K Manufacturing, Inc EvoERP Version 1-22-10 SP3 5 User Workgroup Pervasive 10 IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: Funky Data With ODBC Connection Reply #8 - 12/12/07 at 07:44:53 Ah, yes. Did you try smacking it? Might not help, but you'll feel better.
Back to top	IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: Funky Data With ODBC Connection
Reply #9 - 12/12/07 at 16:36:18

Quote from kkmfg on 12/12/07 at 06:11:55:

Have you tried deleting the DSN's and recreating them?

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......... kiss

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

Back to top

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Funky Data With ODBC Connection Reply #10 - 12/13/07 at 06:44:50 Quote from JNAPIER on 12/12/07 at 16:36:18: The only remaining issue is redirecting all of the reports to the new DSN location. Which is a pain, but simple pain Do you have a mass-change method, or what?
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: Funky Data With ODBC Connection
Reply #11 - 12/13/07 at 10:13:37

Quote from David Waldmann on 12/13/07 at 06:44:50:

Quote from JNAPIER on 12/12/07 at 16:36:18:

The only remaining issue is redirecting all of the reports to the new DSN location. Which is a pain, but simple pain

Do you have a mass-change method, or what?

Even Better,

A very willing young Assistant that likes to kiss

kiss A$$. He should be done next year some time Grin

John

Back to top

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: Funky Data With ODBC Connection Reply #12 - 12/13/07 at 10:33:15 And you are located where?
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

Tim Goldstein

Full Member

'Cause sooner or
later everyone needs
a chief geek

Posts: 213
Gender: male

Re: Funky Data With ODBC Connection
Reply #13 - 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

Back to top

Tim

IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: Funky Data With ODBC Connection
Reply #14 - 12/13/07 at 11:19:48

Quote from 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.

Hope it helps,

Tim

That is good to know, sometimes we tend to make things more complicated in our own heads. I like Simple Shocked

Thanks Everyone...

John

Back to top

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged