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
相关文档：
BOOL GetAllFields(_RecordsetPtr m_pRecordset,CStringArray & fieldsarray)
{
if (m_pRecordset)
{
if (m_pRecordset->State)
&nbs ......
以下为Access数据库关键字: 如果用到INSERT INTO 语句的语法错误。
-A
ADD
ALL
Alphanumeric
ALTER
AND
ANY
Application
AS
ASC
Assistant
AT
AUTOINCREMENT
Avg
-B
BETWEEN
BINARY
BIT
BOOLEAN
BY
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
......
昨天弄了一个比较棘手的问题。从网上下载了一个软件，他的数据库是access的，打开看了一下，感觉不错，适合我现在项目的需求，大部分能够满足我的项目需要，就想拿来主义。可是我们项目的数据库一直都是用的sqlserver，于是，就在网上疯狂的，找关于access转换为sqlserver的资料在这里我想说一下有关的注意事项：
数据库升 ......
在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 语句启用组� ......
分布式(Distributed)数据访问层(Data Access Layer)(以下简称DAL)是综合MySQL Proxy、Memcached、集群等等技术优点而构建的一个软件系统。目的是为了解决在构建大中型网站时遇到的和数据访问有关的诸多问题，如怎么使得切库分表透明化，如何使得缓存存取清除自动化，怎样才能更好地防止服务单点故障等等 ......
