Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how can i access a data from remote site
- Thread starter azamatali
- Start date
Hi,
It depends on the type of database that you are connections to, but it is all in the connection string. E.g. with SQL Server it would be something like
conn.open="Provider=SQLOLEDB.1;User Id=YourUserId;Password=YourPassword;Data Source=IP Address of Remote SQL
Server;Database=YourDatabase;Network Library=dmssocn;Network Address=IP
Address of Remote SQL Server"
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'
It depends on the type of database that you are connections to, but it is all in the connection string. E.g. with SQL Server it would be something like
conn.open="Provider=SQLOLEDB.1;User Id=YourUserId;Password=YourPassword;Data Source=IP Address of Remote SQL
Server;Database=YourDatabase;Network Library=dmssocn;Network Address=IP
Address of Remote SQL Server"
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'
- Status
