Hi can someone please help me with database connection, everything works fine my only problem's that when I compilethe project and install it on another machine and try to login it gives me this Error:
"‘C:\Documents and Settings\Developers\My Documents\Visual Studio 2005\Projects\ITDivision\ITDivision.mdb’ is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides"
Code:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Security.Cryptography;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace ITDivision
{
public partial class Login : Form
{
/// <summary>
/// Key for the crypto provider
/// </summary>
private static readonly byte[] _key = { 0xA1, 0xF1, 0xA6, 0xBB, 0xA2, 0x5A, 0x37, 0x6F, 0x81, 0x2E, 0x17, 0x41, 0x72, 0x2C, 0x43, 0x27 };
/// <summary>
/// Initialization vector for the crypto provider
/// </summary>
private static readonly byte[] _initVector = { 0xE1, 0xF1, 0xA6, 0xBB, 0xA9, 0x5B, 0x31, 0x2F, 0x81, 0x2E, 0x17, 0x4C, 0xA2, 0x81, 0x53, 0x61 };
private OleDbConnection conn;
public Login()
{
InitializeComponent();
conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\Developers\Desktop\ITDivision\ITDivision\ITDivision.mdb");
}