Home / Questions / 51314
Accepted
Pedro Miguel Pimienta Morales
Asked: 2020-02-24 09:01:54 +0800 CST 2020-02-24 09:01:54 +0800 CST

Insert data into SQL Server without being installed on my computer

  • 772

I want to know if there is any way to insert data into a database that is in SQL Server without having any of its versions installed or having Visual Studio installed on my computer.

These are the data I have:

  • server = tcp:"Link to connect to the DB", 1433
  • user = username
  • pass = password
sql-server

4 Answers

  1. Best Answer

    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 they are not on the same network, a VPN is a possible solution :D

    Now, if what you mean is a software to manage and/or execute queries, I recommend the same SQL Server Management Studio https://docs.microsoft.com/en-us/sql/ssms/download-sql- server-management-studio-ssms and if in case you are looking for a good alternative to it, use this one: http://www.squirrelsql.org/

    • 6 
  2. 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
    • 0

  3. Also, you have this option

    Toad SQL Server

    • 0

  4. You could connect using Navicat is a database manager.

    • -1