ole db connection string
-
Hi, can i get the connection string to connect to a microsoft access database in a remote mechine. "Provider=Microsoft.Jet.OLEDB.4.0;server=127.0.0.1;database=" & Application.StartupPath & "\News.mdb;UID=;Password=;". can i set something like this? Thanks for your attention. Thomas
-
Hi, can i get the connection string to connect to a microsoft access database in a remote mechine. "Provider=Microsoft.Jet.OLEDB.4.0;server=127.0.0.1;database=" & Application.StartupPath & "\News.mdb;UID=;Password=;". can i set something like this? Thanks for your attention. Thomas
I myself have used this so try it Provider=Microsoft.Jet.OLEDB.4.0;Data Source=remotemachine\db.mdb;User Id=;Password=; Regards
-
Hi, can i get the connection string to connect to a microsoft access database in a remote mechine. "Provider=Microsoft.Jet.OLEDB.4.0;server=127.0.0.1;database=" & Application.StartupPath & "\News.mdb;UID=;Password=;". can i set something like this? Thanks for your attention. Thomas
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=remotemachine\db.mdb;User Id=; Password=;
-
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=remotemachine\db.mdb;User Id=; Password=;
Sir, as your direction. i set the connection like this. Dim strConString As String Dim Cn As OleDbConnection strConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://loacalhost/D:\\News\\News\\bin\\News.mdb" Cn = New OleDbConnection(strConString) Cn.Open() This will make an error : Not a valid file name. Thanks for reply Thomas