Perhaps the AyaNova.exe.config file the remote computer is using is incorrect. Or there is something with the configuration:
Please zip up the following files into a file called serverfiles.zipand attach to your reply:
-Web.Config from the computer where the Data Portal utility is installed to
-AyaNova.exe.config file from the computer
Please zip up the following file into a file called remotecomputer.zip and attach to your reply:
-AyaNova.exe.config file from the remote computer
Identify the following information:
-What is the IP address of the computer where the Data Portal is installed on
-You stated “remote test yields the following” - and than pasted a copy of the results. Confirm that this is from the computer where you installed Data Portal too . not the remote computer which your statement indicates
version 3 The AyaNova.exe.config file that you sent from the computer is connecting to a local stand-alone installation of the AyaNova database - it has not yet been configured to connect to the networked Firebird database and this should be done.
Easist way to do this, is log into AyaNova on a local networked computer and confirm connecting to the networked AyaNova database.
Than copy that local netowrked computers AyaNova.exe.config file to the server, and test making sure connecting to the networked databse, not a stand-alone database.
I’ve attached an AyaNova.exe.config file zipped to this message. I want you to do each of the following and provide specific details on what occurs for each one:
A. On the server where the database resides and where you have Data Portal set up, rename the existing AyaNova.exe.config file to AyaNova.exe.configlocalnetwork
-Extract the attached zip file to extract the AyaNova.exe.config file into the AyaNova program folder onto this server
-Run AyaNova - can you log into AyaNova on this server using this AyaNova.exe.config I just sent?
-If you can, open menu Help -> About AyaNova, copy all text to a NotePad document, save as serverAyaNovaHelp.txt and attach
-If you can not, provide the exact error you receive.
B. On a local networked computer, rename the existing AyaNova.exe.config file to AyaNova.exe.configlocalnetwork
-Extract the attached zip file to extract the AyaNova.exe.config file into the AyaNova program folder onto this server
-Run AyaNova - can you log into AyaNova on this networked computer using this AyaNova.exe.config I just sent?
-If you can, open menu Help -> About AyaNova, copy all text to a NotePad document, save as LANAyaNovaHelp.txt and attach
-If you can not, provide the exact error you receive.
I’m working with Bert to remedy this. Somehow our config files are getting changed.
Regardless. Our configuration is with an MSSQL server that we’ve migrated Firebird to using the tool. After that I configured the server configuration to use SQL: dir=ltr " ">
<appSettings>
<!–“Authentication” should always be set to “CSLA” -->
<add key=“Authentication” value=“CSLA” />
<!-- Set your database connection here, it’s easiest to just copy this section from a working and tested AyaNova.exe.config file–>
<!-- Note that Embedded Firebird can not be used with a data portal only a full shared Firebird server or MS sql server–>
<!-- The connection block below is a sample only, you will need to replace it with your specific settings–>
<!-- Do not change anything in this file other than the data connection sectin below -->
<!-- ****** Start of data connection section *****–>
<!-- Use a shared Firebird server, NOTE change the 192.168.1.100 below to your Firebird server’s actual IP Address -->
<add key=“ConnectionType” value=“DataBase” />
<add key=“DataBaseType” value=“MSSQL” />
<add key=“DataBaseConnectionString” value=“ServerType=0;DataSource=192.168.0.10;DataBase=AYANOVA;User=xxxxxx;Password=xxxxxx;Dialect=3;” />
<!-- ***** end of data connection section *****–>
</appSettings>
the IIS tests work and the firewall has been configured on a specific port.
locally the software works running the client on the server. From any client or remote it doesn’t. I suspect config files issue.
Before configuring the AyaNova Data Portal, you need to make sure that local networked computers themselves can connect. This must be done before proceeding.
Please confirm the following as I want to make sure of each item before we proceed:
On the AyaNova server itself, you are using SQL Server to host the AyaNova database - correct?
On the server itself, are you able to log into the AyaNova SQL database using the locally installed AyaNova program? - confirm this as the AyaNova.exe.config previously sent to me indicates use of the stand-alone default configuration which is conflicting information
From your post above, Server=localhost is being used - what is the IP address of the server where the database resides, and what is the actual servername for this server where the AyaNova SQLdatabase resides
Zip up a copy of the server’s AyaNova.exe.config file and attach labeled SQLserverAyaNova.exe.config.zip
I understand from your last post that you can not connect to the SQL Server database from a local networked computer?
What is the exact message you receive from a local network computer when you attempt to run the AyaNova program connecting to the AyaNova SQL database?
Zip up a copy of this local networked computers AyaNova.exe.config and name it localnetworkAyaNova.exe.config