Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...crm 3.0 error 03-01-06
I'me getting this error while installing crm3.0 for SBS:
"error writing to file microsoft.mshtml.dll verify that you have access to
That file is in the C:\Program Files\Microsoft.NET\Primary Interop
I (and 'everyone') has full access to that dir.
What can I do about this??
...Macro for Sharepoint List and another Table?? Same # records?
I am creating a database which we have a form made up of prepopulated data
(from a sharepoint list) and also data input needed by a user (for example,
I have two tables: one sharepoint list that is linked to sharepoint website
and another table that houses the additional user inputs [table 2]. I have
linked the files based on the primary key. So, every record in my table 2
has a plus sign and it will expand and you will see the linked data from the
Is there a way that I can automatically create a record for every
corresponding record ...Error in Outlook Today
Whenever I go to Outlook Today, I get a runtime error,
line: 297 Error: Class Not Registered. Then I get the
error two more times when I click 'Customize Outlook
Today...' and the list 'Show Outlook Today In This Style'
is empty, and the box under it has a broken image icon.
What could be the cause of this?
Sorry...forgot to say...I'm using Outlook 2003 Student
and Teacher Edition on Windows XP.
>Whenever I go to Outlook Today, I get a runtime error,
>line: 297 Error: Class Not Registered. Then I get the
>error two more time...Re: 'Uknown Error 0x800CCC97'
I just heard back from the folks with whom I filed this bug. They say the
bug is fixed in cppop 5.4 - request that your ISP upgrade to that.
This posting is provided "AS IS" with no warranties, and confers no rights
"Jeff Stephenson [MSFT]" <email@example.com> wrote in message
> See the attached reply to another similar question. Your ISP's POP3
> has a bug, and they should get a fixed version of the server.
> Jeff Stephenson
> Outlook Development
> This posting...stop error defeating me
XP Pro PC. When I start the computer I can start in safe mode but when I try
to start in normal mode it loads to the log on screen. I type the username
and password in then it starts to load but stops after a few moments with a
blue screen. The error is Stop: c000021a (fatal system error)
The windows subsystem system process terminated unexpectedly with a status
of 0xc0000005 (0x7c9106c3 0x0055f36c).
Begininning dump of physical memory.
I have uninstalled AVG, also taken out the graphics card and uninstalled all
the drivers for it. I have also changed the RAM. I have also d...Error in database....
A user posted a batch in payables management. After posting, there was an
error encountered. It displays that the table updating was interrupted, use
batch recovery to continue the posting. But when I used the batch recovery,
it was not successful to continue the update process. When I click the "More
Details" button it displays, A save operation on table 'PM_Transaction_WORK'
caused a sharing error.
How can I resolve this issue?
John, it is a db sharing violation.
Have all users logout
DELETE dynami...RMS 1.2 vs 1.3, plus integrate with Great Plains
1.) I am working on an assessment for upgrading our current RMS software from
1.2 to 1.3. My assessment will take in account the benefits, broken down by
store operations (Retail) and the benefits to IT. Also, list risks and
potential problems that might be experienced. We currently have 28 stores
with 3+ registers per location with another 22 new stores on the schedule
over the next 2 years. Are their other in this group of similiar size that
have done this upgrade to the new version?
2.) If we do not upgrade the software, can we still integrate the RMS to
Great Plains? Would we...error 553
The following error occurs when sending email from my
business domain. It does not occur when sending through
my roadrunner account.
The following recipient(s) could not be reached:
on 10/22/2003 2:05 PM
553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
What does this mean and how can it be fixed?
...80070005 error #2
I am getting this error when trying to view public folder
property from system manager. My issue is same as what
you can find out from
Anyone has a clue?
...SUTA state message on Pay Code Integration
I'm having trouble importing pay codes that are based on another code, such
as Sick and Vacation. These records get rejected with the error message "pay
code 'V' requires a SUTA state". I have a SUTA state in the Emp Maint window
and the HOURLY pay code already exists and contains a SUTA state.
I tried mapping the SUTA State code in my file and even tried using a
Constant value in Destination mapping but these codes will not import. I can
go into the Pay Code Maintenance window and add these codes manually with no
What am I missing?
...me too, problem with import... only 15 records
me too, problem with import... only 15 records.... also in one of my
i need a fast answer....
I dont see a question to answer...?
JUAN MARKETING wrote:
> me too, problem with import... only 15 records.... also in one of my
> customers crm
> i need a fast answer....
Hehe yeah, what is the question!? what are you trying to import?
I don't know the reason, bu each time i try to import x number of accounts
or contacts, MSCRM only import 15 records... Promise, everything is ok...
columns, format csv from excel, size, records....
I say that, becau...Subquery
I'm trying to code a subquery on a table but to no avail...it's a very simple
table that has Date (short date, just recording the day) and NAV which is a
All I'm wanting to do is have a query that displays the Date, the NAV and the
NAV from the day before - only recording business dates. In other words, the
subquery number I want is the NAV from the record preceeding the current one.
I've got as far as the below, but that just gets the same NAV number as
SELECT tblNAV.Date, tblNAV.NAV, (SELECT LAST(x.NAV) FROM tblNAV as X LEFT
JOIN tblNAV on...Integration Transactions Pls help
Can anyone let me know how much time does the integration manager takes to
upload a 10,000 lines(SOP) into GP
There are two methods of importing SOP transactions. One uses the SQL
optimized adapter and one does not. The method used depends upon the data you
would need to map. There are some fields and business logic not available
with the SQL adapter.
But, assuming you are using the SQL adapter, you should be able to import
10,000 transactions in about 60 minutes or less. If you are using the other
one, start it and go home for the night. It will take hours.
If you have some reso...How to Identify Records with Overlapping Dates
I need to be able to systematically identify any instance where there are
overlapping date ranges in a data set. I need to pull records like those
listed below out of a larger data set. I previously posted a question similar
to this and was advised to pull the same table in a query, match on Member
Number, and qualify that the product code from TableA did not match product
code in TableA_1 where the Begin Date TableA was < Term date TableA_1 and
TableA_1 Begin Date < TableA End Date. Which worked great for me finding
overlapping records where the product was different, bu...Anyone use Promys CRM software integrated with GP Dynamics?
Our company is considering using Promys as a CRM to create quotes and
sales orders for the sales team. I am concerned about the integration
with GP and what the pitfalls may be. Is anyone here currently using
Promys with GP Dynamics?
...ACC: How to Display Line Numbers on Subform Records
I found this article on MS' website
but ran into problems when I pasted the code and tried to compile it. It
gives a Compile Error:
Method or data member not found
when it reached the line below:
RS.FindFirst "[" & KeyName & "] = " & KeyValue
and it highlights "FindFirst".
I have a sub-form (child) of a parent form's and I have a variable in the
child that the user currently manually increments from 1,2,3 and so forth.
Can this not be done w/o the user's intervention?
When a user replies to an CRM email, clicks the "reply" button or the "reply
all" button, clicks in the body of the email message and clicks
"insert template", this error appears.
This does not happen every time, and happens to various users.
Does anyone know why we would get this error?
...smtp authentification errors
I just installed Exchange 2003. It all works fine. I=B4m now=20
retrieving the emails via pop-con and pop3. However I=20
cannot send any authenticicated emails, because the=20
exchange server sends a wrong authentification account to=20
the mail provider, despite the fact, that the right one to=20
be used is enterd.
The mail provider tells me that he recives a smtp call,=20
but it=B4s aborted by his server.
We do not have a static IP but a dynamic IP, that changes=20
every 24 hours.
If a messages is sent to an existing hotmail account the=20
following error message is displayed in the ...#error in the calculated field
I locked the data entered for some users, because their role is just to
input the date of invoice for approval by Prj.Manager.
My qeustion is, is it the reason we see the "# error" in the VAT checking
field??. I tried to ck formula in the qrid query, nothing wrong
Thanks for your explanation
H. Frank Situmorang
On Tue, 15 Jan 2008 23:33:01 -0800, Frank Situmorang <firstname.lastname@example.org>
>I locked the data entered for some users, because their role is just to
>input the date of invoice for approval by Prj.Manager.
>My q...Error when changing average perpetual
I Have the following error in Microsoft Dynamics GP on the screen of average
perpetual "Message #10577 Missing" somebody knows about this???
I created a datbase for an archery tournament. Is there a way to easily
delete last years scores so I can start clean again this year without
deleting each score individually.
If you designed it properly to begin with you wouldn't need to delete
anything and could just move forward. But, barring that, you can just open
the tables and click the top left square where the columns and rows meet,
which should select all of the records and then hit your delete key
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
______________...Outlook MAPI (WMS idle error message while shutting down)
I am loading the mapi32/mapisp32 dll in my program.
When I shut down while my program is still running, I am getting "WMS
1. While shutting down, why i am not getting 'fnevCriticalError'
notification in my IMAPIAdviseSink class?? and
2. What exactly is causing the WMS Idle message ?
Any help will be appreciated...
...Excel.Range.Name gives error an exception
I am trying to execute below code but it gives me an COMException
///// Code Start ////
public string GetName(Excel.Range range)
if (range.Name != null)
Excel.Name name = range.Name as Name;
if (name.Name != null || name.Name.Length != 0)
///// Code End ////
Now every time my very third line "if (range.Name != null)" gives me
an except...WSDLReader error '80020009'
I have created an ASP page that calls a local webservice. Everything works
fine on my system but once it is deployed to the server I get the following
WSDLReader error '80020009'
WSDLReader:XML Parser failed at linenumber 0, lineposition 0, reason is:
WINHTTP5.DLL or higher must be registered to use the ServerXMLHTTP object.
HRESULT=0x1: Incorrect function. - WSDLReader:Loading of the WSDL file
failed HRESULT=0x80070057: The parameter is incorrect. - Client:One of the
parameters supplied is invalid. HRESULT=0x80070057: The parameter is