Can't find SQL Server error when using Oracle? 
Author Message
 Can't find SQL Server error when using Oracle?

Using CR 6, Oracle 7.3 and VB4

Some reports created in CR when ran from VB produce the above error -
sometimes to get round
it - save the report while on the perview tab

All the reports seem to work OK from Crystal - it's just when calling from
VB!

This really is a serious bug and reminds me why I never took Crystal
Reports seriously right
back in the early days of VB 3

Have sent bug report to Crystal several days ago but still haven't had a
response

Any ideas?

Adrian Harrison




Wed, 26 Apr 2000 03:00:00 GMT  
 Can't find SQL Server error when using Oracle?

One toher thing that I did forget to mention..

Make sure that the client machines all have the same DSN as you are
using and that the Oracle Client is installed on them.

On 8 Nov 1997 12:50:24 GMT, "Adrian Harrison"

Quote:

>Using CR 6, Oracle 7.3 and VB4

>Some reports created in CR when ran from VB produce the above error -
>sometimes to get round
>it - save the report while on the perview tab

>All the reports seem to work OK from Crystal - it's just when calling from
>VB!

>This really is a serious bug and reminds me why I never took Crystal
>Reports seriously right
>back in the early days of VB 3

>Have sent bug report to Crystal several days ago but still haven't had a
>response

>Any ideas?

>Adrian Harrison



ANTI SPAM - Please delete the # before my email in order to send me a responce.

http://www.mcyork.com

Fraser



Wed, 26 Apr 2000 03:00:00 GMT  
 Can't find SQL Server error when using Oracle?

Hmmm..., well it looks like your missing some of your code..., ie:
your not setting the log on information for your server. Are you using
the OCX or API calls. If you are using the OCX then you will need to
set the connection string..

ie:

crystal1.connect = "DSN = MyDatasource;UID = me;PWD = MyPWD....
etc....

If you are using api calls, then you may want to have a look at the
PESetNthTableLogonInfo call..

On 8 Nov 1997 12:50:24 GMT, "Adrian Harrison"

Quote:

>Using CR 6, Oracle 7.3 and VB4

>Some reports created in CR when ran from VB produce the above error -
>sometimes to get round
>it - save the report while on the perview tab

>All the reports seem to work OK from Crystal - it's just when calling from
>VB!

>This really is a serious bug and reminds me why I never took Crystal
>Reports seriously right
>back in the early days of VB 3

>Have sent bug report to Crystal several days ago but still haven't had a
>response

>Any ideas?

>Adrian Harrison



ANTI SPAM - Please delete the # before my email in order to send me a responce.

http://www.mcyork.com

Fraser



Wed, 26 Apr 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Can not find SQL Server (I'm not using SQL Server)

2. Crystal 6 with Oracle - Error 599 SQL SERVER NOT FOUND

3. Error : 20955 can't find sql server

4. Error #-2146824582 ADO could not find the specified provider Using SQL SERVER CE

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. CR 6 and Personal Oracle, Cannot find SQL server

9. SQL Server error '80004005'

10. Moving Oracle records to MS SQL Server using MS Access

11. Export Access records to SQL Server/Oracle using ADO

12. I can't find the SQL server on the network

 

 
Powered by phpBB® Forum Software