VO + C# DLL with both connecting to ADS

[robert.pope]

This is probably a bit of a long shot asking here, but I'll take my chances...

I'm running a VO application that imports some C# code via DLL. Both VO and C# are opening a connection to the same database in ADS (free tables / no data dictionary). VO is using DbServer classes and C# is mapped with Entity Framework and a connection string. The connection string is: metadata=aaa.csdl|aaa.ssdl|aaa.msl; provider = Advantage.Data.Provider; provider connection string= 'Data Source=.; CharType = ADS_OEM; DbfsUseNulls = False; LockMode = PROPRIETARY; ReadOnly = False; SecurityMode = IGNORERIGHTS; ServerType = REMOTE; Shared = True; ShowDeleted = False; TableType = CDX; TrimTrailingSpaces = True'

The problem I have is around both assemblies running within the same process space accessing the DB at the same time. Querying the database from C# seems to be killing VO's ADS connection. I get 5333's and invalid ads connection handles. VO works fine up until the C# query runs. For example if I run:

Code: Select all

Code: Select all

using (MYDB db = new MYDB())
                {
                    var res = from lines in db.MyTable
                                 where lines.MyColumn == xxxx
                                 select lines;
                    foreach (var line in res)
                    {
                            System.Diagnostics.Trace.WriteLine(line.yyyy);
                    }


                    return res;
                }

VO works fine up until that point. After that I'll get an exception when it tries to access the database on a DbServer that was opened prior to the call, and held open until afterwards. Any DbServer opened and closed prior to the call, or opened and closed after the call is fine. This bug only affects servers that remain open during the call.

Any ideas? I've been playing with Pooling=False and ConnectionHandle=<Connection I'm manually opening>, but I've had no luck as yet. I don't suppose any similar problems have been reported previously here?

I'm continuing to troubleshoot this problem. If I find any more clues I'll post them here too.

[robert]

Robert,
This sounds like the C# code closes the connection that was created by the VO process.

Robert

[robert.pope]

It looks like disabling connection pooling was the solution to my problem. Leaving this here for anyone else who might have this problem in the future.

My app.config was being overwritten by another file with the same name later on, so it looked like it wasn't working

[robert.pope]

Yep, that's exactly what I was thinking too. The confusing part was that for entity framework, I don't have any code to open / close the connection. The provider (??) does all that for me.

I just figured it out though. It had to do with the connection pooling feature in ADS. I've now turned it off and all is good.

[robert.pope]

For anyone with this problem in future, just add Pooling = False to your provider connection string.

Mine now looks like this: connectionString="metadata=xxx.csdl|xxx.ssdl|xxx.msl; provider = Advantage.Data.Provider; provider connection string= 'Data Source=.; CharType = ADS_OEM; DbfsUseNulls = False; LockMode = PROPRIETARY; ReadOnly = False; SecurityMode = IGNORERIGHTS; ServerType = REMOTE; Shared = True; ShowDeleted = False; TableType = CDX; TrimTrailingSpaces = True; Pooling = False'"