User Profile

Collapse

Profile Sidebar

Collapse
gaubun
gaubun
Last Activity: Feb 19 '08, 06:38 AM
Joined: Jan 7 '08
Location: Ahmedabad
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • gaubun
    started a topic To pass sql query from VB6 to crystal reports

    To pass sql query from VB6 to crystal reports

    Dear All,

    I am using :
    -> VB6
    -> mysql
    -> crystal report 8.5
    -> Mysql odbc 3.51 Driver

    Now my problem is:

    I want to pass SQL query to the report from vb form.

    I tried:
    report.sqlquery string= str
    report.database .verify

    but it didn't workd.

    Plz help!

    Regards.
    See more | Go to post

  • gaubun
    replied to Merging Two Access DATABASES
    Hi Fish,

    Thanx for your concern.
    "Do you want to work with both as a single one or do you want work with each?
    If you are mentioning the first, then I would like to stay that it is generally a bad practice."


    Actually I am merging some village databases to its upper level i.e Subcenters or SCs database and then will use latter to generate reports. I am not going to manipulate ANY OF THE VILLAGE...
    See more | Go to post

    Leave a comment:


  • Hi all ,
    even I am also wanted to know the same thing....
    I want to connect my mysql database with other computers on lan....
    I am using VB6 as frontend and myodbc as connector...

    Plz help.

    Gaurav
    See more | Go to post

    Leave a comment:


  • gaubun
    replied to Merging Two Access DATABASES
    Hi vksingh

    In simple words...I want to combine to identical Access databases into one and that to from vb6. Just need a hint to get started....can I do this by using adodc? or should I have to use some database object like
    "dim db1 as database"
    but I don't know how to manipulate this object? Jz need a little help.

    Gaurav...
    See more | Go to post

    Leave a comment:


  • gaubun
    replied to Merging Two Access DATABASES
    and yeah I forget to mention that structures are same.

    Gaurav
    See more | Go to post

    Leave a comment:


  • gaubun
    started a topic Merging Two Access DATABASES

    Merging Two Access DATABASES

    Hi All,

    Just joined this site....I am really stuck into one problem. Actually I am writing a code in VB6 to merge TWO ACCESS DATABASES. Wanted to know if I can use a single sql query to merge. Is MERGE or UNION effective in merging two DATABASES. Plz help.
    I am looking forward to get some positive replies.
    Thanx in advance.

    Gaurav
    See more | Go to post
No activity results to display
Show More
Working...