Re: VB AND MS SQL 2000 REMOTE CONNECTIVITY
- From: "joel paula" <jp@xxxxxxxxxxx>
- Date: 12 Feb 2007 03:03:17 -0800
I use ADO.
With ADO, I use ADO COnnection Strings (no need for ODBC
configuration).
Example of an ado connecion string to a remote server:
Provider=SQLOLEDB.1;Data Source=82.84.25.67;
In this case, the user would be asked for an SQL username and
password, but you can also provide it in the connection string.
The server has to have TCP/IP protocol enabled (using SQL Server
Network Utility). The above string assumes you are using the default
TCP/IP port for SQL Server, but you can also configure it for another
port. For example, port 3456:
Provider=SQLOLEDB.1;Data Source=82.84.25.67,3456;
Your firewall would have to open that port (1433 is the default one).
All the best,
JOEL
On Feb 12, 7:46 am, psi...@xxxxxxxxxxxxxxxx wrote:
hi,
i have a vb 6 application running on LAN using ODBC. Now i want to
deploy it to a remote machine.
Now my problem is.
what is the best connectivity to use.
should i use odbc or which?. does any one have a solution for this?
Thanks
Pius
.
- References:
- VB AND MS SQL 2000 REMOTE CONNECTIVITY
- From: psigei
- VB AND MS SQL 2000 REMOTE CONNECTIVITY
- Prev by Date: Re: Make word open in front of app
- Next by Date: Re: Can't assign to read-only property
- Previous by thread: VB AND MS SQL 2000 REMOTE CONNECTIVITY
- Index(es):
Relevant Pages
|
