Devart Forums

hepek

devart folks, please anwser my question.

is using SID in connection string obsolete? what format of connection stgring I should use for diurect connect?

my oracle experts tell me oracle will cut the support for SID, and they will use service name instead.
so how does the connection string look like withoud SID, but with service name?

thank you

hepek

hi. anyone cares to answer this question please?

hepek

hi,

I am using connection string like this:
"direct=True;Min Pool Size=5;Validate Connection=true;Connection Timeout=5;Default Command Timeout=90;Connection Lifetime=1800;user id=xxx;password=xxx;server=xxx;sid=xxx;Port=1521;persist security info=True"

I’ve heard this format is depreciated(sid in particular). what is the new format?

thank you

hepek

I have my apps running on windows server 2012 with no issues. I moved the apps to server 2016 and started receiving this error message while trying to connect to oracle:

Cannot obtain Oracle Client information from registry. Make sure that Oracle Client Software is installed and that the bitness of your application (x64) matches the bitness of your Oracle Client, or use the Direct mode of connecting to a server.

I am using dotConnect version 9.14.1382

here is how my connection string looks like:
$"Data Source={_dbInfo.DbName};User ID={_dbInfo.UserName};Password={_dbInfo.Password};";

I deploy an app as 64 bit and I am using a oracle client 32 bit. in IIS settings I have Enable 32-bit apps set to false.
the same configuration worked on 2012 server, but not on 2016 server.

please advise
thank you

hepek

I do not have any entry in my app.config file related to devart.

can you please provide that config entry with <publisherPolicy apply="no"/>?

btw - I don't thik I ever installed devart on this server. is there a way to tell devart NOT to use GAC?
in another words - may I deploy the app in a way that it does not need devart installation at all.

hepek

I think the issue is with different versions of devart:

Type A originates from 'Devart.Data.Oracle, Version=9.11.1034.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\9.11.1034.0__09af7300eec23701\Devart.Data.Oracle.dll'.
Type B originates from 'Devart.Data.Oracle, Version=9.14.1382.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'E:\PollingDSP\UAT\Devart.Data.Oracle.dll'.

hepek

I would expect all devart DLLs to be included with my app, but they are not.

hepek

I developed a program and it is working fine on my PC. when I deploy it to the server I get the following error:

Code: Select all

[A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand. 
Type A originates from 'Devart.Data.Oracle, Version=9.11.1034.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\9.11.1034.0__09af7300eec23701\Devart.Data.Oracle.dll'. 
Type B originates from 'Devart.Data.Oracle, Version=9.14.1382.0, Culture=neutral, PublicKeyToken=09af7300eec23701' in the context 'Default' at location 'E:\PollingDSP\UAT\Devart.Data.Oracle.dll'. at Devart.Data.Oracle.Linq.Provider.OracleDataProvider.CreateCommand(String commandText, IDbConnection connection, Boolean forBatch)
at Devart.Data.Linq.DataProvider.a(av A_0, Object[] A_1)
at Devart.Data.Linq.Engine.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

hepek

this MUST be a bug.

the default value generated by devart is: DefaultValue="'N'space-tab-tab-tab-tab"
that is 'N' with space and 4 tabs. this does not look ok to me.

can you please at least acknowledge there is an issue and advise on how to fix it?

entity developer version - 6.3.555
dotConnect version (oracle): 9.6.570.0

thank you

hepek

please note I have experienced the same issue 6-7 years ago.
exactly the same issue: one version of devart was generating invalid default value for fields specified as CHAR(1) in database.

people do not report this bug because they probably set every flag in a code, and that works ok. so it does not happen very often. if you attempt to insert new row in database without setting the flag value - the default value will kick in and insert will fail.

thank you.

hepek

hi,

I have a table ASMBLY_MAIL_LIST_PREP that has field FLAG_MERGE_PURGE CHAR DEFAULT 'N' NOT NULL.
when I attempt to insert a new record in database I get this error:
ORA-01400: cannot insert NULL into ASMBLY_MAIL_LIST_PREP.FLAG_MERGE_PURGE
please note that I DO NOT SET this field anywhere in my code.

I checked the default value for the column in database and in devart diagram.
in database it is set to 'N', in devart it is set to "'N' " (note 10 spaces after 'N')

thank you.

hepek

my manager is asking me about how do i check linq insight license number.

how do I check that?

thank you

hepek

any news on this?

the question was asked two and half years ago.

thank you

hepek

any news on this?

the question was asked two years ago.

thank you

hepek

another good idea is to show all objects user has access to in databse explorer.
we have user called "webapps" but this user does not own any objects, he is using synonyms.
because of that - the list of objects for this user is blank.
so, show all objects that user has access to, including synonyms and SPs.

or

be able to filter out users in a user’s list when I click "show all users".
in my case the list is few thousand users long and it is very hard to navigate to the right user in order to drag his objects to a diagram.

thank you

Devart Forums

Search found 126 matches

Re: direct mode connection string

Re: direct mode connection string

direct mode connection string

Cannot obtain Oracle Client information from registry

Re: [A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand

Re: [A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand

Re: [A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand

[A]Devart.Data.Oracle.OracleCommand cannot be cast to [B]Devart.Data.Oracle.OracleCommand

BUG: ORA-01400: cannot insert NULL into

BUG: ORA-01400: cannot insert NULL

BUG: ORA-01400: cannot insert NULL into

how do i check linq insight license number

Re: Commit NoWait option

Re: Commit NoWait option

Re: Entity Framework suggestions