Devart Forums

ColinBo

We've got a project that up until this point has used the built-in ADO.NET driver for SQL Server access. We are now deploying to a test environment that has a clustered SQL Server where encrypted connections are required. Because of the clustering and requirements of SQL Server on certificate names the actual cluster DNS name is attached to the SSL certificate as a "subject alternative name" as defined in the X.509v3 specification. To get this to work we need to switch to using the SQL Server Native Client. We have been having problems getting it working in our app with NHibernate. Wondering if:

a) is there support in the dotConnect driver for SANs in the SSL certificate? (see Encryption on a Cluster - http://technet.microsoft.com/en-us/libr ... 89067.aspx)

b) is there support for NHibernate in dotConnect for SQL Server?

ColinBo

IIS 6 is installed on the deployement server. And IIS 6 is in 64bits.

If is IIS is running in 64-bit mode (that is, the Enable32BitAppOnWin64 metabase setting is false), then your worker process is running in a 64-bit mode. This will mean that you can only bind to assemblies compiled for MSIL or x64. You can determine if the assembly is compiled for 32-bit, 64-bit, or MSIL (compile using just-in-time compiler for the specific machine) using CORFLAGS.EXE. You can play with the bitness flag but only do so with caution. Everything needs to line up to be 32-bit and MSIL or 64-bit and MSIL. If your Oracle client is 32-bit then your worker process needs to be 32-bit. Alternatively using the Direct mode in the dotConnect connection string will do a straight TCP/IP connection without the need for the Oracle client.

In the notes above it looks like the problem is that your assembly, myApp.Business.dll, may be compiled for 32-bit only and the CLR is looking for a 64-bit version.

Cheers,
Colin[/quote]

ColinBo

john wang wrote:ORA-12154: TNS:could not resolve the connect identifier specified."

It sounds like you are using the mode that depends on the Oracle client being installed. Is the service identifier setup in the tnsnames.ora in your Oracle client install folder? If you want direct mode, which doesn't rely on the Oracle client, you will need to add "Direct=True" to the connection string.

ColinBo

Shalex wrote:Sorry for the delay. We cannot reproduce the problem with the latest 5.25.39 build of dotConnect for Oracle when executing the similar script via OracleScript. The possible reason can be incorrect assigning of the ScriptText property in runtime (please use only \n without \r). Please check the work of OracleScript in design time. Does the problem disappear?

I ended up solving it with the following approach:

Code: Select all

string scriptText = File.ReadAllText(filename).Replace("\r\n", "\n");
OracleScript script = new OracleScript(scriptText, connection);
script.Error += delegate(object sender, Devart.Common.ScriptErrorEventArgs e)
{
    Debug.WriteLine(string.Format("Error in SQL Script: {0} - {1} : line {2}, column {3} - '{4}'", e.Exception.Message, filename, e.LineNumber, e.LinePosition, e.Text));
    e.Ignore = false;
};
script.Execute();

It looks like using the Stream is useless as there is no way to intercept and replace the carriage returns. I tried to using the SqlStatementExecute event but the command text is read only. Perhaps a better design is in order to deal with an Oracle-ism?

Cheers,
Colin

ColinBo

I am using the latest version, I have emailed off the sample.

ColinBo

Bump. Anyone?

ColinBo

Shalex wrote:As for the mentioned error, could you please send us a small test project with appropriate DDL/DML script to reproduce the problem in our environment?

Where should I send it to? I should note that I am using FluentNHibernate 1.0 RC with NHibernate 2.1. This has been noted as a problem with the MySQL side as well.

ColinBo

Is anyone using dotConnect for Oracle with NHibernate and FluentNHibernate? How are you connecting to the driver? Using the latest GA bits I am hitting "ArgumentException:
Column 'ReservedWord' does not belong to table ReservedWords."

System.Data.DataRow.GetDataColumn(String columnName)
System.Data.DataRow.get_Item(String columnName)
NHibernate.Dialect.Schema.AbstractDataBaseSchema.GetReservedWords()
NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect
dialect, IConnectionHelper connectionHelper)
NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactory
sessionFactory)
NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping
mapping, Settings settings, EventListeners listeners)
NHibernate.Cfg.Configuration.BuildSessionFactory()
FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory() in c:
\Documents and Settings\Administrator\dev\fluent-nhibernate\src
\FluentNHibernate\Cfg\FluentConfiguration.cs: line 93
FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory() in c:
\Documents and Settings\Administrator\dev\fluent-nhibernate\src
\FluentNHibernate\Cfg\FluentConfiguration.cs: line 98

ColinBo

Just started to trial dotConnect and we're hitting a snag with OracleScript. When I try to run a script with the following block it fails:

DECLARE RowCount NUMBER := 0;
BEGIN
SELECT COUNT(*) INTO RowCount FROM DBA_Tablespaces WHERE UPPER(Tablespace_Name) = 'TESTDATA';
IF (RowCount > 0) THEN
EXECUTE IMMEDIATE 'DROP TABLESPACE TestData INCLUDING CONTENTS AND DATAFILES';
END IF;
END;

ORA-06550: line 1, column 30: PLS-00103: Encountered the symbol "" when expecting one of the following: begin function package pragma procedure subtype type use form current cursor

The same statement block works fine in SQL Developer.

Thoughts?

Thanks,
Colin

Devart Forums

Search found 9 matches

SSL Encryption Certificate with Subject Alt Name Support?

Re: Is trial version of Devart supports DotNet C# unit test?

Using with NHibernate / Fluent NHibernate

OracleScript not happy with statement