Skip to main content

[archive] Acu4gl And Sql 2008 Server Expresss

  • June 28, 2010
  • 2 replies
  • 0 views
D

[Migrated content. Thread originally posted on 28 June 2010]

We have been doing development on XP, Windows 2000 and SQL server 2005 express using V 8.10 all is working just fine, when porting to 2008 server using SQL 2008 express I keep getting a 9D,17 when trying to initialize any files (9D,17 Access denied or can not find the server)

I used the same ms_inst.sql used in WIndows 2000 server, and WIn XP. The DB was created on the SQL 2008 express successfully.
Settings when we start the software:
Set variable 'SQLDB_FLG' to value 'Y'
Set variable 'SQLDB_TYP' to value 'MSSQL'
Set parameter '4GL_ILLEGAL_DATA' to 1
Set parameter 'XFD_DIRECTORY' to '4GLXFD'
Set parameter 'A_MSSQL_ADD_TIMESTAMP' to TRUE
Set parameter 'A_MSSQL_DATABASE' to 'pbsv12'
Set parameter 'A_MSSQL_LOCK_DB' to 'pbsv12'
Set parameter 'A_MSSQL_ADD_IDENTITY' to TRUE

After starting program to create a table in the DB

APOBJ\\APDOSI.acu loaded
PATHFILE.DAT: read, key 0 (thread 775)
>>>key 0 = '00APCTLF '
Set variable 'APCTLF00_HOST' to value 'MSSQL'
Set parameter 'XFD_MAP' to 'APCTLF* = APCTLF'
>>>trying alias = APCTLF00
APCTLF00: open output with lock (thread 775)
>>>>trying APCTLF00
-->insert (0), assign_name: APCTLF00, filesystem: 1, external_name: APCTLF00
mssql_open 'APCTLF00', 197122, '0000000522,0000000522,001,0'
report_status called from 1175
[1] 08001 17 - [DBNETLIB]SQL Server does not exist or access denied.
[2] 01000 2 - [DBNETLIB]ConnectionOpen (Connect()).
No more messages
Leaving, find_connection
>>>file status = 9D,17

I can see the DB (pbsv12) using SQL MGMT studio, so I know it is there, so I'm guessing its access denied.

Any ideas on how to resolve this problem.

Thanks in advance;
Alex

    2 replies

    D

    [Migrated content. Thread originally posted on 28 June 2010]

    We have been doing development on XP, Windows 2000 and SQL server 2005 express using V 8.10 all is working just fine, when porting to 2008 server using SQL 2008 express I keep getting a 9D,17 when trying to initialize any files (9D,17 Access denied or can not find the server)

    I used the same ms_inst.sql used in WIndows 2000 server, and WIn XP. The DB was created on the SQL 2008 express successfully.
    Settings when we start the software:
    Set variable 'SQLDB_FLG' to value 'Y'
    Set variable 'SQLDB_TYP' to value 'MSSQL'
    Set parameter '4GL_ILLEGAL_DATA' to 1
    Set parameter 'XFD_DIRECTORY' to '4GLXFD'
    Set parameter 'A_MSSQL_ADD_TIMESTAMP' to TRUE
    Set parameter 'A_MSSQL_DATABASE' to 'pbsv12'
    Set parameter 'A_MSSQL_LOCK_DB' to 'pbsv12'
    Set parameter 'A_MSSQL_ADD_IDENTITY' to TRUE

    After starting program to create a table in the DB

    APOBJ\\APDOSI.acu loaded
    PATHFILE.DAT: read, key 0 (thread 775)
    >>>key 0 = '00APCTLF '
    Set variable 'APCTLF00_HOST' to value 'MSSQL'
    Set parameter 'XFD_MAP' to 'APCTLF* = APCTLF'
    >>>trying alias = APCTLF00
    APCTLF00: open output with lock (thread 775)
    >>>>trying APCTLF00
    -->insert (0), assign_name: APCTLF00, filesystem: 1, external_name: APCTLF00
    mssql_open 'APCTLF00', 197122, '0000000522,0000000522,001,0'
    report_status called from 1175
    [1] 08001 17 - [DBNETLIB]SQL Server does not exist or access denied.
    [2] 01000 2 - [DBNETLIB]ConnectionOpen (Connect()).
    No more messages
    Leaving, find_connection
    >>>file status = 9D,17

    I can see the DB (pbsv12) using SQL MGMT studio, so I know it is there, so I'm guessing its access denied.

    Any ideas on how to resolve this problem.

    Thanks in advance;
    Alex
    When using the SQL MGMT tool is that one the same machine SQL Server 2008 Express is? or is it on another machine.

    When I installed SQL Server 2008 Express I could access it locally using SQL Server tools but could never get to it from a remote machine using any of the Microsoft tools.
    D

    [Migrated content. Thread originally posted on 28 June 2010]

    We have been doing development on XP, Windows 2000 and SQL server 2005 express using V 8.10 all is working just fine, when porting to 2008 server using SQL 2008 express I keep getting a 9D,17 when trying to initialize any files (9D,17 Access denied or can not find the server)

    I used the same ms_inst.sql used in WIndows 2000 server, and WIn XP. The DB was created on the SQL 2008 express successfully.
    Settings when we start the software:
    Set variable 'SQLDB_FLG' to value 'Y'
    Set variable 'SQLDB_TYP' to value 'MSSQL'
    Set parameter '4GL_ILLEGAL_DATA' to 1
    Set parameter 'XFD_DIRECTORY' to '4GLXFD'
    Set parameter 'A_MSSQL_ADD_TIMESTAMP' to TRUE
    Set parameter 'A_MSSQL_DATABASE' to 'pbsv12'
    Set parameter 'A_MSSQL_LOCK_DB' to 'pbsv12'
    Set parameter 'A_MSSQL_ADD_IDENTITY' to TRUE

    After starting program to create a table in the DB

    APOBJ\\APDOSI.acu loaded
    PATHFILE.DAT: read, key 0 (thread 775)
    >>>key 0 = '00APCTLF '
    Set variable 'APCTLF00_HOST' to value 'MSSQL'
    Set parameter 'XFD_MAP' to 'APCTLF* = APCTLF'
    >>>trying alias = APCTLF00
    APCTLF00: open output with lock (thread 775)
    >>>>trying APCTLF00
    -->insert (0), assign_name: APCTLF00, filesystem: 1, external_name: APCTLF00
    mssql_open 'APCTLF00', 197122, '0000000522,0000000522,001,0'
    report_status called from 1175
    [1] 08001 17 - [DBNETLIB]SQL Server does not exist or access denied.
    [2] 01000 2 - [DBNETLIB]ConnectionOpen (Connect()).
    No more messages
    Leaving, find_connection
    >>>file status = 9D,17

    I can see the DB (pbsv12) using SQL MGMT studio, so I know it is there, so I'm guessing its access denied.

    Any ideas on how to resolve this problem.

    Thanks in advance;
    Alex
    The above issue was fixed by opening up port 1433, for both local and remote, thanks for your interest, once the port is opened this error disappears

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement