Changing datasource for Crystal Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I Have devloped an application in VB.net 2003 and its working very good the
problem is raised when I want to change the source of data from testing sql
server to the real data in an other SQL server
How can I change the datasource of my reports
 
Identify where in the program the data source string is specified ("DSN").
It typically be the machine name (the name of you're local box) if you're
testing
locally (called local host) unless you installed SQL server locally with an
instance name (\\machine\instance name). Depending how the app was
implemented
this string can be hidden in a property of some control as well (usually named
data source name)

So if the SQL server is hosted on a remote server whose share name is
sqlremoteserver and the SQL server instance name is myserver than the DSN
string is changed to "\\sqlremoteserver\myserver" (by the way - SQL server
instance name are used so you can have multiple SQL servers for one
installation
of the server).

You might also have to go in to the Control Panel and configure Data Source
Names
(System DSN's)
 
Back
Top