.xlsx do not work in ODBC?

Open forum for end-user questions about Wine. Before asking questions, check out the Wiki as a first step.
Forum Rules
Locked
sathish
Level 1
Level 1
Posts: 6
Joined: Tue Nov 27, 2012 5:26 am

.xlsx do not work in ODBC?

Post by sathish »

Hi,

I am facing an issue while importing .xlsx files through ODBC. Does these files have any dependency on wine? I have changed the wine to 32 bit and copied the .dll files from win XP. I am getting an error "Specified driver could not be loaded due system error 126 (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb))." I have installed the drivers for ODBC. But still i am getting the same error.

Regards,
Sathish
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Re: .xlsx do not work in ODBC?

Post by dimesio »

Importing into what? Excel should just be able to open xlsx files, and no native dlls are needed.
sathish
Level 1
Level 1
Posts: 6
Joined: Tue Nov 27, 2012 5:26 am

Re: .xlsx do not work in ODBC?

Post by sathish »

Importing into MySQL server through ODBC. I am able to import .xls files fine into MySQL server. But i am not able to import .xlsx into MySQL server.
sathish
Level 1
Level 1
Posts: 6
Joined: Tue Nov 27, 2012 5:26 am

Re: .xlsx do not work in ODBC?

Post by sathish »

While configuring ODBC for xlsx I am getting this error. I am trying to import .xlsx files into MySQL. So had to configure the ODBC driver for xlsx.
Please note that I can configure and import .xls files properly. I am facing this problem only for .xlsx.
sathish
Level 1
Level 1
Posts: 6
Joined: Tue Nov 27, 2012 5:26 am

Re: .xlsx do not work in ODBC?

Post by sathish »

But in windows I am able to configure and import .xlsx files without any problem. But i am having issues in wine.
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Re: .xlsx do not work in ODBC?

Post by dimesio »

What Wine version? If it's not the latest development release, upgrade. If it doesn't work in the latest development release, post terminal output.
sathish
Level 1
Level 1
Posts: 6
Joined: Tue Nov 27, 2012 5:26 am

Re: .xlsx do not work in ODBC?

Post by sathish »

I am using the latest version of wine 1.4.

Here is the terminal output

fixme:msvcrt:msvcrt_get_flags :unknown flag c not supported
fixme:heap:HeapSetInformation (nil) 1 (nil) 0
fixme:ntdll:NtLockFile I/O completion on lock not implemented yet
fixme:heap:RtlCompactHeap (0x110000, 0x0) stub
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Re: .xlsx do not work in ODBC?

Post by dimesio »

That's not the latest version. The current development release is 1.5.18.
sathish
Level 1
Level 1
Posts: 6
Joined: Tue Nov 27, 2012 5:26 am

Re: .xlsx do not work in ODBC?

Post by sathish »

Hello

I have updated the latest version of wine to 1.5.18

And here is the terminal output:

p11-kit: couldn't load module: /usr/lib/i386-linux-gnu/pkcs11/gnome-keyring-pkcs11.so: /usr/lib/i386-linux-gnu/pkcs11/gnome-keyring-pkcs11.so: cannot open shar
ed object file: No such file or directory
fixme:msvcrt:msvcrt_get_flags :unknown flag c not supported
fixme:heap:HeapSetInformation (nil) 1 (nil) 0
fixme:ntdll:NtLockFile I/O completion on lock not implemented yet
fixme:heap:RtlCompactHeap (0x110000, 0x0) stub
fixme:winsock:WSAIoctl SIO_GET_EXTENSION_FUNCTION_POINTER: unimplemented DisconnectEx
fixme:imagelist:ImageList_DragLeave DragLeave hWnd != DragEnter hWnd
err:ole:RevokeDragDrop invalid hwnd (nil)
err:ole:RevokeDragDrop invalid hwnd (nil)
fixme:winsock:WSAIoctl SIO_GET_EXTENSION_FUNCTION_POINTER: unimplemented DisconnectEx
fixme:winsock:WSAIoctl SIO_GET_EXTENSION_FUNCTION_POINTER: unimplemented DisconnectEx
NT Man
Newbie
Newbie
Posts: 1
Joined: Thu Jan 24, 2013 5:53 am

Re: .xlsx do not work in ODBC?

Post by NT Man »

Any updates?
Wine 1.5.22 problem still here
User avatar
dimesio
Moderator
Moderator
Posts: 13367
Joined: Tue Mar 25, 2008 10:30 pm

Re: .xlsx do not work in ODBC?

Post by dimesio »

File a bug.
Locked