CR8+VB6+SQL Server 2000 and Windows 2000 
Author Message
 CR8+VB6+SQL Server 2000 and Windows 2000

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



Mon, 09 Jun 2003 04:35:59 GMT  
 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



Mon, 09 Jun 2003 07:38:16 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. know anything about Stored Proc and using SQL Server 2000, CR8.5 and VB6.0

2. CR6 and SQL Server 2000 and Windows 2000

3. VB6 application using SQL Server 2000 migrating db to SQL Server 2

4. SQL Connectivity - CR9 Developer Edition, VB6, SQL Server 2000

5. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL

6. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

7. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

8. Executing MS SQL Server 2000 stored procs via MS Access 2000

9. Windows 2000, VB Script, Visual InterDev and SQL Server 7

10. Type Name is Invalid error -- Windows 2000/98 application with SQL Server/stored procedure problem

11. SQL Server 2000 with Windows XP?

12. Windows XP dropping connection to SQL Server 2000

 

 
Powered by phpBB® Forum Software