topic Database Table List is Empty - Help! in QlikView

Database Table List is Empty - Help!

Fri, 12 Mar 2010 11:28:29 GMT

Hi,

I have a problem with retrieving the table list from a database I am connected to. We have checked that my computer can access the database using another piece of software and checked that I have the right permissions. The connect statement works if I link through from someone else's computer and shows the list of tables but when I link from mine - nothing!

I am using an Interbase Driver set up in the User DSN section but this is the same as my colleague so this should be fine.

Can anyone help?

Thanks,

Emma

Database Table List is Empty - Help!

Fri, 12 Mar 2010 13:46:11 GMT

Hi,

could you check that you can ping the Interbase Server from your machine ? in a DOS command line, try


ping myserverName

using the actual logical name of the machine that hosts the Interbase server, in place of "myserverName". Thus you'll check whether the machine's logical name resolves in a IP adress or not.

Also make sure that the ODBC data source is defined in the same section (User/System DSN) on both machines.

Hilaire

SV:Database Table List is Empty - Help!

Fri, 12 Mar 2010 13:50:34 GMT

Had the same problem although not with an Interbase driver. Worked for me when checking "Allow saving password". Then the list was populated.

/Michael

SV:Database Table List is Empty - Help!

Fri, 12 Mar 2010 14:02:40 GMT

hi Michael,

many thanks for the info ... where do you get the option to check the "Allow Saving Password". Is it within Qlikview or on your computer settings somewhere?

thanks,

Emma

Database Table List is Empty - Help!

Fri, 12 Mar 2010 14:04:36 GMT

Hi Hilaire,

I'll try that but I know the ODBC connection works and I know I can access the database from my laptop ... just not through Qlikview! That's what is so confusing 😞

Will let you if it works.

Cheers,

Emma

SV:Re: SV:Database Table List is Empty - Help!

Fri, 12 Mar 2010 16:18:27 GMT

It's when pressing connect on the "data" sheet in Qlikview (at bottom). Looking it over again I am using OLE DB and "OLE DB Provider for ODBC Drivers" where checking "Allow save password" helped.

Regards

/Michael

Database Table List is Empty - Help!

Fri, 17 Dec 2010 11:37:51 GMT

Hi All,

Just in case it was of interest ... turns out the dirver was the problem. I have changed the driver for my ODBC link from Interbase to Firebird and this seems to have resolved the problem.

Thanks,

Emma

Database Table List is Empty - Help!

Wed, 06 Jul 2011 09:22:36 GMT

For me it was important to use the 32 bit drivers via c:\windows\syswow64\odbcad32.exe, and force a 32 bit connection. Also I had to use a SYSTEM ODBC. The user odbc did not work.