Database Logon issues VB6, CRXI, ken hamady

[mgason]

I have tried this on a button in VB6 to logon to a SQL server database

Private Sub Command2_Click()
Set report = crxApplication.OpenReport("C:\Userdir\MIXVISION\reports\MarkIngredient.rpt")
Load Form2
report.Database.LogOnServer "p2sodbc.dll", "mixvision", "NewMixvision", "sa", "mesabi"
report.RecordSelectionFormula = "{RecipeIngredients.Mixer}=2 AND {RecipeIngredients.Recipe}='0white'AND {RecipeIngredients.Rev}=' A' AND {RecipeIngredients.Pass}=1"
Form2.Show
End Sub

I followed an example and instructions I purchased at kenhamady.com.
I checked in Crystal (by right clicking the database and selecting properties) DSN, Database, username and password are all correct.
Database Type is ODBC(RDO)
Logon fails, what am I doing wrong and what is the referance to "p2sodbc.dll" about. Is this dll wrong? It is the one from the example.
thanks for any help
mark

 

[mgason]

problem fixed