Basic problem about remote connection to Ingres

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adriano B. - 25 Jul 2006 10:04 GMT

Good morning,
this is my first message to this group.
I'm a new Ingres db user and I have a couple of problems regarding
connection.
So probably mine are dummy question because the db expert is on
holiday.

I have to connect through a Excel sheet to a remote DB through a Macro.
That sheet is working in other networks so I suppose the code is right.
I just changed the db name and the address of the server in the
connection string.

The problem it says to me unknown host.
SoI downloaded the latest drivers from ingres.com for win 2k.
Then I went to Win ODBC manager and tried to create a new connection.
And it prompt to me the same error.

There are many menus on the Ingres I downloaded.
Have I to change something there?
It says also I should define a vnode.
What's the easiest procedure to let them communicate???

I don't know if there is a firewall in the middle, but I think not.

Many many thanks in advance to everyone

Reply to this Message

Paul Andrews - 25 Jul 2006 10:35 GMT

> Good morning,
> this is my first message to this group.
[quoted text clipped - 7 lines]
> I just changed the db name and the address of the server in the
> connection string.

Ingres uses vnodes to define connections to remote servers. If you change
the address of the server and there's no vnode defined of that name (or the
database doesn't exist), your client will be unable to connect.

There's a utility for defining vnode connections - netutil that should allow
you to see what vnodes exist.

Given that you have been loading drivers, etc. I'm not sure exactly what
state your client is now in, so I'd suggest waiting for the expert to return
if you can.

Paul

Reply to this Message

Adriano B. - 25 Jul 2006 11:19 GMT

First of all thank you very much!

There is only a vnode called local.
I suppose I should define a new one.
I do:
add node
then for vnode what name should I use?
where can I set the server ip address?
I chose tcpip and listen address ge (the name of the installation). Is
it right?
I have the name of the installation on the server. Is it useful?
Thanks a lot

Paul Andrews ha scritto:

> > Good morning,
> > this is my first message to this group.
[quoted text clipped - 20 lines]
>
> Paul

Reply to this Message

Paul Andrews - 25 Jul 2006 11:40 GMT

----- Original Message -----
From: "Adriano B." <adriano.bat@katamail.com>
Newsgroups: comp.databases.ingres
To: <info-ingres@cariboulake.com>
Sent: Tuesday, July 25, 2006 11:19 AM
Subject: [Info-ingres] Re: Basic problem about remote connection to Ingres

> First of all thank you very much!
>
> There is only a vnode called local.

looks like you've wiped out the vnode table by re-installing.

> I suppose I should define a new one.

Maybe

> I do:
> add node
[quoted text clipped - 3 lines]
> it right?
> I have the name of the installation on the server. Is it useful?

Some of this depends on you knowing the username and password to allow
access as a client to the ingres installation. It also depends on how user
security has been set up.

I guess you're ingres expert is not going to be happy when he returns. Why
were you messing with this in the first place?

> Thanks a lot
>
[quoted text clipped - 32 lines]
> Info-ingres@cariboulake.com
> http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres

Reply to this Message

John Dennis - 25 Jul 2006 12:35 GMT

Before the Ingres ODBC driver can be used, you need to have an
Ingres/Net installation on the client machine. Should we be assuming
that you have an Ingres/Net install?

John Dennis

Reply to this Message

Adriano B. - 25 Jul 2006 13:34 GMT

I have installed Ingres 2006-9.1
John Dennis ha scritto:

> Before the Ingres ODBC driver can be used, you need to have an
> Ingres/Net installation on the client machine. Should we be assuming
> that you have an Ingres/Net install?
>
> John Dennis

Reply to this Message

Adriano B. - 25 Jul 2006 13:57 GMT

An attempted network receive failed

I followed some hints found on this NG regarding configuration (and
yours) and now this is the log file I get

Reply to this Message