Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
1  General / Gerrit-Jan Linker's Weblog / Debug inline javascript in google chrome
 on: 08.09.17 at 09:31:39 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Debug inline javascript in google chrome
 
Inline javascript code is not seen as a source by Google Chrome unless you add a comment at the end of the script block.  
The following comment will add the inline js code as source: inline.js in the chrome debugger.
 
<script type="text/javascript" >
  ... the code lines ...
//# sourceURL=inline.js
</sc
ript>

 
It is also necessary that the type of the script is set to text/javascript.
Reply Quote Notify of replies  

2  General / Gerrit-Jan Linker's Weblog / Find computer serial number
 on: 14.10.16 at 12:20:32 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Find computer serial number
 
To find a computer's serial number, the following command can be used in a MSDOS window:
WMIC BIOS GET SERIALNUMBER
Reply Quote Notify of replies  

3  SQL*XL / Database Connections / Oracle connections through LDAP
 on: 14.06.16 at 21:27:10 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Oracle connections through LDAP
 
It is possible to connect to Oracle databases through LDAP:  Lightweight Directory Access Protocol.
 
When using this protocol, the ldap.ora file can be used to specify the ldap properties.  
Location: $ORACLE_HOME/network/admin
 
In the sqlnet.ora file you need to specify the name resolution adapter in the following way:
NAMES.DIRECTORY_PATH=(LDAP)
or if you have multiple name resolution adapters:
NAMES.DIRECTORY_PATH=(LDAP, TNSNAMES, ...)
 
Source:
http://www.orafaq.com/wiki/Ldap.ora
Reply Quote Notify of replies  

4  SQL*XL / General Usage and Feature Troubleshooting / Re: date range in sql query is ignored
 on: 25.05.16 at 09:02:31 
Started by MikeLust | Post by Gerrit-Jan Linker
Hi,
We need a little more information. Which database do you use and which driver?
 
In general it is best to be explicit with dates and not rely on implicit conversions. A good query would be:
 
select * from mytable where mydate between to_date('01-01-2000', 'dd-mm-yyyy') and to_date('01-01-2010', 'dd-mm-yyyy');
Reply Quote Notify of replies  

5  SQL*XL / General Usage and Feature Troubleshooting / date range in sql query is ignored
 on: 13.05.16 at 19:15:20 
Started by MikeLust | Post by MikeLust
In a search of other forums there doesn't seem to be a report of this finding with SQL*XL 515.  The date range in my sql query is being ignored and the query pulls into Excel all records in the Oracle database table being queried (from Kronos Visionware), regardless of the date in the date field.  The same query returns an appropriate resultset when run the Visionware user interface custom query section. This is a recent occurrence - any advice?  Thanks.
Reply Quote Notify of replies  

6  SQL*XL / Evaluation, Installation & First use, Purchasing / Excel in safe mode: Use our digital certificate
 on: 09.05.16 at 09:36:55 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Excel in safe mode: Use our digital certificate
 
To ensure SQL*XL can run in Excel in safe mode, it is important that you mark our digital certificate as trusted. Excel will ask you to mark it as trusted, but if it does not you can do it manually too.
 
The important file to mark as trusted is sqlxl.xla. This file is located in the SQL*XL program folder (default installation directory is c:\program files\sqlxl).
 
Double click this file to open it in Excel. Alternatively, start Excel and use file-open to open it.
 
Excel might display a message similar to the message below. It states that it cannot use this file as a trusted file because the digital signature with which it was signed was not marked by you as trusted yet.
You can view the digital certificate as indicated by the arrows.
 
To mark the certificate as trusted, simply click the button in Excel marked with the arrow.
 
Reply Quote Notify of replies  

7  General / News and announcements / MasSim
 on: 29.04.16 at 10:44:08 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Software release: MasSim
 
A new version of the MasSim software was released. A digital signature was added to the code to ensure secure download and installation. On the technical level, old DAO code was rewritten as ADO code. The software was tested on windows 2010 (x86).
 
A new version of the program can be downloaded.
Reply Quote Notify of replies  

8  General / News and announcements / Software release: Outlook2Excel
 on: 19.04.16 at 12:00:45 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Software release: Outlook2Excel
 
A new version of the Outlook2Excel software was released. A digital signature was added to the code to ensure secure download and installation. The software was tested on windows 2010 (x86) and Outlook 2016.
 
A new version of the program can be downloaded.
Reply Quote Notify of replies  

9  General / News and announcements / Software release: Huckel 3.2
 on: 18.04.16 at 09:55:38 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Software release: Huckel 3.2
 
A new version of the Huckel software was released. A digital signature was added to the code to ensure secure download and installation. Enhancements include the calculation of bond orders and pi charges. Small fixes were applied to the user interface for windows 10. The software is now secured with a registration key. Upon download, a 10 day activation key is sent for an evaluation of the software with full functionality.
 
A new version of the program can be downloaded.
Reply Quote Notify of replies  

10  General / News and announcements / Software release: SQL*XL 2.2.12
 on: 15.04.16 at 23:59:29 
Started by Gerrit-Jan Linker | Post by Gerrit-Jan Linker
Software release: SQL*XL 2.2.12
For SQL*XL, version 2.2.12. was released.  
    
The new version is compatible with Windows 10 and Excel 2016.
A new digital certificate was added which ensures the software can run in Excel in secure mode.
    
 See also:  
SQL*XL Revision History  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130772637
Reply Quote Notify of replies