i need to connect to a db on a web server from a vb application can i do it ? and how? thanks

Is the webserver/database remote or local?

Hi Fred, the web server is local right now but will be remote in the future to use it in a local i use the path with the provider - a regular connection with ado, but my question is what or, how to connect to a remote one - using the web as a middle tier. thanks Vb Madness

If you are using MS SQL or MS Access you can create a COM object to manage the connection or use a custom handler available in RDS 2. PS: If your using MS Access I would suggest picking up a copy of MySql(free to cheap), Access is a bit weak to build nTier applications on it. Using a custom handler the connection is pretty much the same as you are using once you are setup. Tweek the registry & .ini for security etc... Rs.ActiveConnection = “Handler=MyHandler.obj;Provider=MS Remote;Remote Server=http://www.somewhere.com;DSN=dbNameHere;” Rs.Source = “Select * from Products” Rs.Open Heres the tech doc on it: http://www.microsoft.com/data/ado/rds/custhand.htm MySql, Oracle as well as most other robust DBs have remote access features built-in.

Fred, Thanks a Banch, the article really hit the spot, i was looking for it in the crazy world of MSDN any way, take care. :)