Hi,

This is a web service question. I can't seem to get a simple web service to connect to a local database using odbc.

software Im using is as follows:

powerbuilder 2019 beta,  sybase anywhere 16,  iis 10,  windows 10.

This is a standard power builder web service ( no c# ).  Everything is running on the same machine.

The database is started manually ( I added asp.net & application pool permissions anyway )
The web service deploys correctly. The client talks to the web service ( i.e. the web service returns the
error message from the connect sqlca statement. )

Ive deployed the runtime package to the \bin directory under my webservice.
Ive deployed the .net runtime to the same \bin directory under my webservice.

Ive made sure the application pool is 32bit.

My connection statement works perfectly from an application but not from a web service.

Can anyone shed some light on this? I dont know what to try next.  Here's my connect statement.

//---------------------------------------------------------------------------------------------
// fill out the sqlca object
//---------------------------------------------------------------------------------------------
SQLCA.DBMS = "ODBC"
SQLCA.Database = ""
SQLCA.UserID = "dba"
SQLCA.DBPass = "sql"
SQLCA.LogID = ""
SQLCA.LogPass = ""
SQLCA.ServerName = "local1"
SQLCA.DBParm = "ConnectString='DSN="+"local1"+";UID=dba;PWD=sql;'"
SQLCA.Lock = ""

//---------------------------------------------------------------------------------------------
// check the autocommit flag, which is hardcoded to false
//---------------------------------------------------------------------------------------------
//Choose Case Lower ( "false" )
// Case "1", "true", "on", "yes"
// SQLCA.AutoCommit = True
// Case "0", "false", "off", "no"
SQLCA.AutoCommit = False
// Case Else
// SQLCA.AutoCommit = False
//End Choose

//---------------------------------------------------------------------------------------------
// try connecting to the database
//---------------------------------------------------------------------------------------------
Connect using SQLCA;

if sqlca.sqlcode <> 0 then
as_errorstring = String(SQLCA.SQLCode) + ", " + sqlca.sqlerrtext + ", " + String(sqlca.sqldbcode)
return sqlca.sqlcode
end if

thanks

mitch