Business Object Interface

[tomwilk]

I was wondering if anyone has information on passing the MAS ODBC connection information to a custom Crystal Report called within VB.NET 2010? See the sample code below:

Dim connCR As ConnectionInfo = New ConnectionInfo

　

connCR.ServerName = MASConnString   -   'DSN=SOTAMAS90

connCR.DatabaseName = MASCompany  -   'ABC

connCR.UserID = MAS90UserName  -   'rmd

connCR.Password = MAS90PassWord  -  'password

or can we just feed the entire ODBC connection string to the ServerName property like so:

connCR.ServerName ="DSN=SOTAMAS90; UID=" & MAS90UserName &  "; PWD=" & MAS90PassWord & "; Company=" & MASCompany

Thanks

Tom

[tomwilk]

The second option works just fine. You don't get the Providex ODBC login prompt.