connection string
-
Hi i've made a connection object with ConnectionString that looks like: "Data Source= C:\...." the problem is that when i an installation of that program it looks for the database file in the specific location that i wrote in the connection string. how can i make the connection string so it'll turn to the database in the same directory where the app's EXE is located?
-
Hi i've made a connection object with ConnectionString that looks like: "Data Source= C:\...." the problem is that when i an installation of that program it looks for the database file in the specific location that i wrote in the connection string. how can i make the connection string so it'll turn to the database in the same directory where the app's EXE is located?
Hi,, If you use VB6 use App.Path to get the EXE folder.
"DataSource=" & App.Path & "\FileName.mdb;......."
-
Hi,, If you use VB6 use App.Path to get the EXE folder.
"DataSource=" & App.Path & "\FileName.mdb;......."
-
Dim strPath As String = Application.StartupPath & "\db4.mdb" Dim Connection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath
Application.StartupPath being the app's path ( like App.Path in vb6 ) hope it helps.:)Csharp™ the coder formally known as dynamic
Dim TwinsHaveArrived As String = "twins arrived safely , 17/08/2003 (18:05 & 18:07)"