12-04-2001
Well, if you wanted to run SQLServer (I am assuming Microsoft SQLServer), you could dual-boot, but keep in mind you would not be able to run them at the same time, generally speaking. Normally, when you dual boot, you are working with one OS, or the other. There are certain solutions (I think VMWare could do something like this), but keeping costs, details, and simplicity in mind, it's probably not the best solution.
If you accepted beforehand that you could only work with one at a time, it could be a very viable solution... Also, you could run multiple Unix SQL databases on the same machine at once (MySql, Oracle, PostgreSQL, etc...) without having to reboot to switch operating systems, although you would take somewhat of a performance hit running so much at once... Yet another twist on the latter option would be to have the databases set up, just turn each one on as you use it, and off again when you're done.
Lots of choices!
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello! All Unix Expert,
I just graduated from college with Bachalor degree in Computer Information System, and decided to start my career in Unix System. I am trying to set up my own unix Environment at home so that I can get more hand on experience since the class offered by unix vendors are... (1 Reply)
Discussion started by: jung1975
1 Replies
2. UNIX for Advanced & Expert Users
Hi,
I work at IT department of a home furnishing company in Canada. Presently we are working on printer issue on UNIX system and we like to set up a dummy printer on the system. We are not much sure about the procedure to try it and it woul dbe great if we get some advice to go ahead.
Thanks... (3 Replies)
Discussion started by: srabanti
3 Replies
3. UNIX for Dummies Questions & Answers
I was wondering if anyone has used VMWare Workstation? I wanted to practice and learn Unix in a networking environment and have my own home lab. However room and money prevent me from buying several computers to do so. Any input would help thank you. (0 Replies)
Discussion started by: vedder191
0 Replies
4. Shell Programming and Scripting
We are researching the possibility of using Oracle 10g Scheduler on Solaris 10 to launch scripts at our site, and the script that I am testing does not get $HOME (and other environment variables) set correctly. Here is the Korn shell script (show_info.ksh):
#!/usr/bin/ksh
id
env | sort
Here... (4 Replies)
Discussion started by: shew01
4 Replies
5. Solaris
hi can anybody give me a site that provide a free software for sun solaris workstation to test above title. i downloaded this RUMT-0.2 sofware in the net but it doesn't work after i try.
thnks a lot for any help. (1 Reply)
Discussion started by: jao_madn
1 Replies
6. UNIX for Dummies Questions & Answers
Hi Everyone,
Gud Afternoon.
Myself Amol working on unix (vi editor ).
I want to practice shell scripts and vi editor command at home.
So can anyone guide me, if there is any standalone application or some software like vi editor which can be installed at my home PC and i can... (9 Replies)
Discussion started by: Amol_Dicholkar
9 Replies
7. Solaris
Hi everyone!
I have an odd question - If a sun workstation (Blade 2000) boots up into a login prompt, is there any chance that it could have hardware issues? Or once it gets that far is it 100% working.
I cant play with it before buying, so was interested to see if anyone could shed some... (4 Replies)
Discussion started by: ajdiamond
4 Replies
8. UNIX for Dummies Questions & Answers
I want a cheap dedicated machine to install a flavour of unix on and try to learn this OS.
I know nothing about unix, just gone out and bought some books etc.
Should I just get the cheapest old laptop off Ebay to install it on?
What type of unix OS should I install?...a version of... (5 Replies)
Discussion started by: IBMPBC
5 Replies
9. UNIX for Dummies Questions & Answers
Hi I've just made a directory, what command do I use to now make it the base directory?
Thanks!!!!!!!!!!!!!!! (1 Reply)
Discussion started by: beckywatson
1 Replies
10. Shell Programming and Scripting
Could somebody please provide me with verbatim description / purpose of the following ?
set dummy $ac_prog; ac_word=$2
set dummy $ac_tool_prefix; ac_word=$2
could it be written
set dummy $ac_prog;
ac_word=$2
set dummy $ac_tool_prefix;
ac_word=$2 (9 Replies)
Discussion started by: anne
9 Replies
LEARN ABOUT PHP
oci_set_client_identifier
OCI_SET_CLIENT_IDENTIFIER(3) OCI_SET_CLIENT_IDENTIFIER(3)
oci_set_client_identifier - Sets the client identifier
SYNOPSIS
bool oci_set_client_identifier (resource $connection, string $client_identifier)
DESCRIPTION
Sets the client identifier used by various database components to identify lightweight application users who authenticate as the same
database user.
The client identifier is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL
statement is executed.
The identifier can subsequently be queried, for example with SELECT SYS_CONTEXT('USERENV','CLIENT_IDENTIFIER') FROM DUAL. Database admin-
istration views such as V$SESSION will also contain the value. It can be used with DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE for tracing and can
also be used for auditing.
The value may be retained across page requests that use the same persistent connection.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $client_identifier
- User chosen string up to 64 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the client identifier to the application user
<?php
// Find the application user's login name
session_start();
$un = my_validate_session($_SESSION['username']);
$c = oci_connect('myschema', 'welcome', 'localhost/XE');
// Tell Oracle who that user is
oci_set_client_identifier($c, $un);
// The next roundtrip to the database will piggyback the identifier
$s = oci_parse($c, 'select mydata from mytable');
oci_execute($s);
// ...
?>
NOTES
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
SEE ALSO
oci_set_module_name(3), oci_set_action(3), oci_set_client_info(3).
PHP Documentation Group OCI_SET_CLIENT_IDENTIFIER(3)