Announcement

Collapse
No announcement yet.

ODBC drivers

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • ODBC drivers

    I wonder if anybody has scuccesfully connected to any database through ODBC drivers. I really do not understand NM concept here.
    Obviously in many cases the password is not required but SC8 will not allow me to connect without password.I'm just trying t oconnect to Excell table through ODBC driver. The connection has been setup as UserDSN but I get errors when connecting


    Arthur
    Last edited by aka; 10-06-2014, 07:26 PM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    Hello,

    Issue reported to our bugs team.

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Arthur, i'm subscribing to this thread to know what happens actually this is very important aspect not a lot of pals using it, but we defiantly need to know all about it

      although, seeing bartho here with his usual template isn't promising with near-feature solution


      cheers

      Comment


      • #4
        At this moment with 2 drivers not working at all SC8 is like a man with only one eye. How can you even advertise a product like that (?).
        Obviously this hasn't been even tested because such a major problem should not let the company even release SC8 for public use.

        Arthur
        -----------------------------------------
        Arthur Klisiewicz
        dATA POINT SOFTWARE
        www.datapointsoftware.com

        Comment


        • #5
          Hello,

          What is the database you are trying to connect and what driver you're using?
          Are you using our ODBC connection or ODBC extension of some database?
          Best Regards,
          John L. Santos

          Bug Tracker Team
          NetMake - IT Solutions

          Comment


          • #6
            no matter what database or ODBC I sue it does not work. Recently I tried to connect to Access/Excell (just for testing). Build the DSN connection on the PC and tested with other tools - all OK, but SC simply does not even recognize there is any DSN on the system.
            -----------------------------------------
            Arthur Klisiewicz
            dATA POINT SOFTWARE
            www.datapointsoftware.com

            Comment


            • #7
              Did you tried as systen dns?not sure if userdns will work
              /Giuseppe

              Professional Scriptcase Services
              Some Customers opinions

              Comment


              • #8
                yes I did, same result = can't connect !

                Arthur
                -----------------------------------------
                Arthur Klisiewicz
                dATA POINT SOFTWARE
                www.datapointsoftware.com

                Comment


                • #9
                  Hello,

                  If possible, we can schedule a remote access to do a better analysis of your environment.
                  Best Regards,
                  John L. Santos

                  Bug Tracker Team
                  NetMake - IT Solutions

                  Comment


                  • #10
                    Hi John, could you please post back the results? ODBC is important point which we are missing how to deal with it, if you can give also more information would be much better, thanks in advanced.

                    Comment


                    • #11
                      ok, I did some more testing and seems like System DSN works (I only tested .dll for Excell and for READING data only).

                      When using USed DSN I get following error:
                      -------------------------------------
                      Connection Error

                      odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect
                      -------------------------------------


                      Of course in most cases you want to use UserDSN because you will need some sort of security. System DSN does not provide password access.
                      Arthur
                      Last edited by aka; 10-16-2014, 08:27 PM.
                      -----------------------------------------
                      Arthur Klisiewicz
                      dATA POINT SOFTWARE
                      www.datapointsoftware.com

                      Comment


                      • #12
                        Where did you set your ODBC connection? In the odbc manager or in the odbcad32 manager?
                        As system or as user?

                        Since netmake is 32 bit I suggest taking the 32 bit odbc manager using system. And dont put spaces in the odbc name just to be safe.

                        Comment


                        • #13
                          My ODBC or SQL connection does not work. I have tried dozens of different methods. When I reported this I was told to upgrade and enter my new serial and then it "SHOULD" work. But it doesn't. It doesn't even recognise the local host server. I created several various databases and even though it saw the database it said that it could not connect.

                          This is extremely frustrating.

                          Comment


                          • #14
                            This is just one error when trying to connect

                            Connection Error

                            [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot open database "JCPZ_FLAG_FORMS" requested by the login. The login failed. odbc_exec() expects parameter 1 to be resource, boolean given

                            Comment


                            • #15
                              This is the fault when trying to connect directly

                              Connection Error

                              Login failed for user ''. mssql_connect(): Unable to connect to server: CHARLENE

                              Comment

                              Working...
                              X