on 09-15-2011 11:00 AM
Hi,
i created a universe when i am using the universe in QAAWS.i`m getting error like this get data provider warning....Data Source name not found and no default driver specified.....
how can i set default drivers?? where can i set?? can anyone give me a guide please....
Thanks,
Sella Perumal P
Hi,
Data source name not found is an ODBC message, you manage your ODBC data sources on your own pc.
Universe designer also runs on your pc, as does WebI rich client and DeskI.
So if those work, it means you defined the ODBC name on your pc the right way.
Now QAAWS is server based, meaning it will try to find the ODBC name on the BOE server, not on your pc.
Same is true if you try to run a WebI report from Infoview (HTML or java, not rich client). So a simple test can confirm, try running a webi from InfoView and see if you get the same errormessage.
Then you know for sure you will have to make the ODBC name available on the BOE server.
Work with the system administrator to make it available.
This also means that the actual database should be accessable from the server too.
So if you try to use an access database on your own pc for instance, this will not be possible.
The user that owns the server processes should have access to it.
Good luck,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
While creating universe in Designer try to test universe connection given to it. If it works then there shouldn't be any problem.
Cheers,
Suresh Aluri.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you used and ODBC connection to SQLserver, it is better to use the OLE DB connection type that is also available for SQL server.
This way you put the information needed to connect to SQL server all in the connection, instead of partly in the connection (which ODBC name) and partly in the ODBC name definition, making it available to everyone with access to the connection without having to have the ODBC name definition too.
If you really want to keep using ODBC, you have to define the ODBC name on the BOE server machine too...
Good luck,
Marianne
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.