From: | leoabhi <abhishekrm(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: connecting VB to postgreSQL |
Date: | 2008-04-09 17:21:35 |
Message-ID: | 16592116.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
In brief.
TASK : Write a code in VB so that i can connect to postgreSQL and then
execute some stataments from my VB application.
I didnt want to code it ..I found the other way round very similar but
without coding.
Visual basic has a server explorer .. which can be used to connect to
various database(Eg:Access database,mdb or in our case postgreSQL) and then
you can execute the SQL statements in VB, now once you open Server explorer
you need to ADD/Create/setup a A CONNECTION TO DATABASE which you want to
use., i.e. setup a connection to postgreSQL.
now my first 2 posts speak about this setup and problem/error i had while
setting up connection..it gives OLE-DB error which we already spoke
about..STILL UNRESOLVED.
All goes around setup required to connect to postgreSQL using VB ,Server
Explorer.
I need the settings to be done in Server explorer , so tht i could connect
to postgreSQL...please see snapshots from first posts..That is all you will
neeed.you will understand it quickly now i hope..I know this speaks much
around VB but you need to know why OLE-DB error occurs when you connect a
database?
I have found another way to connect , still i need to check its surety,
hopefully tomo it works
I hope this helped you understand me better , please reply if you find any
solution. I will again post update about it tomorrow., but if this works it
would be gr8 atleast for me ;-)
>>I'm assuming you can connect from this machine using psql and/or
>>pgadmin, yes?
Yes richard , I am able to connect
>>I'm assuming you've turned on connection logging at the server and have
>>checked to see what's happening there, yes?
Yes i turned it on and it helped me to find out the other method , Thanks.
Thank you
Abhi
No idea. You're still not telling us what the error message is when you
try to connect.
I don't use .net, but if you write code to connect to any database then
the connect method/function will return some sort of status code to
indicate success or failure. There will then be a way of getting a
precise error code and message.
I'm assuming you can connect from this machine using psql and/or
pgadmin, yes?
I'm assuming you've turned on connection logging at the server and have
checked to see what's happening there, yes?
What happened when you tried the example code in the driver's tutorial?
--
Richard Huxton
Archonet Ltd
--
View this message in context: http://www.nabble.com/connecting-VB-to-postgreSQL-tp16583837p16592116.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2008-04-09 17:33:26 | Re: Quoting table/column names vs performance |
Previous Message | Jozef Ševčík | 2008-04-09 17:19:29 | Re: Quoting table/column names vs performance |