Forum Discussion
Fabric Notebooks communication to on-premise SQL with jdbc driver
Hello, We have a scenario that we need to access on-premise data on SLQ server from microsoft fabric using notebooks with jdbc driver. Is that scenario supported because as i have seen on-premise...
Hi Anonymous ,
Using notebooks from Microsoft Fabric to connect to local SQL Server via the JDBC driver is a bit tricky. The local gateway does not support JDBC.
But try connecting to SQL Server using pyodbc, which may be an alternative. See below for a similar solution:
Solved: JDBC connection to Fabric Lakehouse SQL endpoint u... - Microsoft Fabric Community
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.