连接到Access数据库的问题： [英] Problems connecting to Access Database:

问题描述

Windows Vista

Visual Studio 2008 Team Suite

Microsoft Access 2007

错误：初始化字符串的格式不符合从索引0开始的规范

Windows Vista
Visual Studio 2008 Team Suite
Microsoft Access 2007
Error: Format of the initialization string does not conform to specification starting at index 0

我见过讨论
http://social.msdn.microsoft.com/Forums/en-CA/adodotnetdataproviders/thread/9f191038-dbf6-4306-8f66-ec211a1e933a  并且没有任何建议有帮助。

I've seen the discussion http://social.msdn.microsoft.com/Forums/en-CA/adodotnetdataproviders/thread/9f191038-dbf6-4306-8f66-ec211a1e933a and none of the suggestions help.

当我用
时1.点击"添加新数据源" "数据源配置向导"出现。

When I
1. Click "Add New Data Source" the "Data Source Configuration Wizard" appears.

2。我选择"数据库"，然后点击"下一步"。成功的数据连接可从以下屏幕的下拉列表中获得，但它们都不是我想要的。我点击"新建连接" "添加连接"出现对话框。

2. I choose "Database", then click "Next". Successful data connections are available from the dropdown in the following screen, but none of them are what I want. I click "New Connection" The "Add Connection" dialog box appears.

3. 我点击"更改"并选择条目"Microsoft Access数据库文件"。 我点击"确定"。

3.  I click "Change" and select the entry "Microsoft Access Database file".  I click "OK".

4。 "添加连接"对话框在顶部显示适当的选项，但下面的列表仅包含"Misc"类别。使用条目连接字符串。当我在旁边的框中键入连接字符串时，我可以单击"测试连接"。
并报告成功。但是，如果我单击OK，我会收到上面引用的错误消息。

4. The "Add Connection" dialog box displays the appropriate choice at the top, but the list below contains only the category "Misc" with an entry Connection String. When I type the connection string into the box next to that I can click on "Test Connection" and that reports success. But if I click on OK I get the error message quoted above.

我已尝试使用JET和ACE连接字符串（使用* .mdb resp。* .accdb文件），出现相同的错误消息。我已经检查并仔细检查了拼写，流浪角等等，并且没有发现任何错误。示例：

I've tried both with JET and ACE connection strings (with *.mdb resp. *.accdb files), the same error message appears. I've checked and double-checked spelling, stray characters, etc. and don't find any errors. Sample:

Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" D：\ Books\WordDev3Final\CD-ROM \Datenbank \ Nordwind.mdb" ;

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="D:\Books\WordDev3Final\CD-ROM\Datenbank\Nordwind.mdb";

当我在VBA过程中使用它通过ADO链接时，连接字符串可以工作。

The connection string DOES work when I use it in a VBA procedure to link via ADO.

我尝试修复Visual Studio安装没有快乐。

I tried a repair of the Visual Studio installation, no joy.

我还能尝试什么？

编辑：我在另一个安装上尝试了相同的操作，并在步骤中获得了完全不同的对话框4.上面。该机器上的连接没有问题。但我需要在我的主要开发机器上，而不是别人的。

I tried the same on another installation and got a completely different dialog box in Step 4. above. There was no problem with the connection on that machine. But I need this on my main development machine, not someone else's.

推荐答案

Hi Cindy，

Hi Cindy,

感谢您的帖子。

在您的第4步中，"添加连接"对话框应该这样：

In your step4 the "Add Connection" dialog box should like in this way:

你可以"浏览"您的.accdb文件，然后是"测试连接"----->成功

you can "Browse" your .accdb file, then "Test Connection"-----> success

>>>>>""添加连接"对话框在顶部显示相应的选项，
但下面的列表 仅包含 类别"其他"使用条目连接字符串。当我在旁边的框中键入连接字符串时，我可以单击"测试连接"。并报告成功。但是，如果我点击确定，我会收到
我收到上面引用的错误消息。

>>>>>The "Add Connection" dialog box displays the appropriate choice at the top, but the list below contains only thecategory "Misc" with an entry Connection String. When I type the connection string into the box next to that I can click on "Test Connection" and that reports success. But if I click on OK I get the error message quoted above.

连接字符串可能是这样的： （ " Provider = Microsoft.ACE.OLEDB .12.0 ;数据  Source = | DataDirectory | \users.accdb" ） 

Connection string may like this way:("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\users.accdb") 

有美好的一天。

 

这篇关于连接到Access数据库的问题：的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！