ODBC driver for widnows (vsql6.0) issue

Moderator: NorbertKrupa

Post Reply
integer
Newbie
Newbie
Posts: 3
Joined: Mon Nov 12, 2012 2:56 am

ODBC driver for widnows (vsql6.0) issue

Post by integer » Mon Nov 12, 2012 3:32 am

Hi,

I have a question.
There is no way to connect the ODBC for windows(vsql 6.0) to vertica 6.0.
Please let me know what I can do without downgrading version(vsql4.1).

Thanks & regards
Jay Han.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: ODBC driver for widnows (vsql6.0) issue

Post by JimKnicely » Mon Nov 12, 2012 2:03 pm

Hello,

Sorry, but I don't understand what you meant by this:
There is no way to connect the ODBC for windows(vsql 6.0) to vertica 6.0
vsql uses ODBC. If you download and install the Windows Client 32-Bit or 64-bit 6.0.1 driver, it includes the vsql executable that can be used to connect to a Vertica 6 database.

Example from the command prompt on Windows XP:

Code: Select all

C:\>vsql --version
vsql version v6.0.0, built for Windows 32 bit

C:\>vsql -h vertica01 -U jimk -w *********
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h for help with SQL commands
       \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

jknicely=> select version();
              version
------------------------------------
 Vertica Analytic Database v6.0.0-3
(1 row)
Are you getting an error? If so, what is it?

Thanks!
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

integer
Newbie
Newbie
Posts: 3
Joined: Mon Nov 12, 2012 2:56 am

Re: ODBC driver for widnows (vsql6.0) issue

Post by integer » Tue Nov 13, 2012 9:50 am

Hi,

I think client's OS(version:Windows Home Edition K 32bit) doesn't be supported to vsql6.0 for windows(Vertica version v.6.0.1).
I have sent the mail to vertica support team.
If I solve the problem, I'll comment it.

Thanks!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: ODBC driver for widnows (vsql6.0) issue

Post by id10t » Tue Nov 13, 2012 10:31 am

Hi!

[sarcasm]
Of course - it doesn't be supported. Why you didn't tried Windows Starter Edition or a free edition for Africa,
where you can simultaneously to run only 3 tasks, and of course there no way to connect the ODBC for windows(vsql 6.0) to vertica 6.0
(forget about 64 bit connection and many posts how to connect - just NO WAY).
[/sarcasm]

PS
Vertica is 64 bit, so you will require 64 bit emulation for connection.
Windows Home Edition have no such ability, if I'm remember right, only from Professional edition or Home Premium windows has environment emulators.

integer
Newbie
Newbie
Posts: 3
Joined: Mon Nov 12, 2012 2:56 am

Re: ODBC driver for widnows (vsql6.0) issue

Post by integer » Fri Nov 16, 2012 5:39 am

Hi,

I was confusing you. :)
Restate the environment.
It have been tested on Windows 7 Home Premium K (32bit).

Of course using vsql 4.1 successfully connected to vertica.

Thanks,

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: ODBC driver for widnows (vsql6.0) issue

Post by id10t » Fri Nov 16, 2012 7:25 am

Hi Jay Han!

Now it's look on 180 degrees different.
But help me to understand it little more, because it's can be Vertica's issue or your's - the are no such creature - "vsql 4.1", vsql for windows was released only with Vertica 6.0 , so what do you try to do? :shock: And also can you clarify: windows native vsql client or vsql client via cgwin.

PS: If you successfully connected (whatever you say) with vsql 4.1 and did not with 6.0 on he same machine/host - so 99% it's Vertica's issue and problem not in env. emulators as I thought before. I this case I suggest to open ticket.

Post Reply

Return to “ODBC”