_____

From: tharen [mailto:tharen@...]
Sent: 06 April 2007 03:49 PM
To: 'Firebird-Support@yahoogroups.com'
Subject: How to design Crystal report 8.0 using Firebirdsql DB & how to view
the report using VB-6.0


Hi,

I'm using Visual Basic 6.0 as developing language,Firebird 2.0 as database &
crystal report 8.0 as reporting tool.
Operating system Windows XP.

I'm facing difficulties in designing & viewing crystal report.
I used Zstyle as provider.

When i tried these methods to design reports,

Under "Data Explorer" window,
-"More Data Sources" -> Active Data & OLE DB.

under "Data Source" i gave the correct path for database.
At design it worked perfectly.

At runtime when i choose the database path,it's not taking the new path. &
give error "Cannot open SQL server".
At runtime its taking the design time path,not new path which we are giving
at runtime.

How can i assign new path @runtime.?
What is the code for access the database from another machine?

Crystal report code - vb 6
----------------------------
CrystalReport1.Connect = "Provider=ZStyle IBOLE Provider; Data Source = "
& txtpath & ";UID=sysdba;password= masterkey"


connection string code -vb 6
----------------------------------
conn.Open "Provider=ZStyle IBOLE Provider; Data Source = " & txtpath &
";UID=sysdba;password= masterkey"

Please give soltion..

Tharen


[Non-text portions of this message have been removed]