快速的方法来测试OLE DB连接字符串 [英] Quick ways to test OLE DB Connection String

问题描述

有关调试的目的，我想知道的方法来测试OLE DB连接字符串快。

For debugging purpose I'd like to know ways to test OLE DB connection string quickly.

我发现<一href="http://www.digitalcoding.com/free-software/database/Database-Connection-String-Tester.html">this免费软件，它的作品在我的机器，成功地测试了。

I've found this free software, it works on my machine, tested successfully.

有没有更快的方法来做到这一点，也许通过命令行上的Windows？因为大部分的时间，这是客户端，而不是我会做这个任务，所以preFER这将影响到他们的系统中的至少一个零安装的方式。

Is there a even quicker way to do so, maybe from command line on Windows? Because most of the time, it is the client rather than me that would do this task, so I prefer a "zero-installation" approach that would impact their system the least.

推荐答案

如果客户端已经安装PowerShell的（给定的，如果他们运行的是Windows 7或Windows Server 2008 R2），那么你可以从PowerShell控制台窗口中执行这些命令

If the client has PowerShell installed (a given if they are running Windows 7 or Windows Server 2008 R2), then you can execute these commands from a PowerShell console window:

$conn = New-Object System.Data.OleDb.OleDbConnection
$conn.ConnectionString = "Provider=Search.CollatorDSO" # whatever you are testing
$conn.Open()
$conn.Close()

这篇关于快速的方法来测试OLE DB连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！