I have set up a table registration in BIS using OTBL and have installed the client ODBC tools. The connection I set up using the following details:
Datasource name: Test
Resource name: <site letter to connect to>
Login User ID:
Host name or IP: <IP address of our BIS server>
Server port: 1802
I have tried a 'new database query' from Excel and, following the advise from the BIS ODBC server help file, keyed my username and department in the userID field and my password in the password field.
The help file said the following:
Enter the following
Your System data source name in the Data Source field.
Your user-id and department number in the User ID field.
Your password in the Password field.
I cannot get a connection though. I have tried my username and department with a space between them and without but cannot get it to work.
Can anyone help???