Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Connectivity » View Thread |
Messages 1 to 4 of 4 total |
Adding DSN for remote connection |
Thu, May 9 2013 12:47 PM | Permanent Link |
Sigma Assessment Systems, Inc. | 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. |
Fri, May 10 2013 4:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << 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 |
Mon, May 13 2013 11:59 AM | Permanent Link |
Sigma Assessment Systems, Inc. | 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 |
Tue, May 14 2013 12:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |