We are in the process of upgrade sql anywhere 12 to sql anywhere 16.
We use .net C#.
Instead of installing sql anywhere on user's machine, we use sql anywhere deployment package.
So, in our code, we start a new process which runs SAConnection with a connection string that specifies db name, user id and password etc. When using sql anywhere 12, we specify the environment variables as following:
myConverter = new Process();
string sqlAnywhereEnvDirectory = Path.Combine(myParameters.ResourceFolder, "SQL Anywhere 12") + @".";
myConverter.StartInfo.EnvironmentVariables["SQLANY12"] = sqlAnywhereEnvDirectory;
myConverter.StartInfo.EnvironmentVariables["SQLANYSH12"] = sqlAnywhereEnvDirectory;
The above code works for sql anywhere 12. but now we want to use sql anywhere 16, in my imagination, I just changed the reference to 12 to 16, hoping it could work, but it does not.
After fair bit of struggle, it appears that if the db is not using the default user name(i.e. dba) and not using the default password (i.e. sql), it does not work. The error I am getting is Connection error: Found server but communication error occurred
Does anyone know what to do to solve the problem? i.e. is there any other environment variable that we need to set?
Thanks in advance.
asked 06 Jul '15, 10:20