Hi all,
I am having some issues with connecting a progress database to SQL reporting services via ODBC.
I can connect to the DB through Windows ODBC. The connection does not use a username or password. This I think is where the problem is.
I try to connect to the ODBC connection through SQL by adding a shared datasource. However, I get the following error message, presumably because it requires a username and password:
"Insufficient information to connect to the datasource"
I have tried adding blank uid and pw in the connection string with no luck.
Any ideas??
I am having some issues with connecting a progress database to SQL reporting services via ODBC.
I can connect to the DB through Windows ODBC. The connection does not use a username or password. This I think is where the problem is.
I try to connect to the ODBC connection through SQL by adding a shared datasource. However, I get the following error message, presumably because it requires a username and password:
"Insufficient information to connect to the datasource"
I have tried adding blank uid and pw in the connection string with no luck.
Any ideas??