Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. Sqlclient and SQLTransaction error:::: vb. net

Sqlclient and SQLTransaction error:::: vb. net

Scheduled Pinned Locked Moved Visual Basic
helpcsharpdotnetquestion
6 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Offline
    N Offline
    Nilesh Hapse
    wrote on last edited by
    #1

    hello everybody, I've created setup of my vb.net application using installshield 12. This setup when installed on my development machine works fine. But when i install this thing on another machine which has only .Net framework and MS-office, and try to run my exe it gives me error which says: **No accessible overloaded 'SqlCommand.Transaction' is most specific for these arguments: Public Sub set_Transaction(value As System.Data.SqlClient.SqlTransaction) Public Sub set_Transaction(value As System.Data.Common.DbTransaction)** :( Can naybody help me out and tell me what this error is about? Thanks in advance............

    C 1 Reply Last reply
    0
    • N Nilesh Hapse

      hello everybody, I've created setup of my vb.net application using installshield 12. This setup when installed on my development machine works fine. But when i install this thing on another machine which has only .Net framework and MS-office, and try to run my exe it gives me error which says: **No accessible overloaded 'SqlCommand.Transaction' is most specific for these arguments: Public Sub set_Transaction(value As System.Data.SqlClient.SqlTransaction) Public Sub set_Transaction(value As System.Data.Common.DbTransaction)** :( Can naybody help me out and tell me what this error is about? Thanks in advance............

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      What database are you using, Access ?

      Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

      N 1 Reply Last reply
      0
      • C Christian Graus

        What database are you using, Access ?

        Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

        N Offline
        N Offline
        Nilesh Hapse
        wrote on last edited by
        #3

        No ! i am using SQL server 2000. This works fine on my developemtn machine. But when i create a setup using installshield 12 and install it on test machine it gives the said error.

        C 1 Reply Last reply
        0
        • N Nilesh Hapse

          No ! i am using SQL server 2000. This works fine on my developemtn machine. But when i create a setup using installshield 12 and install it on test machine it gives the said error.

          C Offline
          C Offline
          Christian Graus
          wrote on last edited by
          #4

          Nilesh Hapse wrote:

          i am using SQL server 2000.

          OK, but you didn't say SQL Server is installed on the target machine.  so, how can it work ?

          Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

          N 1 Reply Last reply
          0
          • C Christian Graus

            Nilesh Hapse wrote:

            i am using SQL server 2000.

            OK, but you didn't say SQL Server is installed on the target machine.  so, how can it work ?

            Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

            N Offline
            N Offline
            Nilesh Hapse
            wrote on last edited by
            #5

            on the test machine SQL client is installed. SQL server is installed on another machine. I am getting the server details thru a file. From those details i am formatting the connection string and connecting to the database.

            C 1 Reply Last reply
            0
            • N Nilesh Hapse

              on the test machine SQL client is installed. SQL server is installed on another machine. I am getting the server details thru a file. From those details i am formatting the connection string and connecting to the database.

              C Offline
              C Offline
              Christian Graus
              wrote on last edited by
              #6

              It's the exact same project ? It looks to me like you need to be more specific about which item you're trying to pass through. Why did yo usay you had Office installed, when you're using SS ?

              Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups