A1VBCode Forums

Help with accessing database


http://www.a1vbcode.com/vbforums/Topic28405.aspx

By victor64 - 11/18/2009

Hello,



I'm getting an error message when using "Application.StartupPath" to access my databse.



This code worked ok from my windows form, can you please help me with the correct syntax for the web form.



Thanks,



Code:



If IsPostBack Then

Dim myaop6report As New AOP6RPT10X

Dim crConnectionInfo As ConnectionInfo = New ConnectionInfo

crConnectionInfo.ServerName = (Application.StartupPath & "\AOPT2002org.mdb")

crConnectionInfo.Password = "testaopupdate"

setDBLogonForReport(crConnectionInfo, myaop6report)

myaop6report.RecordSelectionFormula = "{AOP5.nsn} like " & "'*" & TextBox1.Text & "*'" & ""

CrystalReportViewer1.ReportSource = myaop6report

End If