Errors in connecting to OLEDB

[#1]

Hi,

I am new to QlikView,

I have been connecting to my database using OLEDB provider;

and my script side code is

OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=D:\QlikView Development\Airline Operations\Data Files\MDBs\Dimension Tables.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

[Origin Airports]:

LOAD `%Origin Airport ID`, `Origin Airport`;

SQL SELECT `%Origin Airport ID`, `Origin Airport` FROM `Origin Airports`;

[Destination Airports]:

  LOAD `%Destination Airport ID`,

    `Destination Airport`;

  SQL SELECT `%Destination Airport ID`,

    `Destination Airport`

  FROM `Destination Airports`;

while reloading the script I getting these Errors

can antne help why i getting these error?

dont sher QVD I am using Personal edition;

thanks and regards

venu

[#2]

all are in my system are 32 bit versions(QV, Drivers)

Is your system is 64bit. If, then First go to My Computer -> Windows -> SysWOW64 -> odbcad32.exe

Double Click on odbcad32.exe

Then a pop up window ODBC Data Source Administrator is open then under User DSN select MS access Database and double click on it. Then a pop up window open for ODBC for Microsoft Access Setup is open. Then click on select and goto the path where your .mdb file is located and select that file and click ok. So your odbc connection is ready now come to Qlikview and pressing CTRL+E to come into script editor where you see data tab where you first click on Force 32 Bit and then select OLE DB from drop down list and press connect button. Then a pop up window of Data Link Properties is open . Here you select Microsoft Jet OLE DB Provider then click next then on next window just select your database table and test your connection and click ok

I had done this but I am getting the error in while reload..

when click test connection it shows connection is succeeded..

I am getting problem same;

[arsal_90]

Ok venu

go to your script and remove single quotations and place square bracket like below code. Basically the problem is that Qlikview script it read single quote wrongly so you remove single quotes from script and place single quote by your self:

LOAD [%Aircraft Configuration ID],

    [Aircraft Configuration];

SQL SELECT *

FROM `Aircraft Configuration`;

Or

LOAD '%Aircraft Configuration ID',

    'Aircraft Configuration';

SQL SELECT *

FROM `Aircraft Configuration`;

[arsal_90]

Venu

is your problem resolved

[#5]

Actually I commented the Below lines of connection string;

and reloAD GETTING SAME ERROR ;

[arsal_90]

Venu for your explanation the problem is that the field containing spaces So in qlikview if field name ha s space then we enclosed that field name in square Bracket or in Single quotes. For Example: 'Origing ID'  or [Originn ID] and the problem you are facing while extracting table script qlikview place single quote but it not read as single it read as character.

If your problem is resolved then check that post as Answer

[arsal_90]

Venu

dont comment the connection string lines your connection string is oK the problem is Table Script and i give the solution for that in second last post that place square bracket. like that

LOAD [%Aircraft Configuration ID],

    [Aircraft Configuration];

SQL SELECT *

FROM `Aircraft Configuration`;

[arsal_90]

if you are still getting error then send me the script of your.

[arsal_90]

if still getting error then also share your error screen shots

[arsal_90]

Hi Venu

is your problem resolved or not. if not then show me ur error snap shots and also show me ur script.

And if problem is resolved then mark as Answered.

[maxgro]

if possible, post  your access db or better a reduced (smaller) version, just one table, the first you load, with few records