cancel
Showing results for 
Search instead for 
Did you mean: 

Universe....error on data provider warning......

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

MariannevL
Advisor
Advisor
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Suresh,

the connection is responding.using this universe i created WebI,it works fine.but i tried the same thing in QAAWS,i`m getting error..

thanks in advance..

Regards,

Sella Perumal P

amitrathi239
Active Contributor
0 Kudos

Hi,

What is your data source for Universe?

Thanks,

Amit

Former Member
0 Kudos

Hi,

SQL server 2008 is the datasource....

Thanks,

Sella Perumal P

MariannevL
Advisor
Advisor
0 Kudos

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