Connection with oledb in crystal report from visual basic

I have an application developed in visual basic that uses for the reports crystal reports 8. The connection to the Database is done by means of oledb. Since I can from visual basic change the connection without need to use a connection SQL Server ODBC.
CSadaAsked:
Who is Participating?
 
EwaldLConnect With a Mentor Commented:
hi csada, please bear with me if i haven't fully understood the question yet. you have created a report in cr 8 using an ole db connection and want to point this report via vb to a different server / database? If so, here is some code for the report designer component (rdc).

Dim myReport As CRAXDRT.Report
.....
Dim myTable As CRAXDRT.DatabaseTable
For Each myTable In myReport.Database.Tables
  myTable.SetLogOnInfo "ServerName", "DatabaseName", "User", "Password"
  myTable.Location = "Database.dbo." + myTable.Name
Next

let us know in case you are using a different object model, although i dont think i could help you myself then.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.