I am trying to add a System DSN to my local work station.  I have successfully added a local DSN for my database, but would like to add a remote connection.  

Using Vista Business - 32 bit
odbccad32 - to create the DSN (local and remote)
elevatedb unicode is running as a service.

I get to the point where I input the User and password Administrator/EDBDefault and get login failed #501

My database is encrypted and the catalog is encrypted.  I don't see anywhere where you can type in the encryption password for the database.  Enable encryption checkbox is UNCHECKED (don't send data to server encrypted)

ElevateDB Manager has a remote connection to my database working.  the session - connection parameters show a text box to input the password, but the in the DSN creation there is no where to add in the encryption password.

I have created DSNs for dummy databases with and without encrypted catalog files, they work for local connection but not remote.

Have I set up my server incorrectly somehow? catlog files in a wrong place?  Is this a permission issue?

Any suggestions appreciated.

<< My database is encrypted and the catalog is encrypted.  I don't see
anywhere where you can type in the encryption password for the database. >>

You can do so by directly editing the registry for the DSN:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2dac&topic=Registry_Entries

The setting that you want is the ENCRYPTPWD setting.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Thank you Tim,

However I cannot create a DSN for a remote connection without the password entry.  It stops me at the step after the administrator login screen - error #501 invalid login.

I did create a local entry - I see it in the registry and change the local to a remote type and added the password registry entry and still no connection.  removed config path - assume remote uses the edbsrvr entries which are the same as the local entries.

here is the updated reg entry

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Sigma Report]
"Driver"="C:\\Program Files\\ElevateDB 2 DAC-CS\\libs\\edbodbcunicode\\edbodbc.dll"
"NAME"="Sigma Report"
"DESCRIPTION"=""
"READONLY"="FALSE"
"TYPE"="REMOTE"
"TEMPPATH"="C:\\Users\\Public\\Documents\\ElevateDB DSN temp"
"LARGEFILES"="FALSE"
"UID"="Administrator"
"PWD"="EDBDefault"
"DATABASE"="SIGMADatabase"
"ROWLOCKPROTOCOL"="PESSIMISTIC"
"ROWLOCKRETRIES"="15"
"ROWLOCKWAIT"="100"
"DETECTROWCHANGES"="FALSE"
"STANDARDNULL"="TRUE"
"FLUSHWRITES"="FALSE"
"KEEPTABLESOPEN"="FALSE"
"ENCRYPTPWD"="PasswordEncrypt"
"ADDRESS"="127.0.0.1"
"PORT"="12010"
"ENCRYPTED"="FALSE"

Changing ENCRYPTED to TRUE does nothing.

Thanks for your time on this.
Ron

<< However I cannot create a DSN for a remote connection without the
password entry.  It stops me at the step after the administrator login
screen - error #501 invalid login. >>

That can mean one of two things:

1) The user name/password combo is wrong.
2) The encryption password being used for the remote connection doesn't
match that being used by the EDB Server.

Since you can connect using the EDB Manager, then 1) is the most likely
scenario, and you just need to make sure that you're using the same login
name/password that you're using with the EDB Manager.  To do this, go into
the EDB Manager, right-click on the session name that you're using, and
select Edit Session.  Once the Edit Session dialog appears, click on the
Login tab.  From the Login tab, just click on the Show Password icon next to
the Password edit.  That should show you the user name and password that
you're using successfully with the EDB Manager.

<< here is the updated reg entry >>

That all looks good, assuming that the encryption password matches that of
the EDB Server configuration and you're using the correct user name/password
for logging in (IOW, the default administrator/password combo hasn't been
changed or altered in any way).   Can you post your edbsrvr.ini file from
the EDB Server machine ?  You can find it here:

C:\ProgramData\Elevate Software\ElevateDB Server  (Vista or higher)

C:\Documents and Settings\All Users\Application Data\Elevate
Software\ElevateDB Server (XP or lower)

Tim Young
Elevate Software
www.elevatesoft.com