VS2008 Datadriven Test fails using Oracle DataSource

VS2008 Datadriven Test fails using Oracle DataSource

Postby GeoInfo » Tue 23 Feb 2010 07:56

Hi

I try to use an Oracle (10g) Table as datasource of an datadriven UnitTest in VisualStudio 2008. The test seems to connect to the Oracle DB (fails on wrong credentials), but then fails with error "The unit test adapter failed to connect to the data source or to read the data, .... Error details; Index out of Range (Array)."

I use the following attributes:

_
_
Public Sub OoiDataManagerGetAllPoiDetails_ValidObject()

Client OS is Windows7 (64bit)

Using VS2008 ServerExplorer I can connect to the oracle DB read/write Data using Provider 'dotConnect for Oracle'

Is this a bug in dotConnect? Is there any solution or workaround.

Any help is very much appreciated.

Best Regards


Bernd Nierula
GeoInfo
 
Posts: 2
Joined: Tue 23 Feb 2010 07:39

Postby Shalex » Wed 24 Feb 2010 10:18

Your UnitTest with dotConnect for Oracle should work. I have checked the latest 5.55.97 version of dotConnect for Oracle. You can find your current version via the Tools | Oracle | About menu of Visual Studio.

Maybe the reason of the error is incorrect connection string. If you are using the Direct mode, the Home parameter is not necessary because Oracle Client is not used. For more information about the Direct mode, refer to our documentation. Is a connection string in your UnitTest the same as the one you used in Server Explorer? Please try to localize the problem: create an instance of OracleConnection with your connection string in a separate small (e.g., ConsoleApplication) project, and open this connection. Is it successful? If the problem persists, post here your call stack.
Shalex
Devart Team
 
Posts: 7539
Joined: Thu 14 Aug 2008 12:44

Postby GeoInfo » Wed 24 Feb 2010 15:25

Hi Shalex

Thank You very much for Your reply.

I use Pro Edition, Version 5.35.79.0, downloaded and installed about two weeks ago. Is there a more recent version available for download?

I use the same Connection String as VS Server Explorer in the Tests DataSource. I activateted Debug ¦ Exceptions ¦ CLR Exceptions and receive the following Exception Details:

System.IndexOutOfRangeException occurred
Message="Der Index war außerhalb des Arraybereichs."
Source="Microsoft.VisualStudio.QualityTools.Common"
StackTrace:
bei Microsoft.VisualStudio.TestTools.Utility.TestDataConnectionSql.FindIdentifierEnd(String text, Int32 start)
InnerException:

Is this of any help?

Thank You very much for Your support

Best regards


Bernd
GeoInfo
 
Posts: 2
Joined: Tue 23 Feb 2010 07:39

Postby Shalex » Thu 25 Feb 2010 09:12

1. The latest Beta build of dotConnect for Oracle is 5.55.97.
It can be downloaded from http://www.devart.com/dotconnect/oracle/dcoracle555.exe (trial version) or from Registered Users' Area (for users with valid subscription only). Please try it.

2. Is there longer stack trace available? Try to set this to get full call stack: in the (Tools | Options) window, Debugging | General uncheck Enable Just My Code (Managed Only).

3. Why did you decide that this error is caused by our components? Please create an instance of OracleConnection with your connection string in a separate small (e.g., ConsoleApplication) project, and open this connection. Is it successful? If the problem persists, post here your call stack.
Shalex
Devart Team
 
Posts: 7539
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle