Comments (5)
electroly
commented on September 22, 2024
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.
from sqlnotebook.
Loublain
commented on September 22, 2024
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
<#57 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACDZU7AXUFRZJCPT42EPQQDYMUGI3AVCNFSM6AAAAABBKCIHU6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZUHE3TQMBWGU>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
from sqlnotebook.
Loublain
commented on September 22, 2024
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
> <#57 (comment)>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/ACDZU7AXUFRZJCPT42EPQQDYMUGI3AVCNFSM6AAAAABBKCIHU6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZUHE3TQMBWGU>
> .
> You are receiving this because you were mentioned.Message ID:
> ***@***.***>
>
from sqlnotebook.
electroly
commented on September 22, 2024
SQL Notebook includes the drivers built-in. You need only to enter the hostname, database name, username, and password as in the screenshot below.
from sqlnotebook.
Loublain
commented on September 22, 2024
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
<#57 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/ACDZU7GI7JYZFWC3V2OKHF3YNIVLBAVCNFSM6AAAAABBKCIHU6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZZHE2DONZXGE>
.
You are receiving this because you were mentioned.Message ID:
***@***.***>
from sqlnotebook.
Related Issues (20)
- TABLESAMPLE on import fails for views HOT 1
- tab delimited files
- multiple read_csv in 1 script file not work
- string replace is not working
- error connecting to SQL Server that is fully case sensitive
- Import file with separator other than comma?
- Enhancement : Transclude SQL Results in Notes
- Error running installed and portable version HOT 3
- Markdown support and plot function HOT 3
- sqlite sql CTE function failure HOT 2
- Column datatype assignment HOT 3
- Support PostgreSQL schemas other than the default public schema HOT 1
- Unable to save SQL Notebooks due to "Object reference not set to an instance of an object." HOT 7
- Print a notebook HOT 3
- 32bit support HOT 1
- issue when press ctrl+s shortcut multiple times HOT 1
- MYSQL
- Can LIST_FILES accept a VAR?
- cannot support mac？
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlnotebook.