Crystal Reports New Connection to ODBC database is BLANK

I have created by ODBC Datasource and when I go into Crystal to make a NEW CONNECTION I select the datasource and say finish but there are no files available.
kvrogersAsked:
Who is Participating?
 
kvrogersAuthor Commented:
Well I figured it out.  
1.   In the FAIRCOM folder I have two files.  One called pp.db and one called pp2.db.  These files contain all the file names of the files in the  original database and the location of the folder on my "C" drive where I am running the reports from.  Looks like this: " Ar12cd99  C:\CopyPPart\Ar12cd99.dat " with a line for every file in the pp.db file.  It takes to long to run the report from the server so I copy the files to my "C" drive.
2.    The file called pp2.db holds the same files as pp.db but reads " Ar12cd99  C:\CopyPPart2\Ar12cd99.dat " as this is where the PSY database files are.
3.    In recreating this pp2.db file I must have been missing a file needed to run.  
4.    This time when I tried the NEW CONNECTION it found the files.  
5.    I ran the report the first time with no results.  But then I thought I should update the files on my "C" drive where the report is run and THEN run the report again and this time it worked.
0
 
peter57rCommented:
When you create an ODBC datasource you usually have the option to test the connection.
Did you do so and did it work?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
kvrogersAuthor Commented:
Did not have option to test datasource.
0
 
peter57rCommented:
Then I don't know what to suggest.
If you can't be sure the ODBC connection is valid I don't know what you do.
0
 
vastoCommented:
If your machine is 64 bit you need to create the DSN using c:\windows\sysWOW64\odbcad32.exe. Otherwise crystal will nit be able to see it.
0
 
kvrogersAuthor Commented:
I am running these reports off my "C" drive.  I have actually 2 folders with the files I need in them.  These are the files from 2 different databases.

Now Folder 1, I can connect and use Crystal.  Folder 2, is the one that I am having trouble with.

I am attaching screen shots of how I set this up.
CTREE2-ODBC.JPG
CTREE-ODBC.JPG
datasource-connection.JPG
NO-FILES-ADDED.JPG
0
 
mlmccCommented:
What version of Crystal?

What WIndows version?

mlmcc
0
 
kvrogersAuthor Commented:
CR - 11.0.0.895

Windows: 7 Professional.
0
 
mlmccCommented:
CR 11 is strictly 32-bit.

Also, that is release 1 which was rather quickly replaced by release 2.  It will only run in .Net Framework 1.1.

What is the difference between Folder 1 and Folder 2?

mlmcc
0
 
kvrogersAuthor Commented:
One is family practice data and the other is psychology.
0
 
mlmccCommented:
Are they pointing to different databases or just need to use different tables in the same database?

mlmcc
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.