- Posts: 154
- Thank you received: 0
Record/Table Issues
8 years 1 month ago - 7 years 10 months ago #13393
by JD
Record/Table Issues was created by JD
I am having a problem with accessing Table/Record menu items that edit tables in our database. The IP address in the error message does not match up with the IP address of the connection each item is using, this was an old IP address on another server but we have since swapped it out.
5.3.1.13
5.3.1.13
Last edit: 7 years 10 months ago by JD.
Please Log in or Create an account to join the conversation.
8 years 1 month ago #13394
by JD
Replied by JD on topic Record/Table Issues
It looks like the issue could be with forms, the Tables/Records that aren't working are all using the same form but others that use a different form are working.
Please Log in or Create an account to join the conversation.
8 years 1 month ago #13395
by admin
Mike
ETL Architect
Replied by admin on topic Record/Table Issues
Have you tried reopening forms or restarting active table editor ?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
8 years 1 month ago #13396
by JD
Replied by JD on topic Record/Table Issues
Yeah I have closed and reopened a number of times. These files used to be associated with an older database connection, we moved them over from Postgres to SQL Server a few months ago and the issue started happening after the Postgres connection type was deleted.
Here is the connection string for the new sql server connection
Here is the connection string for the new sql server connection
Please Log in or Create an account to join the conversation.
8 years 1 month ago #13399
by admin
Mike
ETL Architect
Replied by admin on topic Record/Table Issues
Your source server is LOCALHOST
And that is a real problem
You should change it to actual server name
And that is a real problem
You should change it to actual server name
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
8 years 1 month ago #13401
by JD
Replied by JD on topic Record/Table Issues
I took out the IP address of the server in the picture, the actual source is x.x.x.x \LOCALHOST.
LOCALHOST is the instance name in the database, the IP is the host name of the database.
LOCALHOST is the instance name in the database, the IP is the host name of the database.
Please Log in or Create an account to join the conversation.