<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff><FONT face=Arial size=2>
<DIV>Hi Paul<BR></DIV>
<DIV>We have succeeded in getting Crystal to interface with Firebird without
prompting for UserName / Password. We achieved it using a file DSN for the
report. In the DSN we specified the UserName / Password and we use the VCL
crystal component to change the report to look at the file DSN.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If this sounds like it would be any help I can post
a file DSN example and the code used to change a crystal report to use it.
In general we found the Crystal (v8.5) documentation and APIs to be quite poor
(the APIs do not work exactly as described).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>Rob Martin<BR>Software Engineer<BR> <BR>phone 03 377 0495<BR>fax 03
377 0496 <BR>web <A
href="http://www.chreos.com">www.chreos.com</A><BR>Wild Software Ltd</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=paul@smss.org.nz href="mailto:paul@smss.org.nz">Paul McKenzie</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=Delphi@ns3.123.co.nz
href="mailto:Delphi@ns3.123.co.nz">Delphi List - Delphi</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, September 08, 2004 8:33
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [DUG] Delphi Crystal and
Interbase via ODBC</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
<DIV><FONT face=Arial size=2>We have a Delphi App that uses Crystal to access
a remote InterBase database via ODBC.</FONT></DIV>
<DIV><FONT face=Arial size=2>What I want to use is the local computer ODBC
Usename and Password for logon to the InterBase Database...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The Crystal TypeLibrary provides a "</FONT><FONT
face=Arial size=2>LogOnServerWithPrivateInfo(const pDllName:
WideString; privateInfo: OleVariant)" but I am unsure how to use it. The
parameters are DLLName (that's ok) PrivateInfo (??? no idea).</FONT></DIV>
<DIV><FONT face=Arial size=2>The only erxample on the net indicates an
ODBC connection handle (I think)</FONT></DIV>
<DIV><FONT face=Arial size=2>the use "SQLGetProp" which I can't
find...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Has anyone used "<FONT face=Arial
size=2>LogOnServerWithPrivateInfo</FONT>" or managed to use the local computer
ODBC info for Crystal logon via ODBC ???</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards<BR>Paul McKenzie<BR>SMSS
Ltd.<BR>Wellington<BR>New Zealand</FONT></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE></BODY></HTML>