关于odbc? 我在vc中使用了CDataBase类通过ODBC数据源来连接Access数据库,所以在制作安装程序时必须手动添加odbc数据源,请问怎么在安装过程中来实现此功能?或者有没有其它方法连接Access数据库? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你在安装的时候,将对方主机上的 %windir%\odbc.ini 给修改以下就行了。当然你再好先 检查一下 %windir%\odbcinst.ini 文件中有没有你的odbc驱动。 能具体描述一下过程吗,例如怎么指定Access数据库的路径等? 我给你说个方法,你手工增加一个odbc数据源,然后看一下增加前后以上两个文件的变化。access的路径在odbcinst.ini中已经指出来了,你找一下肯定可以找到的。 我是过了,两个文件的具体内容如下:odbc.ini:[ODBC 32 bit Data Sources]Xtreme Sample Database - CHS=Microsoft Access Driver (*.mdb) (32 λ)Visual FoxPro Tables=Microsoft Visual FoxPro Driver (32 λ)Visual FoxPro Database=Microsoft Visual FoxPro Driver (32 λ)MS Access Database=Microsoft Access Driver (*.mdb) (32 λ)Excel Files=Microsoft Excel Driver (*.xls) (32 λ)dBASE Files=Microsoft dBase Driver (*.dbf) (32 λ)CBA_EH_DB=Microsoft Access Driver (*.mdb) (32 λ)CBA_TL_DB=Microsoft Access Driver (*.mdb) (32 λ)test=Microsoft Access Driver (*.mdb) (32 λ)[Xtreme Sample Database - CHS]Driver32=C:\WINDOWS\SYSTEM32\ODBCJT32.DLL[Visual FoxPro Tables]Driver32=C:\WINDOWS\SYSTEM32\vfpodbc.dll[Visual FoxPro Database]Driver32=C:\WINDOWS\SYSTEM32\vfpodbc.dll[MS Access Database]Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll[Excel Files]Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll[dBASE Files]Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll[CBA_EH_DB]Driver32=C:\WINDOWS\SYSTEM32\ODBCJT32.DLL[CBA_TL_DB]Driver32=C:\WINDOWS\SYSTEM32\ODBCJT32.DLL[test]Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dllodbcinst.ini:[SQL Server (32 λ)]Driver=C:\WINDOWS\SYSTEM32\SQLSRV32.dllSetup=C:\WINDOWS\SYSTEM32\sqlsrv32.dll32Bit=1[ODBC 32 bit Drivers]SQL Server (32 λ)=InstalledMicrosoft Access Driver (*.mdb) (32 λ)=InstalledMicrosoft Text Driver (*.txt; *.csv) (32 λ)=InstalledMicrosoft Excel Driver (*.xls) (32 λ)=InstalledMicrosoft dBase Driver (*.dbf) (32 λ)=InstalledMicrosoft Paradox Driver (*.db ) (32 λ)=InstalledMicrosoft Visual FoxPro Driver (32 λ)=InstalledMicrosoft FoxPro VFP Driver (*.dbf) (32 λ)=InstalledMicrosoft dBase VFP Driver (*.dbf) (32 λ)=InstalledMicrosoft Access-Treiber (*.mdb) (32 λ)=InstalledMicrosoft Text-Treiber (*.txt; *.csv) (32 λ)=InstalledMicrosoft Excel-Treiber (*.xls) (32 λ)=InstalledMicrosoft dBase-Treiber (*.dbf) (32 λ)=InstalledMicrosoft Paradox-Treiber (*.db ) (32 λ)=InstalledMicrosoft Visual FoxPro-Treiber (32 λ)=InstalledDriver do Microsoft Access (*.mdb) (32 λ)=InstalledDriver da Microsoft para arquivos texto (*.txt; *.csv) (32 λ)=InstalledDriver do Microsoft Excel(*.xls) (32 λ)=InstalledDriver do Microsoft dBase (*.dbf) (32 λ)=InstalledDriver do Microsoft Paradox (*.db ) (32 λ)=InstalledDriver para o Microsoft Visual FoxPro (32 λ)=InstalledMicrosoft ODBC for Oracle (32 λ)=InstalledMicrosoft FoxPro Driver (*.dbf) (32 λ)=Installed[Microsoft Access Driver (*.mdb) (32 λ)]Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dllSetup=C:\WINDOWS\SYSTEM32\odbcjt32.dll32Bit=1[Microsoft Text Driver (*.txt; *.csv) (32 λ)]Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dllSetup=C:\WINDOWS\SYSTEM32\odtext32.dll32Bit=1[Microsoft Excel Driver (*.xls) (32 λ)]Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dllSetup=C:\WINDOWS\SYSTEM32\odexl32.dll32Bit=1[Microsoft dBase Driver (*.dbf) (32 λ)]Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dllSetup=C:\WINDOWS\SYSTEM32\oddbse32.dll32Bit=1[Microsoft Paradox Driver (*.db ) (32 λ)]Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dllSetup=C:\WINDOWS\SYSTEM32\odpdx32.dll32Bit=1[Microsoft Visual FoxPro Driver (32 λ)]Driver=C:\WINDOWS\SYSTEM32\vfpodbc.dllSetup=C:\WINDOWS\SYSTEM32\vfpodbc.dll32Bit=1[Microsoft FoxPro VFP Driver (*.dbf) (32 λ)]Driver=C:\WINDOWS\System32\vfpodbc.dllSetup=C:\WINDOWS\System32\vfpodbc.dll32Bit=1[Microsoft dBase VFP Driver (*.dbf) (32 λ)]Driver=C:\WINDOWS\System32\vfpodbc.dllSetup=C:\WINDOWS\System32\vfpodbc.dll32Bit=1[Microsoft Access-Treiber (*.mdb) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odbcjt32.dll32Bit=1[Microsoft Text-Treiber (*.txt; *.csv) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odtext32.dll32Bit=1[Microsoft Excel-Treiber (*.xls) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odexl32.dll32Bit=1[Microsoft dBase-Treiber (*.dbf) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\oddbse32.dll32Bit=1[Microsoft Paradox-Treiber (*.db ) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odpdx32.dll32Bit=1[Microsoft Visual FoxPro-Treiber (32 λ)]Driver=C:\WINDOWS\System32\vfpodbc.dllSetup=C:\WINDOWS\System32\vfpodbc.dll32Bit=1[Driver do Microsoft Access (*.mdb) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odbcjt32.dll32Bit=1[Driver da Microsoft para arquivos texto (*.txt; *.csv) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odtext32.dll32Bit=1[Driver do Microsoft Excel(*.xls) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odexl32.dll32Bit=1[Driver do Microsoft dBase (*.dbf) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\oddbse32.dll32Bit=1[Driver do Microsoft Paradox (*.db ) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odpdx32.dll32Bit=1[Driver para o Microsoft Visual FoxPro (32 λ)]Driver=C:\WINDOWS\System32\vfpodbc.dllSetup=C:\WINDOWS\System32\vfpodbc.dll32Bit=1[Microsoft ODBC for Oracle (32 λ)]Driver=C:\WINDOWS\SYSTEM32\msorcl32.dllSetup=C:\WINDOWS\SYSTEM32\msorcl32.dll32Bit=1[Microsoft FoxPro Driver (*.dbf) (32 λ)]Driver=C:\WINDOWS\System32\odbcjt32.dllSetup=C:\WINDOWS\System32\odfox32.dll32Bit=1添加的是名为test的odbc数据源,但test的具体信息如指定的Access数据库文件在文件中则不能找到! 利用installshield可以实现,谢谢各位! 离个职,竟然最少要8个人签字 有没有不需要注册的窗口类 怎样在单文档程序(SDI)中实现清除屏幕这一功能? 想换程序学习的网友请进。 密友 讨论 MU 外挂 已经编好的DAO数据库访问程序,如果我修改了表的结构,应该应该修改什么地方才能对新的表进行读写? vc环境下如何外部调用exe可执行文件?最好给个例子。 一个关于Com组件的简单问题 哪位高手用过TMS的TCABFile控件? 是否有办法将某个Font的某个Size的任一字符打印到一个文件中,并将该文件以Bitmap格式存储? Internet还是数据库?? SDK初学者问题!(在线等候)
当然你再好先 检查一下 %windir%\odbcinst.ini 文件中有没有你的odbc驱动。
access的路径在odbcinst.ini中已经指出来了,你找一下肯定可以找到的。
odbc.ini:
[ODBC 32 bit Data Sources]
Xtreme Sample Database - CHS=Microsoft Access Driver (*.mdb) (32 λ)
Visual FoxPro Tables=Microsoft Visual FoxPro Driver (32 λ)
Visual FoxPro Database=Microsoft Visual FoxPro Driver (32 λ)
MS Access Database=Microsoft Access Driver (*.mdb) (32 λ)
Excel Files=Microsoft Excel Driver (*.xls) (32 λ)
dBASE Files=Microsoft dBase Driver (*.dbf) (32 λ)
CBA_EH_DB=Microsoft Access Driver (*.mdb) (32 λ)
CBA_TL_DB=Microsoft Access Driver (*.mdb) (32 λ)
test=Microsoft Access Driver (*.mdb) (32 λ)
[Xtreme Sample Database - CHS]
Driver32=C:\WINDOWS\SYSTEM32\ODBCJT32.DLL
[Visual FoxPro Tables]
Driver32=C:\WINDOWS\SYSTEM32\vfpodbc.dll
[Visual FoxPro Database]
Driver32=C:\WINDOWS\SYSTEM32\vfpodbc.dll
[MS Access Database]
Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll
[Excel Files]
Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll
[dBASE Files]
Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll
[CBA_EH_DB]
Driver32=C:\WINDOWS\SYSTEM32\ODBCJT32.DLL
[CBA_TL_DB]
Driver32=C:\WINDOWS\SYSTEM32\ODBCJT32.DLL
[test]
Driver32=C:\WINDOWS\SYSTEM32\odbcjt32.dll
odbcinst.ini:
[SQL Server (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\SQLSRV32.dll
Setup=C:\WINDOWS\SYSTEM32\sqlsrv32.dll
32Bit=1
[ODBC 32 bit Drivers]
SQL Server (32 λ)=Installed
Microsoft Access Driver (*.mdb) (32 λ)=Installed
Microsoft Text Driver (*.txt; *.csv) (32 λ)=Installed
Microsoft Excel Driver (*.xls) (32 λ)=Installed
Microsoft dBase Driver (*.dbf) (32 λ)=Installed
Microsoft Paradox Driver (*.db ) (32 λ)=Installed
Microsoft Visual FoxPro Driver (32 λ)=Installed
Microsoft FoxPro VFP Driver (*.dbf) (32 λ)=Installed
Microsoft dBase VFP Driver (*.dbf) (32 λ)=Installed
Microsoft Access-Treiber (*.mdb) (32 λ)=Installed
Microsoft Text-Treiber (*.txt; *.csv) (32 λ)=Installed
Microsoft Excel-Treiber (*.xls) (32 λ)=Installed
Microsoft dBase-Treiber (*.dbf) (32 λ)=Installed
Microsoft Paradox-Treiber (*.db ) (32 λ)=Installed
Microsoft Visual FoxPro-Treiber (32 λ)=Installed
Driver do Microsoft Access (*.mdb) (32 λ)=Installed
Driver da Microsoft para arquivos texto (*.txt; *.csv) (32 λ)=Installed
Driver do Microsoft Excel(*.xls) (32 λ)=Installed
Driver do Microsoft dBase (*.dbf) (32 λ)=Installed
Driver do Microsoft Paradox (*.db ) (32 λ)=Installed
Driver para o Microsoft Visual FoxPro (32 λ)=Installed
Microsoft ODBC for Oracle (32 λ)=Installed
Microsoft FoxPro Driver (*.dbf) (32 λ)=Installed
[Microsoft Access Driver (*.mdb) (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM32\odbcjt32.dll
32Bit=1
[Microsoft Text Driver (*.txt; *.csv) (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM32\odtext32.dll
32Bit=1
[Microsoft Excel Driver (*.xls) (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM32\odexl32.dll
32Bit=1
[Microsoft dBase Driver (*.dbf) (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM32\oddbse32.dll
32Bit=1
[Microsoft Paradox Driver (*.db ) (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM32\odpdx32.dll
32Bit=1
[Microsoft Visual FoxPro Driver (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\vfpodbc.dll
Setup=C:\WINDOWS\SYSTEM32\vfpodbc.dll
32Bit=1
[Microsoft FoxPro VFP Driver (*.dbf) (32 λ)]
Driver=C:\WINDOWS\System32\vfpodbc.dll
Setup=C:\WINDOWS\System32\vfpodbc.dll
32Bit=1
[Microsoft dBase VFP Driver (*.dbf) (32 λ)]
Driver=C:\WINDOWS\System32\vfpodbc.dll
Setup=C:\WINDOWS\System32\vfpodbc.dll
32Bit=1
[Microsoft Access-Treiber (*.mdb) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odbcjt32.dll
32Bit=1
[Microsoft Text-Treiber (*.txt; *.csv) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odtext32.dll
32Bit=1
[Microsoft Excel-Treiber (*.xls) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odexl32.dll
32Bit=1
[Microsoft dBase-Treiber (*.dbf) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\oddbse32.dll
32Bit=1
[Microsoft Paradox-Treiber (*.db ) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odpdx32.dll
32Bit=1
[Microsoft Visual FoxPro-Treiber (32 λ)]
Driver=C:\WINDOWS\System32\vfpodbc.dll
Setup=C:\WINDOWS\System32\vfpodbc.dll
32Bit=1
[Driver do Microsoft Access (*.mdb) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odbcjt32.dll
32Bit=1
[Driver da Microsoft para arquivos texto (*.txt; *.csv) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odtext32.dll
32Bit=1
[Driver do Microsoft Excel(*.xls) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odexl32.dll
32Bit=1
[Driver do Microsoft dBase (*.dbf) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\oddbse32.dll
32Bit=1
[Driver do Microsoft Paradox (*.db ) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odpdx32.dll
32Bit=1
[Driver para o Microsoft Visual FoxPro (32 λ)]
Driver=C:\WINDOWS\System32\vfpodbc.dll
Setup=C:\WINDOWS\System32\vfpodbc.dll
32Bit=1
[Microsoft ODBC for Oracle (32 λ)]
Driver=C:\WINDOWS\SYSTEM32\msorcl32.dll
Setup=C:\WINDOWS\SYSTEM32\msorcl32.dll
32Bit=1
[Microsoft FoxPro Driver (*.dbf) (32 λ)]
Driver=C:\WINDOWS\System32\odbcjt32.dll
Setup=C:\WINDOWS\System32\odfox32.dll
32Bit=1添加的是名为test的odbc数据源,但test的具体信息如指定的Access数据库文件在文件中则不能找到!