Search found 6 matches

by shubham15
Fri 20 May 2022 06:54
Forum: Excel Add-ins
Topic: connecting VBA code with PostgreSQL using NPGSQl
Replies: 1
Views: 44164

connecting VBA code with PostgreSQL using NPGSQl

Hi,

is there any possibility to connect VBA code with PostgreSQL using NPGSQL Provider and able to run the code and fetch the data from PostgreSQL dB to Excel sheet using VBA code.

Regards,
Shubham
by shubham15
Fri 20 May 2022 06:33
Forum: Excel Add-ins
Topic: Possibly to refresh data programmatically from VBA?
Replies: 8
Views: 19988

Re: Possibly to refresh data programmatically from VBA?

Hi,

is there any progress with Excel add-in for VBA code to connect PostgreSQL dB?

regards,
Shubham
by shubham15
Fri 08 Apr 2022 15:32
Forum: dotConnect for PostgreSQL
Topic: How to call Stored procedure from c# .Net
Replies: 1
Views: 9853

How to call Stored procedure from c# .Net

Hi,

we are calling stored procedure from C# .NET framework 4.6.1 and using dot connect for PostgreSQL with Devart.Data.Postgresql.

we are unable to called the stored procedure and not able to insert data in PostgreSQL DB(PostgreSQL 11).


All suggestion are welcome.
by shubham15
Fri 01 Apr 2022 06:14
Forum: dotConnect for PostgreSQL
Topic: special character insertion issue with PostgreSQL database
Replies: 1
Views: 8743

special character insertion issue with PostgreSQL database

Hello all,

We are switching to Dot connect for PostgreSQL from another provider (Oracle). After switching to Dot Connect for PostgreSQL from oracle when we try to insert data (some special character), we can see the wrong data getting inserted in the table. example in Oracle we had one column with data ("PÖN") but in PostgreSQL same data is storing as("PÖN").

Now, we are curious about if there is a way to specify target data type for all specific data types. or is there any solution for this. or do we need to do some property changes for our PostgreSQL Db.

Regards
by shubham15
Thu 27 Jan 2022 12:22
Forum: dotConnect for PostgreSQL
Topic: Unable to load dotConnect ADO.NET provider for NHibernate
Replies: 3
Views: 14721

Re: Unable to load dotConnect ADO.NET provider for NHibernate

So now do we have any driver created to connect ADO.NET provider for nhibernate?
by shubham15
Thu 27 Jan 2022 07:48
Forum: dotConnect for PostgreSQL
Topic: Postgresql Driver to connect Nhibernate
Replies: 1
Views: 12166

Postgresql Driver to connect Nhibernate

Hi,
I need to access a postgre server database using Nhibernate.

In oracle we have support to connect Nhibernate using "NHibernate.Driver.DevartDataOracleDriver " to connect Nhibernate with oracle database.

when I tried to connect PostgreSQL with Nhibernate using "NHibernate.Driver.NpgsqlDriver", it throws error saying
"cannot create driver, Nhibernate.Driver.NpgsqlDriver".

Do we have similar driver for connecting PostgreSQL with Nhibernate to our code.

Can somebody help me?

thanks,