Compilation Error; LNK1104: cannot open file "user32.lib'

[arthurhsk]

Hi,

I tried to compile prest-odbc but got error as follows:

LINK: fatal error LNK1104: cannot open file 'user32.lib'
--- errorlevel 1104
Makefile:36: recipe for target 'driver' failed'

I tried two versions of Windows, both have the same error:

1. Windows 8.1
   dmd 2.065
   Express 2013 with Update 4 for Windows Desktop

2. Windows 7
   dmd 2.065
   Express 2013 with Update 4 for Windows Desktop

Please help!!

Regards
Arthur

[nezihyigitbasi]

@arthurhsk First to state the obvious, please follow the installation instructions at https://github.com/prestodb/presto-odbc . The ODBC driver requires dmd 2.065, which has to be installed after Visual Studio. Also make sure that after you install Visual Studio, the VS_HOME variable in the Makefile points to the correct Visual Studio path.

[nezihyigitbasi]

@arthurhsk Btw you can also try the Windows installer: https://github.com/prestodb/presto-odbc/releases

[arthurhsk]

HI,

Thank you so much!! I have installed the Windows Installer.

Few questions:
Q1: When I try to connect to DB, it prompts up a notepad for the connection string,
about "key=value;key=value", what is the key names for user and password?
Are they "Username=myname;Password=mypass"?

Q2: It seems that I need to enter these strings manually every time, is it possible to set up the ODBC DSN so I can avoid repeating manual input? (I have tried to add DSN, but it returned "the driver cannot be accessed"), or how do you save/handle the DB connection string?

Regards
Arthur

[nezihyigitbasi]

Q1: please see https://github.com/prestodb/presto-odbc/blob/master/connection-parameters.md
Q2: AFAIK you can't automate that currently.

[markisaa]

To add: I do not believe that we support passwords at the moment.