|
|
|
Junior Member
 
Group: Forum Members
Last Login: 4/7/2008 8:34:10 AM
Posts: 19,
Visits: 58
|
|
| I had to change the import config file (AyaImport.exe.config) a litte for this to work, I thought I would post this up so that others could use it as well. I followed the Manual for setup and configuration of SQL worked fine. I down loaded in extracted the import utility that AyaNova has provided. -----you must modify "AyaImport.exe.config" -----file that you extracted. This is the database connection settings for the import utility, which only make sense to modify. Followed the rest of the manual, and it worked perfect. I hope this helps. ORGINAL CONFIG FILE <add key="DataBaseType" value="FireBird" />
<add key="DataBaseConnectionString" value="ServerType=1;DataBase=AYANOVA.FDB;User=AYANOVA;Password=AYANOVA;Dialect=3;" />
<add key="GenerateFromThisConnection" value="true"/> MODIFIED CONFIG FILE <add key="ConnectionType" value="DataBase" />
<add key="DataBaseType" value="MSSQL" />
<add key="DataBaseConnectionString" value="data source=SQL_SERVER_NAME;initial catalog=AyaNova;User Id=LOGINNAME; Password=PASSWORD;" />
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 5:11:14 PM
Posts: 1,778,
Visits: 4,123
|
|
Hi Just a heads up, as outlined in the AyaNova v3 Manual section, it is easier to just make a copy of your existing AyaNova.exe.config file which already connects to the SQL AyaNova database, and call that copy AyaImport.exe.config In this way, all the < and / and information is already in the AyaImport.exe.config file for you From the AyaNova v3 Manual section on configuring the AyaImport utility. i. If have configured AyaNova v3 to use the network Firebird configuration, or SQL Express configuration or SQL Server configuration: 1. Open Windows Explorer and move to the CEImport program folder 2. Rename the existing AyaImport.exe.config file to AyaImport.exe.config.BAK as we will not be using it. 3. Move to the AyaNova v3 program folder 4. Copy the existing AyaNova.exe.config file to the CEImport folder (this is the edited AyaNova.exe.config file that you had edited for use with your particular configuration) 5. Move back to the CEImport folder 6. Rename the AyaNova.exe.config file to AyaImport.exe.config 7. Continue to Step 4 Perform the AyaNova CE Import
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
Posted 4/2/2006 12:36:25 PM
