Devart Forums

But my use case have worked before and I have verified that it worked when you said that it was fixed and sent me a test application that I verified that worked. Did it ever work or

Thanks,

Charlie J.

Ok. Like I stated I am using EntityFramework with my connectionstring in my web.config and using the DDProviderFactory from the machine.config

The problem is back. When I set Unprepared Execute=True in my connection string and use Protocol = Ver30, Postgres is preparing the statements on the Server-Side. This was fixed before. How do I disable Server-Side prepared statements using Protocol=Ver30? I am using DBFactoryProvider to create the connnection in my machine.config.

I really thought this was working before and got broken again.

So you are saying that my configuration using Entity Framework has never worked and I need to use this workaround to get it to work?

Thanks,

Charlie J.

I did not received the sample application your wanted me to run to generate the log. Please email it to [email protected].

Thanks,

Charlie J.

The Postgres SQL Server is version 8.4.1

So I can test it will my own application that is using dotConnect for PostgresSQL 5.30.172 and Entity Framework creating the connection using the DBProviderFactory in the machine.config? Why can't I just replace my currently installed assemblies with the test assemblies and use my application to do the test? Send me a test application if I can use my own application. Email it to [email protected]

Thanks,

Charlie J.

We couldn't reproduce this issue in our environment. Could you please specify the following:
1) the version of PostgreSQL you are working with;
5.30.172

2) the list of server variables set for this PostgreSQL instance;
Default Installed Values

3) the exact version (including the build number) of dotConnect for PostgreSQL you are using;
5.30.172 from the Customer Download

4) the commands you are executing.
Just simple inserts

I am using Entity Framework 4.1 and the DBProviderFactory from my machine.config

Is there a specific version of dotConnect for PostgresSQL I need to have installed to get the assemblies that was emailed to me? I have dotConnect for PostgresSQL 5.30.172 installed. Plus I am using Entity Framework and DBProviderFactory to connect. Are there any issues with using Entity Framework and DBProviderFactory with the special build for SSPI?

Thanks,

Charlie J.

Any update or reply to the Unprepared Execute=true is not working.

Thanks,

Charlie J.

Put a trace on your Postgres Server. With Unprepared Execute=true and Protocol=Ver30, the trace is showing that the Postgres Server is preparing the statements. So it appear that Unprepared Execute=true is not working.

Hi,

Sorry but we have not received the test build for the SSPI. Can you please send it to [email protected] We are all setup and ready to test it out today.


Thanks,

Charlie J. Biggs

Have the test build for SSPI been sent so I can test the fix in my environment.

Thanks,

Charlie J.

The problem is back. When I set Unprepared Execute=True in my connection string and use Protocol = Ver30, Postgres is preparing the statements on the Server-Side. This was fixed before. How do I disable Server-Side prepared statements using Protocol=Ver30? I am using DBFactoryProvider to create the connnection in my machine.config.

Thanks. The registered user email for my company is [email protected] We will test the build as soon as we get it.

Thanks,

Charlile J.

As a licensed Devart User, my company need to know the plans for supporting SSPI in the Devart dotConnect for PostgresSQL. This has been a feature of PostgresSQL for a couple of years and pgAdmin has support for it. Npgsql was it implemented in there Open Source .NET Data Provider. Looking at the open source for it, it seem to be pretty easy to implement.

Can Devart provide a clear answer and direction on this feature? I have a 2 weeks to make my decision of leaving Devart and going to Npgsql to meet my company requirements.

Thanks,

Charlie J.

Have this problem been resolved so that workaround is no longer needed? I am getting this problem with the latest dotConnect for Postgres Beta. I am using VS 2010 SP1 and TFS SP1.

Thanks,

Charlie J.