NO INTERNET CONNECTION
this is very frustrating: i am unable to connect to the internet - heres the
my system runs xp sp2 with an msi motherboard (ms 7093, ati radeon xpress
200, athlon 64 bit, rs480m2 (socket 939)), realtek alc658c audio that uses a
realtek ac'97 driver and a creative sb x-fi soundcard, a siemens speedstream
4100 modem, a realtek 8139 family pci fast ethernet nic and a d-link g510
wireless pci adapter.
my device mgr indicates that under network adapters, i have working a 1394
net adapter, d-link adapter, and a rtl8139. under "other devices," i only see
a yel...Hide divo error
I have the following formula in cells for future months. I would like to
hide he divo result for months wihout data.
my formula is =F37/SUM(F37:F38)
I tried to enter this as =IF(ERROR(F37/SUM(F37:38)),"-",F37/SUM(F37:38) as I
found in online help. This formula does not work either.
Can anyone give me the correct formula to hide the divo error message for my
Try this one:
"Cassie Rodgers" wrote:
> I have the following formula in cells for future months. I ...How can I monitor open database connections?
I need to resolve some issues with a website which is leaving database
connections open, according to the hosting company!
The ASP code is quite extensive, and it's going to be quite a job
trawling through it.
Is is possible to see a count of the open database connections? That
way I could monitor this while using the website, to pinpoint the
pages that are leaving open connections.
Would connection pooling leave open connections, even though they are
closed in code?
Thanks in advance.
You can query the database to see how many active connections
there are. But ASP normally uses...Install SQL 2008 express sp1
I download SQLEXPR_x86_ENU.exe (sql 2008 express sp1)from microsoft but do
not know how to install sp1 from this exe file.
Can someone help me? Is there any site can download sp1 only?
Message posted via SQLMonster.com
aspfun via SQLMonster.com (u53138@uwe) writes:
> I download SQLEXPR_x86_ENU.exe (sql 2008 express sp1)from microsoft but do
> not know how to install sp1 from this exe file.
> Can someone help me? Is there any site can download sp1 only?
Have a look at
http://www.google.se/#hl=sv&so...Total Failure of CRM/SQL
I am (was) running CRM 1.2 and SQL 2000 SP3 on the same box when CRM
started acting funny and finally i couldn't access the web interface
anymore. The box was still running (W2K3)so I backed up the databases
with NT backup. Now, i rebuilt the server and have tried
unsuccessfully to restore the CRM data following the IG. Any
Do you have a backup of the sql database? If you have a
backup of the database you can restore and do a reinstall
of CRM, dont try to restore the crm program as well. Just
restore the database, install CRM and point it to the
>-...Running CRM client as normal user. Getting SQL errors (offline mode)
I'm at a company where they have a policy to not make users
administrator. Also I have administrator rights, but no access to CRM,
so I can install the client, but that's about it.
Several of the users have gotten an offline installation but now get the
message 'Action microsoft.crm.config.common.install databaseAction
create database permission denied in database master'.
Any idea how to solve this?
Also have 1 or 2 with a 'SQLDumper library failed initialization. Your
installation is either corrupt or has been tampered'. Please uninstall
then re-run set...String TO xml (xml string)
I am trying to take a string and convert it to a data
source. The string is Xml that I am pulling out of
sharepoint and looks like this:
<Field FromBaseType="TRUE" Type="Choice" Name="Status"
This is about all I have come up with but of course it
String xmlData1 = oList.Fields.Get...Hiding exchange alias in adress list OWA
we are using exchange 2003 and I need to hide or remove the alias from the adress list
I have removed it from the template, but when searching in adress list in OWA alias is still there
Someone has any ideas on how to remove alias from OWA aswell
thanks in advanc
I suggest you change the Alias to something unclassified. There is no
requirement that it have any relevance.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Joakim Larsson" <email@example.com> wrote in message
news:E1E41BF2-5A97-4BD8...Get ID control value from string
I need to get the ID value for a lot of controls in orde
to modify caption for each one.
those controls are not in continius order, so I can use
ID number from resourde and add x value.
so, how can I get resourde number from an ID in string
CString str1 = "ID_STATIC_V1" /* = 1095 */
int value = ????? should be 1095 but how to get this
value from ID_STATIC_V1 ... V10 /* 1095, 1098, 1112,
thanks in advance for your help.
"Eduardo" <firstname.lastname@example.org> wrote in message
> I need to get the ID val...Subquery help for the sql defficient
Looking for a little help with what is probably a simple problem.
I am looking to create a subquery that returns all columns in a table
but for only a subset of the total records. If I run a simple query
and return two fields [s duns#] and [add_1] I return all records in
the dataset 2400ish. the [s duns#] represents a specific company site.
I would like to return a single combination of [s duns#] and [add_1]
for each unique [s duns#], but since there are multiple formats for
each address I don't have uniqueness. Which address is picked doesn't
really matter, I simply want to return one...Problem connecting Win XP SP2 to exchange server
I am trying to connect outlook 2003 on Windows XP SP2 (rtm) computer to an
Exchange 2003 server. The computer is not part of the domain so I get a
login screen when I am trying to connect to the server via Outlook.
The problem is that I am using the correct user/pass but it still does not
connect. When I am trying to access a shared drive on the exchange server
from this computer I am using the same user/pass and it allows me to access
Any idea how to solve it ?
Thanks for your time
"ra294" <email@example.com> wrote:
>I am trying to connect...In Access, How do I hide records, but include them in the total
I'm running a report where I have work orders. They are grouped by appr and
comp. I need to create a report that will show all the appr tickets, but
give me a total count of appr and comp. I have the report generated the way
I want, with total count, but how do i hide just the comp tickets.
>I'm running a report where I have work orders. They are grouped by appr and
>comp. I need to create a report that will show all the appr tickets, but
>give me a total count of appr and comp. I have the report generated the way
I have the following lines of code in the GridView.RowDataBound event
do I fix the first line of code below to allow for single quotes?
seldata = "userSelected('" + strCustName + "','" + strCustCompany +
"', '" + strAddress + "')"
'test the code above by s...IE6
I inadvertently checked the "Do not show me this message again" box,
but, as I like to know when I am being re-directed to or from a secure
site, I would like to re-enable it. Is is possible, please?
> I inadvertently checked the "Do not show me this message again" box,
> but, as I like to know when I am being re-directed to or from a secure
> site, I would like to re-enable it. Is is possible, please?
Have you looked at the settings for the security zone (probably the Internet
security zone) under which the unidentified web...Linq to sql - object designer
I have a winform and a few texteditfields. These are bound to the
result from a linq query:
var person = ProjectGlobal.rd.ER_Persons.Single(c => c.LogonId ==
The query gets the person of the entered logon-id. Next, the persons
departments are feched:
var sections = from s in ProjectGlobal.rd.ER_Person_Sections
where s.Person_Id == person.Person_Id
The results from this query is databinded to a DataGridView. The
result columns is Person_Id and Section_Code. And these two columns
are then shown in t...SQL Error Help
I have the following SQL:
strSQL = "INSERT INTO taDEFENDANTS(TrusteeDefendantID)" & _
"VALUES(lngTrusteeDefendantID)" & _
"WHERE DefendantID=" & lngDefendantID & ";"
I get the following error:
Run-time error 3137:
Missing semicolon (;) at end of SQL statement
What am I missing that prevents the code from seeing the semicolon that is
Sorry if this is double posted. My system crashed right after I clicked
post and never saw the first posted.
What you are missing is ...Unable to connect to server #2
I can receive messages but when I try to send I
get "unable to connect to server"??
...CRM Laptop Client Connection Issue
Recently we registered ASP.Net2 on IIS in order to install a custom ASP.Net2
application on a CRM machine...
Afterwards all sorts of problems occured of which we couldn't connect to CRM
anymore. So we figured out that it could be an ASPNet version issue because
we found that the main Web Site and sub sites like Microsoft CRM 3.0 now were
using ASP.Net v2, so we changed these from properties, and we changed the
master Web Site from the Properties > Virtual Directory Configuration to
point to the Framework 1.4 rather than 2.0.
Now, we managed to get CRM back to work and we are a...hide a statusbar pane
How do I hide a CStatusBar pane?
I'm trying to show a progress bar on a pane of the status bar, which is a
snap. I'd like to make it the same way as it is in Internet Explorer: they
show/hide the pane whenever they need that. I tried to set the pane's width
to '0' in SetPaneInfo. It made the pane approx. 5 pixels wide. That was as
close as I could get to it. Any ideas would be appreciated.
Create a sample CView based SDI app. This feature already
comes via the menu handler
I will demo how to add your own code.
1) Add...Showing/Hiding Columns by clicking a button
I would like to write some smarter code to -
(a) initially hide columns C-I on Worksheets 1-3, then
(b) show only the columns selected by check boxes on each of those
Worksheets after pressing a button named 'SIB'.
What I am doing at the moment for is the following:
Private Sub SIB_Click()
Worksheets("Sheet2").Columns("A:A").Hidden = False
Worksheets("Sheet2").Columns("B:B").Hidden = False
Worksheets("Sheet3").Columns("A:A").Hidden = False
Worksheets("Sheet3").Columns("B:B").Hidden = False
Worksheet...extract data from middle / right of string
I have a column in a spreadsheet containing the following type of
330189149967 Ideal - Series 2 (DVD) 3 12.99 GBP 38.97 GBP
I would like to extract the number after the (DVD) in this string.
However, the set of characters (DVD) does not always appear in the
string. The only thing that is always constant is the number of spaces
before the 3 on the right of the string. So I think the best way to
extract the number is count 4 spaces from the right and return the
number after the 4th space. This number could also be more than 1
character which might make things difficult.
Tha...Re: limit numbers of connections to one server
hi there :-)
my pop3 server is limited to 10 query per sec. and per ip. i have abou
16 mail-accounts on this server. the last 6 allways error with timeou
is there a way to limit the number of connections to one server i
outlook 2002 on windows xp pro?
thanks a lo
Posted via http://www.mcse.m
View this thread: http://www.mcse.ms/message674073.htm
Set your send/receive settings to consecutive mail checks, rather than
conc...The remote server did not respond to a connection attempt #2
When sending an email to an external email account, the email gets stuck
with the above error. The domain name is inchltd.co.uk. I can send ok to it
via hotmail, but just not from my server. I have tried to telnet onto it, but
I am running SBS2003.
Hope you can help.
It must be a network connection issue. You can start with checking your DNS
server first and see if the it can resolve the remote domain correctly. If
yes, you will need to check your outbound/proxy server to see if there's any
"Scott Reading" <ScottReading@discussions.microsoft...Change Pivot Table Data-Source Connection
I have a fairly huge Pivot Table which source's its data from a SQL Server
I need to change this connection but keep the pivot table - I can't seem to
do this. When I click on Pivot table, then the back button to show the list
of tables, it won't allow me to go back another time to re-choose the actual
Is this possible?
My last resport is to re-create the whole Pivot table again, but I'm trying
to avoid this......
...Passing Param to GP Forms with VB.net
I am writting a form that when you click on a grid, you open up another form
with more detail (This form is a gp form.) and am trying to figure out how to
pass the info that need the for to open up with.
Casino Queen Inc.