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
相关文档：
一、Access从Excel中导入数据
1.用到的Excel表的格式及内容
实现
OleDbConnection con = new OleDbConnection();
try
{
OpenFileDialog openFile = new OpenFileDialog();//打开文件对话框。
openFile.Filter = ("Excel 文件(*.xls)|*.xls") ......
在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 语句启用组� ......
Technorati 标签: VC,ListCtrl 原文地址：http://www.vckbase.com/document/viewdoc/?id=1274 ADO操作access全过程和CListCtrl的用法
作者：张展明 下载源代码
一个ADO和CList的示例程序（程序中的tele.log即为access文件，可以直接更改扩展名后打开）:
使用ADO操作access数据库.增加,删除,修改,查询 ......
mysql 明明已经装好了，但是无法访问。链接的时候 总是说
Access Denied.
解决方法：
用mysqld --skip-grant-table启动mysql
然后在mysql库中执行这个
INSERT INTO user VALUES ('localhost', 'root', PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y', ......
