ODBC Connection wise VB6

Cant open report with password protectod ODBC connection

Page 1 of 1

1 Replies - 3196 Views - Last Post: 09 February 2010 - 08:01 PM Rate Topic: -----

#1 abshaman  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 36
  • Joined: 11-December 09

ODBC Connection wise VB6

Posted 04 February 2010 - 03:54 PM

Please give me a help how to open crystal report wise vb6
ODBC connection have a password protection

Code sample....................................................

CR.WindowState = crptMaximized
CR.ReportFileName = App.Path & "\Report\Reorder Report-All.rpt"
CR.SelectionFormula = "{STOCK.QT}<=" & Val(QIS.Text) & ""
CR.RetrieveDataFiles
CR …………………………… I Can’t write this lile
CR.Action = 1

................................................................

this is code that but a cant write 5th line for this code please give me a help

Is This A Good Question/Topic? 0
  • +

Replies To: ODBC Connection wise VB6

#2 abshaman  Icon User is offline

  • New D.I.C Head

Reputation: -1
  • View blog
  • Posts: 36
  • Joined: 11-December 09

Re: ODBC Connection wise VB6

Posted 09 February 2010 - 08:01 PM

I Do it .....................

CR.WindowState = crptMaximized
CR.ReportFileName = App.Path & "\Report\Reorder Report-All.rpt"
CR.SelectionFormula = "{STOCK.QT}<=" & Val(QIS.Text) & ""
CR.Connect = "Dsn=EBUS;Uid=sa;pwd=38573857;dsq=database"
CR.RetrieveDataFiles
CR.Action = 1

Syntex
<CRname>.connect="dsn=<databasename>;Uid=sa;pwd=<Password>;dsq=database"
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1