Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




VB Vs. Oracle Forms, Reports


I'm doing a project and am having to make the decision to use VB or Oracle's development tools for a front end reporting app with an Oracle backend. Can anyone shed some light on some pro's and con's?




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Oracle Reports
Hi there
i want to run report6i based on SQL file from oracle forms6i menu.
can i do this????
currently i'm doing this by passing host commands for printer setting also.

please help me this is urgent...

thanking you

regards
sachin

ORACLE......REPORTS 6i HELP
Hi
I'm new to Reports 6i. Can anybody help me how to go abt it. If u can provide me any good site then i'll be thankful to you.
How to start and how to make master detail reports.....
the book which i have doesn't focus more light on it.
please help me out.
this is very urgent...
regards
sachin

VB With Oracle Reports
Does anyone know if we can call Oracle reports from VB.
If yes where would I get to know more about this.
need some sample code, examples etc

thanks
-Aslam

Oracle Reports And VB
Does anyone know if we can call Oracle reports from VB.
If yes where would I get to know more about this.
need some sample code, examples etc

thanks
-Aslam

Crystal Reports 5 Vs Oracle
My question is short... crystal reports v5 supports Oracle 8i?
Thanks

Oracle Forms
I know very little about Oracle Forms, but what I need to do is call a COM object. In VB, or VBscript all I'm doing is "createobject". I've heard that it's possible to imbed VB code into Oracle Forms so I could call methods with data from my form. Does anyone have any ideas?

Crystal Reports Oracle Connection
I'm having trouble connecting to my Oracle database. My Crystal Report (done in VB6.0) tries to connect to my Oracle database, but I get the error, "Logon failed, null password given". Where do I put the password? What is the connection string? Here is all I have so far<vb>CRViewer91.ReportSource = Report
CRViewer91.ViewReport<vb>Thanks for the help!

Crystal Reports Connection With Oracle 8.1.6
I am using oracle 8.1.6 , Crystal Reports 8.5 and VB 6.0 win 2000 in my home
I can't connect to the my db in oracle

I tried the file DSN through the crystal reports (when it ask for the DB and used Oracle odbs provider, also user MS odbc driver for oracle but no differance)
but it didnt show me the tables in my db the files it showed me are
1--- outln.ol$
2--- outln.ol$hints

and nothing else
(my db has over 30 tables)
and if the System DSN is used first ask for the service name, password & username in services name I ve provided the DSN name and left it blank but it give me error in any case
ODBC ERROR : [ORACLE][ODBC][ORA]: ORA 12154: TNS : COULD NOT RESOLVE SERVICE NAME.

I why creatred new DSN deleting the prevone but no use ......................

Where I am making the mistake.????????????


WHY ????????????????????????????




Edited by - haahoou on 1/16/2004 5:08:49 AM

Passing Parameters In VB 6.0 Reports With Oracle 8.1.3 Database
I have been trying to create some Parameters in the Data Environment but
I am unable to do so. Can anyone help me. Below is how I do it

In visual basic 6 when i want to make a new report
i) First I have already created the Connections using Oracle 8.1.3
ii) Then I creata a new Command
iii) Under the Properties of the Command there is
a Tab Box which have the Tab for
General,Parameters,Relations,Groupings,
Agregates,Advance
iv) Under the General Tab in the SQL Builder
I put the SQL under the Design that I want for the report as
shown below

SELECT DISTINCT
ei.call_origin_access_no, ei.account_no, c.code_des, s.tos_yn,
s.current_balance, SUM(ei.event_amount)
FROM event_itemisation ei, codes c, subscribers s
WHERE c.CODE_TP_CD = 'ACCOUNT' AND
c.code LIKE @ PARAMETER1_STRING
AND c.CODE = s.ACCOUNT_CLASS_CD AND
ei.account_no = s.account_no AND
event_date = @ PARAMETER2_DATE
GROUP BY ei.call_origin_access_no, ei.account_no, c.code_des,
s.tos_yn, s.current_balance
HAVING SUM(ei.event_amount) > 50000


v) There is 2 parameters in this SQL that I need to pass
to this SQL the VB Form level (PARAMETER1_STRING and PARAMETER2_DATE)

vi) I don't know how to pass the parameter to this
SQL because it always give me error in the Design section
under the SQL Builder

vii) I tried using the Tab for Parameters under the
Tab Box of COmmand Properties but I cannot
enter anything in there because it is always
Untabable and nothing can be entered in there

Passing Parameters In VB 6.0 Reports With Oracle 8.1.3 Database
I have been trying to create some Parameters in the Data Environment but
I am unable to do so. Can anyone help me. Below is how I do it

In visual basic 6 when i want to make a new report
i) First I have already created the Connections using Oracle 8.1.3
ii) Then I creata a new Command
iii) Under the Properties of the Command there is
a Tab Box which have the Tab for
General,Parameters,Relations,Groupings,
Agregates,Advance
iv) Under the General Tab in the SQL Builder
I put the SQL under the Design that I want for the report as
shown below

SELECT DISTINCT
ei.call_origin_access_no, ei.account_no, c.code_des, s.tos_yn,
s.current_balance, SUM(ei.event_amount)
FROM event_itemisation ei, codes c, subscribers s
WHERE c.CODE_TP_CD = 'ACCOUNT' AND
c.code LIKE @ PARAMETER1_STRING
AND c.CODE = s.ACCOUNT_CLASS_CD AND
ei.account_no = s.account_no AND
event_date = @ PARAMETER2_DATE
GROUP BY ei.call_origin_access_no, ei.account_no, c.code_des,
s.tos_yn, s.current_balance
HAVING SUM(ei.event_amount) > 50000


v) There is 2 parameters in this SQL that I need to pass
to this SQL the VB Form level (PARAMETER1_STRING and PARAMETER2_DATE)

vi) I don't know how to pass the parameter to this
SQL because it always give me error in the Design section
under the SQL Builder

vii) I tried using the Tab for Parameters under the
Tab Box of COmmand Properties but I cannot
enter anything in there because it is always
Untabable and nothing can be entered in there

Please look at my attachment

How To Connect Oracle Server (Crystal Reports 8) With VB 6
Hello everyone, I need your help.
I need to make a report in a Vb's project using oracle server of Crystal Reports but I don't know how to establish the cennection into VB, do you know how is the connection string that I have to introduce in the code?????

I appreciate your help.....thanks a lot

Access97 Reports With Oracle DB (performance Issues?)
Pls can some one let me know if there are performance issues coming in if Oracle is used as backend and Access 97 as front end for Reporting only. Pls provide tips on using Access for reporting with oracle. I will be using ADO and not linked tables or pass thru queries.





EDIT by DaVBMan: I just changed your title in hopes of getting you help as your other subject line really did not provide information to users scanning the site for questions to answer. Subject lines such as you had actually do the opposite of helping as it makes some users ignore the post. Just trying to help.



Edited by - DaVBMan on 1/9/2004 2:49:17 PM

Passing Parameters In VB 6.0 Reports With Oracle 8.1.3 Database
I have been trying to create some Parameters in the Data Environment but
I am unable to do so. Can anyone help me. Below is how I do it

In visual basic 6 when i want to make a new report
i) First I have already created the Connections using Oracle 8.1.3
ii) Then I creata a new Command
iii) Under the Properties of the Command there is
a Tab Box which have the Tab for
General,Parameters,Relations,Groupings,
Agregates,Advance
iv) Under the General Tab in the SQL Builder
I put the SQL under the Design that I want for the report as
shown below

SELECT DISTINCT
ei.call_origin_access_no, ei.account_no, c.code_des, s.tos_yn,
s.current_balance, SUM(ei.event_amount)
FROM event_itemisation ei, codes c, subscribers s
WHERE c.CODE_TP_CD = 'ACCOUNT' AND
c.code LIKE @ PARAMETER1_STRING
AND c.CODE = s.ACCOUNT_CLASS_CD AND
ei.account_no = s.account_no AND
event_date = @ PARAMETER2_DATE
GROUP BY ei.call_origin_access_no, ei.account_no, c.code_des,
s.tos_yn, s.current_balance
HAVING SUM(ei.event_amount) > 50000


v) There is 2 parameters in this SQL that I need to pass
to this SQL the VB Form level (PARAMETER1_STRING and PARAMETER2_DATE)

vi) I don't know how to pass the parameter to this
SQL because it always give me error in the Design section
under the SQL Builder

vii) I tried using the Tab for Parameters under the
Tab Box of COmmand Properties but I cannot
enter anything in there because it is always
Untabable and nothing can be entered in there

I Need Help With ActiveX And Oracle Forms 5
Hi!
I´m making an ActiveX control in Visual Basic 6, and I´m trying to insert it in Oracle Forms 5.0. It works very well but when I close the Forms application it sends me a message like this " application error : could not read from memory location 0x00000038". So I think that the problem es in the ActiveX control ??
Could anyone help me ??

I Unbale To Execute Oracle Developer 2000 Reports With VB
Dear Firneds,

I developed application in VB with Oracle Backend. I wrote some reports in D2K Reports. I found an Activex contol (R30SXA32.OCX : Oracle Developer/2000 Reporting Control) and i add this componant within vb application.

i gave the following parameters to execute the d2k reports file (general.rpt/general.rep)

    d2k.DatabaseName = cnPayroll ' cnPayroll is a Database Connection
    d2k.ReportsServer = ?
    d2k.ReportMode = Character
    d2k.DatabasePassword = ?
    d2k.DatabaseUser = "admin"
    d2k.ReportName = App.Path & "users1.REP"
    d2k.CommandFile = ?
    d2k.RunReportSimple

when I execute the report i got the following error:
==============
Run-time error '4157':
Can not run report: Value of one of the properties specifies a filename which does not exist.
Correct the filename and try again.
==============

pl.help me asap....

Sudha

ORACLE...Forms Related Question
Hi all
i have some fields on oracle forms 6i. i want to show the cursor movement with VISUAL ATTRIBUTE. when the cursor moves from one field to another i want to change the backgroud color to blue. i have created the visual attribute also having blue as back colour.
but i don't know where and how to call that perticular attribute so that when the user presses "TAB" button the colour changes to blue. and while leaving that perticular item again the back colour will be white.
Please help me out in this...or if i have posted this in wrong place then please suggest me the same site as this for ORACLE.
thank you very much
with best regards
sachin

Oracle Forms As SQL Server Front End
Can anyone tell me though it is possible to use Oracle Forms as a front end for SQL server or Access database, why it is not used widely?

Forms And Data Reports
Can I run a data report by binding data from a form? From what I've read I can only bind data from a data soure (database) to a data report. If so, can someone provide me with some ideas. I tried a and I get an error "Invalid Data Source".

Using Access Forms And Reports In VB6?
Is there anyway I can make use the forms and reports created in Microsoft Access? Can I called these forms and reports inside my VB6 application?

TIA

Resize Forms And Reports
How can I resize a full Access Database depending on the system resolution of the machine using visual basic module??

Thanks,
Joe

Reports And Printed Forms
What is the best method to use for writing reports and printed forms (invoices, Po's) for data tables managed by my VB6 application?

How To Create Drill-down Forms/reports
Hello!

My user wants to see a summary level display of some information (up to 4 rows , each with 5 fields) which I obtain from SQL Svr. With each row, he would like the ability to click something (button, or ??) that would allow him to drill down from that row to the details supporting that row. Then, he would again like to drill down further if possible.

The hierarchy would be:
Date (the main driver for the query)
>Location (here are the 4 rows max - 1 for each plant)
>>Project
>>>Shift
>>>>(Details) - project activity list (1 to maybe 5 or 6)

Then to complicate it, he would like the ability to switch the hierarchy from Date/Location/Project/Shift to Date/Project/Location/Shift, changing the drill-downs to support that.

I am too green to figure this out in VB/SQL, and would welcome your kind assistance, or direction to another website. Examples are gratefully received, too!

Thanks in advance!
Don

Generate/Read PDF Reports/Forms In VB 6.0
I would like to generate PDF reports/forms from within my VB 6.0 application. Also, I would like to import the filled in form results into my VB application. Is there a way to do all of this? If so, can someone point me in the correct direction? Thanks in advance!!!!

Access...previewing Reports From Forms
I am attempting to open a preview report from a button on the form, the field is in text format and I think thats giving me some difficulty, everytime I click on the preview button, it gives me a popup to enter the primary key again. The key issue has to do with the filter, the coding I have is:

Code:DoCmd.OpenReport "Product transaction log", acPreview, , "[Master Table].[UniqueID]=" & Me![UniqueID]

this same code worked fine in another form when the text format was a number, I was wondering if there is some modification I need to make to the filter part of the code to get it to find a match in text format?

Thank you in advance

Question About VB.NET And Displaying Access Forms/reports
Leave it to me to be asking for a miracle with my first post but...

Is there a way I can open forms and reports without opening the rest of the MS Access program? Or if not, can I remove/disable all toolbars in Access and most of the options in the Menubar when loading a form from MS Access for my application? And when the user is finished with the program, how can I re-enable the menus again so it appears to the user that nothing changes the next time the user opens Access? Can this be done using VB.NET or Visual Basic for Office Applications?

I don't know if this has anything to do with my problem or what it means but I read somewhere on this forum, and I quote "The Access Developer Extensions are only available as part of the Visual Studio Tools box and MSND Universal."

Thanks for any advice!

REPORTS - Is There Such Thing As Repeat Regions In Forms?
Hi, I'm new to the whole DOT.NET VB thing and I have an app that I have connected to a SQL db. Users can add/edit and delete rows of data. I'd like to also allow them to generate some canned reports that I write the queries for. How is the best way to go about this? I'm an ASP type programmer and am used to building repeat regions to generate reports. I have NOO idea how to do this in windows forms.

HELP!!!

TIA

Calling Reports && Forms From Access 2000
I'm a newbie VB programmer and need assistance.

Background: I have a application design with VB 6.0 front-end and a MS-Access 2000 back-end. I have created MS-Access 2000 forms with buttons that in turn call up in MS-Access 2000 reports on the same database.

Problem/Question: How do I call the MS-Access forms (and reports) via VB 6.0 so that they maintain their complete functionality? I'd like to avoid having to re-do the MS-Access forms in VB. Any special scripts which I can use?

Please advise. Thanks in advance for your help.

Passing Values From Forms To Crystal Reports
Hi,
I would like to know as to how to pass values from
forms to crystal reports after placing the crystal
control in the form. If there are any specific codes,
include them if possible. Is it possible to embed the
query in the form itself instead of designing it in
the crystal report.

Also I would like to print a summary of a single
record from multiple tables and not list out all the
records. Is it possible in crystal reports to do so.

Please reply ASAP.
Thank you in advance.

Regards,
Lakshmi narasimhan

Howto Create Forms In Vb With Crystal Reports
hi folks
i am using vb for developing an database application. iwant to
create reports. the reports will contain 4 parameters. dependingon the
parameters that i gave on the forms in vb i want report to contian that data
only.
suppose the four fiels are (1. mainlot, 2.)sublot,3.)start_Date,4.)
end_date ) depending on the no. of parameters enter on the opened form the
reports contians that particular data. how can i achieve this in vb using
crystal report. iam using access 2000.
thankx in advance.

Access Reports In Visual Basic With Like [FORMS]![NEW DISP]!ID
In Access I have a form named NEW DISP where the user searches for a particular record. Once the user finds that particular record, he/she has 12 different reports to print. All 12 reports are based on one query - the ID that the form displays.
Thus the following: (qryrptsearch) located in Access:


Code:
SELECT [DISP].[ID], [DISP].[DECI], [DISP].[ORDER], [DISP].[DATE], [DISP].[TYPE], [DISP].[JOB], [DISP].[CUSTOMER], [DISP].[FIRSTNAME], [DISP].[PHONE], [DISP].[PHONE1], [DISP].[CONTACTO], [DISP].[ORIGADDRESS], [DISP].[ORIGCITY], [DISP].[ORIGST], [DISP].[ZIP], [DISP].[CONTACTD], [DISP].[DESTADDRESS], [DISP].[DESTCITY], [DISP].[DESTST], [DISP].[ZIPDEST], [DISP].[WT], [DISP].[UNIT], [DISP].[CONTRACTOR], [DISP].[DRIVER], [DISP].[MOVERS], [DISP].[REMARKS], [DISP].[STOP], [DISP].[SPVR], [DISP].[GBL], [DISP].[SCAC], [DISP].[RANK], [DISP].[SOCIALSEC], [DISP].[code], [DISP].[ACCOUNT], [DISP].[KEYMAP], [DISP].[MAPREF], [DISP].[ETA], [DISP].[TIMEIN], [DISP].[PATRA], [DISP].[COMMREV], [DISP].[PAID], [DISP].[ACTWT], [DISP].[LH], [DISP].[PKG], [DISP].[CURRENTDATE], [DISP].[BKBY], [DISP].[SALESPERSON]
FROM DISP
WHERE ((([DISP].[ID]) Like [Forms]![NEW DISP]!ID));

Now I'm at a dilema.
I have tried to make the same thing with Visual Basic. It is a better form that connects to the data with an ADO control named datPrimaryRS. The 46th field in the Recordsource contains the ID of each record. I know that I want to change the above query (qryrptSearch) to something like this:


Code:
SELECT [DISP].[ID], [DISP].[DECI], [DISP].[ORDER], [DISP].[DATE], [DISP].[TYPE], [DISP].[JOB], [DISP].[CUSTOMER], [DISP].[FIRSTNAME], [DISP].[PHONE], [DISP].[PHONE1], [DISP].[CONTACTO], [DISP].[ORIGADDRESS], [DISP].[ORIGCITY], [DISP].[ORIGST], [DISP].[ZIP], [DISP].[CONTACTD], [DISP].[DESTADDRESS], [DISP].[DESTCITY], [DISP].[DESTST], [DISP].[ZIPDEST], [DISP].[WT], [DISP].[UNIT], [DISP].[CONTRACTOR], [DISP].[DRIVER], [DISP].[MOVERS], [DISP].[REMARKS], [DISP].[STOP], [DISP].[SPVR], [DISP].[GBL], [DISP].[SCAC], [DISP].[RANK], [DISP].[SOCIALSEC], [DISP].[code], [DISP].[ACCOUNT], [DISP].[KEYMAP], [DISP].[MAPREF], [DISP].[ETA], [DISP].[TIMEIN], [DISP].[PATRA], [DISP].[COMMREV], [DISP].[PAID], [DISP].[ACTWT], [DISP].[LH], [DISP].[PKG], [DISP].[CURRENTDATE], [DISP].[BKBY], [DISP].[SALESPERSON]
FROM DISP
WHERE ([DISP].[ID] Like datPrimaryRS.Recordset.Fields(46));

This is so when I click on the Command1 button to view "rpttime" (one of my 16 reports)...


Code:
Private Sub Command1_Click()
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.OpenCurrentDatabase "c:Documents and SettingsStephen LeCompteMy Documentsdisp-1.mdb"
appAccess.DoCmd.Maximize
appAccess.DoCmd.OpenReport "rpttime", acPreview
appAccess.Visible = True
End Sub

the first thing it will go to is the qryrptsearch!

My problem is that it won't work.
I get a run-time error '3085'.
Undefined function 'datPrimaryRS'.Recordset.Fields' in expression.

How can I define or change qryrptSearch query to where it understands what the datPrimaryRS.Recordset.Fields function is?

Any help is appreciated!

Thanks

Display Names Of Forms And Reports Of Access In Alphabetized Order In A List Box Using Vb
hi
can some1 pls help
i am displaying names of forms and reports from the access database in the list box. the code to display names of forms n reports that i am using is as given below:

For Each obj In dbs.AllForms
If obj.IsLoaded = False Then
List1.AddItem (obj.Name & " form")
End If
Next obj

For Each obj In dbs.AllReports
If obj.IsLoaded = False Then
List1.AddItem (obj.Name & " report")
End If
Next obj

the above code displays the names of forms and reports of the access database in the list box. i want to display the names in alphabetized order and names of forms must be displayed first and then reports using vb

can some1 pls help

thanks in advance

Display Names Of Forms And Reports Of Access In Alphabetized Form In Listbox Using Vb
hi
can some1 pls help
i am displaying names of forms and reports from the access database in the list box. the code to display names of forms n reports that i am using is as given below:

For Each obj In dbs.AllForms
If obj.IsLoaded = False Then
List1.AddItem (obj.Name & " form")
End If
Next obj

For Each obj In dbs.AllReports
If obj.IsLoaded = False Then
List1.AddItem (obj.Name & " report")
End If
Next obj

the above code displays the names of forms and reports of the access database in the list box. i want to display the names in alphabetized order and names of forms must be displayed first and then reports using vb

can some1 pls help

thanks in advance

Error When Compacting - Separate Forms, Reports, Queries, Module Code From Tables
I am trying to compact a database.

Just to give you some history:

I divided my original .mdb file into 2 .mdbs.

I just made 2 copies and in one of the copies, deleted everything but the tables. In the other database I create links to these tables.

When I try to Compact and Repair the database I get the following error :

The form name 'frmReporting_Main' is mispelled or refers to a form that doesn't exist.

If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and enter the correct form name.

(I don't understand because this form does not exist or at least it doesn't show up):

Problem Connecting To An Oracle 9i Database With The Oracle ODBC Driver
I have this older VB6 application that I don't have the time to convert to VS2005 right now. I have the Oracle ODBC client installed and the DSN are created as system DSN's. They are not using the "Microsoft ODBC for Oracle" driver, instead they are using the actual Oracle driver. Ive tried several connection strings including:

Code:
cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"

cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"
    
cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"


I keep getting the error handler from my function:


Code:
Public Function OpenDatabaseConnection() As Boolean
On Error GoTo errhandler
Dim connectionstring As String

    Set cn = New ADODB.Connection
    cn.Provider = "MSDAORA.1"
    'cn.connectionstring = "Provider=OraOLEDB.Oracle.1;Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
    'cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
    'cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN
    'cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"
    cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"
    cn.Open
    OpenDatabaseConnection = True
    Exit Function
errhandler:
    MsgBox "Connection failed, Enter Login Parameters Again", vbCritical
    OpenDatabaseConnection = False
    Exit Function
End Function


...any ideas on the correct connection string?

How To Connection To Oracle Dataase Using Oracle 9.2 ODBC Driver
I try to connect to the Oracle database using the Oracle in OraHome92 driver, the code is:

Private Sub ConnectDB()
   Dim sConn As String
   Dim DB As String
  
   Select Case cboEnviro.Text
      Case "Production"
         DB = "PROD"
      Case "Testing"
         DB = "TEST"
   End Select
   
   sConn = "Driver=(Oracle in OraHome92);" & "Data Source=" & DB & _
                ";Uid=userid;Pwd=password;"
   dbConn.Open sConn
End Sub


I got the following error message:

Run-time error '2147467259 (80004005)':
[Oracle][ODBC][Ora]ORA12560: TNSrotocol adapter error

Can anyone tell me what wrong with this and how to fix the problem. Thanks.

Connection To An Oracle 9i Database With The Oracle ODBC Driver
I have this older VB6 application that I don't have the time to convert to VS2005 right now. I have the Oracle ODBC client installed and the DSN are created as system DSN's. They are not using the "Microsoft ODBC for Oracle" driver, instead they are using the actual Oracle driver. Ive tried several connection strings including:


Code:

cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"

cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"


I keep getting the error handler from my function:



Code:

Public Function OpenDatabaseConnection() As Boolean
On Error GoTo errhandler
Dim connectionstring As String

Set cn = New ADODB.Connection
cn.Provider = "MSDAORA.1"
'cn.connectionstring = "Provider=OraOLEDB.Oracle.1;Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
'cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
'cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN
'cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"
cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"
cn.Open
OpenDatabaseConnection = True
Exit Function
errhandler:
MsgBox "Connection failed, Enter Login Parameters Again", vbCritical
OpenDatabaseConnection = False
Exit Function
End Function


...any ideas on the correct connection string?

VB Connectivity To Oracle DSN Using Oracle In OraHome92 Driver
Hi,

I have a desktop VB application which connects to an Oracle 9i database. Uptill now it has been using the Microsoft ODBC for Oracle driver (MSORCL32.DLL) to connect to the Oracle DSNs. Now I wish to change over to the "Oracle in OraHome92" driver (SQORA32.DLL).

When the above change is made, the application connects fine and the select queries (simple fetches without aggregate functions) execute alright. However I am facing issues, when I try to execute complex SQL statements such as statements invoking stored procedures and returning recordsets.
eg.
Code:
{ call wPHARMACY_VALIDATIONS.pwPHARMACY_VALIDATIONS(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, {RESULTSET 1, o_validation_error_codes}) }

This gives an oracle error "o_validation_error_codes needs to be defined". This error was not encountered with the Microsoft ODBC driver for Oracle previously.

Also, we are facing issues with executing stored procedures directly using ADODB command object
The error in this case is "-2147217887 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done".

If anybody has worked on something similar or can give pointers on the same, and similar such issues that we might encounter because of the driver change, please reply.

Thanks & Regards,
V!kram

Accessing Oracle From Std VB6 Exe Without Oracle Client
Is it possible to access Oracle database using VB6 std exe without having the Oracle Client Installed on the client machine.
The oracle server resides on a UNIX/SUN machine.

Currently I'm using ADO, MDAC 2.5 without a DSN. It uses tnsnames.ora

Oracle 9 DMP File Cannot Be Imported In Oracle 8i
Dear all
I have exported a file in oracle 9 and created a dmp file.
I am unable to import the same in Oracle 8i
Is it technically possible, if so please guide me
Turab

Importing Dmp File From Oracle 7.3 To Oracle 8.0 I
I would like to get detail unformation.
I have a file puls.dmp exported from oracle 7.3
I would like to import this file on to new Oracle 8.0 i Server

I would be oblidge if any one

Let me know step By step process of creating dataBase,User,Schema

---&gt; Importing and restoring the exported file.

Data Reports Active Reports Or Crystal Reports
Hi all

I am really stuck here and i need help urgently
I have to call three tables in a row to print a single invoice entry
noe the problem is if the do it by calling single tables then there is a problem that it is nopt going to print the last order which is filled.Is there is any way it can be done through using sql command or something.
Secondly if i use max order in sql then i would not be in a position to print order after searching for it


Thanx

In Crystal Reports, How To Display Financial Reports (P & L, Balance Sheet Etc.) In Columnar Format
Dear All,

I am developing a Financial application using VB6, MS-Access & Crystal Reports 8.5. I am facing problems in certain reports. Some of the reports like Profit & Loss and Balance Sheet require the output to be printed in columnar format.

I have tried giving subreports for each section, i.e.; Assets & Liabilities, but then, the output is not coming in order as per the groups. The problem is even more where there are sub-sections in the right side column & left side column for example in Profit & Loss, where there are sub-sections for Gross Profit/Loss and Net Profit/Loss. In such cases, how to bring the total amount fields at the same horizontal level.
I hope someone can help me how to do the above.

Thanks in advance.

Best Regards
Mahesh

Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I have several reports that were designed in Crystal Reports that have the DB location changed during runtime. When I move my database, or choose another copy of the DB that has a lot of records in it, my reports don't fire. I need to be able to Verify the database during runtime. I'm usiung VB6.0 and CrystalReports8.5 I've tried using Crystal's "Verify On Every Print" function, but I haven't had any luck. Here is the code I am using.

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

Also, does anyone know if changing the DataFiles location during runtime also effects the subreports. I don't think it does, but any input would be appreciative.

Need To Understand Data Reports - Heard That Crystal Reports Were Slow
I have two questions:

1.) I was going to take a step forward to learn how to use crystal reports but I heard that on a website they are viciously slow. Is that true or is there a way around that with coding?

2.) I have been using Access reports through Visual Basic 6.0 with the following code - thanks for the tremondous help of everyone on this website:

Code:
appAccess.OpenCurrentDatabase SERVER & "disp-1_be.mdb"
appAccess.DoCmd.Maximize
appAccess.DoCmd.OpenReport "oalog", acPreview
appAccess.Visible = True

The reports work great UNTIL I came accross a situation where the report is based off of the data entry of the user. oalog is a monthly report and in the query it automatically pulls the current month with the following query:

Code:
SELECT oalogallmonths.ctsbranch, Count(oalogallmonths.Amount) AS [Total Of Amount], oalogallmonths.GivebyName, oalogallmonths.United, oalogallmonths.Mayflower, oalogallmonths.Other, oalogallmonths.Tord, oalogallmonths.CURRENTDATE, oalogallmonths.Amount, oalogallmonths.Month1, oalogallmonths.ORDER
FROM months, oalogallmonths
WHERE (((months.monthID)=[oalogallmonths].[Amount]))
GROUP BY oalogallmonths.ctsbranch, oalogallmonths.GivebyName, oalogallmonths.United, oalogallmonths.Mayflower, oalogallmonths.Other, oalogallmonths.Tord, oalogallmonths.CURRENTDATE, oalogallmonths.Amount, oalogallmonths.Month1, oalogallmonths.ORDER
HAVING (((oalogallmonths.Amount)=11;

If you notice the records are pulled HAVING the 11th month in there.

If I want the user to ENTER the month I know that I must change the last line to:


Code:
HAVING (((oalogallmonths.Amount)=[ENTER MONTH]));

But a user might type January or 12/2003, etc...

so I made a combobox named ListMonth of the 12 months.
Then I made the change from:


Code:
HAVING (((oalogallmonths.Amount)=11;
to

Code:
HAVING (((oalogallmonths.Amount)=ListMonth.ListIndex + 1));

The only problem is that I keep getting a message box asking for ListMonth.ListIndex + 1.

My question is in the above code that defines appAccess.DoCmd.OpenReport "oalog"...
is there a way to change the RecordSource of the report to pull from my own query instead of the Access Query?

Thanks,
Stephen

Crystal Reports - Upgraded To 8.5, Now Reports Written In 8.0 Wont't Work!!!
My reports are crashing when I run them on a machine with CR8.5, but they work fine on cr8.0. They crash inside the .DiscardSavedData Routine.


Does anyone know why or what I can do...

I call the report.Printout routine and right after I call the
.DiscardSavedData. The report is still printing out in debug mode.


Please help. Is my syntax wrong. The help file says I can only use Printout and DislcardSavedData in "formatting idle" mode. I don't know what this this???? The .PrintOut routine works but not the discardsaveddata.


Thanks,

Any help is appreciated.


M

How To Use Crystal Reports To Make The Dynamic Reports?(I Can't Use The Design Expert To D
  How to use Crystal Reports to make the dynamic reports?(I can't use the design expert to design the report,because the data source with different fields is unknown in design time.)
     Hello all!
     I use the dynamic generating MS Access table as the Data Source of Crystal Report.
How to use the Crystal Reports to display the data of the dynamic generating MS Access table?
     Thanks All!
                                                    China






Edited by - dehuiworkroom@hotmail.com on 12/17/2003 9:37:59 PM

Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I've created a Report Viewer that displays Crystal Reports 8.5 reports. I have the DB location in Crystal Reports changed during runtime, but I can't get the location to change in the subreports at runtime as well. Also, by using my method of calling the reports, I can't get VB to pass any parameters to the Main report. Below is the code that I am using. I'm using VB 6.0 and CR 8.5

Dim MyNewKey
MyNewKey = Who.Text

' On Error GoTo KeepGoing

MyLocation = GetStringValue("HKEY_LOCAL_MACHINESoftwareAptCom", "AptCom DB Path")
strReportFile = "c:aptcom
eports eninfo.rpt"

Set CRReport = New CRAXDRT.Report
Set CrxApp = CreateObject("crystalruntime.application")
Set CRReport = CrxApp.OpenReport(strReportFile)
' Set CRReport.ParameterFields(0) = "ThisKey;" & MyNewKey & ";true"

' KeepGoing:

For Each dbTable In CRReport.Database.Tables
dbTable.SetLogOnInfo "", MyLocation, "", ""
dbTable.Location = MyLocation
dbTable.SetDataSource MyLocation
Next dbTable
CRReport.Database.Verify


CRReport.SQLQueryString = strSQL

frmReportViewer.Show
frmReportViewer.CRViewer1.ReportSource = CRReport
frmReportViewer.CRViewer1.ViewReport

Set CRReport = Nothing
Set CrxApp = Nothing
Set CRReport = Nothing

&gt;&gt;&gt;&gt;
I've tried using this method:

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

But, I can't get Crystal Reports to verify the database during runtime. The first way verifies the DB, but won't change the DB location of the subreports or pass parameters to the reports.

Any help would be appriciative.

Access Reports Vs Visual Basic Data Reports?
I need some help.

For the longest time - I've been using Access Reports that are printed on carbon copy bill of ladings and the like, etc. These reports print only the data that is based on one query. That one query is based on three text boxes on a form. The query searches whatever the user typed in those 3 text boxes and pulls all the records that match. If the user does not type anything in those 3 text boxes they automatically default to '*' in each of the text.

I want to do the same thing in Visual Basic. But I have a better idea for a search. I am using a DataGrid to list everything in a query and basically the user just highlights the row that he wants to choose. Then up top on the menu he clicks on whatever report he wants to print based on the record he/or she highlights. I know I've got to use DataGrid.Columns(0) as a criteria for a search and so I've finish what kind of SQL statement I'm going to use. As regards output, I'm unsure of what to use. I did try to pull up the actual Access Report I used before but that did not work because it would not recognize the DataGrid.Columns(0) command in the query.

I'm new to the Visual Basic Data Report - I don't see any tutorials anywhere.
I understand Crystal Reports are the old way of doing this but don't have a means to try that out.
At this point - in my development - I'm thinking I'd probably make a form that would have the same output with the text boxes tied to the datasource (recordsource would be the query) and then i'd print the form data only. But not sure how to do this either? Please help.

Thanks,

Stephen

Crystal Reports- I Need Help Running Reports With A Shared Database.
I am trying to figure out how to use a shared database in crystal reports. I have it set up for my application were I use: App.Path +
"databaseWMdbase.mdb" But in crystal reports it makes you use a drive name. I am trying to use the UNC but when I run it on the computer without the physical database it tells me Database not found... is there a way to set the Location of the database in the form load like you do with ADO? Any help or Ideas would be great.

Copyright 2005-08 www.BigResource.com, All rights reserved