Member Avatar for elouch

Hi everyone. I got a situation here.

Usually making a T-SQL(using sqlclient) on a server is very simple in vb.net if you have access to a sever.
But I got this problem, where in a computer does not have access to that server but need to make a T-SQL on it without requesting an access.

I actually thought of 2 possible solution.
1. The application from the Computer(W/o access) will Use a valid IP address to connect on that server and make a T-SQL.
2. The application from the Computer(W/o access) will communicate to an application from the computer (w/ access) to make a T-SQL for it.

I actually want the 1st solution because it will save me time and effort and also, I only have a week to do this. But prankly, I don't know how to do the swapping of IP just to connect on the server.

Can someone help me with this?

thanks in advance.

  • 2 Contributors
  • 1 Reply
  • 517 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by kb.net
Member Avatar for kb.net

The connection string is the same whether you want to use the server name or IP:
ex:
Dim conn As SqlConnection = New SqlClient.SqlConnection("server=192.168.1.1;database=xxx;UID=yyy;pwd=zzz")

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.