Olukayode Oluwole
asked on
What would be the PostgreSQL database connection string equivalent for a known sqlserver connection string
I have a C# application that needs to connect to sqlserver and postgresql
I have been able to connect it to sqlserver and it works and the connection string is shown below
<add name="Tournaments" connectionString="Server=C HRISTINESP C;Database =Tournamen ts;Trusted _Connectio n=True;" providerName="System.Data. SqlClient" />
I have tried a number of options for postgresql without success
Can anybody kindly help to specify what the postgresql connection string equivalent is
Notes:
CHRISTINESPC is my servername as displayed in sqlserver management studio thou I am open to using an IP address
Tournaments my Database name in both sqlserver and postgresql databases
Thanks
Oluwole
I have been able to connect it to sqlserver and it works and the connection string is shown below
<add name="Tournaments" connectionString="Server=C
I have tried a number of options for postgresql without success
Can anybody kindly help to specify what the postgresql connection string equivalent is
Notes:
CHRISTINESPC is my servername as displayed in sqlserver management studio thou I am open to using an IP address
Tournaments my Database name in both sqlserver and postgresql databases
Thanks
Oluwole
ASKER
I have actually tried the options i saw from that web site without success
I believe some one who has tried connecting c# to postgresql would
find this straight forward
Thanks
Oluwole
I believe some one who has tried connecting c# to postgresql would
find this straight forward
Thanks
Oluwole
You asked...
What would be the PostgreSQL database connection string equivalent for a known sqlserver connection string which seems odd.
SQL Server + PostgreSQL are two different products... Both are databases... so if this is your question, you can't...
If by known sqlserver connection string you really mean known PostgreSQL connection string... you state you have a working connection string already...
State the problem you're trying to solve coming up with a different connection string.
What would be the PostgreSQL database connection string equivalent for a known sqlserver connection string which seems odd.
SQL Server + PostgreSQL are two different products... Both are databases... so if this is your question, you can't...
If by known sqlserver connection string you really mean known PostgreSQL connection string... you state you have a working connection string already...
State the problem you're trying to solve coming up with a different connection string.
ASKER
Please read my very first post.
The question is how to get the postgresql connection string for a C# application
The example i gave was for connection of a C# application to sqlserver from my application
The issue is that i need the 2 connection strings (and currently only have 1 working)
Regards
O.A. Oluwole
The question is how to get the postgresql connection string for a C# application
The example i gave was for connection of a C# application to sqlserver from my application
The issue is that i need the 2 connection strings (and currently only have 1 working)
Regards
O.A. Oluwole
Two questions: 1. Do you have the PostgreSQL driver installed on that system? 2. What is the error message you are getting?
ASKER
1. YES I have postgresql 9.5 installed on my laptop and connects to it with a visual basic. application
2. The Connection string for sqlserver and postgresql from my C# application are as shown below
for sqlserver:
<add name="Tournaments" connectionString="Server=C HRISTINESP C;Database =Tournamen ts;Trusted _Connectio n=True;" providerName="System.Data. SqlClient" />
with sqlserver connection my application runs
for postgresql:
<add name="Tournaments" connectionString="Server=1 27.0.0.1;P ort=5432;D atabase=To urnaments; Integrated Security=true;
" providerName="System.Data. SqlClient" />
With postgresql i get the error below:
System.ArgumentException: 'Keyword not supported: 'port'.'
Please note that in both case i use Dapper to effect connection.
What do you suggest i try
Thanks
O.A. Oluwole
2. The Connection string for sqlserver and postgresql from my C# application are as shown below
for sqlserver:
<add name="Tournaments" connectionString="Server=C
with sqlserver connection my application runs
for postgresql:
<add name="Tournaments" connectionString="Server=1
" providerName="System.Data.
With postgresql i get the error below:
System.ArgumentException: 'Keyword not supported: 'port'.'
Please note that in both case i use Dapper to effect connection.
What do you suggest i try
Thanks
O.A. Oluwole
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.connectionstrings.com/postgresql/