Upgrading to 9.0 on Windows Server 2003 64bit Edition
We are upgrading from 7.0 to 9.0. We have new SQL Servers on which we
will perform the upgrade and move into production once complete
replacing our existing servers. These SQL Servers are running Windows
Server 2003 Enterprise x64 Edition. When attempting to install either
GP v7.0 or v7.5 the error message "The image file ...\CDSetup.exe is
valid, but is for a machine type other than the current machine." is
presented and the installation script will not initialize. Is it
possible to install GP 7.0 or 7.5 on the 64bit version of Windows
Server 2003 or must we install the 32 bit v...Help with SQL Query 06-30-10
We have a distinct list of email addresses in alpha order and we need
to transform it from a single column into a grid of three columns
maintaining the alpha order. The list is contained in a temp table
inside of our query. We then use the temp table list and perform case
statement with a mod on the row_number in a select statement to
columnze the data. However, the columnar data contains a null value in
two of the three columns and we are needing to remove the nulls and
have the actual values on each row in the output.
Here is our current sql:
CREATE TABLE #tmpTable
( Email_Add...Updating 20k+ rows from Excel to access. vbscript? VBA? SQL?
Some of these rows only need a few columns updated, and others need
all of them updated. If possible if say row 800 column 'S' is filled
in the access DB but is blank on the excel spreadsheet, if possible i
like to keep the existing data in access and over right it with a
The spreadsheet is a export of the access DB, changes were made/merged
from other spreadsheets so the Unique ID is the same and in column A.
A script suggestions to complete this?
set dbe = createobj("dao.dbengine.36")
set db = dbe.openda...SQL Query
I'm trying to create a query that will result in receipt transaction
details from POP10310 combined with GL transactions from GL20000 and
so far no success. I assume I also need POP10300 in the mix. Which
field(s) should I be joining between GL20000 and POP10300 or PO10310?
Frank Hamelly, MCP-GP
NOVA Solutions LLC
Try using POP30310 instead. The receipt transactions would have to be posted
before anything got to GL20000.
"Frank Hamelly, MCP-GP" wrote:
> I'm trying to create a query that will result in receipt transaction
&...Exchange Server Backup
When using the Windows Backup utility on my 03 Exchange
Clustered server, there is no 'Microsoft Exchange Server'
option to check under the Backup tab (like the docs
show...only My Computer, My Documents, and My Network
Places). Any ideas why? I see no documentation saying I
need to do soemthing to make it appear. Thx
Is Exchange System Manager installed on the machine that you are trying to
run the backup from?
"John" <firstname.lastname@example.org> wrote in message
ne...Enterprise server with multiple organizations
Organization has CRM 4.0 Enterprise version with three diffrent organizations.
When CRM user goes to meeting with their client, they want "the big picture"
of the customer data from all of three CRM environmets.
Is it possible to build report, that gathers data from multiple CRM
organizations within one Enterprise server? If so, how many licenses/user is
If you are creating a report using SQL Reporting Services I can see no reason
why you could not connect to the 3 database and get data from each. Not sure
how you would know which records ar...SQL backup corrupted or unreadable
I did a backup of a 36GB SQL database to a USB hard drive, which completed
successfully. When I went to copy that backup to my archive server, at around
40% it errored aaying the file was unreadable or corrupted. Of course, I had
already deleted the database since I needed room on my server and thought I
had a good backup.
I've tried everything I know, including trying to undelete the databse files
from the server, which found nothing and running chkdsk on the USB drive. Of
course, when I did that, it showed the file as having 0 KB!
So am I hosed or what? is there anything e...Copying Data From SQL Into Excel
When I copy a range of data from SQL and paste it into
Excel, the data doesn't appear to be available for
formulas - in this case a VLOOKUP formula. However, once
I click in the formula bar (as if to edit the data) then
hit "return" the data is "magically" available for the
VLOOKUP formula. It seems to me to be a format problem,
but changing the format of the data doesn't help. Could
this be related to similar issues when copying data from
Access into Excel? Are there any workarounds?
It sounds similar to the Access problem. Instead of pasting, you can ...Re: Server address
When i set up my server account i put yahoo.com and i have Verizon for my
internet provider. I can't send my resume from yahoo cause i get an error
You can't access Yahoo POP3 accounts unless you have the Plus account.
Windows 7 Ultimate
"Donna Lomagro" <email@example.com> wrote in message
> When i set up my server account i put yahoo.com and i have Verizon for my
> internet provider. I can't send my resume fr...XML vs. SQL Database
I am developing a home project to be later released as an online
I am currently using XML to store game data, user/member data, and other.
Assuming a user base of 10,000 active users, is there a conflict if one
user is updating information and another user is creating data on the
same xml file?
User 1: update inventory that exists in the XML file
User 2: new user adding their inventory data in the XML file
Thanks for your help.
"Michael Jesse" <firstname.lastname@example.org> wrote in message news:tUVDd.13357$iC4.email@example.com....SOAP Server Application Faulted error 01-19-04
I get following error when creating a user in MS CRM 1.2 english:
"SOAP Server Application Faulted error" with the Error Code 80005000
The CRM installation works fine. I used a Domain Admin Account for the
MS CRM services.
I assigned a license to the Admin user. When I try to add users from
the AD using the User Manager in the Deployment Manager, I receive
this error. It is also not possible to add users using the CRM
Can anybody help?
Hi Ralf, can you give us the details of the SOAPException? This will likely
tell you what's wrong.
"Ralf M"...Duplicate emails on exchange server 5.5
Im using w2k server sp4, and exchange server 5.5 witn sp4 also Im suprised that some of the users are receiving duplicate emails local and internet and it is continously increasing and annoying to the user that they received the same kind of emails despite the fact that they read already. What seems to be the problem. Thank you very much in advance for your help.
>>receiving duplicate emails local and internet
local and internet? Are they different messages?
Is the user a member of a distribution list and are the messages sent to
the DL and the user?
> Im...Great Plains and P-Cards
Does anyone have any experience in integrating expense data from p-cards
used employees and the data received from the p-card issuer into either
the Great Plains GL or Payables Management modules?
What is a p-card?
Nowadays, used employees are simply discarded ...
but that is probably not what you were asking...
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
Share your knowledge. Add your favorite questions and answers
He...SQL to update Item.LastCounted based on PhysicalInventory.CloseTime
Because of a bug/deficiency/oversight in a third party inventory counting
application , I did a bunch of physical inventories that did not update the
Item.LastCounted field. I need this field updated so I can see the correct
date each item was counted last.
I am willing to do a seperate SQL statement for each physical inventory
sheet for which I have the problem.
For example, I want to take each item in the PhysicalInventoryEntry table
with PhysicalInventory.Code = '0000057' (or whatever the code is) and set
Item.LastCounted = PhysicalInventory.CloseTime.
I am not great at SQ...Setting email so server will not save emails on server
I have two computers. ( Desktop & laptop) I seldom use the laptop but when I
do use it and get my emails it brings up every email that I have already read
and deleted from desktop.
Is there a setting where I can set so the server will not keep the deleted
On both machines:
Tools | Accounts | Mail | Properties | Advanced - Check: Leave a copy of
messages on the server.
On one machine only, (The desktop would be logical for you), check to
Delete messages after X days to satisfy your allotted space you get from
your server, and Remove from server when d...Outlook client bandwidth to remote exch5.5 server
We are using exchange 5.5 and are going to get some clinets access the
server through our WAN links. They are going to use outllook 2000 and are
going to access the exchange server like if it was local. We have a huge
bandwidth pipe to our exchange server but I just want to how much bandwidth
would for example 60 clients take if they were accessing exchange 5.5
through the WAN link at the same time. Or for example how much bandwidth
would one outllook client take.
If you need to know more parameters please let me know.
On Tue, 16 Aug 2005 13:43:54 +0100, "gurvinder.nijjar"
<...Setting up an email server
I have an established 5.5 server and a I added a new domain to it.
All the routing looks good, I have the new MX pointing to the domain of my
external port on my firewall. And the new domain is added into Exchange.
But when I try to send an email to a new recipent using the new domain name
xx.xxx.xxx.xxx does not like recipient.
Remote host said: 550 Relaying is prohibited
Giving up on xx.xxx.xxx.xxx. Any ideas?
On Wed, 22 Feb 2006 18:57:41 -0700, "Need Help" <firstname.lastname@example.org>
>I have an established 5.5 server and a I added a new domain to it.
&...Trying to create completely server side, document merge
I was given the task of designing a complete web based
document prep system. In simplest terms (using a msword
explanation) create a database of merge fields, and a
library of templates. Allow the webuser to select the
template, merge his DB record, and produce a formatted
document that can be printed or downloaded.
We need to do this without specialized software on the
client, since it will be universally available to
webusers. We considered using PDF, but the creation of the
templates were painfully slow, and the datamerge had
severe space limitations (the form could not adequately...How to execute a parameterized Sql store procedure within Excel?
How to execute a parameterized Sql store procedure within Excel and pass the
Excel cell value as the parameter(s). Need to look at sample to understand
the concept, if any. Many thanks.
hi, Paul !
> How to execute a parameterized Sql store procedure within Excel and pass the Excel cell value as the parameter(s).
> Need to look at sample to understand the concept, if any. Many thanks.
see if any of the following is what you want...
Ed Ferrero: Run SQL Server stored procedure in Excel macro -> http://tinyurl.com/pdmg2
Robin Hammond: Stored procedures -> http://tinyur...Server settings for message addressee limit
How do you check/change the Exchange Server message
addressee(To)limit? When sending messages to servaral
recipients, some names are cut out. Thanks.
...Changed Server Numbers when Travel
I just had my outlook 2003AOL server numbers changed for no reason while
travelling. Switched them back for my pop account and the would work, when
shut down and then restart they would change from the correct to another set
of numbers. Is there a way to stop these server numbers from changing while
I travel. Thanks.
What is a 'server number'? The IP address?
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by email:
email@example.com...Why i keep on getting same message from mail server?
I'm using Microsoft Outlook, and have been getting message from server.
However, i have been keep on getting same message whenever i re-start the
is there any solulation on this matter?
your Outlook version is?
Have a look on this sites:
"Duplicate e-mail messages are downloaded from a POP3 e-mail server account
in Outlook 2003"
"Why does my Outlook keep receiving duplicate messages?"
Maybe it helps.
Share your Outlook PST files without Ex...eConnect Adapter for BizTalk Server 2006
I just would like to ask if any one of you guys have used the econnect
adapter for BizTalk Server. I have successfully installed the
econnect adapter for Biztalk, have done all the steps in the sdk
( added the econnect adapter in biztalk administration manager,
created a new send port, ect. ) but I keep on getting this error
unable to obtain service organization from the adapter
value cannot be null
parameter name: stream
I have searched google for possible solutions to this problem but have
found none. A lot of people using this econnect adapter encounter the
same error as I do and n...Outlook 2003 & Exchange 2000 Server
I have upgraded from Office XP to Office 2003 and all appeared to go well but now Outlook will not connect to the Exchange server. Reports error in conf for RPC. OWA stills works fine. Also when I try to add Exchange Server it reports that the server is not online, but it is. I have review everything on MS site but have found nothing that deals with this issue.
do you have these keys?
"...Can't See New Public Folders on Just Added Backend Exchange Server
I recently added a new exchange server to an existing site,admin group,
routing group. I am running in native mode. Now when I create new public
folders on the new server, my clients are not seeing it (all client mailboxes
are on the first server). It has been several hours now and they are still
not visible. Any ideas?