Ok maybe the problem is more involved.
I did a more basic query
<cfquery name="getreport" datasource="FSDB">
SELECT * FROM ITEM_HISTORY
</cfquery>
<cfdump var="#getreport#">
Problem is that the target table is a linked ODBC table. Will coldfusion not work with this?
I am having a problem getting this query to work. Database type is Access.
<cfquery name="getreport" datasource="FSDB">
SELECT DISTINCTROW (Right(Left([BODY1],13),8)) AS [NewOrder], Min(ITEM_HISTORY.DATE) AS [TranDate] INTO [BookingsTable]
FROM ITEM_HISTORY WHERE (((ITEM_HISTORY.TRANS_ID) Like...
ISAuser:
Sounds like a gateway issue or routing issue. Do you have a firewall? Are you translating a static for you address? You can do a NSlookup. That proves that whatever machine you are connected to for the lookup is abloe to get out fine. Are you using internal DNS? If you cant browse the...
I was in your situation. What I did was install and keep the new 2003 server in the same org. I moved the mailboxes over to the new server then all pub folders. Set up SMTP connector and just changed the static translation on my FW. Worked without a problem.
Whats about service providers? Is there any good service providers to go through? If I had a T1 data line and a VoIP PBX could I just use that T1 for my outgoing local/long distance calls? Anybody know of any reliable VoIP providers?
Have you tried just restarting Exchange Services instead of reboot? I wonder if we could get this narrowed down to a service. Or instead of rebooting, try to do a IPconfig /flushdns from a comman prompt. Youve got me hooked on your problem again until another one of mine comes along.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.