I have a Dell PowerEdge server running SBS 2008, serving an office of 15-20 clients, of various spec s running windows XP.
I have recently and suddenly noticed a dramatic slowdown in the speed at which files are copied from the company shared network drive (v:) to a client machine. File transfer isn’t the main cause for headaches tho, users of access databases are having some very slow running queries and this is causing a serious...
ashwah
Last Activity: Nov 9 '11, 04:33 PM
Joined: Aug 1 '07
Location:
-
Slow File Copy Speeds From Server
-
PC won't connect to network
I have a XP PC that is attempting to join a small work domain controlled by a SBS2008 server. This machine was connecting to the network/internet before today but this morning the user informed me that it was no longer. All other machines on the network are connecting fine.
It is normally configured to automatically obtain an ip address, but on chosing that setting the connecting status is ‘acquiring network address’ for ages then... -
Ah a new week, and seem to have made this work!
Played about with authentication and permission group settings. Started getting a different error message:
"The server rejected the sender address server response was 550 5.7.1 client does not have permission to send as this sender"
So I chose a different sender address which had send-as permissions set.
Thanks -
Thanks ADezii, much appreciated. Don't have time to test this now as it's late on Friday but will play around with it next week. :)Leave a comment:
-
Help with sending emails from Exchange using CDO in VBA
Hi All,
I have been tasked with making an application in Access/VBA which can send emails. I am playing with some code that uses CDO to create and send the message via the server in the office which is running SBS 2008. What I have done so far worked ok with messages on my own domain but failed with the following error message if I attempted to mail an external address:
“The server rejected one or more recipient addresses.... -
ashwah started a topic Creating a class with a variable which is an array of objects from an other class.in AccessCreating a class with a variable which is an array of objects from an other class.
Hi there,
I have created a class called Pair which has 2 variable, char1 and char2, a bit like a 2d co-ordinate, (2,4),(1,8), etc... This seems to work ok. Heres my code:
...Code:Option Compare Database Private pChar1 As Integer Private pChar2 As Integer Public Property Get Char1() As Integer Char1 = pChar1 End Property Public Property Let Char1(Value -
Sorry, it's not SSID, it's SSIS. I just wondered if there an equivalent in Oracle. In fact I've heard there is but I don't know anything about it.
The situation is that we have commited to using an Oracle system. But we have a lot of jobs that could benefit from being scheduled in an intellegent way as in SSIS.
Any pointers would be apreciated,
AshLeave a comment:
-
Thes source is an Oracle Database back end of a workforce managent software package. Basically I'm going from Oracle to Oracle here. But with a view to using different DBs as the source in the future.Leave a comment:
-
Bulk Import of Data into an Oracle Database
I am in a position where I want to get a quantity of data into an Oracle database. My current attempt is using ADO and am finding it to be quite slow as I am looping thru the recordset and firing an INSERT command for each record.
The reason I am using this method is because I am running various bits of vba code at scheduled times and would like to inlcude this process in the same schedule.
Any idea of how I could speed... -
Thanks for your suggestion. I will look into it.Leave a comment:
-
Equivalent to SQL Server Integration Services
Hi,
I have recently been on a site visit to see a my conterpart department in another company and the demostrated the they used SQL Server Intergration Services to process data from a number of sources.
Is there an equivalent to SSID on Oracle? What options are there for scheduling jobs in general?
I am pretty new to Oracle so even the basic suggestions would be welcome!
Ash -
Basic Oracle Connection Question
Hi there,
I have made a few bit of code in VBA in the past connecting to Access databases but this is my first attempt to connect to an Oracle DB. My code is as follows, and it seems to fall down at the point of populating the recordset. The equivalent code works fine using an Access connection, hence I'm a bit stumped.
...Code:Public Sub oracleconnect() Set cn = New ADODB.Connection Set rs = New ADODB.Recordset
-
OK thanks. I still don't understand tho. Taking the program with ADO as an example, before I added the ADO stuff it worked ok on the PCs w/o .NET. It's only today that they ceased to work. Does this mean they DO have .NET? Theres no 'C:\Program Files\Microsoft .NET' folder on those machines but I guess theres a better way to tell, is there?...Leave a comment:
-
ashwah started a topic Why do my programs sometimes work on machines with no .Net installed on them?in .NETWhy do my programs sometimes work on machines with no .Net installed on them?
Hi All,
I'm using Visual Studio 2005 to make various tool for my work. The standard PCs around the office do not have .NET installed on them. Sometimes if I attempt to run my programs on them they work fine and other programs don't as a result of the missing .NET components. Can somebody explain what it is that determines whether they will run without .NET or not.
More specifically, I've made something which uses ADO...
No activity results to display
Leave a comment: