Briefly this is the problem..
I have a module in A VB.Net called Globals in there I have 2 connection strings
Public dsn1 As String = "Data Source=192.168.999.99;Init
ial Catalog=recycle;Persist Security Info=True;User ID=sa;Password=sa;"
'Public dsn2 As String = "Data Source=.\SQLExpress;Databa
d=11;" 'Single System
I first connection string is working fine and with the click of the buttons on my forms my codes runs fine and it reads the database fine..
The problem is I had to create a crystal report...so I used the report wizard.In the database expert I picked the name of the database from the list of connections in the database expert, I chose the database which was represented in my globals as dsn1.
This works fine....
The problem is if I wanted the same report to read the data that was represented by the database for dsn2... How would I do this the 2 databases are identical...except they are in 2 separates places..
So I followed what was at..
This however stops at the following line when I run it ...
crTable.Location = "recycle" & "." & "BLUE\marc" & "." & crTable.Location.Substring
".") + 1)
it says FAILED TO LOAD DATABASE INFORMATION
NO DATABASE dll HAS BEEN SPECIFIED
This is driving me around the bend...
Any help or insight before the weekend begins would be much appreciated