lakshmivaragan
Programmer
Hi,
I'm using TCLODBC to connect to MS-Access db which has password. Its working fine if the database is in local machine. If I go to network, I could not able to connect as it says "Password incorrect". If I unset the passowrd and connect it thru network, it works fine.
Pls examin the connection string given below...
#### For local - works fine ####
set connstr "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/mydb.mdb;pwd=passme"
database connect db $connstr
################################
Whereas for network...
#### For Network ####
set connstr "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database\\\\system1/database/mydb.mdb;pwd=passme"
database connect db $connstr
################################
Is this ODBC problem or with TCLODBC ?
Regs
Laks
I'm using TCLODBC to connect to MS-Access db which has password. Its working fine if the database is in local machine. If I go to network, I could not able to connect as it says "Password incorrect". If I unset the passowrd and connect it thru network, it works fine.
Pls examin the connection string given below...
#### For local - works fine ####
set connstr "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database/mydb.mdb;pwd=passme"
database connect db $connstr
################################
Whereas for network...
#### For Network ####
set connstr "DRIVER=Microsoft Access Driver (*.mdb);DBQ=database\\\\system1/database/mydb.mdb;pwd=passme"
database connect db $connstr
################################
Is this ODBC problem or with TCLODBC ?
Regs
Laks