The DLL is available in the download package on Microsoft's website.
darrix
@darrix_twitter
@David-Engel Ah, I see. Thanks much for your help.
Stefan
@stefanhk31
Hi, I'm new to SQL Server Express, and trying to go through Microsoft's "Create C# apps using SQL Server on Windows" tutorial. How do I find what port to set the builder.DataSource to? I'm getting a "server was not found or was not accessible" exception when I try to apply the code given in the tutorial.
David Engel
@David-Engel
@stefanhk31 SQL Server Express, I believe, by default only listens to named pipe connections. You can simply use a connection string like "<computer_name>\sqlexpress", or configure SQL Express to listen for TCP connections (https://web.synametrics.com/sqlexpressremote.htm) if you want to be able to specify a port.
Stefan
@stefanhk31
Thanks @David-Engel !
djabber2019
@djabber2019
hi
this is Engineer Dhaif Jabber
is it possible to us it with sql server 2012
djabber2019
@djabber2019
hi all
djabber2019
@djabber2019
hey there
djabber2019
@djabber2019
hiii
hi
Pavel Kohout
@pkohout_twitter
Hi, does anyone can recommend MacOS MS SQL client tools?
swa
@swa256_gitlab
Hi, I am planning to do certifications related to .net and sql
any suggestions please
David Engel
@David-Engel
@djabber2019 Yes. You can use SQL Server 2012. @pkohout_twitter The mssql-tools package is available on macOS and includes the sqlcmd and bcp command line tools.
Yas Mohammed
@_wrapme_twitter
After doing Step1.3( running command for SQLCMD), its is again showing sqlcmd: command not found what i have to do next.. am using Ubuntu 16.04, php7.1 in VirtualBox
David Engel
@David-Engel
@_wrapme_twitter What was the output from the commands you ran to install mssql-tools (which contains sqlcmd) in step 1.3? It sounds like it may not have completed successfully. sudo su curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list exit sudo apt-get update sudo ACCEPT_EULA=Y apt-get install msodbcsql17 mssql-tools echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc source ~/.bashrc sudo apt-get install unixodbc-dev
陈沛林
@a0215cpl
Connecting to SQL Server 2000 , ConnectionError ESOCKET Socket error. How to deal with it?
有人知道 连接 SQL Server 2000 的时候出现 ESOCKET 错误如何解决吗?
Stefán Jökull Sigurðarson
@stebet
Hi everyone
Was wondering, is there a new preview release scheduled soon for the Microsoft.Data.SqlClient? Looking forward to trying out the SQL Command text changes.
Tverskaya
@Tverskaya
do we have to use python27 or can we use the newest version python37 with sql server?
David Engel
@David-Engel
@stebet Look for another one in a few weeks. @Tverskaya You can use Python 3.7.
Tverskaya
@Tverskaya
Thanks @David-Engel ! You would think that microsoft would keep their pages up-to-date...
Hi, I'm creating a report in SSRS using ODBC driver for Informix Database. When I run the query in the query designer, I get the results I want, but in the sql panel the query is jumping continuosly like a loop. In the result panel I have a warnging icon, and in the bottom right another warning icon with the legend 'query changed'. I never saw this issue before, but also never use ODBC in SSRS
Hédel Nuñez Bolívar
@hedelnb_twitter
mjm, I started to use the 'graphic' interface for generate the query and I have a better idea how to use the parametrs with ODBC, I think this was the problem
chakriganap
@chakriganap
@David-Engel Thank you Appreciated
Dayashankar Prajapati
@Oliverq755
hello guys, I am trying to connect dbeaver community with mssql server but unable to connect. Any help?
David Engel
@David-Engel
@Oliverq755 It would help to post any specific error messages you get when you have problems. In lieu of that, here is a link that might help you troubleshoot some different connection problems: dbeaver/dbeaver#3377
Evgeniy Pavlovich Demyanov
@Ormadont
Hi. I need help with "Create Node.js apps using SQL Server on Windows" On step 2.1 I was expecting a result: "Connected". But got it: " PS E:\evgen\Documents\web\testSql> node connect.js ConnectionError: Failed to connect to localhost:1433 - Could not connect (sequence) at ConnectionError (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\errors.js:13:12) at Connection.socketError (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connection.js:1258:56) at E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connection.js:1084:21 at SequentialConnectionStrategy.connect (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connector.js:83:14) at Socket.onError (E:\evgen\Documents\web\testSql\node_modules\tedious\lib\connector.js:96:12) at Socket.emit (events.js:209:13) at emitErrorNT (internal/streams/destroy.js:91:8) at emitErrorAndCloseNT (internal/streams/destroy.js:59:3) at processTicksAndRejections (internal/process/task_queues.js:80:21) { message: 'Failed to connect to localhost:1433 - Could not connect (sequence)', code: 'ESOCKET' } "
David Engel
@David-Engel
@Ormadont You need to make sure SQL Server is installed locally and that it is configured to listen for TCP connections on port 1433 (which is the default TCP port).
Evgeniy Pavlovich Demyanov
@Ormadont
@David-Engel Thanks! You helped me. Protocol for TCP connections was disabled
ivanthewebber
@ivanthewebber
Hello I'm running into some trouble. If I don't provide username/password credentials the sqlcmds work, but otherwise I get a failed login error. I also tried to make a Application Role (my understanding is that it's a login that can be used by a program), but login fails for this as well. Running connect.go fails because of the login problem. Any pointers would be greatly appreciated.
ivanthewebber
@ivanthewebber
Okay so I've found that I can login with COMPUTER-NAME\\username. However, any pointers to help me avoid including my password in the source code would be greatly appreciated. (I have to turn in my code for a comparative programming language course; I'm teaching myself Golang).
David Engel
@David-Engel
@ivanthewebber go-mssqldb supports SQL Server Authentication, Windows Authentication in the DOMAIN\User format, and on Windows, if user id is empty or missing Single-Sign-On is used (login is the context of your logged in Windows user account). So the only option you have for not including a password it the last one where you do not specify a user id. https://github.com/denisenkom/go-mssqldb#connection-parameters-and-dsn
ivanthewebber
@ivanthewebber
@David-Engel Thanks, I was unaware that was an option
Oasis
@oasisfleeting
I have a scheduled database redesign task coming up next month.. Hoping to split the database up over 4 drives of 500GB a piece and take advantage of some of the IO benefits from asynchronous reads. Not sure how virtualization will impact that IO.
Anyone have any input or recommendations on this topic?
David Engel
@David-Engel
@oasisfleeting I can confirm that virtualization will be an important consideration during configuration as you will want to be careful about exactly how the database has access to the drives (block size and alignment for example). You'll want to do your research about it.
Watcharathat.pho@gmail.com
@Charathat_gitlab
Create Java apps using SQL Server on Windows, Have you got for gradle ?