Database connection in Visual Cobol

I upgraded to the latest version of Visual Cobol and my data connection no longer works. Has something changed with how I connect? I tried removing and then adding back the catalog using the ADO.Net connection editor and it still does not work. I test the connection from the connection editor and it connects successfully. Iget the following error in the program "A network-related or instance-specific error occurred while establishi". Any ideas on what may be wrong?

Hi David,

When exactly do you get that error and how is it returned, on EXEC SQL CONNECT, in sqlerrmc?

Thanks.

I upgraded to the latest version of Visual Cobol and my data connection no longer works. Has something changed with how I connect? I tried removing and then adding back the catalog using the ADO.Net connection editor and it still does not work. I test the connection from the connection editor and it connects successfully. Iget the following error in the program "A network-related or instance-specific error occurred while establishi". Any ideas on what may be wrong?

Hi Chris

It says that the connection can not be found. I tried un-caterloging it and redoing it but it still can not found the connection. It worked prior to updating to 2.2 and rebuilding. Any ideas?

Thanks

David

I upgraded to the latest version of Visual Cobol and my data connection no longer works. Has something changed with how I connect? I tried removing and then adding back the catalog using the ADO.Net connection editor and it still does not work. I test the connection from the connection editor and it connects successfully. Iget the following error in the program "A network-related or instance-specific error occurred while establishi". Any ideas on what may be wrong?

Hi Chris

It says that the connection can not be found. I tried un-caterloging it and redoing it but it still can not found the connection. It worked prior to updating to 2.2 and rebuilding. Any ideas?

Thanks

David

I upgraded to the latest version of Visual Cobol and my data connection no longer works. Has something changed with how I connect? I tried removing and then adding back the catalog using the ADO.Net connection editor and it still does not work. I test the connection from the connection editor and it connects successfully. Iget the following error in the program "A network-related or instance-specific error occurred while establishi". Any ideas on what may be wrong?

Did you create the ADO connection using the correct bitism of 32-bit or 64-bit?

If your application is built as target x86 then you need to use a 32-bit ADO connection, if it is x64 then it needs to be a 64-bit ADO connection.

ADO connections do not currently work in projects whose target is anyCPU.

For a test please create a brand new connection with a different name and see if that works.

Thanks.

I upgraded to the latest version of Visual Cobol and my data connection no longer works. Has something changed with how I connect? I tried removing and then adding back the catalog using the ADO.Net connection editor and it still does not work. I test the connection from the connection editor and it connects successfully. Iget the following error in the program "A network-related or instance-specific error occurred while establishi". Any ideas on what may be wrong?

Thanks Chris

Changing it to 64-bit worked. I would never had thought about doing that since it has been working before I upgraded to Visual Cobol 2.2.

Thanks again.

David

Sign up

Please log in or register:

Welcome to the Rocket Forum!

Please log in or register:

Scanning file for viruses.

This file cannot be downloaded