Connection String

  • Thread starter Thread starter Arif Çimen
  • Start date Start date
A

Arif Çimen

Hi to everyone,

I created a Access Database (*.mdb) file.

I configured the connection string on the Server Exploer.

My problem is that this conncetion string has a path pointing to mdb file.
But after installing the application to the target machine, the path in the
connection string is invalid.

for Example:

my mdb file path is this on my machine
f:\folder\database.mdb

And the folder may be on the target machine is:

c:\program files\...\database.mdb

How can I deal with this problem.

Thanks for any help.

Arif Çimen.
 
Hi to everyone,
I created a Access Database (*.mdb) file.

I configured the connection string on the Server Exploer.

My problem is that this conncetion string has a path pointing to mdb file.
But after installing the application to the target machine, the path in the
connection string is invalid.

for Example:

my mdb file path is this on my machine
f:\folder\database.mdb

And the folder may be on the target machine is:

c:\program files\...\database.mdb

How can I deal with this problem.

Thanks for any help.

Arif Çimen.
Click to expand...

Arif, you probably should set the connection string in the source code.

string TEMPLATE = "gobbledygook={0}";
string path = "f:\folder\database.mdb";
string conn_string = string.Format(TEMPLATE, path);
mConn.ConnectionString = conn_string;

Only you know what TEMPLATE should be and how to calculate path.
TEMPLATE should be like what you already configured, but replace the explicit path with
{0}.

Alan
 
Hi to everyone,

I created a Access Database (*.mdb) file.

I configured the connection string on the Server Exploer.

My problem is that this conncetion string has a path pointing to mdb file.
But after installing the application to the target machine, the path in the
connection string is invalid.

for Example:

my mdb file path is this on my machine
f:\folder\database.mdb

And the folder may be on the target machine is:

c:\program files\...\database.mdb

How can I deal with this problem.

Thanks for any help.

Arif Çimen.
Click to expand...

Use your application config file to store the connection string. When you are
developing set the app config connection string to the development location.
When you distribute the application make sure the app config points to the
production location.

In your application code retrieve the connection string from the config file.

If you want to learn the details of what I am saying, read the help files
regarding configuration files.

Otis Mukinfus
http://www.otismukinfus.com
 
Back
Top