
CR8+VB6+SQL Server 2000 and Windows 2000
A faster solution would be to pass a disconnected recordset to Crystal. This
solution is 10-40 times faster and will make your problem disappear. See my
earlier postings for sample code or send me a mail.
Best regards
Kay-Christian Hansen
Quote:
> Hi all,
> I cant get CR8 to connect to SQL server 2000 from VB6.
> If I make a simple report based on the "northwind" database and then try
to
> run it, it simply says "Server has not yet been opened"
> This is how I made the report.
> 1. Add Crystal report to project
> 2. Choose "standard"
> 3. Click "Project"
> 4. Click "ADO & OLE DB" and click "build"
> 5. Choose "SQL server" and click "next"
> 6. Choose my sql-server (local), type in username and password click
"allow
> saving password" and press OK (It is important that CR cam remember the
> password).
> 7. Choose "Customers" object
> 8. choose ado.CompanyName
> 9. click Finish
> 10. run the report
> Now I get:
> OLE DB Provider for SQL Server:
> Login failed for user 'sa'
> Hope you can help
> Ren B. Lauritsen