TCLODBC problem ?

[lakshmivaragan]

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

 

[lakshmivaragan]

Finally I could get the solution. I should provide IP address instead of providing the machine name.

Regs
Lax