Hello everyone, I assume that this question cannot be answered positively, or maybe I am the first one who asks this, but I want to know whether it is possible to get (build from the installed, for instance) the portable version of SqlAnywhere and MobiLink components? Sometimes I change my workplace, and I do not want to install SA on Windows, because either I do not have rights, or I do not want to pollute the registry or "Program Files" with the application stuff. It is simpler for me to have everything in the USB stick, and use shell files to start the server and work with it. This also helps me to backup and recover my software quickly, if I need this. What do you usually do in such situations? Do you always use the remote server and the Sybase Central that you somehow carry with you, or you install the server, Thank you in advance for your thoughts, suggestions and the experience. asked 11 Feb '16, 08:21 Vlad |
Point #1: Everything I say here assumes that you have proper SQL Anywhere Licenses to do what you want to do on the machine in question. Point #2: If what I suggest doesn't work, run the SQL Anywhere install. On my development machine, I have 11 different versions of SQL Anywhere "installed", and I have never run the SQL Anywhere install on my developement machine in the 18+ years I've been developing the product. I always simply copy binaries from our build machines, which places newly build binaries in a directory structure that is the same structure used by our installer (that's important!). When I want to run a specfic version of SQL Anywhere, I open a DOS prompt, and run a batch file to setup the environment for that specific version. They'll be nothing in the start menu, and nothing in the SYSTEM PATH, so you'll have to run everything from the DOS prompt, which IMHO is the Right Way To Do Things anyway. What's the minimum :
Optional Stuff :
Hope tht helps. Please remember to ensure that you are properly licensed for whatever you do, so I enventually get paid. :) Reg answered 11 Feb '16, 10:06 Reg Domaratzki 2
I'll add that depending on the components that you need to use you may be able to use an even simpler "installation". For example, for by testing of the database server I typically just copy all of the needed files into a single directory, add the directory to my PATH, and start the server. This won't work if you are using Sybase/SQL Central or dbisql ... but does work if you use dbisqlc. If you are using ODBC you still need to register the odbc driver (Reg's first bullet above). Note however that the 'single directory' installation is not recommended so if it doesn't work for you then take Reg's advice and run the install or at least arrange the files into the appropriate directory tree hierarchy.
(11 Feb '16, 11:36)
Mark Culp
Replies hidden
1
Glad I'm not the only one still relying on that so-called deprecated tool:)
(12 Feb '16, 02:33)
Volker Barth
Thanks to both of you for sharing these inofficial "how-tos" - listen to the experts:) I'm glad that you don't have to answer whether you want to have the SA monitor data dismissed for each and every new EBF:)
(12 Feb '16, 02:38)
Volker Barth
1
Thank you very much for your comments and answers. I will probably install new versions to a VM machine and copy all binaries. Regarding the license, Reg, I have it. I am not sure that my money reach you eventually, but I really hope that they do :)
(12 Feb '16, 04:41)
Vlad
Just a small comment. I have noticed that to load SCJView, I have to have a config file in the Public\Documents directory. I have stolen it from the "c:\Users\Public\Documents\SQL Central 17.scRepository1700_64", and slightly modified paths from "c:\Program Files\" to "c:\myFolder\". The last part was to open Tools->Plugins and set the automatic load for all three plugins found by Sybase Central.
(14 Feb '16, 08:16)
Vlad
1
It is possible to extract the content of the installer as from a regular archive (I have tested on this file: SA1700_Windows_1359_EBF.exe). Then the content of the directory contains the MSI file: SQLANY64.msi, that can be extracted to any location using the solution from SO: http://superuser.com/questions/307678/how-to-extract-files-from-msi-package
I used the recommended utility, it works pretty well. In the output folder, you will see four directories: CommonDocFolder (with samples), Program Files (clear), System32 and System64 (WindowsAccessBridge-xx.dll).
(24 Feb '16, 04:05)
Vlad
1
In addition to the ODBC driver for SA, another DLL should be also registered: regsvr32 ulodbc17.dll (I use 64-bit version). Otherwise, scjview.exe will not be able to open UltraLite files.
(26 Feb '16, 07:30)
Vlad
More comments hidden
|