Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TCLODBC problem ?

Status
Not open for further replies.

lakshmivaragan

Programmer
Sep 30, 2003
25
IN
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
 
Finally I could get the solution. I should provide IP address instead of providing the machine name.

Regs
Lax
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top