ODBC Connection

[Kim296]

In the past, a blank report could be created by selecting "ODBC", choose the Data Source Name, click finish and you would automatically have the tables to choose from. Recently our IT Department moved all of the database information from one server to a completely new server. Now, when you choose "ODBC" the correct data source will not show on the list to choose from.

Does anyone know how I can add a "New Data Source" to the list to choose from? I can't seem to find the new server anywhere. Any help is appreciated..

 

[briangriffin]

You'll need to create a new ODBC connection to the new server on your workstation.

If you go to Start --> Programs --> Crystal Reports you should see '32 Bit Data Source Administrator'. This is where you'll create the connection, ask one of your IT guys for help if you don't know all the settings.

 

[Kim296]

Thank you Brian!!

That was exactly what I was looking for and it worked great.. I appreciate your response.