Moving to new server problem #2 - DRW when switching connection

[Steve Simek]

Here's an odd one. I have SQL on my new server, coming from Access on the
old. I think the ODBC connection is ok, seems to test ok. However, now I'm
trying to get the DRW to use the new connection. In my old server, at the
end of modifying the DRW it says "Do you want to regen"? I say no becuz the
report is nicely formatted my way. On the new server, I change connect to
SQL, and run thru DRW, but it always regens without asking. Major wrecking
of format. I tried to edit connect code, but FP yells at me. I'm editing
table, but no luck so far.
Why is it regenning without asking this time and what are my other options?
TIA
SS

 

[Stefan B Rusynko]

Don't use the wizards

- hand code your connection and DB output

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Here's an odd one. I have SQL on my new server, coming from Access on the
| old. I think the ODBC connection is ok, seems to test ok. However, now I'm
| trying to get the DRW to use the new connection. In my old server, at the
| end of modifying the DRW it says "Do you want to regen"? I say no becuz the
| report is nicely formatted my way. On the new server, I change connect to
| SQL, and run thru DRW, but it always regens without asking. Major wrecking
| of format. I tried to edit connect code, but FP yells at me. I'm editing
| table, but no luck so far.
| Why is it regenning without asking this time and what are my other options?
| TIA
| SS
|
|