Announcement

Collapse
No announcement yet.

need help with connecting to a remote SQL database

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

  • need help with connecting to a remote SQL database

    Hi,

    Does anyone have a solution to the error i get when i try the DB test connection on Scriptcase

    Connection Error
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified odbc_exec() expects parameter 1 to be resource, boolean given

  • #2
    Reading the message I would say that you have not installed the odbc driver correctly or that you are not referencing the datasource name correctly. Start by checking the odbc connection from some other tool to get that rigth and then use the datasource to connect. It's hardly a SC issue, and I it's hard to see what going wrong in your installation I'm affraid. But first step is to be sure that your odbc is installed well and working.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      ok, will check the odbc

      Comment


      • #4
        i was instructed by scriptcase to do this
        You must create a System ODBC Connection. Start > Settings > Control Panel > Administrative Tools > Data Sources (The ODBC must be created in the same Host where ScriptCase is installed ).
        * If you are using Windows 64 bits environment, it is necessary to create the ODBC by "odbcad32.exe" application in the folder "../windows/syswow64/".

        it is take forever for the Test connection to report success status. what next am i missing here?

        Comment


        • #5
          I don't use odbc, but running a 32 bits app to create a 64 bits connections doesn't sound right for me. Besides that what database are you connecting to, is that database running, are you sure you have set the requested variables right? It's virtually impossible to answer this question w.o. any info here.
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment


          • #6
            I am actually trying to connect scriptcase to a remote server hosting my MSSQL db
            And i have details similar to this:

            DB name: aaaaa
            server name/IP: 129.129.129.129
            login: bbbbb
            pasword: ccccc

            Now using the New DB Connection on scriptcase and selecting the "MSSQL Server" option. I use all the DBMS Type and all reported errors, first with MSSQL Server

            Then I got this Connection Error
            Fatal error: Call to undefined function mssql_get_last_message() in C:\Program Files (x86)\NetMake\v71\wwwroot\scriptcase\prod\third\ad odb\drivers\adodb-mssql.inc.php on line 609

            what am i doing wrong?

            Comment


            • #7
              Originally posted by abbeygad View Post
              what am i doing wrong?
              You should read a little at google with "mssql mssql_get_last_message()" then you found the solution ... Look at this post (last paragraph) from yesterday.
              Best regards: - Reinhard -

              I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

              Comment

              Working...
              X