search

electroly / sqlnotebook

Casual data exploration in SQL
https://sqlnotebook.com
MIT License
590 stars 35 forks source link

trouble connecting with SQL Server #57

Open Loublain opened 8 months ago

Loublain commented 8 months ago

Trying to set up a connection to SQL server using URL jdbc:jtds:sqlserver://localhost:1433;DatabaseName=ACPDEV with a verified username and password I keep getting a cannot connect message This URL works in DBVisualizer

electroly commented 8 months ago

Hi @Loublain, SQL Notebook uses ADO.NET for database connections rather than JDBC, so JDBC URLs will not work. I recommend trying the "From Microsoft SQL Server" command on the "Import" menu for a visual connection setup.

Loublain commented 8 months ago

Thanks for the Quick response! I'll give it a try.

On Wed, Jan 3, 2024 at 3:04 AM Brian Luft @.***> wrote:

Hi @Loublain https://github.com/Loublain, SQL Notebook uses ADO.NET https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-overview for database connections rather than JDBC, so JDBC URLs will not work. I recommend trying the "From Microsoft SQL Server" command on the "Import" menu for a visual connection setup.

— Reply to this email directly, view it on GitHub https://github.com/electroly/sqlnotebook/issues/57#issuecomment-1874978065, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACDZU7AXUFRZJCPT42EPQQDYMUGI3AVCNFSM6AAAAABBKCIHU6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZUHE3TQMBWGU . You are receiving this because you were mentioned.Message ID: @.***>

Loublain commented 8 months ago

lack of success.☹️ What is the template for the URL for that kind of connection? And do I need to grab a specific driver for this?

On Wed, Jan 3, 2024 at 8:15 AM Louis Blaine @.***> wrote:

Thanks for the Quick response! I'll give it a try.

On Wed, Jan 3, 2024 at 3:04 AM Brian Luft @.***> wrote:

Hi @Loublain https://github.com/Loublain, SQL Notebook uses ADO.NET https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ado-net-overview for database connections rather than JDBC, so JDBC URLs will not work. I recommend trying the "From Microsoft SQL Server" command on the "Import" menu for a visual connection setup.

— Reply to this email directly, view it on GitHub https://github.com/electroly/sqlnotebook/issues/57#issuecomment-1874978065, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACDZU7AXUFRZJCPT42EPQQDYMUGI3AVCNFSM6AAAAABBKCIHU6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZUHE3TQMBWGU . You are receiving this because you were mentioned.Message ID: @.***>

electroly commented 8 months ago

SQL Notebook includes the drivers built-in. You need only to enter the hostname, database name, username, and password as in the screenshot below.

image

Loublain commented 8 months ago

Eternal gratitude. I was just overthinking the whole thing. works great. I'm in complication mode cause I'm working on moving an on-prem Oracle/web system to AWS, and my tears won't stop flowing

On Sun, Jan 7, 2024 at 12:14 AM Brian Luft @.***> wrote:

SQL Notebook includes the drivers built-in. You need only to enter the hostname, database name, username, and password as in the screenshot below.

image.png (view on web) https://github.com/electroly/sqlnotebook/assets/171909/0ad5df7c-1cc6-4cfb-8520-109abdfb27f0

— Reply to this email directly, view it on GitHub https://github.com/electroly/sqlnotebook/issues/57#issuecomment-1879947771, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACDZU7GI7JYZFWC3V2OKHF3YNIVLBAVCNFSM6AAAAABBKCIHU6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZZHE2DONZXGE . You are receiving this because you were mentioned.Message ID: @.***>