Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 10 of 10 total |
sending table password via odbc connection string |
Mon, Oct 16 2006 6:22 AM | Permanent Link |
Nick Hemsley | 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. |
Mon, Oct 16 2006 2:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Nov 19 2006 9:03 AM | Permanent Link |
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. |
Mon, Nov 20 2006 11:43 AM | Permanent Link |
Viet | 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. |
Mon, Nov 20 2006 4:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jan 23 2007 11:23 PM | Permanent Link |
Nick Hemsley | 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 |
Tue, Jan 23 2007 11:25 PM | Permanent Link |
Nick Hemsley | 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. |
Wed, Jan 24 2007 11:17 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Jan 24 2007 9:33 PM | Permanent Link |
Nick Hemsley | 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 |
Thu, Jan 25 2007 12:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |