Web Server Access on a VirtualBox Guest
Web Server Access on a VirtualBox Guest
In: Computing 数码编程
7
Oct
2008
I been using VirtualBox to deploy virtual machines on my Windows
machine since a significant memory upgrade. VirtualBox is suprisingly
easy to used if compared to VMWare and it just fit to my basic needs.
Access the web server from the guest on host is pretty straightforward but not the other way.
In my scenario, my host OS is XP and the guest OS is Ubuntu. First,
we go to the XP host and open a command prompt, and configure the port
forwarding in the VirtualBox installation directory, as follows:
cd
C:\Program Files\Sun\xVM VirtualBox
VBoxManage setextradata MyUbuntu "VBoxInternal/Devices/pcnet/0
/LUN#0
/Config/apache/HostPort" 8888
VBoxManage setextradata MyUbuntu "VBoxInternal/Devices/pcnet/0
/LUN#0
/Config/apache/GuestPort" 80
VBoxManage setextradata MyUbuntu "VBoxInternal/Devices/pcnet/0
/LUN#0
/Config/apache/Protocol" TCP
This simply arbitrarily assign port 8888 of our host XP to forward
connections to the guest Ubuntu’s port 80, which is the default port
for HTTP connections.
Having done that, we now turn on our guest Ubuntu and use our web
browser on host XP to browse http://localhost:8888/. Alright, now we
got a local web server to play with.
We can also allowing SSH connections from the host OS to the guest OS as follows:
cd
C:\Program Files\Sun\xVM VirtualBox
VBoxManage setextradata MyUbuntu "VBoxInternal/Devices/pcnet/0
/LUN#0
/Config/ssh/HostPort" 2222
VBoxManage setextradata MyUbuntu "VBoxInternal/Devices/pcnet/0
/LUN#0
/Config/ssh/GuestPort" 22
VBoxManage setextradata MyUbuntu "VBoxInternal/Devices/pcnet/0
/LUN
相关文档：
熟悉SQL SERVER 2000的数据库管理员都知道，其DTS可以进行数据的导入导出，其实，我们也可以使用Transact-SQL语句进行导入导出操作。在Transact-SQL语句中，我们主要使用OpenDataSource函数、OPENROWSET 函数，关于函数的详细说明，请参考SQL联机帮助。利用下述方法，可以十分容易地实现SQL SERVER、ACCESS、EXC ......
uses
ADODB;
procedure TForm1.SetupTable(sender:tobject);
Var
adocon1:TADOConnection;
strSQL:string;
Const
SConnectionString= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;'
+'Jet OLEDB:Database Password=%s;';
begin
adocon1:=TADOConnection.creat(self);
adocon1.ConnectionString:=format(S ......
在SQL Server2005中选中要导入数据的库 > 右键 > 新建查询：
执行SQL语句如下：
insert into
目标数据库表名 (字段1,字段2,....) select
字段1,字段2... from
openrowset
('microsoft.jet.oledb.4.0',';database=源数据库路径（如：d:\test.mdb）','select * from 源表 where 查询条件')
SQL 语句启用组� ......
/************************************************************************
* Description: 访问zip中的htm 之 Widgets学习
* Author: 陈相礼
* Compiled: VC8 + wxWidgets2.8.10
* Date: 04/02/10
************************************************************************/
/******************************** ......
access日期和时间函数
access日期和时间函数
------------------------------------------------
设置当前日期或时间。 Date ,Now, Time
计算日期: DateAdd, DateDiff, DatePart
返回日期: DateSerial, DateValue
返回时间: TimeSerial, TimeValue
设置日期或时间: Date, Time
计时: Timer
在帮助 ......
