C#

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;

namespace MyLib
{
	public class Utility
	{

//--------------------------------------------------------------------------------
/// <summary>
/// Create (if necessary) the specified application data folder. This method 
/// only creates the root folder, and will throw an exception if more than one 
/// folder is specified.  For instance, "\MyApp" is valid, but 
/// "\MyApp\MySubFolder" is not.
/// </summary>
/// <param name="folderName">A single folder name (can have a backslash at either or 
/// both ends).</param>
/// <returns>The fully qualified path that was created (or that already exists)</returns>
public static string CreateAppDataFolder(string folderName)
{
	string appDataPath = "";
	string dataFilePath = "";

	folderName = folderName.Trim();
	if (folderName != "")
	{
		try
		{
			// set the directory where the file will come from 
			// under XP, the folder name is "C:\Documents and Settings\All Users\Application Data\[folderName]"
			// under Vista, the folder name is "C:\Program Data\[folderName]"
			appDataPath = System.Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData);
		}
		catch (Exception ex)
		{
			throw ex;
		}
		if (folderName.Contains("\\"))
		{
			string[] path = folderName.Split('\\');
			int folderCount = 0;
			int folderIndex = -1;
			for (int i = 0; i < path.Length; i++)
			{
				string folder = path[i];
				if (folder != "")
				{
					if (folderIndex == -1)
					{
						folderIndex = i;
					}
					folderCount++;
				}
			}
			if (folderCount != 1)
			{
				throw new Exception("Invalid folder name specified (this function only creates the root app data folder for the application).");
			}
			folderName = path[folderIndex];
		}
	}
	if (folderName == "")
	{
		throw new Exception("Processed folder name resulted in an empty string.");
	}
	try
	{
		dataFilePath = System.IO.Path.Combine(appDataPath, folderName);
		if (!Directory.Exists(dataFilePath))
		{
			Directory.CreateDirectory(dataFilePath);
		}
	}
	catch (Exception ex)
	{
		throw ex;
	}
	return dataFilePath;
}
}
}
// Usage:
//
using MyLib;
string dataFolder = Utility.CreateAppDataFolder("MyAppFolder");

Vuyiswa Maseko wrote:

i suggest you use ODBCConnection