Search found 9 matches

by kofoster
Thu Apr 20, 2023 5:14 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

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 ...
by kofoster
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 ...
by kofoster
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 ...
by kofoster
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 ...
by kofoster
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 ...
by kofoster
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 ...
by kofoster
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 ...
by kofoster
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 ...