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.
Thanks
Jeremy


-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Monday, May 06, 2002 10:47 AM
To: 'Vantage (vantage@yahoogroups.com)'
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?
TIA,

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,
True)

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 #"
DoCmd.Beep
If MsgBox(strMessage, vbOKOnly) = vbOK Then
End If
GoTo ERR_Part___AfterUpdate
Else
With rstPart
Me!Desc = !PartDescription
End With
End If
wrkODBC.Close
rstPart.Close

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:
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/