What port does Babelfish work over and should I be able to test with osql?

I've tried this so far. Added port TCP 1433 to the security group in addition to 1434 UDP, and the TCP port associated with my server. When I try to connect via SQL Server Management Studio I get these error messages.
Specified cast is not valid:
(Microsoft.SqlServer.ConnectionInfo)

Reached out to the babelfish-preview email address and got a response back.

Had to connect via first creating a new query window in SSMS and then changing/starting the connection. Also had to specify the database name in the connection information. In the actual query, I had to include my tablename in quotes because I think SSMS was converting it to lowercase and my table name contained an uppercase letter.

Also works with sql-cmd. Which is fine since it replaced osql forever ago. Just had to supply -d parameter with database.

Edited by: codingjoe-hig on Jun 15, 2021 11:26 AM

Which port should I be using?

Babelfish creates an additional port for the TDS protocol, by default, 1433. You can simultaneously connect via the PostgreSQL port (default 5432) with pgAdmin. (You can browse your data live from both ports, using different SQL clients for TDS and PostgreSQL.)

How do I connect using Babelfish?

The easiest way to get started is to use SSMS, which is free to download. When making your Aurora cluster, double check that you select PostgreSQL 13.6 or higher (which includes Babelfish 1.2.0+). Older versions of Babelfish have very limited SSMS support, which require workarounds.

Babelfish is continually improving SSMS support, so choose the latest version of PostgreSQL, which will have the most up-to-date support.

Babelfish documentation can be found here.