Path Specification In Connection String (VB.NET)
Posted on 2010-11-15
At thhe start of my Application's Module I have the following code:
Public sPath As String
When my application starts, I have the following code:
sPath = Application.StartUpPath
My Connection String looks like this:
QtCon.ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=C:\Mayibuye\Quotations.accdb"
Now for obvious reasons, when I deploy the Application, I need to include the definition of Path into this connection. When I use sPath immediately after DataSource=, then I get an error with the following description:
"Format Of The Initialisation String Does Not Conform To Specification."
I am sure there must be a good (or better) way of doing this. Can somebody help me please.
I am Using VB.NET (Visual Studio 2008) under Windows XP Pro.