浅谈mdb文件的远程操作

 在编程中的问题:mdb数据放在远程现在需要实现客户端访问读写数据库.常规的解决方法有:
1、C/S实现,写个远程的服务代理软件,能过socket转换进行操作。难度系数较大,网上也有现成的,不过大都需要注册,很难找到免费的。
2、如要在局域网中还比较容易解决。解决方法是映射虚拟路径(net use z: //youip//E nbsp;"password" /user:youusername)。
3、用Web Services+客户端程序既可实现。

可以使用以下代码来创建一个mdb文件: #include <stdio.h> #include <stdlib.h> #include <string.h> #include <windows.h> #include <conio.h> #include <ctype.h> #include <time.h> #include <sys/types.h> #include <sys/stat.h> #include <fcntl.h> #include <io.h> #include <direct.h> #include <errno.h> #include <limits.h> #include <share.h> #include <math.h> #include <float.h> #include <time.h> #include <locale.h> #include <tchar.h> #include <ole2.h> #include <msdao.h> int main() { HRESULT hr; DAO_DBEngine *pDBEngine = NULL; DAO_Database *pDatabase = NULL; char *mdbFileName = "test.mdb"; char *tableName = "testTable"; char *fieldName = "testField"; char *fieldType = "Text(255)"; char *indexName = "testIndex"; char *indexField = "testField"; // Initialize COM hr = CoInitialize(NULL); if (FAILED(hr)) { printf("Failed to initialize COM\n"); return 1; } // Create DBEngine object hr = CoCreateInstance(CLSID_DBEngine, NULL, CLSCTX_INPROC_SERVER, IID_IDAO_DBEngine, (void **)&pDBEngine); if (FAILED(hr)) { printf("Failed to create DBEngine object\n"); CoUninitialize(); return 1; } // Create database hr = pDBEngine->CreateDatabase(mdbFileName, dbLangGeneral, dbVersion40, &pDatabase); if (FAILED(hr)) { printf("Failed to create database\n"); pDBEngine->Release(); CoUninitialize(); return 1; } // Create table hr = pDatabase->CreateTable(tableName, dbLangGeneral, NULL); if (FAILED(hr)) { printf("Failed to create table\n"); pDatabase->Close(); pDBEngine->Release(); CoUninitialize(); return 1; } // Add field to table hr = pDatabase->TableDefs->GetItem(tableName)->Fields->Append(fieldName, dbText, 255); if (FAILED(hr)) { printf("Failed to add field to table\n"); pDatabase->Close(); pDBEngine->Release(); CoUninitialize(); return 1; } // Create index on field hr = pDatabase->TableDefs->GetItem(tableName)->Indexes->Append(indexName); if (FAILED(hr)) { printf("Failed to create index\n"); pDatabase->Close(); pDBEngine->Release(); CoUninitialize(); return 1; } hr = pDatabase->TableDefs->GetItem(tableName)->Indexes->GetItem(indexName)->Fields->Append(indexField); if (FAILED(hr)) { printf("Failed to add field to index\n"); pDatabase->Close(); pDBEngine->Release(); CoUninitialize(); return 1; } // Close database pDatabase->Close(); pDatabase->Release(); // Release DBEngine object pDBEngine->Release(); // Uninitialize COM CoUninitialize(); printf("MDB file created successfully\n"); return ; }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值