The DLL is available in the download package on Microsoft's website.
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.
@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.
this is Engineer Dhaif Jabber
is it possible to us it with sql server 2012
hi
any suggestions please
@_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
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
有人知道 连接 SQL Server 2000 的时候出现 ESOCKET 错误如何解决吗?
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.
for step 1.2 should remove reference to any specific version: https://www.microsoft.com/en-us/sql-server/developer-get-started/python/windows
how i start
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
@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
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'
}
"
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'
}
"
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.
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).
@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
https://github.com/denisenkom/go-mssqldb#connection-parameters-and-dsn
Anyone have any input or recommendations on this topic?
