Questions tagged [visual-studio-2017]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

Execute SQL Task timeout setting is being ignored for Redshift ODBC Connection

When I run an SSIS SQL Task (VS 2017) against an ODBC Amazon Redshift (32 bit) connection, the timeout setting is not being respected and the Task/SQL continues to run endlessly.
0
votes
0answers
35 views

Unable to add unit tests in Visual Studio or SQL Server Management Studio

I've been looking at Microsoft's official docs and other websites (including this one) and am unable to create unit tests for stored procedures following their instructions. The things I've read say ...
2
votes
1answer
269 views

Error publishing SQLCLR C# Function using Visual Studio 2017

I'm trying to (learn) publish a SQLCLR function using Visual Studio 2017. (It's a simple function that sends an email.) As a reference I used this articles on CodeProject and MSSQLTips: Create, Run, ...
0
votes
1answer
1k views

Install SSDT for VS 2017 - Missing Integration Services

I have downloaded and installed SSDT from Microsoft docs. The install was successful and I now have SSDT for VS 2017 installed - version 15.8.9 (as per screenshot) However, I cannot create an SSIS ...
0
votes
1answer
24 views

Get Data to connect to the AdventureWorksDW

I am trying to connect to a SQL Server 2017 via Visual Studio 2017.What should I be entering in the User name and Password fields?
2
votes
0answers
122 views

View(df) in R throw (function(x, df1, df2, ncp, log = FALSE))

I connected R with SQL Server (in Visual Studio 2017) the connection succeeded this is Setting.R settings <- as.environment(list()) dbConnection1 <- 'Driver={SQL Server};Server= (local)...
-1
votes
2answers
98 views

Connection string throws a SqlConnection Error [closed]

I gave the copied string: SqlConnection con = new SqlConnection("Data Source=ANUPAM-DESKTOP\ANUPAM;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;...
1
vote
1answer
453 views

connect SQL server file (mdf) with R tool [closed]

It's possible to connect SQL server file (mdf) with R tool in visual studio 2017? I tried that many times but the connection failed. From visual studio2017, I want to connect R with Sql server ...
2
votes
2answers
6k views

Database version is higher than SSMS and throwing error when attempted to create table

I have installed VS 2017. After that I have installed SQL Server 2014. Whenever I create a DB using SSMS and attempt to create a table it returns the following error: This backend version is not ...
2
votes
3answers
2k views

Installation of Microsoft SQL Server Data Tools Hangs

I'm attempting to install SQL Server Data Tools, but the installation is hanging. It had an error the first attempt; and I've restarted the machine (as that seems to help in those scenarios). Now it ...
1
vote
1answer
6k views

Connecting MySQL to Visual Studio 2017

For the life of me, I cannot get the MySQL for Visual Force connector to work in VS. I just want to be able to add a MySQL database as a database connection in VS so I can build an integration. I ...
1
vote
2answers
980 views

How to delete stored procedures from a database project and have that reflect on the server?

I have a Visual Studio database project with several stored procedures. I deleted one of them and then published the project. But the SP was still present on the published database and I had to delete ...
1
vote
0answers
389 views

What is the <project name>.sqlproj.user file, and how is it created?

I want to move a .sln file to a directory above where it is currently located (because right now it's in a project directory, which isn't semantically correct). The project is called 'pName', and ...
2
votes
1answer
1k views

how do you reference server logins from a visual Studio database project?

I'm looking for a way to move all our SQL Server databases (on one server) into source control. I tried creating a solution, and then adding VS database projects to the solution that correspond to ...