Insert data in SQL Server without being installed on my computer

Navigation
5

I want to know if there is any way to insert data in a database that is in SQL Server without having any of the versions of this installed or have Visual Studio installed e my team.

These are the data I have:

  • server = tcp: "Link to connect to the DB", 1433
  • user = username
  • pass = password
asked by Pedro Miguel Pimienta Morales 23.02.2017 в 18:01
source

4 answers

6

That is possible, both computers / servers where the system will run and where the SQL Server will be installed must belong to the same network.

In case you do not go on the same network, a VPN is a possible solution: D

Now, if what you are referring to is software to manage and / or execute queries, I recommend the same SQL Server Management Studio link and if you are looking for a good alternative to it, use this: link

    
answered by 23.02.2017 / 18:03
source
0
Set cnn = New Adodb.Connection
            cnn.Provider = "SQLOLEDB"
            cnn.ConnectionString = "driver={SQL Server};" & _
                                   "server=195.248.589.11; " & _
                                   "database=Basedatos; " & _
                                   "uid=Usuario;pwd=password"
                                    cnn.Open
    
answered by 23.02.2017 в 18:51
0

Also, you have this option

Toad Sql Server

    
answered by 10.03.2017 в 01:15
-1

You could connect using Navicat is a database manager.

    
answered by 23.02.2017 в 18:03
Addition and subtraction in a chain For each in javascript?