2.8之前的ADODB版本有aproblem识别新的日期数据类型在SQL Server 2008中引入。

ADODB versions prior to 2.8 had aproblem recognizing the new Date datatype introduced in SQL Server 2008.

所以，检查以下内容：

1. 确保您正在使用连接字符串中的本机 SQL Server提供程序（ NOT OLEDB SQL提供者），因此它应该是类似于Provider = SQLNCLI10.1;数据源= MyServer;初始目录= MyDatabase; Uid = MyUser; Pwd = MyPassword;


2. 确保您已安装最新的SQL Native Client（sqlncli2008.msi或类似的内容您可以从SQL Server 2008再分发中窃取）


3. 确保VB项目中引用的ADO版本为2.8

1. Ensure you are using the native SQL Server Provider (NOT OLEDB SQL provider) in your Connnection string, so it should be something like "Provider=SQLNCLI10.1;Data Source=MyServer;Initial Catalog=MyDatabase;Uid=MyUser;Pwd=MyPassword;"
2. Make sure you've installed latest SQL Native Client (sqlncli2008.msi or something like that, you can steal it from SQL Server 2008 redistributable)
3. Ensure ADO version referenced in your VB Project is 2.8

发现所有在

found all that on ADODB & SQL 2008 (MS Forums)

希望能帮助您从数据库的日期列中获取数组中的日期列！

I hope that helps you get a Date column in your array from a Date column in your db!