• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • Last Modified:

.ASP and Excel 2007 code returning garbage characters

I have an ASP page where i use vb script to connect to an excel worksheet anemd range as a table and pull information out to display it. I was having an issue with it truncating the data so I implemented a fix to the registry on the server as follows:

- Logon to server and open Registry Editor;
3- Go to the key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel, make a backup and save on C:\SR20707440.reg;
4- Modify the TypeGuessRows DWORD value from 8 to 16 (in decimal);
5- Reboot the server;
 Now it shows something thatr i think may be stuff just pulled from ram on the server.

what it should read is:

See G7C-0907-00 for the >60kV Transformer Lifecycle calculation methodology for transformers with >60kV primary windings.  For units that show = 10 years life remaining: decrease oil sample intervals to 2/3 of those per CBE for younger units if the unit does not have an on-line DGA system. For units that show = 5 years life remaining per the tool: perform internal inspection at the next available shutdown, obtain a paper sample if possible, and adjust remaining life estimate based on the inspection and paper sample results.

but what it is displaying is:
See G7C-0907-00 for the >60kV Transformer Lifecycle calculation methodology for transformers with >60kV primary windings. For units that show <= 10 years life remaining: decrease oil sample intervals to 2/3 of those per CBE for younger units if the unit ?????????????????????????????????I"??ication/msoutlook

any idea why it would do this?
0
jlcannon
Asked:
jlcannon
  • 2
1 Solution
 
jlcannonAuthor Commented:
This was resolved by restarting the jet service on the server once the registry update was completed.
0
 
jlcannonAuthor Commented:
I was able to resolve the issue myself.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now