I am having trouble accessing a table with encryption via the ODBC drivers with dbisam
3.xx (latest)

I have tried PWD=, Password= (gotten via web) and created a file-based dsn & copied the
relevant section which is:

TablePassword1=*gobblegook*

Does the TablePassword1 field need to be encrypted in the connection string, & is this the
right field name?

Thanks in advance.

Nick,

<< I am having trouble accessing a table with encryption via the ODBC
drivers with dbisam 3.xx (latest)

I have tried PWD=, Password= (gotten via web) and created a file-based dsn
& copied the relevant section which is:

TablePassword1=*gobblegook*

Does the TablePassword1 field need to be encrypted in the connection
string, & is this the right field name? >>

No, it is only encrypted in the registry, and yes, the name is fine.  The
table passwords are numbered from 1..x.

--
Tim Young
Elevate Software
www.elevatesoft.com

hi, i got the same problem as Tim Young ,i try to open a dataset  of  DBISAM  in Delphi 2006 link to a  OdbcConnection , the connected property of OdbcConnection can be set to true, but
just  while  i try to right click the OdbcDataAdapter ,and select the "Generate Database" ,a error "need a password" accored. Anyone know how to pass  a password into the
ODBCDataAdaper? or any dataset used in  asp.net app with  Delphi 2006.

hi,
i add keyword 'TablePassword1=Mypass' into Connection string, it work fine.
Rechard <netwheat@163.com> wrote:

hi, i got the same problem as Tim Young ,i try to open a dataset  of  DBISAM  in Delphi
2006 link to a  OdbcConnection , the connected property of OdbcConnection can be set to
true, but
just  while  i try to right click the OdbcDataAdapter ,and select the "Generate Database"
,a error "need a password" accored. Anyone know how to pass  a password into the
ODBCDataAdaper? or any dataset used in  asp.net app with  Delphi 2006.

Rechard,

<< hi, i got the same problem as Tim Young ,i try to open a dataset  of
DBISAM  in Delphi 2006 link to a  OdbcConnection , the connected property of
OdbcConnection can be set to true, but just  while  i try to right click the
OdbcDataAdapter ,and select the "Generate Database" ,a error "need a
password" accored. Anyone know how to pass  a password into the
ODBCDataAdaper? or any dataset used in  asp.net app with  Delphi 2006. >>

As indicated in the other response, you have to set the table password(s) in
the connection string or in the data source (if you're using a
pre-configured data source):

http://www.elevatesoft.com/dbisam4odbc_connection_strings.htm

If passing a table password via a connection string, just pass it as plain
text.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sorry to resurrect this after so long... I am now working on an installer for my app &
this has bitten me again (i never got it working, just removed the password)

It appears to be a problem with a space in the password.

here is the connection string:

DRIVER={DBISAM 3 ODBC
Driver};ConnectionType=local;CatalogName=c:\test-build\ProductName;ReadOnly=False;TablePassword1=AdminPassword;ForceBufferFlush=true

It is not working. If I remove the password, all works fine. The origional password had a
space in it, which I removed, still no luck.

I also removed all the other tables in the directory.

Does there appear to be anything amiss with the connection string? Is there perhaps a bug
in the version of the driver I am using? the dbodbc.dll file says it is version 3.30.1.1

Disregard the comment in the above post:

"It appears to be a problem with a space in the password"

I tested this also, and it is not the problem.

Nick,

<< It is not working. If I remove the password, all works fine. The
origional password had a space in it, which I removed, still no luck. >>

So the actual password for the tables is 'Admin Password' ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Nope, but im not putting the default table password here

the origional password did have a space in it, but I tried with or without.

Sorry I'm feeling like I am missing something possible simple, but cannot work out what it
might be.

I will test more with a small c# program or boo script, If I can reproduce it with a small
executable, then I will send to you for debugging.
Nick

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Nick,

<< It is not working. If I remove the password, all works fine. The
origional password had a space in it, which I removed, still no luck. >>

So the actual password for the tables is 'Admin Password' ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Nick,

<< Nope, but im not putting the default table password here>>

Sorry, I didn't mean to ask you to reveal the password exactly.  What I
meant to ask was it similar in that it had a space in it.

<< Sorry I'm feeling like I am missing something possible simple, but cannot
work out what it might be.

I will test more with a small c# program or boo script, If I can reproduce
it with a small executable, then I will send to you for debugging. >>

Thanks, that would be very helpful.

--
Tim Young
Elevate Software
www.elevatesoft.com