![]() ![]() Let’s test the connectivity in code as well. If all goes well you’ll get a confirmation:Ĭlick OK and the click Save on the setup window. Fill in the master username and password fields. The database name will be “urls”, the server is the endpoint you saw in RedShift, the port will be 5439 if you accepted the defaults. Give the data source a name, like RedShiftUrls. Scroll down and locate the driver called PostgreSQL Unicode and click Finish. In the ODBC Data source administrator tool select the tab called “System DSN” and click Add. The ODBC one is not entirely correct, however. ![]() You’ll also find the JDBC and ODBC connection strings further down on the same page. You’ll also see the connection endpoint which will look similar to the following: In RedShift if you click on the cluster name it will open a page where you can view the JDBC and ODBC connection strings. We’ll now test the connectivity to our “urls” database. If you have to redo this process with the 64-bit version then the driver will be called PostgreSQL Unicode(圆4) instead. We’ll need to reference the Unicode one by its name in the connection string eventually. Select the Drivers tab and scroll down in the list of drivers. It opens the ODBC data source administrator window: Like above, I went with the 32-bit version. On Windows 7 the 32-bit tool is located here: Actually, there are 2 of them: one 32-bit and one 64-bit and it really does matter which one you choose. There’s an ODBC management tool on Windows. We’ll now check if the driver has been properly registered. The downloaded package will include a setup file:ĭouble-click it and step through the installation. However, if the below setup process fails for you then you’ll have to repeat it with psqlodbc_09_03_0300-圆4-1.zip. I cannot explain why this is the case but the 64-bit version didn’t work for me. psqlodbc_09_03_0400.zip which is actually for 32-bit systems even though I have a 64-bit system type. The one that ultimately worked for me was the very last file, i.e. At the time of writing this post these are the latest versions of both: ODBC drivers come in two versions: 64-bit and 32-bit and this is an important distinction as connectivity exceptions will arise if you’re trying to connect with the wrong architecture. Scroll all the way down to see the latest versions. You’ll see a long list of downloadable zip files. Navigate to the Postgresql page with a list of ODBC drivers. At times this can be a frustrating experience so I’ll try to give you as much detail as I can.įirst off we’ll need an ODBC driver. In this section we’ll prepare our Windows environment to be able to connect to RedShift using ODBC. We haven’t yet seen how to execute Postgresql commands on RedShift remotely from code. We saw how to get a list of clusters, start a new cluster and terminate one using the. In the previous post we went through some basic C# code to communicate with Amazon RedShift.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |