How to connect database server with different network
Hi all,
I have problem with my database application. I have two networks with separate
network address(A and B). The database server at network "A" and clients
at network B. How to connect clients in B area with VB to the server in A
area with TCP/IP connection(the clients in B area can't found netbios name
server in A area but the clients in B area can ping IP address in A area).
For your information, my database server is SQL Server and this application
is not web application.
Regards,
Narto
Re: How to connect database server with different network
On B side try adding sql server's alias into Client Network Utility (using
TCP/IP or some other protocol)
On B side try connecting to sql server with this alias (using Enterprise
Manager).
If you are using ADO then just set up a UDL file or create a connection
string and there you are.
--
Miha
www.spin.si
"Narto" <narto_gens@hotmail.com> wrote in message
news:3afa6c68@news.devx.com...
>
> Hi all,
>
> I have problem with my database application. I have two networks with
separate
> network address(A and B). The database server at network "A" and clients
> at network B. How to connect clients in B area with VB to the server in A
> area with TCP/IP connection(the clients in B area can't found netbios name
> server in A area but the clients in B area can ping IP address in A area).
> For your information, my database server is SQL Server and this
application
> is not web application.
>
> Regards,
> Narto