Setting Database Password For Print But It Didn't Work

Legacy Poster

• 2014年04月08日 12:29

Hi 

I am using bartender full suit 10.1 

when i assign the value of "btDataBase.ODBC.Password" it cann't got it. But in case of "btDataBase.ODBC.UserId" or "this.btDataBase.ODBC.SQLStatement" there values changed. Please help me in this i am new in this..

 

 

        btDataBase =btFormat.Databases.GetDatabase(1);

        btDataBase.ODBC.UserId = mUserID;

        btDataBase.ODBC.Password = mPassword;

        this.btDataBase.ODBC.SQLStatement = "SELECT * from ScannedData WHERE PackingID='" + l_PackingID + "'";

        this.btFormat.PrintOut();

 

0

• 

  Domingo Rodriguez

  版主

  ★ BarTender Hero ★

  • 2014年04月16日 09:25

  If you're connecting to a database using an ODBC database driver and you need to assign a user ID and password, this is the way to do it.

   

  What do you mean with "can't got it"? Can you explain your problem in more detail?

   

  If you directly print from BarTender and supply the login credentials for the database via the "File > Database Connection Setup" dialog, does it work properly? Can you browse the database with the supplied User ID and password?

  0

請登入寫評論。