Blank Title 17667

Have your tried putting the password in. If your on 9.1c then I believe it
requires the password "sysprogress" for user "sysprogress"

I'm new to the Progress ODBC drive but that is the first thin I seen.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Monday, May 06, 2002 10:47 AM
To: 'Vantage ('
Subject: [Vantage]

I am using the Progress SQL 92 driver to connect to Vantage using the
following VBA code. I get connected OK but can't retrieve any information
via the SQL call. Can anyone point me in the correct direction?

Private Sub Part___AfterUpdate()
Dim conVantage As Connection
Dim rstPart As Recordset
Dim wrkODBC As Workspace
Dim strPart, strSQL, strMessage As String

strPart = Me![Part #]
Set wrkODBC = CreateWorkspace("Vantage", "sysprogress", "", dbUseODBC)
Set conVantage = wrkODBC.OpenConnection("Progress", dbDriverComplete,

strSQL = "Select * from Part Where Company = 'XXX' and "
strSQL = strSQL & "PartNum = '" & strPart & "';"
Set rstPart = conVantage.OpenRecordset(strSQL)

If rstPart.EOF Then
strMessage = "Non-existant Part Number in Vantage, Enter a valid
Part #"
If MsgBox(strMessage, vbOKOnly) = vbOK Then
End If
GoTo ERR_Part___AfterUpdate
With rstPart
Me!Desc = !PartDescription
End With
End If

end sub

[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:
(2) To search through old msg's goto:
(3) To view links to Vendors that provide Vantage services goto:

Your use of Yahoo! Groups is subject to