Remote and Local DB

[Errods]

Hi All,

I have a Application where in sometimes the user has to Access a Local DB and sometines a Remote DB.......

Till now i have been copying the Remote DB to the user local machine using the fileOpen as well as the Filesave method.......

Is there anyway through wich i connect directly to the Remote DB and not copying it to the local machiine...........


And wat care must be taken so as to prevent DeadLock............

M using SQLite.......... Is this possible with SQLIte or i need some Client-Server Database Engine............






Thaks in Advance

 

[jmcilhinney]

In an SQLite connection string you specify the database file to connect to. You would just specify the remote file path, assuming that the SQLite driver/provider supports this.

 

[Errods]

Example.........

An small Example would be of much Help

IP: 192.168.0.62
File path : C:\DB\DB_Cental.db

 

[jmcilhinney]

How would you navigate to the file in Windows Explorer or Internet Explorer? That's the path you use. If you can't access it with one of those then you can't access it with a connection string. You may not be able to anyway but I'm not sure either way.

 

[Errods]

Nd if its Dynamic then.........

 

[jmcilhinney]

Nd if its Dynamic then.........

I don't really know what you just said. Are you asking how to change the path at run time? If so then the ConnectionString property is just a String, so you can change part of it as you would any string. That said, if your ADO.NET provider has a DbConnectionStringBuilder, e.g. OdbcConnectionStringBuilder, then you can create one of those and just set the appropriate property.

 

[Errods]

Thanks a Ton for the Help ...................