need help with connecting to a remote SQL database

Scriptcase 7 Bugs
#1

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.

#3

ok, will check the odbc

#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?

#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.

#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 hird\adodb\drivers\adodb-mssql.inc.php on line 609

what am i doing wrong?

#7

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.