>On the machines that aren't working, you should double check and make sure that the P2SODBC.DLL file is on there. Additionally, have you thought about calling the
SetLogonInfo method from the table object and setting the DSN?
>
>Laterness,
>Jon
Hello Jon,
p2sodbc.dll and u2ddisk.dll were both missing and after adding them to the c:\winnt\system32 folder the report ran okay. Thanks for the info.
Now, regarding the setlogoninfo method, here's the help syntax that I found:
object.setlogoninfo dllname, servername, databasename, userid, password
How does this look?
object = report name (mcrreport.rpt as property)
dllname = dll to access data by crystal report engine (p2sodbc.dll)
servername = name of server or odbc data source (dsn set up in users odbc data source administrator)
databasename = name of database (tablename.dbf, free table)
example:
thisform.crxreport.setlogoninfo.p2sodbc.dll,dsnname,tablename.dbf
I haven't tried this yet, but can you tell if I am close?
Thanks,
Jim