Which is better to use ODBC Connection(System DSN) or OLEDB? In our experience, we are using oledb connection, but our problem is if our server name or server port change we are obliged to recompile reports. in our application at runtime we are also passing oledb connection parameters.
For example we compile the reports using stldev as server name and port is 7000. In our application at runtime we also pass this connection parameters: stldev as server name and port is 7000. Now we notice that if at runtime we pass a different connection parameters lets say stldev as server name and port is 8000 we notice that loading of reports slows down.
Now I'm thinking of using ODBC System DSN instead. does it worth it?