We are using a SQL Server Linked Server to access data in cobol files. It worked ok, until we decided to restart it using the following commands:
del C:\DATABASE\CRPO\XDBC_CRPO\xdbc\*.* /q
call ainit -d C:\DATABASE\CRPO\XDBC_CRPO\xdbc
call xdbcutil -c -d C:\DATABASE\CRPO\XDBC_CRPO\xdbc
call xdbcutil -d C:\DATABASE\CRPO\XDBC_CRPO\xdbc -f C:\DATABASE\CRPO\XDBC_CRPO\xfd
I did not get any errors when running the commands, but after this I was not able to get the data through the linked server anymore. I get the error saying:
OLE DB provider "MSDASQL" for linked server "MyServer" returned message "[TOD][ODBC Driver]Invalid USERID and/or PASSWORD".
As you can see below, there is no password set for this ODBC connection.
The driver we are using is version 8.01.
The Linked server is configured like this:
This is how it has always been and has worked.
If I use XDBCQuery with the following parameters it's working to get data from the files using SQL syntax:
It's been awhile since I created a catalog but I believe there are some options you can pass to ainit that will not create the user and group tables for the catalog. In other words it doesn't pass -p or -pa to xdbcutil.If i remember correeclty, I gave up on ainit because of errors it was throwing and created everything using xdbcutil. The username and password should cache so I am not sure it will affect performance.