Visual Basic - Progress question

Yahoo Archive
1
Worked Great!!!

THanks,
Jasper

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, November 05, 2003 11:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Visual Basic - Progress question


Basically copy the VTG file information into a long format. There are piles
more of parameters, but if you use the ones Epicor has decided to use in
their VTG setup, you shouldn't have any problems.

Example:

in Visual Basic, set a string equal to the following line (change any
settings to match your server and Vantage install):

F:\PROGRESS\bin\prowin32.exe F:\VANTAGE\db\vantage.db -ininame
F:\VANTAGE\vantage.ini -pf F:\VANTAGE\db\Vantage.pf -N TCP -H ntserver -S
vantage -ld vantage -p yourapp.p -rand 2 -q -basekey ini

Then just

x = shell string

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, November 05, 2003 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Visual Basic - Progress question


What parameters/identifiers do I need?

Can you give me an example of the long hand method?

Thanks,
Jasper

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, November 05, 2003 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Visual Basic - Progress question


You're not using the correct parameters/identifiers for prowin32.exe.

no identifier for the DataBase (this is what your program thinks you are
suppling it)

to load a procedure (.p, .w or .r) you need to specify it. Add a "-p "
before your procedure name.

Just a suggestion, I usually configure the entire long hand command line
before shelling it out. This way I know I'm using the correct database, INI
settings file, parameter file, etc....

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, November 05, 2003 9:31 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Visual Basic - Progress question


I'm not sure if anybody has every come across this problem but I'll give it
a go.

I am using Visual Basic to execute a procedure. When you click on the
button, it's supposed to run this program and automatically run the
VendorShipping.p procedure:

Dim Path As Object
Dim Report As Object
Path = "d:\ReportBuilder\VendorShipping.p"
Report = Shell("""V:\PROGRESS\bin\prowin32.exe"" """ & Path & """", 1)

When it tries to run I get this error:

Error
**Your database name is longer than 11 characters.(448)

If I run the procedure without going thru Visual Basic it works great, but
when Visual Basic tries to execute it I get that error.
Any ideas on what this might be?

Thanks,
Jasper





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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I'm not sure if anybody has every come across this problem but I'll give it a go.

I am using Visual Basic to execute a procedure. When you click on the button, it's supposed to run this program and automatically run the VendorShipping.p procedure:

Dim Path As Object
Dim Report As Object
Path = "d:\ReportBuilder\VendorShipping.p"
Report = Shell("""V:\PROGRESS\bin\prowin32.exe"" """ & Path & """", 1)

When it tries to run I get this error:

Error
**Your database name is longer than 11 characters.(448)

If I run the procedure without going thru Visual Basic it works great, but when Visual Basic tries to execute it I get that error.
Any ideas on what this might be?

Thanks,
Jasper





[Non-text portions of this message have been removed]
3
You're not using the correct parameters/identifiers for prowin32.exe.

no identifier for the DataBase (this is what your program thinks you are
suppling it)

to load a procedure (.p, .w or .r) you need to specify it. Add a "-p "
before your procedure name.

Just a suggestion, I usually configure the entire long hand command line
before shelling it out. This way I know I'm using the correct database, INI
settings file, parameter file, etc....

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, November 05, 2003 9:31 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Visual Basic - Progress question


I'm not sure if anybody has every come across this problem but I'll give it
a go.

I am using Visual Basic to execute a procedure. When you click on the
button, it's supposed to run this program and automatically run the
VendorShipping.p procedure:

Dim Path As Object
Dim Report As Object
Path = "d:\ReportBuilder\VendorShipping.p"
Report = Shell("""V:\PROGRESS\bin\prowin32.exe"" """ & Path & """", 1)

When it tries to run I get this error:

Error
**Your database name is longer than 11 characters.(448)

If I run the procedure without going thru Visual Basic it works great, but
when Visual Basic tries to execute it I get that error.
Any ideas on what this might be?

Thanks,
Jasper





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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
What parameters/identifiers do I need?

Can you give me an example of the long hand method?

Thanks,
Jasper

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, November 05, 2003 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Visual Basic - Progress question


You're not using the correct parameters/identifiers for prowin32.exe.

no identifier for the DataBase (this is what your program thinks you are
suppling it)

to load a procedure (.p, .w or .r) you need to specify it. Add a "-p "
before your procedure name.

Just a suggestion, I usually configure the entire long hand command line
before shelling it out. This way I know I'm using the correct database, INI
settings file, parameter file, etc....

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, November 05, 2003 9:31 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Visual Basic - Progress question


I'm not sure if anybody has every come across this problem but I'll give it
a go.

I am using Visual Basic to execute a procedure. When you click on the
button, it's supposed to run this program and automatically run the
VendorShipping.p procedure:

Dim Path As Object
Dim Report As Object
Path = "d:\ReportBuilder\VendorShipping.p"
Report = Shell("""V:\PROGRESS\bin\prowin32.exe"" """ & Path & """", 1)

When it tries to run I get this error:

Error
**Your database name is longer than 11 characters.(448)

If I run the procedure without going thru Visual Basic it works great, but
when Visual Basic tries to execute it I get that error.
Any ideas on what this might be?

Thanks,
Jasper





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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
Basically copy the VTG file information into a long format. There are piles
more of parameters, but if you use the ones Epicor has decided to use in
their VTG setup, you shouldn't have any problems.

Example:

in Visual Basic, set a string equal to the following line (change any
settings to match your server and Vantage install):

F:\PROGRESS\bin\prowin32.exe F:\VANTAGE\db\vantage.db -ininame
F:\VANTAGE\vantage.ini -pf F:\VANTAGE\db\Vantage.pf -N TCP -H ntserver -S
vantage -ld vantage -p yourapp.p -rand 2 -q -basekey ini

Then just

x = shell string

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, November 05, 2003 9:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Visual Basic - Progress question


What parameters/identifiers do I need?

Can you give me an example of the long hand method?

Thanks,
Jasper

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, November 05, 2003 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Visual Basic - Progress question


You're not using the correct parameters/identifiers for prowin32.exe.

no identifier for the DataBase (this is what your program thinks you are
suppling it)

to load a procedure (.p, .w or .r) you need to specify it. Add a "-p "
before your procedure name.

Just a suggestion, I usually configure the entire long hand command line
before shelling it out. This way I know I'm using the correct database, INI
settings file, parameter file, etc....

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, November 05, 2003 9:31 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Visual Basic - Progress question


I'm not sure if anybody has every come across this problem but I'll give it
a go.

I am using Visual Basic to execute a procedure. When you click on the
button, it's supposed to run this program and automatically run the
VendorShipping.p procedure:

Dim Path As Object
Dim Report As Object
Path = "d:\ReportBuilder\VendorShipping.p"
Report = Shell("""V:\PROGRESS\bin\prowin32.exe"" """ & Path & """", 1)

When it tries to run I get this error:

Error
**Your database name is longer than 11 characters.(448)

If I run the procedure without going thru Visual Basic it works great, but
when Visual Basic tries to execute it I get that error.
Any ideas on what this might be?

Thanks,
Jasper





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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/