(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Sesame and Crystal Reports
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Sesame and Crystal Reports (Read 1185 times)
Bejagee
Member
*
Offline


No personal text

Posts: 17
Joined: Dec 16th, 2003
Sesame and Crystal Reports
Mar 11th, 2004 at 9:07pm
Print Post Print Post  
Can you access the Sesame databases with Crystal Reports?  I'm familiar with that report designer and it would make creating reports easier.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Sesame and Crystal Reports
Reply #1 - Mar 11th, 2004 at 10:38pm
Print Post Print Post  
Have you looked into using an ODBC connection?
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Bejagee
Member
*
Offline


No personal text

Posts: 17
Joined: Dec 16th, 2003
Re: Sesame and Crystal Reports
Reply #2 - Mar 12th, 2004 at 2:21pm
Print Post Print Post  
I did check into using an ODBC connection, but wasn't sure where to look for a Sesame driver.  By default, it only lists Microsoft drivers for Access, Excel, Foxpro, Paradox, etc...  Any suggestions on this?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Sesame and Crystal Reports
Reply #3 - Mar 12th, 2004 at 3:12pm
Print Post Print Post  
Quote:
I did check into using an ODBC connection, but wasn't sure where to look for a Sesame driver.  By default, it only lists Microsoft drivers for Access, Excel, Foxpro, Paradox, etc...  Any suggestions on this?



The Sesame ODBC driver is not installed by default. It has its own installation tool and appears on the Sesame install CD and is available on the website.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Bejagee
Member
*
Offline


No personal text

Posts: 17
Joined: Dec 16th, 2003
Re: Sesame and Crystal Reports
Reply #4 - Mar 12th, 2004 at 3:46pm
Print Post Print Post  
I found the ODBC install but I'm not sure how to set it up.  It asks for the following parameters:

Datasource:
Database:
Host:
Port:
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Sesame and Crystal Reports
Reply #5 - Mar 12th, 2004 at 6:30pm
Print Post Print Post  
See the posting that I made on ODBC,  on: Feb 5th, 2004, 2:23am , under the topic "Updated ODBC driver".  Link is:
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=gen_disc;action=display...;

A few summary and follow up comments:

1.  I was ultimately able to make a good ODBC connection with Access and with Word.  I did not do much work with the final connection, just wanted to confirm that I could browse the data and use it in SQL queries.  No real hard testing for reliability, limitations, etc.
2.  There are some documentation errors in the manual.
3.  There are some additional "Known Problems" that are supposed to be fixed in 1.0.2.  You might want to know what they are before you waste time trying to accomplish the impossible.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge