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
Search found 6 matches
- Fri 20 May 2022 06:54
- Forum: Excel Add-ins
- Topic: connecting VBA code with PostgreSQL using NPGSQl
- Replies: 1
- Views: 44164
- 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
is there any progress with Excel add-in for VBA code to connect PostgreSQL dB?
regards,
Shubham
- 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.
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.
- 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
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
- 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?
- 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,
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,