Crystal LogonServer

[naruponk]

Hi there

I'm using Crystal Report 9.2 to access to MS Access 2003
on my workgroup

the DB path is \\server1\db1.mdb and password of DB is 2005

How to use Report.Database.logonserver(....) ?
Does Any one has ever try Database.logonserver ?

Thanks for advance

[RobDog888]

In the CR help files it will tell you which dll driver to use for Access and its syntax. This is an example of Access' DB logon info.

oReport.Application.LogOnServer "P2SODBC.DLL", sServer, sDatabase, sUserName, sUserPwd
oReport.Database.Tables(1).SetLogOnInfo sServer, sDatabase, sUserName, sUserPwd

[naruponk]

oReport.Application.LogOnServer "P2SODBC.DLL", "\\server1", "db1.mdb", "administrator", "2005"
oReport.Database.Tables(1).SetLogOnInfo "\\server1", "db1.mdb", "administrator", "2005"


Is this correct ?
if that report has too many table, do i need to do this every table?

Thanks

[RobDog888]

Without the double backslashes.

oReport.Application.LogOnServer "P2SODBC.DLL", "server1", "db1.mdb", "administrator", "2005"
oReport.Database.Tables(1).SetLogOnInfo "server1", "db1.mdb", "administrator", "2005"

You can iterate through the tables and setlogoninfo for each. I cant remember the exact syntax but its on the Forums. Try a quick search.

[naruponk]

Thanks a lot man

[multicoms]

Hi Rob, What about I have the access with password in the local XP machine? in the server column what should I use?

Im still using Crystal 4.5 so it should be in:
myReport.LogOnServer "P2SODBC.DLL", "localhost", App.Path & "\database\myData.mdb", "admin", "1234"

This return me Unable to Logon server! Please help!

[RobDog888]

Instead of localhost use the computer name. I'm not sure if its compatible with 4.5 but give the code a try.

[multicoms]

Hi Rob, thanks for your advice, any how I has found another to logon the server:

Report.LogonInfo(0) = "dsn=myDSN;uid=admin;pwd=1234;dsq="

Eventhough is working but I much prefer not to use DSN if possible like to use coding, because we have to create the DSN on the other PC with the exact name in our code, if DSN currupted then will be a problem.