ODBC and Vantage

Yahoo Archive
1
Hey Guys:

You might try turning OFF the connection pooling for the ODBC driver
you're using.

D. Smith



--- In vantage@y..., "Terry Williams" <tlw@c...> wrote:
> To continue this thread:
> Yesterday, I successfully connected to both 8.3 and 9.0
Vantage databases
> via ODBC. However, shortly after the connections were made my
phone started
> ringing off the hook with questions about "why is the system so
slow?". I
> stopped the broker at the server, did a survey to see if things
cleared up
> and they had.
>
> Obviously by starting the broker that's gonna take some server
resources.
> Is it really that much that my users would notice? Is there some
other way
> I can go about this such as installing/running the broker on
another machine
> separate from the Vantage server?
>
> As always, I know you guys will steer me straight on this. TIA
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
> Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@c...
> www.chipsco.com
2
I'm trying to configure ODBC for use with both Vantage 3.0 and 4.0. I have
the Merant 3.5 driver installed on a client workstation. I am now at a loss
how to go about connecting via ODBC to the 8.3 and/or 9.0 Progress/Vantage
database. I've configured a connection on the client but have been
unsuccessful in my "test connect". I get a bunch of errors in a dialog box
whenever I attempt that. Is there something I need to be doing at the
server also? Neither have I been successful in finding a "how-to" in order
to help me out.

I know a lot of you folks are experienced in ODBC. Anyone experienced in
this that wouldn't mind walking me through a connection? I really am a fast
learner so it wouldn't take a whole lot of time. Please call me or contact
me off-list.

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com
3
I've uploaded the Epicor support documents to the file area. Included are
the documents for installation in 3.0 and 4.0, along with the 4.0
troubleshooting docs. Just follow these instructions and you should be
going in no time.

Ted Kitch
tedkitch@...

On Mon, 6 Nov 2000 12:05:35 -0500, vantage@egroups.com wrote:

> I'm trying to configure ODBC for use with both Vantage 3.0 and 4.0. I
have
> the Merant 3.5 driver installed on a client workstation. I am now at a
loss
> how to go about connecting via ODBC to the 8.3 and/or 9.0
Progress/Vantage
> database. I've configured a connection on the client but have been
> unsuccessful in my "test connect". I get a bunch of errors in a dialog
box
> whenever I attempt that. Is there something I need to be doing at the
> server also? Neither have I been successful in finding a "how-to" in
order
> to help me out.
>
> I know a lot of you folks are experienced in ODBC. Anyone experienced in
> this that wouldn't mind walking me through a connection? I really am a
fast
> learner so it wouldn't take a whole lot of time. Please call me or
contact
> me off-list.
>
> TIA
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
> Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548
tlw@...
> www.chipsco.com
>
>


Ted Kitch
tedkitch@...





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html
4
Hi Ted,
If you are attempting to install ODBC for Vantage 3.0 and 4.0 on the same machine, I believe you will have to pick one or the other. The variables that are placed into the autoexec.bat files cancel each other out (so to speak). The best suggestion I've been given is to use flow control in your autoexec.bat file to choose which setup you want to use each time you reboot that computer.

Unfortunately, I haven't pursued this any further than what I've stated above. I'd love to hear if anyone else has a better idea.

Troy Funte
Liberty Electronics
----- Original Message -----
From: Terry Williams
To: vantage@egroups.com
Sent: Monday, November 06, 2000 9:05 AM
Subject: [Vantage] ODBC and Vantage


I'm trying to configure ODBC for use with both Vantage 3.0 and 4.0. I have
the Merant 3.5 driver installed on a client workstation. I am now at a loss
how to go about connecting via ODBC to the 8.3 and/or 9.0 Progress/Vantage
database. I've configured a connection on the client but have been
unsuccessful in my "test connect". I get a bunch of errors in a dialog box
whenever I attempt that. Is there something I need to be doing at the
server also? Neither have I been successful in finding a "how-to" in order
to help me out.

I know a lot of you folks are experienced in ODBC. Anyone experienced in
this that wouldn't mind walking me through a connection? I really am a fast
learner so it wouldn't take a whole lot of time. Please call me or contact
me off-list.

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com



eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
5
You can configure batch files to change any of the needed set variables and
run them before you connect to the needed database. That is how I've
configured this in the past. Just put the set variables in a batch file.
You can even configure the batch file to reset the values back to the
original values if you wanted. This would avoid rebooting.

Ted Kitch
tedkitch@...

On Mon, 6 Nov 2000 12:14:04 -0800, vantage@egroups.com wrote:

> Hi Ted,
> If you are attempting to install ODBC for Vantage 3.0 and 4.0 on the
same machine, I believe you will have to pick one or the other. The
variables that are placed into the autoexec.bat files cancel each other out
(so to speak). The best suggestion I've been given is to use flow control
in your autoexec.bat file to choose which setup you want to use each time
you reboot that computer.
>
> Unfortunately, I haven't pursued this any further than what I've stated
above. I'd love to hear if anyone else has a better idea.
>
> Troy Funte
> Liberty Electronics
> ----- Original Message -----
> From: Terry Williams
> To: vantage@egroups.com
> Sent: Monday, November 06, 2000 9:05 AM
> Subject: [Vantage] ODBC and Vantage
>
>
> I'm trying to configure ODBC for use with both Vantage 3.0 and 4.0. I
have
> the Merant 3.5 driver installed on a client workstation. I am now at a
loss
> how to go about connecting via ODBC to the 8.3 and/or 9.0
Progress/Vantage
> database. I've configured a connection on the client but have been
> unsuccessful in my "test connect". I get a bunch of errors in a dialog
box
> whenever I attempt that. Is there something I need to be doing at the
> server also? Neither have I been successful in finding a "how-to" in
order
> to help me out.
>
> I know a lot of you folks are experienced in ODBC. Anyone experienced
in
> this that wouldn't mind walking me through a connection? I really am a
fast
> learner so it wouldn't take a whole lot of time. Please call me or
contact
> me off-list.
>
> TIA
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
> Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548
tlw@...
> www.chipsco.com
>
>
>
> eGroups Sponsor
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it,
go to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>
>
>
> [Non-text portions of this message have been removed]
>


Ted Kitch
tedkitch@...





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html
6
At 03:14 PM 11/6/2000 , you wrote:
> If you are attempting to install ODBC for Vantage 3.0 and 4.0 on the
> same machine, I believe you will have to pick one or the other. The
> variables that are placed into the autoexec.bat files cancel each other
> out (so to speak). The best suggestion I've been given is to use flow
> control in your autoexec.bat file to choose which setup you want to use
> each time you reboot that computer.

If you're running NT on the client, you can define the environment
variables on a per-user basis. Still doesn't get you simultaneous access,
but it's a bunch quicker that rebooting the machine each time.

-Wayne Cox
7
Ted:
Thank you so much. I had searched and searched for such documentation to
no success. It's amazing the results and help one gets from fellow vantage
users. Now on to my dilemma of getting the phone number and fax number to
show up on the sales order acknowledgement.

Thanks, again.

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com


-----Original Message-----
From: Ted Kitch [mailto:tedkitch@...]
Sent: Monday, November 06, 2000 12:13 PM
To: vantage@egroups.com
Subject: Re: [Vantage] ODBC and Vantage

I've uploaded the Epicor support documents to the file area. Included are
the documents for installation in 3.0 and 4.0, along with the 4.0
troubleshooting docs. Just follow these instructions and you should be
going in no time.

Ted Kitch
tedkitch@...

On Mon, 6 Nov 2000 12:05:35 -0500, vantage@egroups.com wrote:

> I'm trying to configure ODBC for use with both Vantage 3.0 and 4.0. I
have
> the Merant 3.5 driver installed on a client workstation. I am now at a
loss
> how to go about connecting via ODBC to the 8.3 and/or 9.0
Progress/Vantage
> database. I've configured a connection on the client but have been
> unsuccessful in my "test connect". I get a bunch of errors in a dialog
box
> whenever I attempt that. Is there something I need to be doing at the
> server also? Neither have I been successful in finding a "how-to" in
order
> to help me out.
>
> I know a lot of you folks are experienced in ODBC. Anyone experienced in
> this that wouldn't mind walking me through a connection? I really am a
fast
> learner so it wouldn't take a whole lot of time. Please call me or
contact
> me off-list.
>
> TIA
>
> Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
> Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548
tlw@...
> www.chipsco.com
>
>


Ted Kitch
tedkitch@...





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
8
To continue this thread:
Yesterday, I successfully connected to both 8.3 and 9.0 Vantage databases
via ODBC. However, shortly after the connections were made my phone started
ringing off the hook with questions about "why is the system so slow?". I
stopped the broker at the server, did a survey to see if things cleared up
and they had.

Obviously by starting the broker that's gonna take some server resources.
Is it really that much that my users would notice? Is there some other way
I can go about this such as installing/running the broker on another machine
separate from the Vantage server?

As always, I know you guys will steer me straight on this. TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com