Que talca !!!
alguien sabe como acceder a una Base de Datos Access,que esta en un Servidor de Internet, desde una aplicacion Visual Basic!!
Please!!!......
Gracias....y..... chabela!!
----------------------------
| |||
VB.....con INTERNET Que talca !!! alguien sabe como acceder a una Base de Datos Access,que esta en un Servidor de Internet, desde una aplicacion Visual Basic!! Please!!!...... Gracias....y..... chabela!! ---------------------------- |
| |||
Re: VB.....con INTERNET Busca el codigo en www.vbcode.com es un "remote.dsn" o algo asi... set cnnGeneric = new Connection ' cnnGeneric.Open "Provider=MS Remote;" _ & "Remote Provider=MSDataShape;" _ & "Remote Server=http://www.eviciti.com;" _ & "Data Source=Products;" _ & "User Id=Distributor;Password=trythis1;" ' set rsGeneric = new Recordset ' With rsGeneric .CursorLocation = adUseClient .Open strQuery, cnnGeneric, adOpenStatic, adLockReadOnly .ActiveConnection = nothing End With ' The crux of the connection lies in the connect string (duh!). You must specify, the provider as "MS Remote" - notice the space in the keyword. I then must provide the address to the "Remote Server". Note that I could just as well have said "http://192.168.1.1";. "Data Source" is the DSN you are trying to open on the server. User Id and Password are self explanatory. |