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

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

How to set Stored Proc name using RDC and the database is SQL server instead
of Access file.
The below example show to set the table name using access database to rdc.

Thanks
------------------------------------------------------
example
------------------------------------------------------
Public Sub AddDatabase()
'Variables used to setup the Database connection
     Dim crDBTables As CRAXDRT.DatabaseTables
     Dim sDatabasePath As String
     Dim sTableName As String

'Get the Tables collection because it has the Add() method needed
  'to add a connection to the report
       Set crDBTables = crReport.Database.Tables

'Set the values for the connection variables
'The full path and name of the Access database.
'The database resides in the same directory as the application
       sDatabasePath = App.Path & "\xtreme.mdb"

  'The name of the Access table
       sTableName = "Customer"

'Use the .Add() method to add the database table to the report.
  'There are several optional arguments for the Add method. Which arguments
are passed
  'will depend on the type of database, the type of table and the type of
connection.

'Add the 'Customer' table
       crDBTables.Add sDatabasePath, sTableName
End Sub
-----------------------------------------------------------



Mon, 01 Nov 2004 06:23:18 GMT  
 know anything about Stored Proc and using SQL Server 2000, CR8.5 and VB6.0
Look at example for your previous posting.

Thanks
--SriT


Quote:
> If anybody know anything about Stored Proc and using SQL Server 2000,
CR8.5
> and VB6.0

> How to set Stored Proc name using RDC and the database is SQL server
instead
> of Access file.
> The below example show to set the table name using access database to rdc.

> Thanks
> ------------------------------------------------------
> example
> ------------------------------------------------------
> Public Sub AddDatabase()
> 'Variables used to setup the Database connection
>      Dim crDBTables As CRAXDRT.DatabaseTables
>      Dim sDatabasePath As String
>      Dim sTableName As String

> 'Get the Tables collection because it has the Add() method needed
>   'to add a connection to the report
>        Set crDBTables = crReport.Database.Tables

> 'Set the values for the connection variables
> 'The full path and name of the Access database.
> 'The database resides in the same directory as the application
>        sDatabasePath = App.Path & "\xtreme.mdb"

>   'The name of the Access table
>        sTableName = "Customer"

> 'Use the .Add() method to add the database table to the report.
>   'There are several optional arguments for the Add method. Which
arguments
> are passed
>   'will depend on the type of database, the type of table and the type of
> connection.

> 'Add the 'Customer' table
>        crDBTables.Add sDatabasePath, sTableName
> End Sub
> -----------------------------------------------------------



Mon, 01 Nov 2004 21:57:16 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. CR8+VB6+SQL Server 2000 and Windows 2000

2. Memory Full While Trying to Connect To SQL Server 2000 Stored Proc With OLEDB

3. multiple parameters with ADO and SQL Server 2000 Stored proc

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

5. Crystal and SQL Server Stored Proc's and VB6

6. SQL Stored Procedures Using Parameters in CR8.5/VB6

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

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

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

10. Help - Using Sql Server Stored Proc with parameters

11. Crystal report using SQL stored proc locks server!!

12. How to store images using ADO in SQL Server 2000

 

 
Powered by phpBB® Forum Software