|
| WDM21 - SqlConnectWS Error |
| Iniciado por guest, 31,ene. 2018 01:24 - 8 respuestas |
| |
| | | |
|
| |
| Publicado el 31,enero 2018 - 01:24 |
Hello
i have developed an app that uses a webservice (namely the one included with windev mobile) and am running into an issue when trying to connect with my phone.
when i connect using the testing tools in the IDE i am having no problem connecting, however when i deploy to my phone i get this error
The Connection to the data source failed.
error code :76005
unable to contact the server
i am unable to find a reference to this error code on the windev help site. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 12:52 |
Hello
Check if the directory of the BD engine library is in the directory?
victor
---
El software de antivirus Avast ha analizado este correo electrónico en busca de virus.
https://www.avast.com/antivirus |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 13:30 |
Hi Elisha
without seeing your connection code, it's going to be hard to help...
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,enero 2018 - 23:12 |
liConn = SQLConnectWS("https://our server/WDSOAPDB_WEB/","my data source","","")
i have been able to get it successfully working when not using an https address. so i assume its the app trying to connect to a url with a ssl.
liConn = SQLConnectWS("http://non ssl domain/WDSOAPDB_WEB/","my data source","","") |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,febrero 2018 - 12:24 |
Hi Elisha
if THAT is your REAL connection code, then you are missing the testing
of the return value and the displaying of the precise error...
Now, if that is just what you THINK we need to see in order to solve a
problem that you don't know how to solve, your logic is faulty... 
As I doubt STRONGLY that your data source is called "my data source", we
are very probably in the second case and you clearly don't want to give
us any information...
So, best of luck...
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)
More information on http://www.fabriceharari.com
Le 1/31/2018 à 5:12 PM, Elisha Spicer a écrit :
liConn = SQLConnectWS(" https://our server/WDSOAPDB_WEB/","my data source","","") i have been able to get it successfully working when not using an https address. so i assume its the app trying to connect to a url with a ssl. liConn = SQLConnectWS(" http://non ssl domain/WDSOAPDB_WEB/","my data source","","") |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
5 mensajes |
|
| Publicado el 10,marzo 2018 - 02:41 |
yes, i was trying to keep our info private off of a public forum.
i didnt think i needed to post my exact connection string and place our server info out to the world.
im still going to hide the server, but this is my code.
mind, if i change it to a http:// address it works, but using a https:// it does not.
i have noticed it does work on my android 7.0 device but my other 4.x devices it does not with https
IF InternetConnected() = True THEN
sqlconwsnum = SQLConnectWS("https://xxxxxxxxxxxx.com/WDSOAPDB_WEB/","AndroidApp","","")
IF sqlconwsnum <> 0 THEN
sSQLQuery is string = "SELECT RTRIM(id), RTRIM(name), RTRIM(description), RTRIM(location) FROM asset WHERE id LIKE "+gsAsset_ID+""
gtStartTime = GetSQLDateTime()
GetGUIDInfo()
IF SQLExec(sSQLQuery, "QRY_SELECT") THEN
SQLFirst("QRY_SELECT")
IF SQL.Out = True
OpenMobileWindow(WIN_AddAsset)
WIN_AddAsset.STC_NewID = gsAsset_ID
Info("Asset Not Found in Database")
END
WHILE SQL.Out = False
STC_Id = SQLCol("qry_select",1)
STC_Name = SQLCol("qry_select",2)
STC_Description = SQLCol("qry_select",3)
STC_Location = SQLCol("qry_select",4)
SQLNext("QRY_SELECT")
END
ELSE
SQLInfo()
Error("Error running the query", SQL.MesError)
END
SQLClose("QRY_SELECT")
ELSE
SQLInfo()
Error("The connection to the data source failed." + CR + "Error code: " + SQL.Error + CR + SQL.MesError)
STC_Id = gsAsset_ID
END |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,abril 2019 - 21:17 |
Hi. I had the same problem.
In my case what solved was adding a rule allowing packet entrance through firewall. TCP port 80 seems to be necessary for your PC to accept the mobile app connection in order for it to talk to the webservice, which handles the HFSQL db (not sure but something like it). Be sure to add the rule to the internet profile you are using (example: Home network, corporate network). Check your firewall and you should see advanced options or something, my OS is outdated for me to be able to be specific with the menus, but let me know if it worked or if you need more help.
Cheers and good luck |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,abril 2019 - 22:24 |
Oh, and I also swapped [MyPcName] for [my pc IP].
Worked for me:
http://[my pc IP]/WDSOAPDB_WEB/
http://[my pc IP]:port
http://[my pc IP]
[my pc IP]
Didn't work for me:
http://[MyPcName]/etc
http://[MyPcName]
[MyPcName without CAPS]
[MyPcName] |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,febrero 2020 - 05:10 |
buenas noches a todos .. yo tengo el mismo problema...
este es mi codigo
mconexion is int
mconexion = SQLConnectWS("localhost","PostgreSQL30","postgres","blierpic","PruebasWinDev24","ODBC")
estoy intentando hacer una conexion por medio de ODBC a un base de datos Postgres, esta base de datos esta en mi maquina local
Ya tengo definido la conexion ODBC en mi maquina y ahi no tengo problema ...
alguien me puede ayudar
|
| |
| |
| | | |
|
| | | | |
| | |
|