Setting up ODE DB connection

Discussion in 'ASP.NET / ASP.NET Core' started by sionsolo420187, Apr 1, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. hi,
    im trying to Set up ODE DB connection, i am running windows 2k and i have mdac 2.8 installed and all that stuff ya know, i have 1 file dns 1 user and 1 system databases configured in my odbc manager, all of them go to the same database
    D:\import\main.mdb
    its all in Access 2000

    all of the odbc databases are configured to
    login= admin
    pass = password

    now when trying to create a connection within dreamweaver i click on templates and choose ms access 2000 jet driver, and then it askes me for the parameters, i have them like this
    Provider=Microsoft.Jet.OLEDB.4.0;
    Data Source=[maindb];
    User ID=[admin];
    Password=[password];

    now my user dns is named maindb my file dns is odbcmaindb.dsn saved in D:\import\ and my system dns is named sysmaindata non of the odbc connections are pointing to a system.wmd only to
    D:\import\main.mdb

    when trying to test the connection in dreamweaver it says user name or password invalid, now
    i have a couple NT users on my comp ive tried their logins and all of mine, nothing seems to work
    i really need to make this connection is ASP.net can any one help me out what am i doing rong?
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    I think you confused the Windows user with MS Access's user. Does your MS Access database ask you to put in a password when you open it with Access? If not, you do not need to provide the username / password in your connection string.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page