BetoVelasco
Programmer
I am using an ADO connection to an access database that is located on a URL. How do i go about doing this??
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 strongm 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 connect to a database located on a URL?
- Thread starter BetoVelasco
- Start date
- Status
For an SQL Server:
ConnectionString = "driver={SQL Server};server=11.11.11.11;uid=user;pwd=password;database=YourDB"
Where:
11.11.11.11 = server ip address
driver={SQL Server} -> here use access driver
You can try to create a dns name first.
Have fun.
Success
ConnectionString = "driver={SQL Server};server=11.11.11.11;uid=user;pwd=password;database=YourDB"
Where:
11.11.11.11 = server ip address
driver={SQL Server} -> here use access driver
You can try to create a dns name first.
Have fun.
Success
- Status
