have you ever installed MSSQL on a server with Oracle already running ?

am i going to cause problems if i install MSSQL2005 on a server with Oracle already installed and running ?
thank youOracle and MSSQL on the same machine is possible without problems ?
have you experience about this ?

thank you
Dario|||I have them both on my dev box at home, but it's difficult to run them both simultaneously. They both grab a lot of memory, but especially oracle.

I only run the services simultaneously when absolutely necessary.

I would never run them on the same box in a production environment.|||I have an Oracle server and a SQL Server running on the same box in a production environment, but there's a couple of BIG catches:

1. The Oracle server (9iR2) is only being used for Oracle Enterprise Management services and as an RMAN catalog/repository. Nothing else. It's certainly NOT an OLTP machine;

2. The SQL Server is SQL 2005 Standard Edition and is the back end for SQL Reporting Services and WSUS (Windows Update Services). The Reporting Services install is used only for management reports (nothing goes to the outside world).

So, yes they can be installed on the same machine together. I wouldn't recommend it for anything that was mission critical (I can lose OEM, WSUS and Reporting Services and not impact production applications).

Regards,

hmscott|||THat server has 2Gbyte ram
Right now oracle.exe is using 430MB memory and java.exe 100MB of memory

I would install Sql Server 2005 Express edition (will not be used heavly)
do you think i should find another machine for this task ?|||it's not just the memory that's the issue. both will be competing for other resources such as disk and cpu.

my instinct is to put express on a separate server.

there's nothing to prevent you from trying it on the same server and reporting back here with your experience howerver ;)|||Well. It's quite possible to run both SQL Server and Oracle on the same computer, without any problems. However, as mentioned, they will compete for CPU, Memory, I/O and other resources, so the performance may drop quite a bit when both are executing queries at the same time. In a testing-environment this should really not be a too big issue. What I've done is going a bit further, installing SQL Server and Oracle in their own Virtual PCs. They still compete for resources, but it's easy for me to transfer one of the Virtual PCs to a different physical computer if I should need to do so.

If you end having Oracle and SQL Server on the same computer, please ensure that you configure both Oracle and SQL Server, so that they both get enough memory.

Handle TEXT FIELDS in Recordset Using ASP

hi there,

I have a problem when i tried to get data from mssql server using recordset in asp language. For example, i have table containing 5 fields. One of them is text field and the rest are varchar.

here i list the table structure (table name: Info):

Field Name Field Type Length

---

Name varchar 50

Gender varchar 50

Address text 16

Status varchar 50

Age varchar 50

---

Sample data inside table info.

Name Gender Address Status Age

---

Ali male MAL S 26

this is my code:

set rs = server.createobject ("adodb.recordset")

rs.open "select * from info", connectionstring

if not rs.eof then

name = rs("name")

gender = rs("gender")

address = rs("address")

status = rs("status")

age = rs("age")

end if

rs.close

what happend here, i managed to get name = Ali, gender = male but for address, status and age is nothing, just empty string.What was really happened, does anyone knows this problem.

If I change

rs.open "select * from info", connectionstring

to

rs.open "select * from info", connectionstring, 3

i managed to get all the info but i have to do a lot of code change for my program. Is there any solution to this problem?

i'm using win server 2003 and mssql server 2000

thanks for cooperation from you guys.

please accept my apologize for my bad language.

regards

kharulli

Firts you need to move all your BLOB-type fields to the end of the list of your fields in a selection list of the SELECT statement. It means your SELECT should look like

SELECT [Name], Gender , Status, Age, Address FROM ....

Now, after you query data, you need to get GetChunk method of the field to read the data in a case if it is longer than 255 characters. Otherwise you could use Value property

|||

thanks VMazur for quick replies,

I tried and its works. But it seems i must do a lot code conversion to overcome this problem. Its this MSSQL weaknesses or blob-type just work like this? Does MSSQL have a solution to this problem. Sorry to cause trouble to your guys in answering my post.

best regards

kharulli.

|||I believe this is how provider handles BLOB fields. They have to be at the end of your selection. Reason for this is, probably, memory allocation|||thanks for the info. it helped me a lot.