norbertk wrote:You can set up a linked server.

Hi Norbertk,

What I meant is from the Vertica (unix box) going to query / connect to the MS SQL Server

Regards

thanks for the reply BoMBaY

but I'm still getting an error =(

I think this would works for oracle only

HI All,

Is there a way (and how) that Vertica DB can browse or Connect MS SQL Database?

do we need driver ?



Regards,

sKwa wrote:try:

Code: Select all

select * from vs_network_interfaces;

Thanks So much ....
This is what I'm looking for ...

Hi! Try next: select * from vs_subnets; Daniel Thanks Bro appreciate it .... how about selecting the network interface created (not on this v_monitor.network_interfaces) ? =) CREATE NETWORK INTERFACE ethXX on v_Dbidev_node0006 with '10.18.21.99'; ROLLBACK 4043: Network Interface "copy_node1" alread...

HI, I'm still a novice when it comes this, anyway my problem is that I need to change the export_address of the server here's the step: CREATE SUBNET copy_subnet WITH '10.12.15.88'; CREATE NETWORK INTERFACE copy_node1 ON v_Dbdevv_node0001 with '10.12.15.11'; ALTER DATABASE Dbdevv EXPORT ON copy_subn...

knicely87 wrote:Use the -P switch:

Code: Select all

[dbadmin@v1 ~]$ vsql -P footer=off -c "select count(*) from sessions;"
 count
-------
     1

Refer to the topic "SET NOCOUNT equivalent in Vertica" here: http://www.vertica-forums.com/viewtopic.php?f=6&t=619

@knicely87 thanks also for sharing =)