Spam: [Vantage 6.1] - ODBC connection issue

Robert,

Thank you so much. That was exactly what we were looking for. We were
able to make the connection.



In the words of my co-worker:



You Rock!



Thanks,

Jim



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert MacDonald
Sent: Friday, April 27, 2007 1:14 PM
To: vantage@yahoogroups.com
Subject: RE: Spam:[Vantage] [Vantage 6.1] - ODBC connection issue



Jim,

We had a similar issue here.

The ODBC connection requires files on the V drive.

The way we got around it was to change the location references in the
registry for the ODBC drivers for Vantage to the UNC path to the Vantage
server share.

Hope this helps.

Thanks,

Robert MacDonald

I.T. Manager,

Ground Effects Ltd.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Moore, Jim (Anniston)
Sent: Friday, April 27, 2007 1:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Spam:[Vantage] [Vantage 6.1] - ODBC connection issue

Our corporate office needs to connect to our 6.1 DB via ODBC.
They can establish a connection from a workstation that has a 6.1 client
install.

However, due to a financial application they want to use to connect to
our DB with, they only want to use ODBC and without having the mapped V
Drive. The financial application runs as a service on the server and
does not recognize the mapped V drive and therefore cannot establish a
connection to the Vantage system tables on the Progress database.

Is there a way to connect to the DB that does not require a mapped
network drive?

Thanks,

Jim Moore

----------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
-----

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Our corporate office needs to connect to our 6.1 DB via ODBC.
They can establish a connection from a workstation that has a 6.1 client
install.

However, due to a financial application they want to use to connect to
our DB with, they only want to use ODBC and without having the mapped V
Drive. The financial application runs as a service on the server and
does not recognize the mapped V drive and therefore cannot establish a
connection to the Vantage system tables on the Progress database.

Is there a way to connect to the DB that does not require a mapped
network drive?

Thanks,

Jim Moore

------------------------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
------------------------------------------------------------------------
-----




[Non-text portions of this message have been removed]
Jim,



You should be able to add an ODBC connection in your System DSN and
point your application to that DSN when you need it. ODBC connections
use port numbers as opposed to mapped drives. Sure you will have to know
the database name.



You will need to define:



Data Source Name

Host Name

Port Number

Database Name - this will be the name of your live dataset

User ID



Click on test connect and enter the password. Once you do that you
should be able to successfully connect using any applications that can
use ODBC sources.



Let us know if you need more information.



Thanks,



Jason Claggett

Microsoft Small Business Specialist

MCP #3856159

2W Technologies, LLC

317.578.2393

jason@...

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Moore, Jim (Anniston)
Sent: Friday, April 27, 2007 1:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [Vantage 6.1] - ODBC connection issue



Our corporate office needs to connect to our 6.1 DB via ODBC.
They can establish a connection from a workstation that has a 6.1 client
install.

However, due to a financial application they want to use to connect to
our DB with, they only want to use ODBC and without having the mapped V
Drive. The financial application runs as a service on the server and
does not recognize the mapped V drive and therefore cannot establish a
connection to the Vantage system tables on the Progress database.

Is there a way to connect to the DB that does not require a mapped
network drive?

Thanks,

Jim Moore

----------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
-----

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Jim,

We had a similar issue here.

The ODBC connection requires files on the V drive.

The way we got around it was to change the location references in the
registry for the ODBC drivers for Vantage to the UNC path to the Vantage
server share.

Hope this helps.

Thanks,



Robert MacDonald

I.T. Manager,

Ground Effects Ltd.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Moore, Jim (Anniston)
Sent: Friday, April 27, 2007 1:36 PM
To: vantage@yahoogroups.com
Subject: Spam:[Vantage] [Vantage 6.1] - ODBC connection issue



Our corporate office needs to connect to our 6.1 DB via ODBC.
They can establish a connection from a workstation that has a 6.1 client
install.

However, due to a financial application they want to use to connect to
our DB with, they only want to use ODBC and without having the mapped V
Drive. The financial application runs as a service on the server and
does not recognize the mapped V drive and therefore cannot establish a
connection to the Vantage system tables on the Progress database.

Is there a way to connect to the DB that does not require a mapped
network drive?

Thanks,

Jim Moore

----------------------------------------------------------
------------------------------
"This email message is for the sole use of the intended
recipient(s) and may contain proprietary and/or confidential
information for which such intended recipients(s) may have
an obligation to treat as proprietary. Any unauthorized review,
use, disclosure, or distribution is strictly prohibited. If you are
not the intended recipient, please contact sender by reply
email and destroy all copies of this e-mail."
----------------------------------------------------------
-----

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]