ఆశీర్వదించు వెంకట రమణ మూర్తి
ఇది నా మొదటి పోస్ట్ postgresql నేర్చుకోవటం మరియు Knowledge gathering లో. నీ అశీసులు కావాలి స్వామి. అమ్మ అయ్యా కి చేపి నాకు బాగా ఈ సబ్జెక్టు మీద knowledge వచ్చేటట్లు చేయి.
How to connect postgresql database through ODBC driver in excel
Postgresql has ODBC driver " psqlodbc " which will be used to connect to postgresql databases. In this post, we are connecting to postgresql from excel using ODBC driver. Step1: Verifying the existing ODBC driver in windows (both 32 and 64 bit driver) for availability of postgresql driver. 32-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). 64-bit driver , we noticed that there is no postgresql driver in the drivers list ( Name column values doesn't start with Postgres text). Step2: Checking the current postgresql server version, to get the corresponding psqlodbc driver. As per below screen shot, current version is " 10.10 ". i will try to get and install psqlodbc of 10.10 version. Step3: When check the psqlodbc driver ( https://www.postgresql.org/ftp/odbc/versions/msi/ ), i have found the, psqlodbc_10_3 is the last version that was a...
Comments
Post a Comment