For Microsoft Access Data Projects ( adp files ) or other ADO connections from clients (remote and local):
ADO Connection string
sCONN = "Provider=SQLOLEDB.1;Data Source=machine.arvixe.com\SQLEXPRESS,1433;Initial Catalog=database_name;User ID=user_name;Password=password"
The key is that the port has to be added to the end of the server name. And machine.arvixe.com can be interchangeable with 'localhost' when using this locally.
- 0 Els usuaris han Trobat Això Útil