Hi LansaHelp,
I wasn't able to get this working with the domain user. We kept fiddling with it, though, and were eventually able to display the login page. Here is what worked for us. Let me know if this is logically correct:
1. In the database configuration of the deployment we set Trusted ...
Search found 9 matches
- Thu Apr 20, 2023 5:14 am
- Forum: Questions & Answers
- Topic: LANSA to MS SQL Server on separate machine
- Replies: 8
- Views: 17560
- Tue Apr 18, 2023 2:35 am
- Forum: Questions & Answers
- Topic: LANSA to MS SQL Server on separate machine
- Replies: 8
- Views: 17560
Re: LANSA to MS SQL Server on separate machine
Unfortunately no. This is uncharted territory. Our LANSA background has been on AS/400 or Windows where the database and code reside on the same machine. Our experience with SQL Server on a separate machine has been with other languages, not LANSA.
Can you provide any instructions or point to some ...
Can you provide any instructions or point to some ...
- Mon Apr 17, 2023 3:21 pm
- Forum: Questions & Answers
- Topic: LANSA to MS SQL Server on separate machine
- Replies: 8
- Views: 17560
Re: LANSA to MS SQL Server on separate machine
Hi René,
I followed the instructions in the LANSA documentation but have not been able to connect to the database. It seems the instructions work for the situation where the database and the LANSA code reside on the same machine. I am trying to have the database on a separate server. Do you have ...
I followed the instructions in the LANSA documentation but have not been able to connect to the database. It seems the instructions work for the situation where the database and the LANSA code reside on the same machine. I am trying to have the database on a separate server. Do you have ...
- Sun Apr 16, 2023 2:13 pm
- Forum: Questions & Answers
- Topic: LANSA to MS SQL Server on separate machine
- Replies: 8
- Views: 17560
Re: LANSA to MS SQL Server on separate machine
Hi René,
Thanks for responding.
No, the Web Administrators Test Connection does not complete successfully. It returns a pop up with the following messages:
Connection failed (0x0000001c)
Is the database started?
Is the user allowed to access the database?
Is the IP address or hostname of the ...
Thanks for responding.
No, the Web Administrators Test Connection does not complete successfully. It returns a pop up with the following messages:
Connection failed (0x0000001c)
Is the database started?
Is the user allowed to access the database?
Is the IP address or hostname of the ...
- Sat Apr 15, 2023 4:35 am
- Forum: Questions & Answers
- Topic: LANSA to MS SQL Server on separate machine
- Replies: 8
- Views: 17560
LANSA to MS SQL Server on separate machine
We are attempting to deploy a LANSA WAM application to an environment where the LANSA code is on a different server from MS SQL Server database. The deployment executes successfully - DB tables, Logins and Users are created on the database but attempts to pull up our login page gives:
Unrecoverable ...
Unrecoverable ...
- Thu Sep 22, 2022 5:52 am
- Forum: Questions & Answers
- Topic: LANSA Integrator SOAP Service - Unable to allocate ODBC statement handle
- Replies: 2
- Views: 7116
Re: LANSA Integrator SOAP Service - Unable to allocate ODBC statement handle
Thanks for responding, Dino.
It turned out to be the way IUSR was locked down on the server. It had no permission to access the database but it seemed LANSA was expecting it to have access. Once access was provided, the code ran successfully.
I did open a ticket with LANSA support also, as the ...
It turned out to be the way IUSR was locked down on the server. It had no permission to access the database but it seemed LANSA was expecting it to have access. Once access was provided, the code ran successfully.
I did open a ticket with LANSA support also, as the ...
- Wed Sep 21, 2022 10:39 am
- Forum: Questions & Answers
- Topic: LANSA Integrator SOAP Service - Unable to allocate ODBC statement handle
- Replies: 2
- Views: 7116
LANSA Integrator SOAP Service - Unable to allocate ODBC statement handle
Has anyone seen this error before and/or know how to fix it?
We are running Visual LANSA/LANSA Integrator V15 on Windows. When we interrogate our SOAP Server service, we are seeing these messages in x_err.log. We aren't attempting to access LX_F96 so suspecting the error is occurring in some LANSA ...
We are running Visual LANSA/LANSA Integrator V15 on Windows. When we interrogate our SOAP Server service, we are seeing these messages in x_err.log. We aren't attempting to access LX_F96 so suspecting the error is occurring in some LANSA ...
- Thu Sep 01, 2022 8:00 am
- Forum: Questions & Answers
- Topic: Migrate Integrator Studio project from one LANSA install to another
- Replies: 2
- Views: 10997
- Wed Aug 31, 2022 1:44 pm
- Forum: Questions & Answers
- Topic: Migrate Integrator Studio project from one LANSA install to another
- Replies: 2
- Views: 10997
Migrate Integrator Studio project from one LANSA install to another
Is there a recommended way to migrate an Integrator Studio project from one LANSA install to another? The source install version is different from the destination install version. Is copying the project's folder from the workspace folder of the source install to the workspace folder of the ...