Hi,
I created the ODBC on the server.
And I created the connection on the Designer, but when I tried to test, I had that error:
the server is not responding …
DBD: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Could you help me please?
Renata
santana (BOB member since 2009-04-16)
check user_name, password and database are correct
or
connect to the database using the user/pass… using SQL utility., then use the same user/pass and database in your connection.
With the above, you can find out whether the server is up and running and accepting connections.
BO_Chief 
(BOB member since 2004-06-06)
Hi,
Did you try testing the connection in Designer in your local desktop or the BO server where the ODBC DSN is already defined.
Thanks.
herb3880 (BOB member since 2009-04-17)