Search found 725 matches

by Paul
Tue 15 Sep 2009 08:11
Forum: LinqConnect (LINQ to SQL support)
Topic: IsNullOrEmpty not working correctly
Replies: 6
Views: 3394

This is not a problem for Oracle server, because values NULL and '' in VARCHAR2 column are equivalent.
So it is enough to check t1.Question IS NULL
by Paul
Tue 15 Sep 2009 08:02
Forum: dotConnect for Oracle
Topic: Missing query operator support in Devart.Data.Linq
Replies: 1
Views: 2159

Yes. It is not supported in Linq To SQL.
Implementation of Linq To SQL by Microsoft does not support it too.
There is no simple way to translate this to SQL. Try to use Skip, Take instead
by Paul
Fri 16 Jan 2009 11:54
Forum: dotConnect for MySQL
Topic: Trial doesn't work at all
Replies: 10
Views: 3833

Try removing "bin" and "obj" folders from you application and recompiling it again. If you still have this problem please send us compiled executable file (*.exe) of a small test project.
What is exact text of the error message that you have in run time of the test project?
by Paul
Wed 14 Jan 2009 17:26
Forum: LinqConnect (LINQ to SQL support)
Topic: Reverse engineering naming algorithm
Replies: 2
Views: 2898

Try to use the following steps:
1. Backup Template folder (in Entity Developer)
2. Remove all references to GetPluralName function in Template you use (CS or VB)
3. Restart Developer and try to Generate with reformed template.
4. If it won't help then restore the backup. Otherwise enjoy generated classes.
by Paul
Fri 09 Jan 2009 15:34
Forum: dbForge for Oracle
Topic: conflict between OCL and stlport
Replies: 1
Views: 3437

We did not test OCL with STLport compiler. Try to find the problem using the source version of OCL Library.
by Paul
Thu 06 Nov 2008 10:17
Forum: dotConnect for Oracle
Topic: Licensing for MSTest during Team Build
Replies: 3
Views: 3525

You have to install OraDirect .NET on the computer where unit tests are compiled by Visual Studio (build server).
To avoid this you can build *.licenses resource as described in "Licensing"|"Compiling License Manually" section of OraDirect .NET documentation. Use your licenses.licx and licenses.config for compiling with lc.exe utility. Do this on the computer where OraDirect .NET is installed.
Then include *.licenses resource to unit tests and process tests as usual.
by Paul
Tue 04 Nov 2008 11:51
Forum: dotConnect for MySQL
Topic: DataLink.AddNew Problem
Replies: 1
Views: 2437

We cannot reproduce this problem. Please check that properties of DataColumn as set correctly. For example, DataColumn.AutoIncrement==true and DataColumn.AutoIncrementStep have correct value.
by Paul
Fri 03 Oct 2008 09:31
Forum: dotConnect for MySQL
Topic: question about linq2mysql and FK,PK relationships (MARS)
Replies: 2
Views: 2901

Thank you for your gratitudes. Please explain on a example which data loading you want to be "lazy"?
If your object "User" has property "UserProperties" of EntitySet type, it is
loaded from server when you are accessing User.UserProperties property.
If your object "User" has property "Company" of EntityRef type, it is
loaded from server when you are accessing User.Company property.
If you run query

var q = (from u in db.Users
select new { u , properties = from p in db.UserProperties where p.User == u select p});

then ".properties" is
loaded from server when you are accessing this property.

Intellisense in the IDE works with code of Microsoft Visual Studio. Our library starts working in run time only. Please check the type of m.Modulesinroless. Possibly it is a list.

MySQL Server does not support MARS (Multiple Active Result Sets). But it is not needed for running LINQ to MySQL. The library has its own solution for the problem and can work with multiple opened data readers at the same time.

If you have a question please write an example LINQ code and specify declaration for instance objects.
by Paul
Tue 30 Sep 2008 12:08
Forum: dotConnect for Oracle
Topic: Install error 1722
Replies: 2
Views: 2860

Please write the full version number (4 digits) of OraDirect .NET. What is the processor kind? Is it 64bit or 32bit?
by Paul
Fri 19 Sep 2008 15:55
Forum: dotConnect for Oracle
Topic: Problem using OracleLoader
Replies: 2
Views: 2689

Thank you for your sample. We reproduced this problem and fixed it. This fix will be included in the
next OraDirect .NET build.
Try to use header.SetInt function as workaround
by Paul
Wed 17 Sep 2008 08:41
Forum: dbForge for Oracle
Topic: need some OCL help
Replies: 2
Views: 4786

There is no way in Oracle to determine if a connection is broken. OCI does not have such functionality. When the connection is broken, the next command execution returns an error. You can determine this situation by executing any simple command that does not affect data ("COMMIT" for example).
Function "isConnected()" returns the current state of OraConnection object and does not know anything about network socket state.
Can you reproduce "access the wrong memory point" error on a small application? What is your OCL version? Send us please small demo project to demonstrate the problem
and include script to create server objects (procedures, tables).
by Paul
Wed 17 Sep 2008 08:39
Forum: dbForge for Oracle
Topic: Oracle Connection with OCL
Replies: 1
Views: 4373

Please see the answer in this topic
http://devart.com/forums/viewtopic.php?p=38684#38684
by Paul
Mon 08 Sep 2008 10:07
Forum: dbForge for Oracle
Topic: Oracle Class Library for C++ Question
Replies: 1
Views: 4100

You can read about Oracle Class library for C++ here: http://devart.com/ocl/ It includes components OraConnection, OraCommand, OraRecordset, and many others. You can use them to execute statements and PL/SQL blocks.
by Paul
Wed 20 Aug 2008 16:59
Forum: Oracle Data Access Components
Topic: Oracle Class Library for C++ Builder 2007
Replies: 2
Views: 2194

Yes, the demo projects are out of date. We are going to provide an OCL demo library for C++ Builder 2007 soon. Please write an e-mail to our support address to get the OCL demo library.
by Paul
Mon 24 Dec 2007 13:29
Forum: dotConnect for Oracle
Topic: ORA-12516: TNS:listener could not find available handler with matching protocol stack
Replies: 3
Views: 7769

This probem happens on the Oracle server side. Possibly one of described solutions will help to solve this problem (http://forums.oracle.com/forums/thread. ... 9&tstart=0).
You can reproduce this problem with OraDirect .NET pooling because not all connections are used at once and peak of maximum created connections can come some time later after starting the process.