https://community.esri.com/t5/arcgis-notebooks-questions/connect-to-sql-azure-db-from-agol-notebook-w/m-p/1404729#M760 <P>Hi all,</P><P>I'm looking to push some data from hosted feature services to a legacy SQL Azure DB on a schedule.&nbsp; This DB is publicly exposed but secured.</P><P>When I try to open a connection using PyODBC, I get an error saying that the driver can't be found.&nbsp; In a desktop environment I've been able to connect using "SQL Server" as the driver in the connection string, but I've tried a few other variations of SQL Server driver names.&nbsp; I'm guessing that the driver isn't available within the Notebook environment and it can't be added, but looking for confirmation before I start building a workaround (Azure Functions to hit the DB or something probably)...&nbsp; has anyone successfully made this type of connection in an AGOL Notebook?</P><P>Thanks!</P> Tue, 02 Apr 2024 17:12:28 GMT MobiusSnake 2024-04-02T17:12:28Z https://community.esri.com/t5/arcgis-notebooks-questions/connect-to-sql-azure-db-from-agol-notebook-w/m-p/1404729#M760 <P>Hi all,</P><P>I'm looking to push some data from hosted feature services to a legacy SQL Azure DB on a schedule.&nbsp; This DB is publicly exposed but secured.</P><P>When I try to open a connection using PyODBC, I get an error saying that the driver can't be found.&nbsp; In a desktop environment I've been able to connect using "SQL Server" as the driver in the connection string, but I've tried a few other variations of SQL Server driver names.&nbsp; I'm guessing that the driver isn't available within the Notebook environment and it can't be added, but looking for confirmation before I start building a workaround (Azure Functions to hit the DB or something probably)...&nbsp; has anyone successfully made this type of connection in an AGOL Notebook?</P><P>Thanks!</P> Tue, 02 Apr 2024 17:12:28 GMT https://community.esri.com/t5/arcgis-notebooks-questions/connect-to-sql-azure-db-from-agol-notebook-w/m-p/1404729#M760 MobiusSnake 2024-04-02T17:12:28Z