LINQPad-与我的Oracle DB的连接字符串 [英] LINQPad - Connection String to my Oracle DB

问题描述

我刚开始使用LINQPad，并且在连接到SQL Server DB时一切运行良好，但是现在我试图建立与Oracle DB的第二个连接，但是我对如何做却一无所知. /p>

我下载了IQ驱动程序(v 2.0.8.0-最新)，当我添加一个新连接时，我选择Oracle作为我的数据库提供程序，但根据我通常的连接字符串，不知道如何做其余的工作如下:

Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = [IP Address])(PORT = [Port]))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [Service Name])));User Id=[name];Password=[password];" 

我知道您通常会发布您尝试过的内容，但是，请相信我，我已经尝试过按我能想到的方式填写这些文本框，并在单击测试"按钮时不断出现错误. /p>

此外，我得到的错误之一是: License not valid due to the problems with dotConnect for Oracle installation-我认为这不是唯一的问题，但是我敢肯定我也需要解决该问题....

有关在什么地方填写此作品的任何建议/链接?

谢谢!!!!!!!

解决方案

最新的IQDriver版本中存在构建问题.恢复到以前的版本(2.0.7)，您将不会看到该错误.作者删除了最新版本，因此您可以直接从LINQPad进行操作(添加连接|选择IQ |删除驱动程序|重新下载IQ驱动程序.)

I just started using LINQPad and all works great when connecting to my SQL Server DB, but now I'm trying to set up a second connection to my Oracle DB and I'm getting stuck as to how to do it.

I downloaded the IQ driver (v 2.0.8.0 - Latest) and when I go to add a new connection, I select Oracle as my DB Provider and don't know how to do the rest based upon my usual connection string looking as follows:

Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = [IP Address])(PORT = [Port]))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = [Service Name])));User Id=[name];Password=[password];" 

I know that you usually post what you've tried, but, believe me, I've tried filling in those text boxes every which way I could think of and keep getting errors when I click the "Test" button.

Also, one of the errors I get is: License not valid due to the problems with dotConnect for Oracle installation - I don't think that's the only issue, but I'm sure I'll also need to fix that problem too....

Any suggestions / links to offer about what to fill in where to make this work??

THANKS!!!!!!!

解决方案

There is a build issue in the newest IQDriver release. Revert to previous version (2.0.7) and you won't see that error. Author removed latest version, so you can do that directly from LINQPad (Add connection | Select IQ | Delete Driver | Re-download IQ Driver).

这篇关于LINQPad-与我的Oracle DB的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！