Hi,

I've just signed up for a trial, and tried replicating a couple of jobs that I currently have running on my own MS Access-based tool. Unfortunately, I'm having trouble connecting to an Oracle database. I'd like to do it without a DSN, so I'm using a connection string, which matches exactly what's in my tnsnames.ora file.



When I try testing the connection, it gives me this error:



I find it odd that it claims to be trying to connect to an SQL Server database, when I've clearly stated that it's an Oracle database.

Does anyone have any thoughts on how to fix this?

Thanks.

Hi,

try select Oracle->Native->Standard 2 - direct mode instead. Then you do not need the Oracle Client.

---

Hi,

This is what I just tried:



Since the credentials are actually in the connection setup, I chose to test it with no credentials:



And it gave me this error:



I also tried it while specifying some credentials, but it gave me the same error. Since it didn't like the "provider" parameter, I figured I'd try deleting it. That gave me another error, although it did remove the parameter from the list:



Now, it complains about the "direct" parameter:



So I tried removing that one, and now it complains about the "port" parameter:



I've gone through all kinds of different combinations of parameters, but so far nothing has managed to connect.

Just a guess: It could be something with the number of semicolons. It probably splits the string on semicolon, and finds that there is one to many or few. Try adding/removing the semicolon at the end.

This issue has been fixed. Please test this build: http://www.visualcron.co....aspx?g=posts&t=7329 

---

Hi,

I've downloaded and installed v8.2.8, and can confirm that it will let me connect to Oracle now. Thanks!