{{ message }}
Repository navigation
Unable to connect SQL Server LocalDB #305
Description
Is there support for MS SQL Server LocalDB?
SQL Server LocalDB Instance : (localdb)\MSSQLLocalDB
So I entered the host as (localdb)\MSSQLLocalDB with pubs as the database. (This hostname works in Excel when connecting using SQL Server connection)
select 1+2;It gives this error.
Error evaluating panel:
[INFO] 2023-08-20T22:49:28 DataStation Runner (Go) 0.11.0
[INFO] 2023-08-20T22:49:28 Evaling database panel: Untitled panel #1
[INFO] 2023-08-20T22:49:28 Failed to eval: parse "sqlserver://user:pass@(localdb)\\MSSQLLocalDB:1433?database=pubs": invalid character "\\" in host name
BTW it works with another similar software called DatabaseBrowser
Activity
eatonphil commentedon Aug 21, 2023
Maybe try replacing
(localdb)\MSSQLLocalDBwith 127.0.0.1?fortunewalla commentedon Aug 22, 2023
Thanks for trying to help out but It gives the following error.
This would make it use TCP connection instead of ODBC connection.
As per the original error, it cannot parse the
\slash in the server name properly. I think? 🤔eatonphil commentedon Aug 22, 2023
DataStation just passes the connection string along to the underlying library. So you could ask this question in https://github.com/denisenkom/go-mssqldb (the library used for connecting to SQL Server) and maybe they'll know!
fortunewalla commentedon Aug 26, 2023
hopefully a resolution will be found by someone. 🤞🏼
fortunewalla commentedon Aug 27, 2023
So as per the suggestion given on this page: https://weblogs.asp.net/jongalloway/sql-force-the-protocol-tcp-named-pipes-etc-in-your-connection-string
I tried with the connection string
Server=np:(localdb)\MSSQLLocalDBIt now gives a different error where it parses everything after
:as a port number.P.S. I'm posting it here also for future use by someone. 😇