SQL reporting: Connect ODBC error

[hambo12]

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??

 

[keenanbr]

When you say 'I can connect to the DB through Windows ODBC' do you mean you have tested the connection. If not create a .udl file and test connection.

 

[genomon]

What is the text of the connection string?

Ever notice how fast Windows runs? Me neither.

 

[hambo12]

Hi and thanks for the info so far.

Below is the connection string I use in SQL reporting services (the same I use to connect via Windows ODBC):

Dsn=QAD2008;host=rdadmqad01;port=7110;db=mfglive;uid=SYSPROGRES

I have connected through Administrative Tools > ODBC without credentials, however SQL reporting gives me the "insufficient information" error...

 

[SkipVought]

Check out

http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForSQLServer

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[keenanbr]

I would still suggest using a .udl to test your connect string.