Crystal reports odbc connection setup

Otherwise, click Finish to continue the data source selection wizard. You now need to select the database and tables that you want to include in your report. For our example, we will expand the selected Sakila database.

Then repeat the action with the country table. Alternatively you can select multiple tables and add them to the report. Finally, you can select the parent Sakila resource and add of the tables to the report. After I enter the connection string, format for the connection string in Crystal Reports.

NET Nov I'll cover. After adding a ODBC connection to. Examples of issuing CL commands using. An example provided in VB6. The connection string options meet the the report, for example,. Assumption that the same person can open both reports on the same computer and one works the other doesn't. So the only difference is the report everything else is the same. Nothing has changed. Same user, same DB, same computer, etc. The difference seems to be any of the reports which are saved won't connect, vs creating a new one.

Any of the new reports we create work like a champ. Ok, on verify database it says "The database table "lwmain" cannot be found. Proceed to remove this table from the report? I've tried logging on and logging off to the database, deleting the database from the report and putting it back in.

Nothing seems to help. If I create a new report exactly like the old one, run it, save it, and reopen it works great. The real issue is since nothing changed no updates to server, or client what the heck happened and do I have to recreate all my saved reports or is there a way to get it working again. Are you able to preview the data in the report?

Modify the server number only if it is incorrect. Server number will be provided to you by Xenegrade Corp. Be sure to follow these steps exactly. Existing Database. Open up Microsoft Access. Go to the File Menu. Select Get External Data. Select Link Tables. You will be prompted to enter your user name and password. Click Select All or the tables desired. Check the Always Prompt for New Location checkbox. The process will start linking all of your XenDirect tables.

If prompted for a primary key, click Cancel. You can close the link window when you are prompted that all tables have been linked. If button fails to function, close this process down and use Manual method in next group of steps. Click the Select All button. Click the OK button. This process may take several minutes. If Access Runtime is installed on your computer, the buttons in the Menu Panel may not function.